Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 12th, 2003, 11:57 AM
Registered User
 
Join Date: Jun 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cannot make connection after opening Access

Guys:

Just hoping you can point me in the right direction. I have a new laptop, XP Pro with Office 2000, Access (9.0.3821 SR-1), IIS server, VBScript. Things are working OK on the desktop.

All scripts run fine. BUT, if I even open and close the Access DB directly (via Office 2000/Access), the connections no longer work. (the script can utilize the DB, opening it that way:

"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 0xa2c Thread 0xb94 DBC 0x1010064 Jet'."

I don't believe I should take this error message too literally. I also get it if I leave a slash out in the connection string syntax. Info on this error talks about running regedit. I have solved most problems related to this error by making less drastic changes.

I've also gotten an "undetermined source" error or something like that.

I've looked around the forum for similar problems and saw some things about NTFS permissions and such, but I'm not sure they apply.

Would like to get some ideas about where to start. (If you do suggest things about XP security, please provide as many details as you have the patience for. That's pretty new to me.)

Thanks.

Joe


Joe G
 
Old September 23rd, 2003, 04:22 PM
Friend of Wrox
 
Join Date: Sep 2003
Location: Minneapolis, MN, USA.
Posts: 171
Thanks: 0
Thanked 1 Time in 1 Post
Default

Have you tried a DSNless connection?


 
Old September 29th, 2003, 08:42 AM
Registered User
 
Join Date: Jun 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dave:

Hey, you're the only one on 3 forums who has offered a guess. I've tried all the connections: DSN, string and both with and without using an application variable in global.asa.

I think I'm going to get Office XP and see if that makes a difference.

Joe

Joe G




Similar Threads
Thread Thread Starter Forum Replies Last Post
opening Websites & make log of sites visited ashwanisrivas ASP.NET 2.0 Professional 1 November 24th, 2008 09:02 AM
Trouble Opening an Oracle Connection BrianWren Visual Basic 2005 Basics 0 August 31st, 2007 11:40 AM
How to make a connection with access database arshad mahmood Classic ASP Professional 1 April 18th, 2006 03:53 AM
How make an automatic dsn less connection abhisheksud Classic ASP Databases 3 October 7th, 2005 04:51 AM
Can't make Connection Johnny6000 Classic ASP Databases 2 April 20th, 2005 04:32 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.