I am trying to connect to a MySQL database using code written in VBA in Excel. I am trying to use the LogOnServer method, but keep getting an "Automation Error"
The syntax I am using is as follows:
crxApplication.LogOnServer "MYODBC.DLL", "ServerName", "DatabaseName", "UserID", "Password"
I could not find any examples on using VBA and the LogOnServer method at the Crystal Decisions web site. I also have tried using the P2SODBC.DLL driver.
Has anyone ever tried this or have some code examples of connecting to a SQL database in VBA.
Thank you for your assistance.
The syntax I am using is as follows:
crxApplication.LogOnServer "MYODBC.DLL", "ServerName", "DatabaseName", "UserID", "Password"
I could not find any examples on using VBA and the LogOnServer method at the Crystal Decisions web site. I also have tried using the P2SODBC.DLL driver.
Has anyone ever tried this or have some code examples of connecting to a SQL database in VBA.
Thank you for your assistance.
