Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
all groups > sql server odbc > march 2004 > threads for march 1 - 7, 2004

Filter by week: 1 2 3 4 5

Re: Occasional "Timeout expired" message - on SP that should take 1 second
Posted by ITFred at 3/5/2004 5:36:45 PM
I have been struggling with a similar problem for a couple of weeks and came to this group in search of a solution. Perhaps a pooling of information will help. In my situation, I have a VB interactive front-end on multiple machines accessing a SQL2K database through ODBC over TCP/IP. ...more >>


Cannot connect to SQL Server through VPN
Posted by Paul Ohlemacher at 3/5/2004 5:13:05 PM
I established a VPN tunnel to my network at work to test merge replication. While I am able to connect via VPN to my network and ping the server in which the SQL server resides, I am not able to establish a connection to the Sql Server to register in my Enterprise Manager. The error I get is "Sq...more >>

Can't connect ODBC/SQLSrvr linked table from within COM+ component
Posted by Raf at 3/5/2004 4:41:07 AM
I have an Access 2000 database containing an ODBC table linked to a SQL Server 2000 database (using a system DSN) No problem opening the table Using Access 2000 itself No problem even within a VB program (EXE) accessing that table using the following code Set rs = New ADODB.Recordse ...more >>

Unknown Token Received
Posted by Greg M. at 3/5/2004 12:17:30 AM
I have a client using SQL 2k, SP2 (due application requirements, SP3 is not an option - the application vendor will not specify why). We are receiving: [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server Connection Broken There doesn't appear to be any rhyme or reaso...more >>

ODBC vs OLE DB
Posted by samuel at 3/4/2004 2:56:47 PM
The ODBC processing via DTS is slower than OLE DB which resulted following inquiries: - Why it so slow (ODBC)? - Any idea how to overcome it I use ODBC to communicate between IBM AS/400 DB2 and MS-SQL Server 2000. Please advise. Thanks. ...more >>

ODBC system dsn problem
Posted by bill at 3/3/2004 11:10:21 AM
We have a client that is trying to connect to a SQL DB on a Win2003 server (thru Citrix) using a system dsn. When a user tries connecting using the system dsn in Crystal Reports (or anyting else for that matter), they get the following error: data source name not found and no default drive...more >>

Login failed for user '(null)'...Reasons?
Posted by JRE at 3/3/2004 10:27:44 AM
A SQL Server (in another domain) I'm trying to connect to with SQL Server authentication (UID and password) fails from an Access application. I've tried a ODBC DSN and a DSN-less connection. The SQL Server is running in mixed authentication mode. I can get to the SQL Server with Enterprise Man...more >>

SQL Driver Question
Posted by Sunden at 3/3/2004 6:08:34 AM
Hello! Not as verse in SQL as I'd like to, but keep learning everyday. When creating an SQL driver, two options appeared to be checked by default, "Use ANSI quoted identifiers" and "Use ANSI nulls, paddings, and Warnings check box". Should they be left alone or should they be unchecke...more >>



Create a DSN programmatically with network options
Posted by Patrick_Mézard at 3/1/2004 8:20:47 PM
Hello, I would like to create a brand new system DSN, programmatically, targeting an MS-SQL Server 2000 database, and with networking options (pipes,TCP/IP, etc.). Until now the only solutions I managed to find on google.groups or forums are: 1- The usual "Why don't you do it manually ?" ...more >>

SQL 7 and MDAC
Posted by MG at 3/1/2004 1:17:02 PM
I am running into MDAC discrepencies between my client workstation with SQL 7 client and production and test sql 7 servers. I have realized that my workstation (Windows2000) has MDAC 2.6 and the production box (which is NT4) has MDAC 2.12. I also have a test SQL Server 7 server with Wind...more >>


DevelopmentNow Blog