Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 28th, 2005, 12:25 AM
Registered User
 
Join Date: Oct 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Pragnesh1205
Default SQL ODBC Driver

i'm using microsoft odbc and i close and open a lot of connections
through my code at a regular basis. for some reason, sometimes, not
always,
i get the following error when i try to open a new connection
to the DB: "ERROR [IM005] [Microsoft][ODBC Driver Manager] Driver's
SQLAllocHandle on SQL_HANDLE_DBC failed".

how to remove this error.


  #2 (permalink)  
Old October 28th, 2005, 12:28 AM
Authorized User
 
Join Date: Jul 2005
Location: Chennai, Tamil Nadu, India.
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Pragnesh,

Did you check this support URL: http://support.microsoft.com/default...b;en-us;259477

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At: http://deepak.blogdrive.com/
  #3 (permalink)  
Old October 28th, 2005, 12:40 AM
Registered User
 
Join Date: Oct 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Pragnesh1205
Default

I check this support URL: http://support.microsoft.com/default...b;en-us;259477

But I am develope the Code in Visual Basic and ASP. In the above URL they gives us C. So how to use this.

Pl. help me how to remove this error.


  #4 (permalink)  
Old October 28th, 2005, 12:58 AM
Authorized User
 
Join Date: Jul 2005
Location: Chennai, Tamil Nadu, India.
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It actually epicenters on the driver you use. Perhaps since ODBC connectionstring would be in only one place, can you check using OLEDB connectionstring.

Check out the connectionstring in OlEDB for http://www.connectionstrings.com/

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At: http://deepak.blogdrive.com/
  #5 (permalink)  
Old October 28th, 2005, 04:05 PM
Friend of Wrox
 
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There are ways to limit the number of connections to a given computer. Do you know how many connections your opening???

  #6 (permalink)  
Old October 29th, 2005, 03:17 AM
Registered User
 
Join Date: Oct 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Pragnesh1205
Default

At present i am provoding the 25 Users. But same thing is run properly on other location. they have low hardware configuration as compare to this one. pl

  #7 (permalink)  
Old October 31st, 2005, 01:15 PM
Friend of Wrox
 
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

25 users should not be a problem. Most likely I would guess you have a client with a newer version of the MDAC than the server. If you have not upgraded your MDAC version on your server recently you may want to consider that. Most are backward compatible thus a newer server version can talk to an older client version. But a newer client version may not be able to talk to an older server version.



Similar Threads
Thread Thread Starter Forum Replies Last Post
[Microsoft][ODBC SQL Server Driver] TIME OUT ERROR rtr1900 ASP.NET 2.0 Basics 1 November 12th, 2008 09:36 AM
[Microsoft][ODBC SQL Driver]Connection is busy muthumari_p2003@yahoo.com Pro JSP 0 May 8th, 2006 07:51 AM
Age Old ODBC Sql Server Driver Timeout busher Classic ASP Databases 5 December 7th, 2005 12:10 PM
java.sql.SQLException: [Microsoft][ODBC Driver Man pvsharinath@gmail.com Java Databases 1 May 5th, 2005 02:40 AM
ODBC driver 2000.81.7713.00 for SQL 7.0 Jai SQL Server 2000 1 October 13th, 2003 11:56 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.