Labview 32Bit running on 64Bit causing issues with connecting to database

[Stigwood]

Hi All.

Ok, Windows 7, LV 32Bit Profesional installed.

Wampsever latest

ODBC latest installed

ODBC Latest

Created a Database (MySQL) within PHPMYADMIN. using a DSN name trying to view all of the fields in the table, I get teh following error.

1st - it was mis match in architecture, (so I upgraded to all teh latest versions) now I get teh following:

Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'James'.  Make sure it exists and that its name is spelled correctly. in ADO Connection Execute.vi->SQL Execute.vi->GetSQLTable.vi->Send&RecieveSQL.vi

I am trying to run the ODBC from the 64 bit file version. But still no joy...................

Any ideas would help loads.

Thanks

James

[Rhys - AE]

Hi James,

Here is what Microsoft has to say on the issue in Access. I hope it proves helpful.

http://support.microsoft.com/kb/287696

I will let you know if I find aynthing else specific to ODBC.

[Wart]

Are you using the right driver?  "ODBC Microsoft Access Driver" wouldn't be my first choice to connect to a MySQL database, though it might work.

Are you configuring your connection in the ODBC Data Source Administrator?  Do other reads or writes to the database work?

[Stigwood]

I Have actually moved on to a 32Bit machine - due to teh headaches that have been caused.

The ODBC connection was correct - and this was able to connect to the Database created. The last problem faced was teh JET 4.0 issue which looking into is also tied down to a 64Bit platform issue.

If there is another connection prgram that would work Ia m happy to try that.

James