|
Subject:
|
can't connect to remote server
|
|
Posted By:
|
alyeng2000
|
Post Date:
|
2/8/2004 2:47:27 PM
|
hi all,
i am using asp.net,
i was trying to connect to a new sqlserver but a return error msg returned "sql server does not exist or access denied", i transfer the program to the remote sqlserver server and it works fine, also i use the same connection string to connect to the remote sqlserver from my machine using vb.net(desktop application) and it works fine, so the problem here with asp.net, any help !!!
do any face this problem.
Ahmed Ali
Software Developer
|
|
Reply By:
|
melvik
|
Reply Date:
|
2/9/2004 1:15:56 AM
|
Fast judge! It might be from ur Network Connection.
did u tried from another PC or not?! Does ur PC connected to LAN or not?!
Kepp in touch.
Always ,
Hovik Melkomian.
|
|
Reply By:
|
alyeng2000
|
Reply Date:
|
2/9/2004 8:11:42 AM
|
my pc is on a lan with the server,
i can connect to the server using client QA from pc also i can connect using a test Desktop application(vb.net) the problem when connecting using asp.net
Ahmed Ali
Software Developer
|
|
Reply By:
|
stu9820
|
Reply Date:
|
2/9/2004 8:15:10 AM
|
How are you trying to connect to the server with ASP.NET?
|
|
Reply By:
|
alyeng2000
|
Reply Date:
|
2/9/2004 10:24:10 AM
|
i am using ado.net,
for ex.
dim conStr as string="data source=XXXXX;Initial Catalog=XXXXX;User id=XXXXX;Pwd=XXXXX;"
dim conn as new sqlconnection(connStr)
dim cmd as new sqlcommand(QueryStr,conn)
conn.open
cmd.executescalar
conn.close
note : i use the same code as check in Desktop App with the same connection string and it works fine
Ahmed Ali
Software Developer
|
