I'm getting an error while running an aspx page on a production server.

The error is that either the server can not be found or the access is
denied.

The following code fails at line 36.
Line 34: str = "Driver={SQL
Server};server=sallyserver;database=school;uid=www_intra;pwd=www_intra"
Line 35: C.ConnectionString = str
Line 36: C.Open()
Line 37: Dim R As New ADODB.Recordset

Other aspx pages that don't talk to the data server run correctly.

The same page run on the development PC (WinXp Pro) connects and dispays the
data correctly. (SQL server is on another box)

If I alter the code to run in an Access 2000 database on the same production
server, it runs correctly.

Thus I'm not sure how to go about getting this up and running.

Any thoughts would be appreciated.

Cheers

Mike

I should have added that in the development system the data is on an SQL
server, and in the production environment it is MSDE.

"Mike" <(E-Mail Removed)> wrote in message news:42bb556e$(E-Mail Removed)...
> I'm getting an error while running an aspx page on a production server.
>
> The error is that either the server can not be found or the access is
> denied.
>
> The following code fails at line 36.
> Line 34: str = "Driver={SQL
> Server};server=sallyserver;database=school;uid=www_intra;pwd=www_intra"
> Line 35: C.ConnectionString = str
> Line 36: C.Open()
> Line 37: Dim R As New ADODB.Recordset
>
> Other aspx pages that don't talk to the data server run correctly.
>
> The same page run on the development PC (WinXp Pro) connects and dispays
> the data correctly. (SQL server is on another box)
>
> If I alter the code to run in an Access 2000 database on the same
> production server, it runs correctly.
>
> Thus I'm not sure how to go about getting this up and running.
>
> Any thoughts would be appreciated.
>
> Cheers
>
> Mike
>

Mike,

Although this is not really a ADONET question more a DATA question for which
is a seperate dotnet newsgroup. Can this in the way you describe it in my
opinion only be in that user on your SQL server or/and his password.

Cor

Thanks Cor,

I guess that the key is that I'm not sure where to start, and thus this may
be in the wrong group.

Thanks for the pointer.

Cheers,

Mike
"Cor Ligthert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Mike,
>
> Although this is not really a ADONET question more a DATA question for
> which is a seperate dotnet newsgroup. Can this in the way you describe it
> in my opinion only be in that user on your SQL server or/and his password.
>
> Cor
>

On Fri, 24 Jun 2005 08:30:03 +0800, "Mike" <(E-Mail Removed)> wrote:

¤ I'm getting an error while running an aspx page on a production server.
¤
¤ The error is that either the server can not be found or the access is
¤ denied.
¤
¤ The following code fails at line 36.
¤ Line 34: str = "Driver={SQL
¤ Server};server=sallyserver;database=school;uid=www_intra;pwd=www_intra"
¤ Line 35: C.ConnectionString = str
¤ Line 36: C.Open()
¤ Line 37: Dim R As New ADODB.Recordset
¤
¤ Other aspx pages that don't talk to the data server run correctly.
¤
¤ The same page run on the development PC (WinXp Pro) connects and dispays the
¤ data correctly. (SQL server is on another box)
¤
¤ If I alter the code to run in an Access 2000 database on the same production
¤ server, it runs correctly.
¤
¤ Thus I'm not sure how to go about getting this up and running.
¤
¤ Any thoughts would be appreciated.

See if the following helps:

http://support.microsoft.com/default...b;en-us;328306


Paul
~~~~
Microsoft MVP (Visual Basic)

Thanks Paul.

I've been doing some more checking, and it appears as though it may be an
IIS issue, as I redid the pages to connect to an Access database, and I was
getting a similar error.

Does that make sense?

Cheers,

Mike
"Paul Clement" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Fri, 24 Jun 2005 08:30:03 +0800, "Mike" <(E-Mail Removed)> wrote:
>
> ¤ I'm getting an error while running an aspx page on a production server.
> ¤
> ¤ The error is that either the server can not be found or the access is
> ¤ denied.
> ¤
> ¤ The following code fails at line 36.
> ¤ Line 34: str = "Driver={SQL
> ¤ Server};server=sallyserver;database=school;uid=www_intra;pwd=www_intra"
> ¤ Line 35: C.ConnectionString = str
> ¤ Line 36: C.Open()
> ¤ Line 37: Dim R As New ADODB.Recordset
> ¤
> ¤ Other aspx pages that don't talk to the data server run correctly.
> ¤
> ¤ The same page run on the development PC (WinXp Pro) connects and dispays
> the
> ¤ data correctly. (SQL server is on another box)
> ¤
> ¤ If I alter the code to run in an Access 2000 database on the same
> production
> ¤ server, it runs correctly.
> ¤
> ¤ Thus I'm not sure how to go about getting this up and running.
> ¤
> ¤ Any thoughts would be appreciated.
>
> See if the following helps:
>
> http://support.microsoft.com/default...b;en-us;328306
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)