Problems with System DSN....

[Smirre]

Hi!

Is there any way to set the connection time on a System DSN??

I'm connection to a Access database from a ASP page using ADO and ODBC (a System DSN). This works when I open the connection for the very first time. But if I try to open a new connection say 20 sekunds later through the same System DSN, I get a driver error. And yes I have closed the first connection by using the close method and setting the object to nothing.

It seems to be some problem with a ODBC setting?? Can this be fixed in some way???

I have tried connecting to the database without any DSN and then it works great.

/Smirre

[JoshT]

This doesn't answer you're question, but use a DSN-less OLEDB connection. You'll get better performance.