General discussion
-
Topic
-
sql server connection problem
Lockedi am using asp/vbscript to access an sql database
residing on another server. i get the following error :
————————————-
Microsoft OLE DB Provider for SQL Server error ‘80004005’[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/checkid_index.asp, line 25
———————————–
given below is the code for checkid_index.asp
———————————-
dim conn,rs,strsql
Set conn=Server.CreateObject(“ADODB.Connection”)‘Standard
‘ Conn.connectionstring =”PROVIDER=SQLOLEDB;DATA SOURCE=203.199.114.100;UID=jamea;PWD=jamea;DATABASE=reg_mumineen”
‘ Conn.connectionstring=”driver={SQL Server};server=203.199.114.100;uid=jamea;pwd=jamea;database=reg_mumineen”‘Network Library and port 1433
‘ conn.connectionstring = “Provider=sqloledb;Data Source=203.199.114.100,1433;Network Library=DBMSSOCN;Initial Catalog=reg_mumineen;User ID=jamea;Password=jamea”‘Trusted connection:
conn.ConnectionString=”Provider=SQLOLEDB; Data Source=203.199.114.100;Initial Catalog=reg_mumineen; User ID=jamea; Password=jamea; Integrated Security=SSPI;”conn.open
error is on last line which is line 25
i have tried all ways possible but nothing works on my website although on localhost IIS 5, it works perfectly whichever string i use. connection is succefull and i can retrive data through stored procedures thereafter.i have also used
conn.open varstring
where varstring is the connection string above.only on website this does not work.
please pls help.