Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
baturkilic
Starting Member
6 Posts |
 Posted - 2009-03-17 : 12:34:19
|
| Hi there, I have a problem about the broken sql connection specialy on SQL 2005. I try to reproduce the problem for you. Our application is devoloping on Delphi 6 and we are using SDAC 3.08 for connecting the sql server. Application can connect to sql server correctly but when the start batch process working for example 80 or more query later sql server connection broken abnormaly and all process stoping. But some other clients on the same network can be finish all process succesfuly. Network cable and other hardware think are fine. Also i am getting following error when the connection is broken."[DBNETLIB] [ConnectionOpen (Connect()).] Sql server does not exist or access is denied."I try to solve for then problem i am install sql server native client 2005 but not working.Thank you. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-17 : 13:14:35
|
| How did you verify that the netork connection was fine? I'd be very suspicious about that. SQL doesn't let you start something and then stop working. It either works when you try to start it or it doesn't. I would crawl around in the logs and see if I could find something there.Mike"oh, that monkey is going to pay" |
 |
|
|
baturkilic
Starting Member
6 Posts |
Posted - 2009-03-17 : 13:21:44
|
| I am sure because when i connect to SQL server 2000 on same server and same db it is working correctly. |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-17 : 13:25:34
|
| After you get that error what happens if you restart your batch process? Can it connect? It only takes a second for something in the network to hiccup and drop you and then when you go back you would be able to connect. If you had that error occur and then tried to connect from your SQL 2000 the hiccup could have already passed.Mike"oh, that monkey is going to pay" |
|
|
|
baturkilic
Starting Member
6 Posts |
Posted - 2009-03-18 : 04:29:22
|
| Actualy there is no hiccup . I wan't to give you more detail. My application is calculate the company invoices. There is a ower 100000 case for calculation. Process start from first record when came to number of 99. record i get this error. Every time same record number. But when i use the sql server 2000 i never get this error. |
|
|
|
|
|
|
!!!Sql server does not exist or access is denied.