Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP General (http://www.velocityreviews.com/forums/f65-asp-general.html)
-   -   Connection string errors (http://www.velocityreviews.com/forums/t802394-connection-string-errors.html)

abc929y@googlemail.com 11-22-2006 08:23 AM

Connection string errors
 
Hello

I am a complete newcomer to ASP and I am trying to get around a few
teething problems. I would be very grateful if any of you can point me
in the right direction because I am tearing my hair out!

I am using DW8 to create a simple database-driven site using IIS and
ASP vbscript. I have created a virtual directory in IIS and I have
created the DSN, connection and appropriate recordsets. The problem is
I keep getting the following error:

Error Type:
Provider (0x80004005)
Unspecified error

The line the error refers to is always the connection string. And it
seems to be intermittent. Sometimes the page works fine, other times I
get this error - but I can't figure out why. I always make sure that I
save my files and put them to the server so I really can't work this
out.

Can anyone help?

TIA.


Mike Brind 11-22-2006 01:14 PM

Re: Connection string errors
 

<abc929y@googlemail.com> wrote in message
news:1164183838.091292.16360@m7g2000cwm.googlegrou ps.com...
> Hello
>
> I am a complete newcomer to ASP and I am trying to get around a few
> teething problems. I would be very grateful if any of you can point me
> in the right direction because I am tearing my hair out!
>
> I am using DW8 to create a simple database-driven site using IIS and
> ASP vbscript. I have created a virtual directory in IIS and I have
> created the DSN, connection and appropriate recordsets. The problem is
> I keep getting the following error:
>
> Error Type:
> Provider (0x80004005)
> Unspecified error
>
> The line the error refers to is always the connection string. And it
> seems to be intermittent. Sometimes the page works fine, other times I
> get this error - but I can't figure out why. I always make sure that I
> save my files and put them to the server so I really can't work this
> out.
>
> Can anyone help?
>


Not without seeing the line that causes the error, and other relevant lines
that contain the connection information. Can you post it?

Also, while I also use DW8 for ASP sites, I do not allow it create any ASP
code. DW is not particularly good at it. I suggest that you learn how to
produce the code manually. It will be more difficult to begin with, but you
will learn a heck of a lot more, and more quickly if you do it this way.


--
Mike Brind



abc929y@googlemail.com 11-22-2006 02:15 PM

Re: Connection string errors
 
Thanks for your post, Mike, and for your advice.

It seems that by simply rebooting my machine, the problem is solved. I
have done a bit of searching on lists elsewhere and it seems this is a
common problem. Seeing as the problem doesn't appear to be wholly down
to the code, is there a way to make IIS more stable?

Many thanks

Jo


Mike Brind 11-22-2006 03:47 PM

Re: Connection string errors
 

<abc929y@googlemail.com> wrote in message
news:1164204948.665385.231910@j44g2000cwa.googlegr oups.com...
> Thanks for your post, Mike, and for your advice.
>
> It seems that by simply rebooting my machine, the problem is solved. I
> have done a bit of searching on lists elsewhere and it seems this is a
> common problem. Seeing as the problem doesn't appear to be wholly down
> to the code, is there a way to make IIS more stable?
>


Rebooting your machine is not solving the problem - it's recovering after
the problem has ocurred. And I don't know how you have deduced it is not
down to the code you are using. DSN connections, for example are
notoriously unstable, which is why they are not recommended practice. That
isn't an IIS stability issue, it's a code choice problem.

--
Mike Brind




All times are GMT. The time now is 11:53 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.