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


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


Sorry, only registered users may post in this forum.

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.