Database

18-Jul-02 8:12

Greetings,

I am trying to connect to a ms access db remotely, and I keep getting a file not found error.
Does anyone know what I am doing wrong?

Here is my connection string like what I am using:
------------------------------------------------------------
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = http://Myserverblah/somedir/mydatabase.mdb";

The file exists on the server, and I can actually download it via a browser, so
it appears that there is no apparent security problem. I have tried putting the mdb file in the root web directory, and I have tried creating a virtual directory to put the database in.

I keep getting the error below:
-------------------------------
"Source = Microsoft JET Database Engine"
"Description = Not a valid file name. "

I am new to remote database, so any ideas as to what I am doing wrong would be great.
I think it has something to do with my connection string, but I am not sure.

Thanks in advance!

Jeremy Falcon18-Jul-02 8:35

18-Jul-02 8:35

What's the size of your project? If you are going to have more than a handful of people access this then do not use Access over the web. It's slow! The DB can't grow past 2GB and Access can't handle more than 64K rows in a table.

Bart-Man wrote:
The file exists on the server, and I can actually download it via a browser, so
it appears that there is no apparent security problem.

Never, ever, allow anyone to download your database. Move it out of a public folder pronto. But, do make sure you have write permissions for the folder the MDB is in so it can create a lock file.

Try this for your connection string...

"Provider=MS Remote; Remote Server=http://somewhere.com; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\somewhere\my.mdb;"

If you require a login to the database you can also specify User Id and Password in the connection string.

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

Bart-Man18-Jul-02 8:59

18-Jul-02 8:59

Thanks for your reply, and your suggestions about access db and it's limitations!!!
For now I am stuck using it since only a few people use the db, and they are sticking
to access. Frown | :(

Here's what I did.
------------------
1.) I moved the database from the public folder like you suggested.
2.) Checked the folder to make sure it had write permissions.
2.) Tried the connection string you provided and it worked great!!!
I can now connect to the database!! Smile | :)

*3.) ++My Problem now++: I can't seem to get the recordset to do anything.
I just did a simple query of "Select * from Table1".
and I get the error "Internet Client Error: Invalid Server Response".
I checked, and "Table1" is a valid table within the database

Is this a security setting that I didn't set right?
At any rate thanks for helping me with the connection string.

Jeremy Falcon18-Jul-02 9:12

18-Jul-02 9:12

Bart-Man wrote:
and I get the error "Internet Client Error: Invalid Server Response".

How exactly are you accessing this DB? Is it from a program or within an ASP page or what?

Bart-Man wrote:
At any rate thanks for helping me with the connection string.

No problem. Smile | :)

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

Bart-Man18-Jul-02 9:18

18-Jul-02 9:18

A program...is that the problem should I use an asp page instead?

Jeremy Falcon19-Jul-02 4:49

19-Jul-02 4:49

Bart-Man wrote:
A program...is that the problem should I use an asp page instead?

No, not at all.

Could you tell me what language you are using? RDS (what you are using) over ADO is idenpendent of language, but I'm gonna try and past a code sample for ya.

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

Bart-Man19-Jul-02 7:00

19-Jul-02 7:00

Jeremy Falcon wrote:
Could you tell me what language you are using?

I am using Visual c++ 6.0 to connect to the database.

Cool, thanks for your help! Smile | :)

Jeremy Falcon19-Jul-02 7:58

19-Jul-02 7:58

http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q220152

You'll want to change the connection string, etc. of course.

Bart-Man wrote:
Cool, thanks for your help!

You're welcome. Smile | :)

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

Bart-Man22-Jul-02 5:30

22-Jul-02 5:30

It is weird I used microsoft's sample, changed the connection string, and it still does not work.
I noticed something odd about when I connect a "First-chance exception" ocurrs, but my exception code does not catch it. It appears that an access problem occurs on the server side.

I am trying to configure the rds, so that it will allow access..
After several attempts, it still does not work correctly. An msdn article suggested that I download msadc sdk and use that to test that the Rds is working correctly.

At any rate I think the connection string is right, and my query code was right. But the rds is not setup right.

Jeremy Falcon22-Jul-02 14:34

22-Jul-02 14:34

Bart-Man wrote:
At any rate I think the connection string is right, and my query code was right. But the rds is not setup right.

Ok, if you get the solution I'd love to hear about it. Inquiring minds wanna know. Smile | :)

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

Solution to my problem

Bart-Man25-Jul-02 9:45

Re: Solution to my problem

25-Jul-02 9:45

I figured it out, it was a configuration problem in rds.
It took awhile to find it buried in msdn, and after many cans of mountain dew. Smile | :)

See the link below for the solution:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdhowconfigurerdsonwin2k.asp

Jeremy Falcon25-Jul-02 10:02