Seal Report Forum
»
Report Edition
»
Data Source Creation
»
I dont connect to MySQL using Serl Server Manager
Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14  Location: 江苏 Thanks: 2 times
|
I can create a MySQL connection，but dont create table from catalog.
the error is "ERROR 22018 MYSQL ODBC 5.3a Driver Mysqld-5.6.29-log"
Pls help me.
Provider=MSDASQL.1;Persist Security Info=True;Data Source=pu;Initial Catalog=pudev
[2016/11/10 9:50:11] Database connection checked successfully.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Sorry, we have a poor experience with MySQL, I know that it has worked (probably with an older version of the ODBC driver).
You can still create your tables manually...
Could be nice if someone can look at it to integrate the fix in the coming version....
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14 Location: 江苏 Thanks: 2 times
|
Now i can add table but dont use to create table from catalog.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
I made a quick test with the MySQL default database and the ODBC Driver and it works fine: it reads the database catalog and creates the tables and columns. Here is my connection string: Code:Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=mysql;SERVER=localhost;UID=root;DATABASE=sakila;PORT=3306"
|
|
|
|
|
|
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: SEAL REPORT works ~great~ in connecting to MS SQL Server databases and have already delivered reports to my manager. Yay!!
|
|
|
|
|
|
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.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/14/2019(UTC) Posts: 3  Location: Amstelveen
|
Hi EPF,
I seem to have a similar problem:
I succeeded to run my report in the way you described, however when I wanted to publish it via IIS on the web it did not work.
I got the message:
Error detail:
Error opening database connection:
ERROR [IM002] [Microsoft][ODBC-stuurprogrammabeheer] The name of the source has not been found and there is no driver found [... translated from Dutch]
Do you have any tips?
Marten
|
|
|
|
|
|
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 the Web Report Server, first reboot your server so IIS can load your new installed drivers...
then check the identity of the user running your Web application (this is more IIS stuff), by default the Web Report Server is published on an application pool using LocalSystem user.
this user must have the rights to connect to the database...
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Data Source Creation
»
I dont connect to MySQL using Serl Server Manager
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.
