S
Steve
I'm trying to get some data out of SQLServer on our
Webserver.
I built the database on my local machine and the code
pages are on my C: drive and the virtual folders are in
IIS running on my local machine.
The following connection string works fine (TRHXP210 is
my maching name):-
Private Const m_strConnection As String
= "Password=;Persist Security Info=True;" & _
"User
ID=sa;Initial Catalog=Committee;" & _
"Data
Source=TRHXP210;" & _
"Network
Library=dbmssocn"
The problem is if I try to connect to an SQL db on our
webserver I get the following Error:-
System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied.
The code files are on my local machine - could it be that
I have to build everything locally then disconnect the
database, deploy the app on the server, then re-attach
the db on the remote instance of SQLServer?
Should I be able to pull data from the remote server? It
works with my ASP pages!??
Can anyone help please.
TIA
Webserver.
I built the database on my local machine and the code
pages are on my C: drive and the virtual folders are in
IIS running on my local machine.
The following connection string works fine (TRHXP210 is
my maching name):-
Private Const m_strConnection As String
= "Password=;Persist Security Info=True;" & _
"User
ID=sa;Initial Catalog=Committee;" & _
"Data
Source=TRHXP210;" & _
"Network
Library=dbmssocn"
The problem is if I try to connect to an SQL db on our
webserver I get the following Error:-
System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied.
The code files are on my local machine - could it be that
I have to build everything locally then disconnect the
database, deploy the app on the server, then re-attach
the db on the remote instance of SQLServer?
Should I be able to pull data from the remote server? It
works with my ASP pages!??
Can anyone help please.
TIA