DBNETLIB Error - SQL Server Forums

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 2008 Forums

SQL Server Administration (2008)

DBNETLIB Error

Author

Topic

kitez
Starting Member

9 Posts

Posted - 2010-12-16 : 22:55:14

hello, i've got error message like this "[DBNETLIB][ConnectionOpen_(Connect()).]SQL_Server_does_not_exist_or_access_denied". i did everything from every guide that i've found from Google but still doesn't help.here is the code :

<!--METADATA TYPE= "typelib" NAME= "ADODB Type Library" FILE="C:\Program Files\Common Files\SYSTEM\ADO\msado15.dll" -->
<SCRIPT LANGUAGE="VBScript" RUNAT="Server">
Sub Application_OnStart

'	107 ??? ??
'	??? ??
	Application("Connection_ConnectionString")   = "Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=Server IP;Initial Catalog=O2JamTrade;User ID=username;PWD=password"
	Application("m_Connection_ConnectionString")   = "Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=Server IP;Initial Catalog=O2JamTrade;User ID=username;PWD=password"		
	
'	??????
	Application("c_Connection_ConnectionString")   = "Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=server IP;Initial Catalog=O2JAM;User ID=username;PWD=password"			

	Application("Connection_ConnectionTimeout") = 80
	Application("Connection_CommandTimeout") = 80
	

End Sub

Sub Application_OnEnd

End sub

Sub Session_OnStart
	Session.Timeout = 20
End Sub

</SCRIPT>

<SCRIPT LANGUAGE="VBScript" RUNAT="Server">
Sub Session_OnEnd 

End Sub
</SCRIPT>

back then i'm using SQL SERVER 2000 and everything's fine.

thank you for all your help..

Cheers...
***************************
Kitez

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-16 : 23:21:10

Here's how to troubleshoot it: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kitez
Starting Member

9 Posts

Posted - 2010-12-17 : 08:15:17

quote:
Originally posted by tkizer

Here's how to troubleshoot it: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

thx, but still got same error..

Cheers...
***************************
Kitez

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-17 : 13:18:09

You didn't go through everything in that link then.

Please describe everything that you tried so that I can point out what you missed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kitez
Starting Member

9 Posts

Posted - 2010-12-17 : 21:38:46

quote:
Originally posted by tkizer

You didn't go through everything in that link then.

Please describe everything that you tried so that I can point out what you missed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

okay, i did:
1. using tcp/name instances
2. enable remote access
3. allow it from firewall
4. edit the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo

now what??
Cheers...
***************************
Kitez

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-18 : 16:45:48

Did you try HostName,PortNumber. Did you try telnetting to the port? This is all detailed in my links.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kitez
Starting Member

9 Posts

Posted - 2010-12-23 : 02:17:56

quote:
Originally posted by tkizer

Did you try HostName,PortNumber. Did you try telnetting to the port? This is all detailed in my links.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Okay, i did Hostname,PortNumber and anything else. now i got new error "Invalid Connection", i don't know why is that??

Cheers...
***************************
Kitez

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-23 : 15:02:26

Did the Telnet test work?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kitez
Starting Member

9 Posts

Posted - 2010-12-27 : 21:54:39

quote:
Originally posted by tkizer

Did the Telnet test work?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

i did open the remote host connectin on sql surface area configuration. but Telnet doesn't work. i checked on another forum, it's said that everything is okay coz my sql server is running so that's why i can't telnet to the server. is it true??

Cheers...
***************************
Kitez

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-27 : 22:59:19

If telnet test doesn't work, then you've got a firewall/network problem that needs to be looked into. Contact your network administrator for help. Let that person know that even telnet tests are failing.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kitez
Starting Member

9 Posts

Posted - 2010-12-28 : 10:00:00

quote:
Originally posted by tkizer

If telnet test doesn't work, then you've got a firewall/network problem that needs to be looked into. Contact your network administrator for help. Let that person know that even telnet tests are failing.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
but i turned off the firewall in my server, and my pc too. now what should i do?

Cheers...
***************************
Kitez

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-28 : 11:42:12

You should contact your network administrator.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kitez
Starting Member

9 Posts

Posted - 2010-12-29 : 22:11:59

thank you...it's okay now after i re-install the windows server...

Cheers...
***************************
Kitez

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-29 : 22:52:37

Glad you got it working.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kitez
Starting Member

9 Posts

Posted - 2010-12-30 : 10:25:32

quote:
Originally posted by tkizer

Glad you got it working.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

thx, but i still wonder why after i re-install the server everything's running well.....though i did the IIS,SQL Server and everything with the same way...

Cheers...
***************************
Kitez

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-30 : 12:56:16

Obviously something was screwed up.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

kitez
Starting Member

9 Posts

Posted - 2011-01-06 : 01:39:36

quote:
Originally posted by tkizer

Obviously something was screwed up.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

it's very clear. well, i re-install my server coz it got hacked, and there's a program running in background. maybe that's why my server was screwed up at 1st time...

Cheers...
***************************
Kitez

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources