error- Labview dataconnectivity toolkit with mysql.

[varshashastri]

Hi

I Installed mySql, Mysql connector odbc and also labVIEW-data connectivity toolkit and read this post- http://digital.ni.com/public.nsf/allkb/47A8CF66D5E3C8CC8625720A006139D6..

but even after I followed the procedure, I am getting the following error:-

Error -2147467259 occurred at NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Create Table.vi->Create DatabaseTable.vi

Possible reason(s):
ADO Error: 0x80004005
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 3.51 Driver][mysqld-5.1.42-community]No database selected in NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Create Table.vi->Create DatabaseTable.vi

I was just trying to open a connection and close connection. But I am getting the error. Can anybody please help me out?

[muks]

this should help

[smercurio_fc]

---

muks wrote:
this should help

---

How, exactly? Is the user running Windows 7 64-bit and trying to use the 32-bit version of the ODBC program? Is the user actually getting the same error message (NO)? Muks, your contributions are many, but sometimes you post links which have no bearing on the subject. It's as if you're jost posting links for the sake of posting. This leads users down blind alleys, as they would have been in this case. 

[danny_t]

Muks,

I have been battleing with his poblem for a while today and tha Win7 64 bit 32 bit situation was my problem so thanks for posting the link

[mindsclay2]

I am getting the error on only 1 computer while all the others that don't show it are clones. If it were a 64-bit/32-bit issue, why don't the other 32-bit computers have the same error? Also, the error is happening in only 1 .VI while using the same database code as other .VIs that don't show the error. Narrowed down but there is still no explanation for the isolated error.

[livermor]

Hi

I am getting the same error accessing a server odbc with a 64bit computer. How can I fix this problem? Any ideas?

[InfiniteNothing]

I ran into this error and found out you have to use "USE" to select which database you are trying to talk to.

USE documentation: http://dev.mysql.com/doc/refman/5.0/en/use.html

Here's some test code I wrote that adds happyTable if it doesn't already exist.