Error when using AccessDataSource

Thread View: borland.public.delphi.aspdotnet.components.using

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Kaboose Fri, 09 May 2008 10:24

#48

Author: Kaboose
Date: Fri, 09 May 2008 10:24

24 lines
1415 bytes

Hi,

I get an error when i try to connect to a mdb when using the 
AccessDataSource component.

The errors are :

"The file '~/BioData.mdb' either does not exist or could not be mapped to a 
local file that could be read."
when using root or path relative.

or

"Database schema could not be retrieved for this connection. Please make 
sure the connection settings are correct and that the database is online.

No metadata could be loaded for: MS Jet."

When slecting user specify.

Can someone please shed some light on this matter.

Regards
Shaun Peusschers

Re: Error when using AccessDataSource

#49

Author: John Moshakis
Date: Fri, 09 May 2008 14:45

38 lines
1697 bytes

Kaboose wrote:

> Hi,
> 
> I get an error when i try to connect to a mdb when using the
> AccessDataSource component.
> 
> The errors are :
> 
> "The file '~/BioData.mdb' either does not exist or could not be
> mapped to a local file that could be read." when using root or path
> relative.
> 
> or
> 
> "Database schema could not be retrieved for this connection. Please
> make sure the connection settings are correct and that the database
> is online.
> 
> No metadata could be loaded for: MS Jet."
> 
> When slecting user specify.
> 

Hi Shaun,

I think ~ should be mapped to the root of your project directory at
runtime. If the mdb is there and the connection can't be opened then I
guess it isn't supported at designtime.

The data explorer needs meta data support to be able to see database
schema information and I don't believe ms jet is supported. That would
be why you get "No metadata could be loaded for: MS Jet.""

Cheers,
John

--

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads