B
bk
This is driving me crazy. I get "SQL Server is unavailable or does not
exist" error while developing asp.net application in vs2003's IDE
development mode but when I install the application on the server the
error disappears and everthing seems to be ok.
The error does not appear when I connect to the same databse on the
local sql2000 server. I use the same connection string for local
WindowsXP+sql2000 server and the remote Windows 2003 server+sql2000
with ip address changed from 127.0.1 to ip address of the remote
server.
I am able to connect to remote server using sqlConnection control from
the Toolboox. I copied the connection string from sqlConnect
ConnectionString property but error persists. I am aslo able to connect
to server using Query Analyzer and Enterprise Manager.
My connection string is
string sConStr= "Server = 192.168.0.28;User ID=myuser;Initial
Catalog=pubs;Password=mypassword"
I have read
http://support.microsoft.com/?id=328306
and looked at all the possible connection strings at:
http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#SQLClientManagedProvider
Any help on this will be appreciated.
BK
exist" error while developing asp.net application in vs2003's IDE
development mode but when I install the application on the server the
error disappears and everthing seems to be ok.
The error does not appear when I connect to the same databse on the
local sql2000 server. I use the same connection string for local
WindowsXP+sql2000 server and the remote Windows 2003 server+sql2000
with ip address changed from 127.0.1 to ip address of the remote
server.
I am able to connect to remote server using sqlConnection control from
the Toolboox. I copied the connection string from sqlConnect
ConnectionString property but error persists. I am aslo able to connect
to server using Query Analyzer and Enterprise Manager.
My connection string is
string sConStr= "Server = 192.168.0.28;User ID=myuser;Initial
Catalog=pubs;Password=mypassword"
I have read
http://support.microsoft.com/?id=328306
and looked at all the possible connection strings at:
http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#SQLClientManagedProvider
Any help on this will be appreciated.
BK