ODBC driver for SQL Server 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a server application that uses ODBC drivers to connect to databases.

When the number of parameters in a stored procedures reach a certain number such as 25, and named parameters are used and SQL Server 2000 ODBC driver is used to connect SQL Server 2000 databases, the server application crashed when calling ODBC APIs from time to time. I could not find a pattern to duplicate the crashes as yet.

If named parameters are NOT used, then the server application does not crash.

If SQL Native Client ODBC driver(ODBC driver from SQL Server 2005) is used to connect to SQL Server 2000 databases, the server application does not crash even named parameters are used.

I used other ODBC drivers to connect to Oracle databases using similar stored procedures, the server does not crash either.

From those facts, I believe some things are wrong with the SQL Server 2000 ODBC driver.

I have two questions:

1. Are there any newer SQL Server 2000 ODBC drivers?
The version of the ODBC driver for SQL Server 2000
installed on my computer is 2000.85.1117.00 dated Aug 4, 2004?

2. Are there any work around to get rid of this problem? I do not want the server application crash.



Thanks

Charles Zhang




.

Relevant Pages

  • Re: How to move system databases to new SAN drive in cluster serve
    ... I have moved model, msdb, and tempdb on a cluster ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrate stand alone sql server to a cluster without downtime
    ... Use backup and restore to create the databases on the new system. ... Run a log backup WITH STANDBY on each database on the old server. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: SPS 2003 Portal change SQL server
    ... select portal site to delete and choose to NOT delete the databases ... server farm, you can just copy them over. ... attach the databases to the new sql server. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Moving SQL Server 2000 to a new machine
    ... In addition to all the CYA advise, you CAN move the system databases. ... Once you've got the new server at SQL2K, SP2, and the physical paths to ... > Recently I was tasked to move our entire SQL Server 2000 to a new server. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving databases to a new server
    ... Moving Databases between Servers ... Disaster Recovery Articles for SQL Server ... I am leaning toward the detach and> attach method but I want to make sure there are not any hidden problems with> this method. ...
    (microsoft.public.sqlserver.setup)