Database connectivity

[Marcelo MGA]

Dear all,

Iam doing my project with database connectivity . the following error is occuring  frequently or some time once in 2 or 3 days .

Error -2147467259 occured at DB Tools Open

Connec (String).vi --> DB Tools Open Connec

(Path ).vi -->OQC:vi-->iconsensor.vi.

Possible reasons

Exception occured in DB Provider for ODBC Drivers,

[MySQL][ODBC 3.51 Driver]Cant connect to MySQL

server on 'localhost'(10048).in DB Tools Open Connec (String).vi -->DB Tools Open Connec.

KINDLY POST YOUR VALID SUGESSTION  FOR AVOIDING ABOVE  ERROR

[ramji]

IAM ALSO HAVING SAME PROBLEM ; CAN SOME ONE HELP ON THE ABOVE QUIERIES:

[Megan B.]

Marcelo & ramji,

This error is actually being generated by the ODBC drivers.  I've spent some time researching it on the web, and it looks like it in all sorts of programming languages and applications.  Unfortunately, I didn't find a solution or workaround for the error.  I searched the Microsoft KnowledgeBases and didn't find any relevant to this particular error so I have submitted the question to Microsoft support.  You may want to do this as well.  I will certainly post any information I hear back from them.

Good luck!
Megan B.
National Instruments

[Marcelo MGA]

i think the problem maybe due to synchronization between the vi's , but iam not having the solution for that.

[Marcelo MGA]

Mr Megan ,

iam using mysql . hope this is nothing to do with Microsoft product.

[Megan B.]

Hi Marcelo,

Sorry about that, I had a lapse of focus.  You are right that this is unlikely to be a Microsoft problem.  However, it still looks like it is an issue with the ODBC drivers.  Searching google I've found people encountering the same error in Python:
http://groups.google.com/group/mailing.database.myodbc/browse_thread/thread/635e32bd80aefb88/e4b7659...)
and more
http://groups.google.com/group/mailing.database.myodbc/browse_thread/thread/406ef72aab160032/5e9ed45.... 

The easiest thing may be to check for this error and try to handle it in LabVIEW (perhaps just clear it and redo the database operation).

Megan B.
National Instruments