Hi, I'm running Windows XP Professional and Sql Server 7 and I keep getting errors about losing my connection to the server. This happens frequently in query analyzer and in VB 6 programs. Any help would be appreciated. Thanks Ellie ...more >>

I have come across this numerous times. I will have a query or view that times out at 30 seconds. However, it runs fine when in a procedure. The error is below. I believe it has to do with my ODBC connection settings, but don't know where to go to make the changes? Can anyone help? ===...more >>

This may be a simple question. We recently converted our backend database from Access 97 to MS SQL 2000. I have a huge reporting database (Access 2002) with thousands of queries that I have been using for years when the database was in Access 97. Now I am linking ODBC to the SQL Server. ...more >>

Anyone know how to do a dirty read through a linked server? I've got a linked server to a very busy Informix DB using Informix 3.38 drivers. John TL Lee ...more >>

I keep getting error 8114 when I query on the linked Oracle server. It states it could not be converted to a datetime value in Microsoft=AE SQL ServerT. The DBTYPE_DATE column most likely has a value outside the range supported by the datetime data type (datetime values must be from January 1...more >>

Which is the best way to get data from an Oracle stored procedure that is returning a ref cursor to SQL server. The data returning in the ref cursor is a unoin of rows that will be saved in a table. Can this be done without creating a separate application between the two databases....more >>

Is it possible to configure ODBC driver, that will provide connectivity to another SQL Server instance, if the primary is not available? Thanks a lot...more >>

Hi, I'm having problems to do updates and insert into an IBM DB2 database from SQL Server. Does anyone know if this is possible ? If so, do you have any suggestions on how to make it work? My environment: Windows 2000 server SP2; SQL Server 2000 SP 2; DB2 ver. 7.2 fixpack 8. Both databa...more >>

I need some help any help would be greatly appreciated- the database administrator is out sick and we can no longer log onto the database. We are a small company with two servers & 7 workstations. Svr1 is the primary domain controller, Win2k Adv Svr - Active Dir Svr2 is the database s...more >>

We are considering upgrading our SQL Server from version 6.2 to version 2000. We're running on an NT operating system, and most users connect using ODBC versions 3.6 and 3.7. I'm finding when users are upgraded to ODBC 2000, they are unable to retrieve their info. Rolling back the driv...more >>

We just upgraded from SQL 6.5 to SQL 2000. We also have moved SQL Server to a much beefier machine. Actual data access in our database is much faster, but we've noticed that the speed of the application itself has slowed down some because sp_sproc_columns now seems to take quite a bit longer to...more >>

I installed Cambridge learner's dictionary on a winXP perfersional edition(sp1) and I receive the message "The ODBC Library is locked. ODBC setup will not continue". How can i solve this problem? thanks for your help! -- Posted via http://dbforums.com...more >>

Ok I _want_ to connect to a SQL server (desktop) from a PocketPC 2002 client. 1. Does PocketPC support ODBC? 2. Is a remote connection possible? Any help will do. Thx. J ...more >>