473,327 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

problems opening db

Hi!

I'm woking on my cms sytem.

I want to do this:

My admin system lies on one domain on the server. eg. d:\binaer\admin\

When the clients open the admin page, the system opens the clients database.
eg. d:\clientsdomain\db\
But when I try to open a database wich is not on the same domain, BUT on the
same harddisk I get this error:
Microsoft JET Database Engine error '80004005'

Not a valid file name.

/nova/execute_login.asp, line 30

I know it works to open a database from anoter iis accont, because I have
tried to do this with
http://www.aspcode.it/store/store.as...showprod&id=15

With the database editor I can browse the whole harddisk, and open wich ever
database i want to....

The code I used to open the database looks like this:

AdoConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=d:\fagernesweb.no\sites\centrumur\nova\_db\ db.mdb"

cn.Open(AdoConnection)

Then I get the error

Microsoft JET Database Engine error '80004005'

Not a valid file name.

/nova/execute_login.asp, line 30
Jul 19 '05 #1
2 1244
Well, the error is pretty self-explanatory. d:\clientsdomain\db\ is not a
filename, that's a folder. If you are trying to open an Access database,
you need to give it the filename, e.g. d:\clientsdomain\db\somefile.mdb
AdoConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=d:\fagernesweb.no\sites\centrumur\nova\_db\ db.mdb"


Are you sure this file exists? Can you navigate to it on the same machine
using Windows Explorer? Is d:\ on the same machine or is it a mapped drive?

--
http://www.aspfaq.com/
(Reverse address to reply.)
Jul 19 '05 #2
hmm got it right now...
the strangest thing...
It did not accept the \ slashes, but only the / slashes...
So I just changed it to / slashes, and the code worked :)

But thanks for the help :)

"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:uL**************@TK2MSFTNGP09.phx.gbl...
Well, the error is pretty self-explanatory. d:\clientsdomain\db\ is not a
filename, that's a folder. If you are trying to open an Access database,
you need to give it the filename, e.g. d:\clientsdomain\db\somefile.mdb
AdoConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=d:\fagernesweb.no\sites\centrumur\nova\_db\ db.mdb"
Are you sure this file exists? Can you navigate to it on the same machine
using Windows Explorer? Is d:\ on the same machine or is it a mapped

drive?
--
http://www.aspfaq.com/
(Reverse address to reply.)

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Mark Sargent | last post by:
Hi All, did anyone have problems opening my previous posting, as it had Japanese characters in it..? Cheers. Mark Sargent.
4
by: hall | last post by:
Hi. I ran across a bug in one of my problems and after spending some time tracking it down i found that the problem arose in a piece of code that essentially did this: ----------- ifstream...
5
by: Shawn Modersohn | last post by:
For the script: <script language="JavaScript"> function pullPage(){ var arrayLength=document.teamSelectionF.teamSelectionS.length; var pageNav = new Array(arrayLength); var...
55
by: drhowarddrfine | last post by:
I'm working on a web site that could use some control using js but am concerned about what problems I may have with potential users having their js turned off. Has anyone had any serious problems...
0
by: Rupreet Singh | last post by:
Hi! Is the relaying properly configured. Try opening the relaying on your server. I got the problem and after opening the relaying on the local server, it got solved! Try it! Regards Rupreet ...
10
by: ste | last post by:
Hi there, I'm trying to query a MySQL database (containing image data) and to output the results in a HTML table of 3 columns wide (and however many rows it takes) in order to create a basic...
1
by: electrixnow | last post by:
Help!, I need to compile this code with static libs so it run on another XP machine that does'nt have MS Studio installed. When I compile now I get an ERROR: 1>------ Rebuild All started:...
2
by: Mike | last post by:
Hi, I am new to C and having problems with the following program. Basically I am trying to read some files, loading data structures into memory for latter searching. I am trying to use structres...
0
by: Alexnb | last post by:
Okay, so what I want my program to do it open a file, a music file in specific, and for this we will say it is an .mp3. Well, I am using the system() command from the os class. The problem I am...
34
by: Alexnb | last post by:
Gerhard Häring wrote: No, it didn't work, but it gave me some interesting feedback when I ran it in the shell. Heres what it told me: Traceback (most recent call last): File...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.