Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ODBC call failed - ODBC with Unidata

Posted on 2004-10-02
3
Medium Priority
?
637 Views
Last Modified: 2010-08-05

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
Comment
Question by:JCB01
3 Comments
 
LVL 15

Accepted Solution

by:
jdlambert1 earned 1000 total points
ID: 12209480
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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question