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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 ;{db-library} unable to connect or server does not exist or access denied

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-08-09 : 07:57:50
matt jullien writes "From my PC I run the SQL Enterprise Manager(WinNT Workstation4)
This has always run fine. Yesterday I loaded WindowsXP onto a client PC. It would not connect to SQL through their database programs which use ADO. The error was;{db-library} unable to connect or server does not exist or access denied.

Now the Enterprise Manager on my PC fails to start. The error is;
SQL Executive service fails on startup with error 109.

When trying to connect through ODBC i get;

SQL state 01000 SQL server error 10061
SQL state 08001 SQL server error 17

Any ideas what could be happening?

Thanks
Matthew Jullien

NT Server 4.0 SP6
SQL Server 6.5"

shsmonteiro
Constraint Violating Yak Guru

290 Posts

Posted - 2002-08-13 : 15:52:28
I Think ODBC Driver that cames with Windows XP is unable to connect to SQL 6.5. Also DBLibrary is notsupoort under SQL 2000, except for compatibility. The interfaces defined in OLEDB for SQL 7.0/2000 are diferent from those defined for SQL 6.5

What about migrate SQL 6.5 to 7.0 or 2000


Sérgio Monteiro

Go to Top of Page
   

- Advertisement -