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
jbiza  
#1 Posted : Monday, March 19, 2018 9:49:28 AM(UTC)
jbiza

Rank: Newbie

Groups: Registered
Joined: 3/19/2018(UTC)
Posts: 2
Czech Republic
Location: Havlickuv Brod

I am reading data from CSV file (Timestamp(date), Value (float)). Connection is fine. I can see corect data in table and also chart is fine.
I have problem when I try create restriction on date (date between 'somedate1' and 'somedate2'). I receive error message "ERROR [22018] [Microsoft][ODBC text Driver] Data type mismatch in criteria expression".
Column Timestamp is set to date format in ODBC.

Knows anybody solution please. Thanks
epf  
#2 Posted : Tuesday, March 20, 2018 11:44:25 AM(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)
this is related to the ODBC Text driver, I do not know if it supports the date time restrictions.
Perhaps the SQL generated must have a special format for datetime.
jbiza  
#3 Posted : Sunday, March 25, 2018 1:23:02 PM(UTC)
jbiza

Rank: Newbie

Groups: Registered
Joined: 3/19/2018(UTC)
Posts: 2
Czech Republic
Location: Havlickuv Brod

Thank you for ansver.
I used construction "where (day(F2) between day('@Date1') and day('@Date2')) and (month(F2) between month('@Date1') and month('@Date2')) and (year(F2) between year('@Date1') and year('@Date2'))". I dont know if it is the best solution but works.
Mactag  
#4 Posted : Friday, March 8, 2019 9:16:27 AM(UTC)
Mactag

Rank: Newbie

Groups: Registered
Joined: 3/8/2019(UTC)
Posts: 3
France
Location: PARIS

Hello,

How to reading data from CSV file ?
what is the connection string to use ?

I'm not able to create a connection to my local file C:\temp\test.csv

Could you help me ? thanks
epf  
#5 Posted : Friday, March 8, 2019 10:12:51 AM(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)
Yes please create first an ODBC Data Source
https://support.microsof...he-microsoft-text-driver

Then from Seal Report, create your connection by using the 'Microsoft OLE DB Provider for ODBC Drivers' and select the source you have created.
Be sure that you are using SR 32bit if you are using 32bit drivers....

Good luck.
Mactag  
#6 Posted : Friday, March 8, 2019 1:56:05 PM(UTC)
Mactag

Rank: Newbie

Groups: Registered
Joined: 3/8/2019(UTC)
Posts: 3
France
Location: PARIS

Thank you for this quick response.
i'm trying right now
Mactag  
#7 Posted : Friday, March 8, 2019 2:12:47 PM(UTC)
Mactag

Rank: Newbie

Groups: Registered
Joined: 3/8/2019(UTC)
Posts: 3
France
Location: PARIS

everything is OK,

15:11:37 Check Data Sources terminated

15:11:37 Youpi, pas d'erreur !

Thank you very much.
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.