Database connection troubles

phudong3da · April 15th, 2005, 07:10 PM

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.

Imar · April 16th, 2005, 02:37 AM

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.

phudong3da · April 18th, 2005, 12:35 PM

Thanks Imar

phudong3da · April 18th, 2005, 12:53 PM

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

phudong3da · April 18th, 2005, 01:14 PM

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

Imar · April 18th, 2005, 01:26 PM

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?