Microsoft OLE DB Provider error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Microsoft OLE DB Provider error

Hello, friends! When we trying to connect with Power Builder Application to SQL server 2000 pack 3a,
we get en error: sqlstate=08001
Microsoft OLE DB Provider for SQL Server
DBNETLIB ][connectionOpen (Connect ()).] Sql server does not
exist or access denied and the procedure’s name during it’s compilation an error was generated. Any ideas?
Thanx in advance.

Try connecting the server with IP Addres and TCP/iP as default netlib.<br /><br />Use TCP/IP instead of the named pipes protocol to connect to the database. To do this, add the following attribute to the connection string: "Network Library =dbmssocn"<br /><br />For example:"User ID=myUserId<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />assword=myPassword;Initial Catalog=Pubs;Data Source=myServer;Network Library =dbmssocn"<br /><br /><br /><br />_________<br />Satya SKJ<br />Moderator<br />SQL-Server-Performance.Com<br />
I will try this!!!! thanx for a quick responce!!!!

Interesting article on the same..;en-us;328306
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

And also try to connect to the server from a client to make sure server is in live condition <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />_________<br />Satya SKJ<br />Moderator<br />SQL-Server-Performance.Com<br />