Rank: Newbie
Groups: Registered
Joined: 1/4/2018(UTC) Posts: 4  Location: Little Rock
|
Can the MSDASQL.1 be used/installed on a MS Windows 2012 R2 Server? (The version I have found is for Windows Server 2003)
Is there any other "provider" that can be used in making connections to mySQL?
I have "MySQL Connector/ODBC" installed and am successful in connecting to my mysql database from there. I am just not sure how to setup the appropriate connection string in SEAL REPORT.
Can you provide some assistance?
Thanks
FYI: No problems in connecting to MS SQL Server databases and have already delivered reports to my manager.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
For MySQL, you first have to install a 32bit ODBC driver on your server. Then using the 32bit ODBC Manager, you can create a Data Source connecting to your MySQL server (better use a System Data Source so it can be used by different user). Finally, using SR, create a connection using the OLEDB Driver for ODBC, then click next and choose the Data Source you have previously created. Concerning MS SQL Server Drivers, they are normally installed with the Windows OS.... Edited by user Tuesday, January 23, 2018 7:05:23 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 1/4/2018(UTC) Posts: 4 Location: Little Rock
|
Yes, I had installed 64 bit MySQL Connector and the 64 bit Visual C++ Redistrib.
Once I installed 32 bit for both and setup the ODBC "System DSN" ... I was good to go!
Thank you very much for your quick reply epf.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
