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

Notification

Icon
Error

Options
Go to last post Go to first unread
meng  
#1 Posted : Tuesday, October 22, 2019 8:18:31 AM(UTC)
meng

Rank: Newbie

Groups: Registered
Joined: 10/22/2019(UTC)
Posts: 1
Netherlands

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

epf  
#2 Posted : Wednesday, October 23, 2019 7:08:03 AM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 167 time(s) in 161 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=305

Edited by user Wednesday, October 23, 2019 7:10:19 AM(UTC)  | Reason: Not specified

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.