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
Simon White  
#1 Posted : Tuesday, June 8, 2021 12:56:56 PM(UTC)
Simon White

Rank: Newbie

Groups: Registered
Joined: 6/8/2021(UTC)
Posts: 4
United Kingdom
Location: Leicester

Hello

New to Seal Report, I've got a basic MS Excel file that I want to use as a test file. In the Server Manager I have:

Database type: MS Excel
Connection type: I have choices of OleDb, ODBC and MS SQL Server
OLE DB Connection string: I've typed in here where the MS Excel file is located

In the connection type I have tried all three, but the Helpers all say error got when checking the connection and format of the initialisation does not conform to spec

Any ideas on what I do? Really could do with a step by step guide if anyone is willing to help me out.
epf  
#2 Posted : Tuesday, June 8, 2021 1:17:09 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
It is now better to use LINQ to query an Excel file:
Add a new LINQ Data Source, then add an Excel Table and set the file path.
You will also be able to define joins with your new table !

There is a sample to check: 201
Simon White  
#3 Posted : Tuesday, June 8, 2021 2:06:46 PM(UTC)
Simon White

Rank: Newbie

Groups: Registered
Joined: 6/8/2021(UTC)
Posts: 4
United Kingdom
Location: Leicester

Thank you so much for your quick response, i shall give it a try!
Simon White  
#4 Posted : Friday, June 11, 2021 12:35:14 PM(UTC)
Simon White

Rank: Newbie

Groups: Registered
Joined: 6/8/2021(UTC)
Posts: 4
United Kingdom
Location: Leicester

I tried this once and it worked, but when i try this again I keep getting the Helpers all say error got when checking the connection and format of the initialisation does not conform to spec.

Is there a problem with a driver or something, really confused as to why it worked on one excel file but not for another. The connection string is pointing in the same place other than the file name is different.

Any ideas?
epf  
#5 Posted : Friday, June 11, 2021 12:47:53 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
The connection string is not used for LINQ Tables...
Just change the 'Excel File Path' property of your Excel table.
Simon White  
#6 Posted : Friday, June 11, 2021 12:48:03 PM(UTC)
Simon White

Rank: Newbie

Groups: Registered
Joined: 6/8/2021(UTC)
Posts: 4
United Kingdom
Location: Leicester

i'm using Excel 365 if that helps?
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.