Seal Report Forum
»
Report Edition
»
Data Source Creation
»
how to connect the string property with the OLE DB Wizard and MySQL?
Rank: Newbie
Groups: Registered
Joined: 10/22/2019(UTC) Posts: 1 
|
Starting with the quick tutorials, I already ran into a problem. I dont know how to edit the Connection String property with the OLE DB Wizard. I want to connect a MySQL database. The following connection string does not work: DATABASE=db_neme: SERVER=127.0.0.1:3306;UID=root;PWD=secret;Provider=SQLOLEDB; How should the connection string look like? Edited by user Tuesday, October 22, 2019 11:24:10 AM(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)
|
For MySQL did you install first the MySQL ODBC driver (32 or 64 bit according to the Seal Report version you are using) ? Then it is a standard OLEDB via ODBC connection, you can google it... Check also https://sealreport.org/f...t.aspx?g=posts&t=305Edited by user Wednesday, October 23, 2019 7:10:19 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Data Source Creation
»
how to connect the string property with the OLE DB Wizard and MySQL?
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.
