• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 642
  • Last Modified:

ODBC call failed - ODBC with Unidata


I am using MS Access and ODBC to Unidata but when I run a parameter query it gives me the following error: ODBC call failed. If I hard code the parameters on the query criteria it runs ok,  but if I get interaction with the user it gives me the error.
If I am using the date criteria  :
 Between #9/1/04# and #9/30/04#
If works fine, but if I use the parameters in the query criteria:
 Between [Start Date:] And [End Date:]
Then I get the error: ODBC call failed
Please help.

My plan B is to try to configure Pervasive SQL Server v8.0 with ODBC conenction to Unidata.
Pervasive SQL Server will be in one server and Unidata is on another one. And also to be able to create SQL link databases to Unidata ODBC or import in automated mode from Unidata to SQL-Pervasive in daily basics.
 
0
JCB01
Asked:
JCB01
1 Solution
 
jdlambert1Commented:
I suggest building the SQL in a string variable, then passing that value. That way you can use the user input, but avoid the [Start/End Date:]'s.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now