Hi,
You should read this:
http:// weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
Your databasename, login and password are correct. I was able to connect and create a table called students with fields name and age.
Test the following in an asp file:
<%
cst = "Provider=SQLOLEDB;" & _
"Data Source=87.117.201.122;" & _
"Initial Catalog=aspnetbd;" & _
"Network=DBMSSOCN;" & _
"User Id=gav23;" & _
"Password=qw34"
set conn = CreateObject("ADODB.Connection")
conn.open cst
set RS = Conn.Execute("SELECT * FROM students")
If not RS.eof then
RS.movefirst
Do
Response.write "Name:" & RS("Name") & "-- Age-->" & RS("age")
Rs.movenext
Loop until RS.eof
End if
%>
If you can try to connect to database and read this table, then everything is fine at server end and database is setp properly. You just need to check your application's code.
regds
IJ
|