Forums

This topic is locked

ADO connection problem access 2003

Posted 08 Mar 2004 17:03:30
1
has voted
08 Mar 2004 17:03:30 Jerry King posted:
Hi,
I have a main page that sets a session variable. That session variable is used to filter a recordset on another page accessed via a link on the main page. If I use a DSN connection to Access 2003 (using for testing purposes) the filter works the first time the filtered page is opened. If you hit the back button to the main page and try to go to the filtered page a second time via the link, the filtered page gets an error on the line setting the recordsets activeconnection.

I redid the connection using a custom connect string and the connection tested out fine in the development environment. Of course the fileted page doesn't open at all now. I get this beauty:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xd0c Thread 0xee0 DBC 0x10aabcc Jet'.
/sinksdownunder/ShoppingCart.asp, line 14.

As far s I can tell ,all dreamweaver is doing with this connection is creating a page, connectionname.asp that it dims and sets a connect string. This connectionname.asp is just included in the page that is failing. Where is the dim of a connection object, seting the connnection object string, openning of the connection object, setting recordset .activeconnection=connectionname? When I did this by hand in the past, I could not just say recordset.activeconnection=Connection string.

Why do the programs say conections test out fine in the dev environment, just to blow up when you test the web pages??

Any help greatly appreciated.

Reply to this topic