Hello there,
i want to connect to MySQL database using VEE and MySQL ODBC.
I have already installed the MySQL ODBC driver and also managed to open the database easily with Excel and Matlab.
However i didn't find any example which shows how to do this in VEE , the only thing i found is "SQLServerUsingADO.vee"
that shows how to connect with SQL Server and not mySQL.
Does anyone have a VEE example that can do this?
If anyone can help with this I would really appreciate
Thanks,
Hi Omar,
It shouldn't really matter until you start sending SQL commands as to which database engine provider you're using as you are going through ODBC. That ( as you probably already know ) provides a common layer to connect to and extract data from any data source.
I'd start with Database -> Initialize Database -> Initialize
which should get you connected given the appropriate connection string: that might need a username/password included depending on how you have the link set up. On that, I'd recommend using Windows authentication instead i.e. once the user is logged in they can connect to the db server with no further credentials. It is worth having a look at the description for the 'Select Data Provider' object.
If all that fails, I'd point you to the System.Data.Odbc.OdbcConnection .NET class which is the DIY way to go.
HTH,
Mike Watts