General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
sql server connection problem
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.