Hi
Lets see how to do this to cover all angles :-)

-- PROBLEM
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Everyone should recognize that error - but before responding - please read further :-). there is a sleight twist to the situation.

-- BASIC CONNECT CODE
PHP Code:
Dim Connection As New ADODB.Connection
Dim RecordSet As New ADODB.RecordSet
Connection.CursorLocation = adUseClient
Connection.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & "SERVER=localhost;" & " DATABASE=zp_world;" & "User=root;Password=root;OPTION=3"
Connection.Open 
--- SYSTEM
  • Win 7 x64
  • XAMPP (if you do not know what this is, do not reply)
  • MySQL v5.1.49 Running (as a service)


--- STEPS ALREADY TAKEN
  • Database is MySQL (not MSS SQL or MDF) and populated
  • mysql-connector-odbc-5.2.5-win32 downloaded - Same Error*
  • mysql-connector-odbc-5.2.5-win64 downloaded - Same Error
  • Even tried the mysql-connector-net-6.7.4 (obviously for vb2008+ but never know)


--- REFERENCES ADDED
  • Microsoft ActiveX Data Objects 2.8 Library (actually tried them all 2.0, 2.1,2.5,2.6, 2.7 and 6.1)


I cannot find an old project where I did get this to work(i am sure its not deleted as im a packrat, so I do not have a reference), so I know it works with VB6.
I have several PHP/MySQL projects done successfully. I just wanted to see if I can do this via VB6. (I do not like vb2008+ )

Hopefully someone here can tell me it's a really small error LOL - I've read so many forums and they all say the same thing, so hopefully I provided all those suggestions here to show they did not work.

*I want the final app to work on all systems, so tried the 32bit.