Microsoft access database

[Fadi]

Hi,

I'm new to WebVelocity, and I'm trying to test it using a Microsoft
Access database, which is included as a database platform, but I was
not able to find information on how to configure this connection.

Can anybody help me?

Thanks,

Fadi Mansour

[James Robertson]

For the connect string, use the path to the access file. Username and
passwd should not matter

[Fadi Mansour]

Thanks, I'll try it.

I thought I would have to configure some ODBC connection or something.

Regards,

Fadi Mansour

[James Robertson]

Mm, I think you might be right.  I was thinking of the SQLLite connection.  Go ahead and configure the ODBC connection and use that name

[Fadi]

I did, but pressing "Test login" gives me back "Database not
configuered".

I tested both with and without a username. When no name is supplied,
the field is highlighted with red.

Any other suggestions, or where can I look to find out what's
happening?

Regards,

[Fadi Mansour]

After delving a little deeper into this problem I found out this error
message:

'[Microsoft][ODBC Microsoft Access Driver] Could not find file ''d:
\fadi\WebVelocity\INFORMATION_SCHEMA.mdb''.'

I found this using the debugger after an exception when trying to open
the schema.

The question is: Do I have to put my database file in a specific
location? Or is this a bug?

Thanks,

Fadi

[James Robertson]

Do you have an access database set up when you try this?

[Fadi Mansour]

Yes I do, the database is in another folder that that in the error message, and there's an ODBC user DSN named 'testfadidb'.

In the database definition I used this 'testfadidb' as the address.

I have even tried accessing this database using Glorp directly, and it workded. I could login and execute SQL commands with no errors.