Rank: Newbie
Groups: Registered
Joined: 3/19/2018(UTC) Posts: 2  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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 653  Thanks: 9 times
Was thanked: 111 time(s) in 108 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.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/19/2018(UTC) Posts: 2 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.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/8/2019(UTC) Posts: 3  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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 653 Thanks: 9 times
Was thanked: 111 time(s) in 108 post(s)
|
Yes please create first an ODBC Data Source https://support.microsof...he-microsoft-text-driverThen 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.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/8/2019(UTC) Posts: 3 Location: PARIS
|
Thank you for this quick response.
i'm trying right now
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/8/2019(UTC) Posts: 3 Location: PARIS
|
everything is OK,
15:11:37 Check Data Sources terminated
15:11:37 Youpi, pas d'erreur !
Thank you very much.
|
|
|
|
|
|
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.
