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 > july 2004 > threads for july 1 - 7, 2004

Filter by week: 1 2 3 4 5

SQL Profiler Download
Posted by Venkat at 7/7/2004 3:57:56 PM
Hi All, Can someone point me to a site where i can download SQL Profiler for SQL Server 2000 server. Thanks In Advance, Venkat ...more >>

IIS4 lockdown install conflicts with MS SQL 7.0
Posted by Grasshopper at 7/7/2004 12:42:39 PM
I need to install IIS4 lockdown for FTP services. However, when i installed it, it caused problems with my MS SQL 7.0 installation. I had to re-installed the old odbc from the sql7 cd and rerun sql service pack 4 in order to get the SQL7 to function again. Can you PLEASE help me on how ...more >>

Problem with simplified chinese
Posted by David A. Caballero J. at 7/7/2004 10:53:26 AM
I have a 3 layer system, SQL Server 2000 database, COM+ dll's (VC++ 6) and ASP frontend, this system has been in production for quite some time using english, spanish and portuguese versions. Now I've been asked to test the system to function with Simplified chinese. The development of the system...more >>

Runtime error 3146
Posted by sam at 7/7/2004 1:23:52 AM
hello! I am currently using SQL 2000 and Access 97. My desktop used to be Win NT. Recently i migrate to Win XP and I got this error while SELECTING, UPDATING and INSERTING record. Full error is Runtime '3146'.ODBC call failed. The documentation for this error is quite limited, anyone c...more >>

Creating a linked server to DB2 from SQl server 2000 64bit
Posted by Geetha Dabbara at 7/6/2004 2:56:14 PM
Hi, I am trying to create a linked server to DB2 using IBM 64 bit OLEDB provider, as Microsoft doesn't have a DB2 OLEDB driver for 64bit. When I test the connection to DB2 using the driver, it works, but when I try to query DB2 using a OPENQUERY it gives me this message. "Error 7399:...more >>

Access 2K + SQL Server: Data Retrieval Q
Posted by Jeffery Hawkins at 7/6/2004 6:25:39 AM
First, if I'm posting this in the wrong newsgroup, please let me know and I'll re-post elsewhere. Trying to get SQL Server 2K data into an Access 2K front-end application (we're upsizing our back-end DB's to SQL Server, want to keep mdb front-ends). To limit the returned recordsets for both f...more >>

field + nullfield = null
Posted by Matthew at 7/2/2004 5:40:48 PM
I have two fields in different tabels. I have a calcualated field in a view that goes something like this: mato.pmainT.product + mato.woodtype.short It seemed to work OK, but I found if mato.woodtype.short is null, it won't display mato.pmainT.product either! I would like it to display mato.pm...more >>

Cannot update record through vb or Enterprise manager
Posted by John at 7/2/2004 3:37:46 AM
When trying to update a specific row in a table an error occurs. [Microsoft][ODBC SQL SERVER DRIVER][SQL SERVER] SQLDumExceptionhandler. Process 51 generated fatal exception c0000005 ACCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. What could be the reason for this? The...more >>



Suppress ODBC Dialog
Posted by Stefan Oedenkoven at 7/1/2004 11:10:39 PM
Hi ng, is it possible to suppress the ODBC-Dialog, when i test the connection to my linked tables an the connection is not alive? (the dialog, which is asking for username, password, servername, etc....) thanks, Stefan ...more >>

ADO on MDAC 2.8
Posted by Melopezcaste at 7/1/2004 11:07:01 AM
I am running an application that runs fine on MDAC 2.6 but when I run it on MDAC 2.8 have the error: Error on the DLL How can I rollback MDAC 2.8 and what will be the consequences on the Windows XP system? Application uses ADO.Open method and crashed here. Isn't MDAC 2.8 backward compatible...more >>

ODBC SQL Server Error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectioOpen (Connect()).
Posted by sqlak sqlak at 7/1/2004 4:36:49 AM
Hi, I'm getting following error while creating a DSN from remote stations PC. I could create DSN from the PCs available in the LAN. Connection Failed: SQL State: 01000 SQL Serve Error: 011001 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectioOpen (Connect()). Connection faile...more >>


DevelopmentNow Blog