logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


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

Notification

Icon
Error

Options
Go to last post Go to first unread
helppls  
#1 Posted : Thursday, March 24, 2022 2:28:31 PM(UTC)
helppls

Rank: Newbie

Groups: Registered
Joined: 3/24/2022(UTC)
Posts: 7
Pakistan

Thanks: 4 times
Hi,

I am trying to connect a data source to Seal Report Designer to construct a dummy report. I have managed to get a successful connection with both an MS SQL and a MySQL database when I press F7 Check Connection (on both the Server Manager and the Seal Report Designer) however none of the tables present in the database show up. I know it's not a problem of permissions as I am logging in with the root user on MySQL and my windows user on MS SQL which can access the tables from SQL server management studio.

I have used the following connection string for MySQL:
"Server=localhost;Database=test1;Uid=root;Pwd=****;"

And the following connection string for MS SQL:
"Server=localhost;Database=test2;Trusted_Connection=True;TrustServerCertificate=True;"

This seems like an issue with the Seal Report client to me. Any suggestions what I should from here? Are there any SQL data sources that are guaranteed to work? Or any data source that for sure works? Or is it an issue with my setup?

Any help with this will be greatly appreciated.
epf  
#2 Posted : Thursday, March 24, 2022 3:54:07 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Just try the context menu: 'Add Table' or 'Add Tables from catalog...'
The Check the table by using the button [Check Table] or if you select a column [Show Column Values]
thanks 1 user thanked epf for this useful post.
helppls on 4/14/2022(UTC)
helppls  
#3 Posted : Friday, March 25, 2022 4:20:34 AM(UTC)
helppls

Rank: Newbie

Groups: Registered
Joined: 3/24/2022(UTC)
Posts: 7
Pakistan

Thanks: 4 times
Thanks! That worked! The tables are showing up there.
bernardgbailey  
#4 Posted : Monday, March 28, 2022 2:41:03 AM(UTC)
bernardgbailey

Rank: Newbie

Groups: Registered
Joined: 3/9/2022(UTC)
Posts: 2
New Zealand
Location: Hamilton

Hi team,

I'm struggling to understand the logic in starting a new report. Namely, I can create a new connection under the LINQ Sources and that is where I can get to.

I am using an OBDC connection to a MySQL database. When checking the connection [F7] it shows up 'checked successfully',; however I cannot see any tables from this connection. The tutorial is light on detail and appears to be out of date.

Can anyone point me in the right direction, with a youtube video or a working example trace?

All assistance is much appreciated.

Cheers
Bernard

Edited by user Monday, March 28, 2022 2:49:58 AM(UTC)  | Reason: Not specified

bernardgbailey  
#5 Posted : Monday, March 28, 2022 2:46:07 AM(UTC)
bernardgbailey

Rank: Newbie

Groups: Registered
Joined: 3/9/2022(UTC)
Posts: 2
New Zealand
Location: Hamilton

Definition:
Name = CDHTEST
Database Type = MySql
Connection Type = Odbc
ODBC Connection string = CDHTESTUSER;DATABASE=CDHTEST
Date Time Format = yyyy-MM-dd HH:mm:ss

Security:
User name = root
Password = ......

Helpers:

Information = 28/03/2022 3:26:02 pm] Database connection checked successfully.
epf  
#6 Posted : Friday, April 1, 2022 10:16:46 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
If you have a MySQL database, you should use an "SQL Data Source" and not a "LINQ Data Source".
Check https://sealreport.org/Tutorials#lineTutorials_1
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.