MySQL Forums
Forum List  »  Microsoft Access

vb to use mysql
Posted by: Hernan Gonzalez
Date: October 06, 2004 09:27PM

Hi, I'm a newbie in this matter but hopefully someone can help me. Here's the problem:

I have this visual basic application that connects to a ms access database via an ODBC connection, I have already exported the tables an data in such access file to a mysql database using "MyAccess" and configured the odbc connection to use myodbc with the server/user settings. When I start the vb application the following error appears: "[mysql][odbc 3.51 driver][mysqld 3.23.58]Table 'database.table' doesn't exist "

two things:
---- in the original and the exported database, the table names are uppercase letters.
---- changing all the table names to lowercase doesn't work either, a different error message appears.

what' going on here? what extra steps should have been taken?

I really appreciate any help

Options: ReplyQuote

Written By
vb to use mysql
October 06, 2004 09:27PM
October 07, 2004 08:56AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.