Database Connection

Hi all, I am using a DSN to connect to the database! this connection works
great and all is fine - EXCEPT -
when I go to another page, it cant open the connection to get more
information from the database! is this the way I have set up the asp
coding? or the way the DSN is set up? or the fact that I am using MS Access
as my database? it will only allow 1 connection at a time it seems. I
require each page to connect to the database to get some sort of
information - so as the users move from page to page, I get errors, until
the connection is timing out! I added a close to the connection but it
still does not work on pages after the first!

any ideas? thanks in advance for your help

Re: Database Connection

Dino wrote:
> Hi all, I am using a DSN to connect to the database!

It's probably not the cause of your problem, but this is not a good idea.
You should be using the native Jet OLEDB Provider:
http://www.aspfaq.com/show.asp?id=2126

> this connection
> works great and all is fine - EXCEPT -
> when I go to another page, it cant open the connection to get more
> information from the database!

What happens when you try? Error messages? Timeouts? How are we supposed to
suggest a solution when you don't describe your symptoms?

> is this the way I have set up the asp
> coding? or the way the DSN is set up? or the fact that I am using MS
> Access as my database? it will only allow 1 connection at a time it
> seems. I require each page to connect to the database to get some
> sort of information - so as the users move from page to page, I get
> errors, until the connection is timing out! I added a close to the
> connection but it still does not work on pages after the first!
>
> any ideas? thanks in advance for your help

I can only guess. All users of an Access database require read/write
filesystem permissions for the folder containing the database. In ASP, this
means granting permission to the IUSR_machinename account.

See these for more possibilities:
http://www.aspfaq.com/show.asp?id=2062 - updatable cursor
http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

If you are not getting an 80004005 error, search aspfaq for the number of
the error you are getting.


Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Database Connection - thanks Bob

thank you Bob, once I got away from the ODBC and went to a DNS-less
connection it works great!



www.mtcss.com
"Bob Barrows [MVP]" wrote in message
news:uh7rs5k3EHA.2572@tk2msftngp13.phx.gbl...
> Dino wrote:
> > Hi all, I am using a DSN to connect to the database!
>
> It's probably not the cause of your problem, but this is not a good idea.
> You should be using the native Jet OLEDB Provider:
> http://www.aspfaq.com/show.asp?id=2126
>
> > this connection
> > works great and all is fine - EXCEPT -
> > when I go to another page, it cant open the connection to get more
> > information from the database!
>
> What happens when you try? Error messages? Timeouts? How are we supposed
to
> suggest a solution when you don't describe your symptoms?
>
> > is this the way I have set up the asp
> > coding? or the way the DSN is set up? or the fact that I am using MS
> > Access as my database? it will only allow 1 connection at a time it
> > seems. I require each page to connect to the database to get some
> > sort of information - so as the users move from page to page, I get
> > errors, until the connection is timing out! I added a close to the
> > connection but it still does not work on pages after the first!
> >
> > any ideas? thanks in advance for your help
>
> I can only guess. All users of an Access database require read/write
> filesystem permissions for the folder containing the database. In ASP,
this
> means granting permission to the IUSR_machinename account.
>
> See these for more possibilities:
> http://www.aspfaq.com/show.asp?id=2062 - updatable cursor
> http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors
>
> If you are not getting an 80004005 error, search aspfaq for the number of
> the error you are getting.
>
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

Re: Database connection

Doru Roman wrote on 16 mrt 2006 in microsoft.public.scripting.jscript:

> Thanks Evertjan for the reply.
> The SQL Server is local on my machine (localhost), it is a Windows
> server. I try to use with ASP (server)

[Please quote what you are replying to.
This is usenet, others could want to join in.]

Better follow up to:
news:microsoft.public.inetserver.asp.db
[follow-up set]

in ASP vbscript:



ASP jscript, I am not so familiar with this database-wize,
perhaps look here:

fed>


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)