logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
treesprite  
#1 Posted : Tuesday, January 23, 2018 2:28:09 AM(UTC)
treesprite

Rank: Newbie

Groups: Registered
Joined: 1/4/2018(UTC)
Posts: 4
United States
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.
epf  
#2 Posted : Tuesday, January 23, 2018 7:03:37 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 576
Switzerland

Thanks: 7 times
Was thanked: 84 time(s) in 81 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

treesprite  
#3 Posted : Tuesday, January 23, 2018 3:56:58 PM(UTC)
treesprite

Rank: Newbie

Groups: Registered
Joined: 1/4/2018(UTC)
Posts: 4
United States
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.
Users browsing this topic
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.