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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2004-07-29 : 15:41:52
|
This morning I run into this strange DTS/DSN error. Here is the error message:Package (or connection property) error:Error Source: Microsoft OLEDB Provider for ODBC DriversError Description: [Sybase][ODBC Driver][Adaptive Server Anywhere] Unable to connect to database server: Database Server not running.The second variation of the error message adds another line to above: Context: error during initialization of the provider.The strange part is that the DTS/DSN combination was working yesterday, and it works from all other developers machine, but not on sql server 2000 box. Another otherwise identical DSN except it points to second database on the same ASA server works. Even a newly created one (to the same server and same database) works! I deleted this corrupted DSN, and created a new one with the same name. Same error!By the way, any time I test the system DSN in ODBC Data Source Administrator, it always works. The problem happens in EM during creating or executing a DTS, which uses the DSN in question.Every time I post something here, I always look at these Smilies thinking if there is one that pulling his hairs, he will be for me.  |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-29 : 18:55:30
|
| Sicne you deleted and created the new one, have you done an nbtstat -RR on all the machines? Are you using DHCP?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2004-07-30 : 09:25:01
|
| What has DHCP(Dynamic Host Configuration Protocol?) to do with the scenario here? I do check the TCP/IP under the Network tab of the ODBC Administrator.And what is nbtstat -RR? I found out it is netbios over TCP/IP. I saw the stats, then what should I look for?Could you please be more specific? |
|
|
|
|
|
|
corrupted DSN?