Connection string to mysql using excel VB6 without ODBC

0.00/5 (No votes)

See more:

I am developing excel form that is connected to MySQL db using the following connection string:

oConn.Open "DRIVER={MySQL ODBC 5.3 UNICODE Driver}; Server=10.153.36.212;Database=CDMS;User=****ziz;Password=###990001992; OPTION=3"

it is working fine on my computer

But when I run the form on other computer
it requires that ODBC to be created on that computer which is impossible because there are more than 3000 computers running in the company

Any help will be highly appreciated

What I have tried:

oConn.Open "DRIVER={MySQL ODBC 5.3 UNICODE Driver}; Server=10.153.36.212;Database=CDMS;User=****ziz;Password=###990001992; OPTION=3"

It is working fine on my computer but it does not in other computers

Posted 3-Sep-16 20:57pm

sakher

Add a Solution

Comments

Richard MacCutchan 4-Sep-16 3:47am

You need to install the ODBC driver on all computers that wish to access the database. A better solution would be to use SQL Server, but you will still need to install software on each system.

sakher 4-Sep-16 5:05am

any other solution like using MS Access DB instead of MySQL

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Richard MacCutchan	50
Pete O'Hanlon	50
Andre Oosthuizen	45
goldli88	35
Rob Philpott	10

Richard Deeming	230
Pete O'Hanlon	130
Richard MacCutchan	110
OriginalGriff	100
M-Badger	50

Connection string to mysql using excel VB6 without ODBC

Add your solution here

Preview 0

Connection string to mysql using excel VB6 without ODBC

Add your solution here

Preview 0

Existing Members

...or Join us