MySQL Forums
Forum List  »  Connector/ODBC

ODBC connection failed
Posted by: PK Odendaal
Date: July 04, 2018 01:10AM

This code fails to open the connection although I have tested the ODBC connection under administrative tools.

Dim wsODBC As Workspace
Set wsODBC = DBEngine.CreateWorkspace("ODBCWorkspace", "admin", "", dbUseODBC)
Workspaces.Append wsODBC
Dim Conn As Connection
Set Conn = wsODBC.OpenConnection("Conn1", , , "ODBC;DSN=IBSMSfreestate;")
Dim rs As Recordset
Set rs = Conn.OpenRecordset("accountterms", dbOpenSnapshot)

Options: ReplyQuote

Written By
ODBC connection failed
July 04, 2018 01:10AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.