i 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.
