SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 DBNETLIB Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kitez
Starting Member

Indonesia
9 Posts

Posted - 12/16/2010 :  22:55:14  Show Profile  Reply with Quote
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

Edited by - kitez on 12/16/2010 22:57:03

tkizer
Almighty SQL Goddess

USA
36632 Posts

Posted - 12/16/2010 :  23:21:10  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

kitez
Starting Member

Indonesia
9 Posts

Posted - 12/17/2010 :  08:15:17  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36632 Posts

Posted - 12/17/2010 :  13:18:09  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

kitez
Starting Member

Indonesia
9 Posts

Posted - 12/17/2010 :  21:38:46  Show Profile  Reply with Quote
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

Edited by - kitez on 12/17/2010 21:41:49
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36632 Posts

Posted - 12/18/2010 :  16:45:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

kitez
Starting Member

Indonesia
9 Posts

Posted - 12/23/2010 :  02:17:56  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36632 Posts

Posted - 12/23/2010 :  15:02:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
Did the Telnet test work?

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

Subscribe to my blog
Go to Top of Page

kitez
Starting Member

Indonesia
9 Posts

Posted - 12/27/2010 :  21:54:39  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36632 Posts

Posted - 12/27/2010 :  22:59:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

kitez
Starting Member

Indonesia
9 Posts

Posted - 12/28/2010 :  10:00:00  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36632 Posts

Posted - 12/28/2010 :  11:42:12  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

kitez
Starting Member

Indonesia
9 Posts

Posted - 12/29/2010 :  22:11:59  Show Profile  Reply with Quote
thank you...it's okay now after i re-install the windows server...


Cheers...
***************************
Kitez
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36632 Posts

Posted - 12/29/2010 :  22:52:37  Show Profile  Visit tkizer's Homepage  Reply with Quote
Glad you got it working.

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

Subscribe to my blog
Go to Top of Page

kitez
Starting Member

Indonesia
9 Posts

Posted - 12/30/2010 :  10:25:32  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36632 Posts

Posted - 12/30/2010 :  12:56:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
Obviously something was screwed up.

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

Subscribe to my blog
Go to Top of Page

kitez
Starting Member

Indonesia
9 Posts

Posted - 01/06/2011 :  01:39:36  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000