Wrox Programmer Forums
|
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) 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 April 15th, 2005, 07:10 PM
Authorized User
 
Join Date: Mar 2005
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database connection troubles

Hi Imar,

It said: "connection was made successfully" when i test the connection between my login page the the database. But when I input username and password in and hit run, it said :

Microsoft JET Database Engine error '80004005'

X:\Database\TheSoccerSite.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/soccer/login.asp, line 14


I've checked "connTheSoccerSite" and saw there're database tables in there. All the files including this "TheSoccerSite.mdb" are residing at my work's server (X:\).

Could you please advise ? Thanks greatly.
 
Old April 16th, 2005, 02:37 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

You can't use X:\ as that drive letter is probably only mapped for your account. When you press the text button, the test is performed under your account, so it succeeds.

However, at run time, the site doesn't run under your account, it runs under IUSR_MachineName where MachineName is the name of your webserver. That account doesn't have the drive letter X mapped.

So, instead of a drive mapping, try a full UNC path like: \\SomeServer\SomeShare\SomeFile.mdb:

connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=\\SomeServer\SomeShare\SomeFile.mdb"


Hth,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old April 18th, 2005, 12:35 PM
Authorized User
 
Join Date: Mar 2005
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Imar

 
Old April 18th, 2005, 12:53 PM
Authorized User
 
Join Date: Mar 2005
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Imar,

The connection was made successfully. But it gave me the below error when I login the login page using "admin" and "admin" for username and password. Cound you please advice ? Thanks.

Microsoft JET Database Engine error '80004005'

The Microsoft Jet database engine cannot open the file '\\cacarqdev1\soccer\Database\TheSoccerSite.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

/soccer/login.asp, line 14


 
Old April 18th, 2005, 01:14 PM
Authorized User
 
Join Date: Mar 2005
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've made sure that the all the database tables are closed. Thanks

 
Old April 18th, 2005, 01:26 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi again,

This sounds like a lot like the issues mentioned in this thread:

http://p2p.wrox.com/topic.asp?TOPIC_ID=29250

You may want to read these two FAQs first:

http://Imar.Spaanjaars.Com/QuickDocId.aspx?QUICKDOC=263
http://Imar.Spaanjaars.Com/QuickDocId.aspx?QUICKDOC=290

They'll explain how to write to network resources like a database.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Mother by Moloko (Track 10 from the album: Things To Make And Do) What's This?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Connection to Access Database reachsevar ASP.NET 2.0 Basics 1 November 28th, 2007 08:56 AM
Database troubles notrosh ASP.NET 2.0 Professional 0 June 13th, 2006 01:20 PM
Database connection fogofogo Classic ASP Professional 2 December 1st, 2005 12:45 PM
Need help w/ Database connection brkd63 Dreamweaver (all versions) 1 August 5th, 2004 01:14 AM





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