SQL Server, ASP and Access Denied

[Bart]

I have a web application in which I use a PDF form to collect data
from the user and submit that data directly from the PDF to ASP.

All pages of the application use the same ADO connection string, and
most pages are able to access the database. One page cannot access
the database. This ASP page is different from the others in two ways:

1. It follows the PDF file and opens in the window previously opened
for the PDF content.
2. It uses an IP address in the address bar instead of a DNS name.

I have minimal control over these two conditions. Unfortunately, I
also do not have control over the web and database servers. The
database server is behind a firewall, but other web pages are able to
access it using the same connection string.

The database error is:

Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

In testing a couple of days ago, the same code worked perfectly on the
same server, so I guess the problem is intermittent although it has
not worked at all today.

What can I do with my code or what can I suggest be done with the
servers to correct this?

Thanks.
-Bart.

[Boris Nikolaevich]

Check the network library that is being used to connect to the sever. It's
possibly a client connection issue, rather than a server problem. (In this
case, by client I mean the web server, not the browser.)

The second possibility is this: if you are storing the connection string in
a Session variable, you can't pass that variable to a new domain--and as far
as the browser is concerned, [url]www.mydomain.com[/url] is a different domain from
10.10.10.10, even if they point to the same machine. So when you move from
[url]www.mydomain.com[/url] to 10.10.10.10 you are losing the connection string.


"Bart" <cshrcat@hotmail.com> wrote in message
news:fa23d9f3.0309101902.3cb39ce0@posting.google.c om...

> I have a web application in which I use a PDF form to collect data
> from the user and submit that data directly from the PDF to ASP.
>
> All pages of the application use the same ADO connection string, and
> most pages are able to access the database. One page cannot access
> the database. This ASP page is different from the others in two ways:
>
> 1. It follows the PDF file and opens in the window previously opened
> for the PDF content.
> 2. It uses an IP address in the address bar instead of a DNS name.
>
> I have minimal control over these two conditions. Unfortunately, I
> also do not have control over the web and database servers. The
> database server is behind a firewall, but other web pages are able to
> access it using the same connection string.
>
> The database error is:
>
> Microsoft OLE DB Provider for SQL Server (0x80004005)
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.
>
> In testing a couple of days ago, the same code worked perfectly on the
> same server, so I guess the problem is intermittent although it has
> not worked at all today.
>
> What can I do with my code or what can I suggest be done with the
> servers to correct this?
>
> Thanks.
> -Bart.

[Bart]

Boris, thanks for your suggestions. I am using the TCP/IP network
library... here is the connection string:

dsn=mydsn;uid=myuid;pwd=mypwd;database=mydb;app=AS P;Connect
Timeout=60;Network Library=dbmssocn"

The connection string was initially stored in an Application variable
in global.asa. I moved it to a global variable in the ASP page during
the troubleshooting process.

I suspect that your last point regarding the IP address is the
problem, but how do I correct it given that Acrobat uses the IP
address? If I can't control for that, I will be re-writing the PDF
piece over the weekend to use DHTML.

Thanks again.

"Boris Nikolaevich" <boris@nikolaevich.com> wrote in message news:<e4$bT0BeDHA.696@TK2MSFTNGP09.phx.gbl>...

> Check the network library that is being used to connect to the sever. It's
> possibly a client connection issue, rather than a server problem. (In this
> case, by client I mean the web server, not the browser.)
>
> The second possibility is this: if you are storing the connection string in
> a Session variable, you can't pass that variable to a new domain--and as far
> as the browser is concerned, [url]www.mydomain.com[/url] is a different domain from
> 10.10.10.10, even if they point to the same machine. So when you move from
> [url]www.mydomain.com[/url] to 10.10.10.10 you are losing the connection string.
>
>
> "Bart" <cshrcat@hotmail.com> wrote in message
> news:fa23d9f3.0309101902.3cb39ce0@posting.google.c om...

> > I have a web application in which I use a PDF form to collect data
> > from the user and submit that data directly from the PDF to ASP.
> >
> > All pages of the application use the same ADO connection string, and
> > most pages are able to access the database. One page cannot access
> > the database. This ASP page is different from the others in two ways:
> >
> > 1. It follows the PDF file and opens in the window previously opened
> > for the PDF content.
> > 2. It uses an IP address in the address bar instead of a DNS name.
> >
> > I have minimal control over these two conditions. Unfortunately, I
> > also do not have control over the web and database servers. The
> > database server is behind a firewall, but other web pages are able to
> > access it using the same connection string.
> >
> > The database error is:
> >
> > Microsoft OLE DB Provider for SQL Server (0x80004005)
> > [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> > access denied.
> >
> > In testing a couple of days ago, the same code worked perfectly on the
> > same server, so I guess the problem is intermittent although it has
> > not worked at all today.
> >
> > What can I do with my code or what can I suggest be done with the
> > servers to correct this?
> >
> > Thanks.
> > -Bart.