ODBC to Query Dates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-11-2013 01:19 PM
I have a ASP.NET application building an executing a query against a SN instance using the ODBC driver. Can anyone tell me where some advanced documentation is on the use of this driver? I am finding many issues.
First and foremost - A query I am looking to run matches other successful queries in other forum posts:
Select "INC"."number" "Incident_Number", "INC"."active" "Active", "INC"."incident_state" "Incident_State_Code", "INC"."dv_incident_state" "Incident_State_Desc", "INC"."opened_at" "Opened_Date" From incident "INC" Where 1=1 And (("INC"."opened_at" Between '1/1/2012 05:00:00' and '1/31/2012 05:00:00'))
Results in this error:
ERROR [HY000] [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Error getting the literal value of right operand.[10169]
I dont want to cloud the discussion by mentioning other issues at this time - I may open other forum threads as the need continues.
I am using the SN ODBC Driver - the latest version as of this post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2013 06:12 AM
Apparently my dates must be formatted as yyyy-mm-dd hh:mm:ss or be wrapped in { d [date value]}
This issue is solved....BTW - The direct data site has the documentation for support functionality with this driver.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2015 07:15 AM
got a link to the "documentation for support functionality with this driver" ?