Rank: Newbie
Groups: Registered
Joined: 5/18/2015(UTC) Posts: 2 
|
I have tried to use the OLEDB (and ADODB?) connectors with this tool but I have no idea whether it's finding the drivers or what the connection string should look like. Curiously there is not mention of mysql anywhere. I am assuming it should be supported via generic interfaces at least. Has anyone tried it? Edited by user Monday, May 18, 2015 1:31:15 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
You can connect with SR to MySQL through an ODBC driver... You first have to download and install the ODBC MySQL driver 32bit version from https://dev.mysql.com/downloads/connector/odbc/Then create an ODBC Data Source using odbcad32.exe (you have to use the 32bit version, typically C:\windows\syswow64\odbcad32.exe on a 64bit machine) Finally create a Data Source in your Report or in the Server Manager with a connection using the OLE Preovider for ODBC and select the data source created. You connection string will look like: Code:Provider=MSDASQL.1;Persist Security Info=True;Data Source=mysql;Initial Catalog=sakila
where mysql is the ODBC Data Source Name created previously and sakila is the database name. I hope it helps. Edited by user Monday, May 18, 2015 2:49:04 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 5/18/2015(UTC) Posts: 2
|
Thanks. I didn't have obdcad32.exe there but it worked when I started ODBC Connection Manager from the control panel after searching about it online. The connection worked fine with the parameters you said. Now I have to see about how to use this program. Thanks a lot.
|
|
|
|
|
|
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.
