connection question

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
Thu Jun 23 20:10:39 CDT 2005

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" <yada@yada.com> wrote in message news:42bb556e$1@quokka.wn.com.au...
> 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
>

Cor
Fri Jun 24 01:19:13 CDT 2005

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

Mike
Fri Jun 24 04:06:00 CDT 2005

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" <notmyfirstname@planet.nl> wrote in message
news:uUYeCTIeFHA.1040@TK2MSFTNGP10.phx.gbl...
> 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
>

Paul
Fri Jun 24 10:48:22 CDT 2005

On Fri, 24 Jun 2005 08:30:03 +0800, "Mike" <yada@yada.com> 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.aspx?scid=kb;en-us;328306


Paul
~~~~
Microsoft MVP (Visual Basic)

Mike
Fri Jun 24 19:40:40 CDT 2005

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" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:5paob1thf0tm69mvv50tih2i1cu99d8u6h@4ax.com...
> On Fri, 24 Jun 2005 08:30:03 +0800, "Mike" <yada@yada.com> 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.aspx?scid=kb;en-us;328306
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

Paul
Mon Jun 27 11:19:53 CDT 2005

On Sat, 25 Jun 2005 08:40:40 +0800, "Mike" <yada@yada.com> wrote:

¤ 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?

I can't imagine they would be related. What is the error you are getting when attempting to connect
to a Microsoft Access database?


Paul
~~~~
Microsoft MVP (Visual Basic)