Hi Vaibhav,
Could you please help with the following:
* Downloading the latest Oracle ODBC Driver - Where should the driver be placed?
* Change the settings below and select the proper driver [from the following part of code]:
'----------------------------------------------------------------------------------------
'Initiate database connection
'------------------------------------------------------------------------------
'Specify your driver below
Set conn = New ADODB.Connection
conn.Open "DRIVER={MySQL ODBC 5.2 Unicode Driver}" _
& ";SERVER=" & server_name _
& ";DATABASE=" & database_name _
& ";UID=" & user_id _
& ";PWD=" & password _
& ";OPTION=16427" ' Option 16427 = Convert LongLong to Int: This just helps makes sure that large numeric results get properly interpreted
' & ";DSN=" & DSN_
'MsgBox "Server connection OK" 'Debug
Thanks,
Vinod Krishna
Bookmarks