Hello This may have been asked before, but I can't seem to find it. I believe the default ODBC time out is 30 seconds. I know that you can override that by changing your application call. Can it be overridden without making program changes? Perhaps through a registry setting (though I ca...more >>

Recently the error message below started appearing when running a query against simple Excel spreadsheets. In the past this worked perfectly. Don´t know if the recently applied SP4 might have anything to do with it. System: SQL Server 2000 SP4 on Windows 2000 SP4 Error: Server: Msg 7399...more >>

We have a group of computers that are having problems connecting to our SQL Server Database... When they pull down the "Which SQL Server do you want to connect to?" box, it shows the server twice. If they select one, then the application fails, if they choose the other sometimes it works fine...more >>

Hello, I'm using the functions exposed in ODBCCP32.dll via C# ([DLLImport ("ODBCCP32.dll")]), but am having trouble figuring out what the return/error codes are. The .dll isn't COM so I can't just add a reference to it. The docs provide the names of the codes (like ODBC_ERROR_REQUEST_FAIL...more >>

We have a mysterious problem connecting to a SQL database with ODBC. Here's a little background on our environment: - We're connecting to a named instance of SQL 2000 on a Win 2003 Server cluter. The virtual server name and the instance name are the same (so the nomenclature to describe the in...more >>

We are calling a stored procedure that accepts a very long comma delimited parm. In the body of the stored proc, we loop through the parm using a user defined function to pull out the tokens. The function call uses 2 input parms: the original long parm and the int position of which token to ext...more >>

Is there a where to Update the Value of a Field in one table to a Field Value from another table. The following works in MS Access but I am unsure on how to do the same in SQL 2000 UPDATE [ci_CaseData] INNER JOIN [ci_Addresses] ON [ci_CaseData].[CaseGUID] = [ci_Addresses].[CaseGUID] SE...more >>

We would like to include it in our install to help facilitate any connectivity issues. -- Brad Ashforth...more >>

Hi, I would like to know if there is anyway of retreiving an entire column of data from a resultset into say an array or a vector. e.g. If the resultset contains columns ID (int), Name(varchar), age(int) then I'd like retrieve the ID values from each tuple in one go into say an int array...more >>

I posted this question in the SBS newsgroup as well. I have two internal client machines who connect to an external SQL server. Both were working fine on our old NT 4.0 domain but now that we have updated to SBS 2003 with ISA 2000, the two internal clients (XP SP2) are having errors with th...more >>

I wish to send dynamic SQL to Openquery but it seems OpenQUERY only accepts string constants. Any advise on how to do this. It would convenient if Openquery could execute similar to dynamic SQL EXEC. Please advise. Regards, Tim Pee...more >>

I have a connection to SQL Server set up via SQLConnect() referencing a System DSN. Is there a programatic way to obtain the SQL Server machine's host name and port number from the established connection? The documentation for SQLGetInfo and SQLGetConnectAttr doesn't seem to cover these items. ...more >>

Hi all i get the following error [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '5'. (#170) when trying to update or delete a record from an Access Linked table. Adding a record is fine. There is a field called 5Years, but this has not been a problem before. ...more >>

I am looking for a way to read a seperate .txt file and extract the paramaters for a query. I am given a .txt file with several thousand numbers a day, to query against the database. I would very much like to call the file and read it's contents in as the paramater. Is this possible through...more >>

Can I use integrated security in an ODBC connection string without using a DSN? If so, what would the syntax be for SQL Server and Oracle (if supported by Oracle)? Tony ...more >>

Hello everyone, I have just created some DTS package wich pump data from Visual FoxPro database to SQL Server 2000. Everything works fine when I execute de package on my local machine or any other machine that aren't servers. Things gets ugly when I try to execute these package directly o...more >>

Hi to all, I have a big performance problem with looping threw rdoresultset. I made some very complex sql queries. They link like 5 tables and uses a couple subqueries. The number of returned rows is something like 1000. Query execution takes about 1 second, which is completly acceptable. Bu...more >>

Hello all, I have a VB application that is running fine in prod on a box without the .net framework installed. The app queries a Oracle 8.1.7 64 bit database. It uses the Microsoft ODBC Driver for Oracle and it works like a champ. However I am adding some enhancements to this application and ...more >>

Hello all. I am having a pretty serious problem and I tried almost every thing (I know…) but still with no success. There are 2 computer on a workgroup (lets call them A and B). On A there is an MSSQL Server 2000 with windows and QSL mixed authentication on Windows 2003 machine. On B I s...more >>

We are trying to troubleshoot a complex issue with SQL server 2000. We have been using an *off the shelf* application for the last 6 months that is used for portfolio management. The application is written in ASP and the database is SQL 2000. One of the screens in the application displays...more >>

I have used the ole db services for odbc to utilise a informix odbc driver to create my linked server in SQL server. The Informix IDS server in question is v9.4 on Suse Linux Enterprise V8. If I use the informix ODBC via Query in Excel I can retrieve data from the IDS databases with no pro...more >>

my access application links to sqlserver odbc the form RecordSource is an path-through query limited to max 30 records 1. how can i show the next 30 records? 2. how can i find a spesific record placed out of the shown records? thanks sam ...more >>

am trying to update an access file table contents using osql and am getting all sort of error Can anyone help This is the querry osql -U aaa -D MyLocalConfig -P synprof97 -Q "update System set LocalConfigPath = 'C:\DBase\Test\Config' where Ref = '{B2244A43-CAF7-11D0-8DD6-0000C07E4B0E}'" I ...more >>