Re: SQR for ODBC connectivity

[Wayne Ivory <wivory@WSL.COM.AU>]

Tom,

No experience in SQR for ODBC, but some general ODBC suggestions:

Microsoft has a utility called ODBC Spy that lets you see what messages are being passed.  If it's not already on your system I imagine you can download it from their web site.

Also the reason you might be getting a dialog is if you haven't provided all/enough of the parameters for the ODBC connection to complete.  Different drivers use different keywords, and they are usually delivered with a help file if you go looking for it.

HTH

Wayne Ivory
Information Services
Westralian Sands Limited


>>> Tom Hippensteel <THippensteel@SPECTRUMHEALTH.COM> 17/11/98 4:24:46 am >>>
I have the task of selecting data from a legacy database called HP
TurboImage and inserting it into an Oracle7 database.  I have been told by
a SQRIBE Technical gentleman that SQR for ODBC will do the job.  I am
evaluating a copy of Visual SQRIBE which contains Personal SQR for ODBC
V4.3.2.1.  I am simply trying to select records from the legacy database
and insert them into the Oracle7 database.  On pg. 51 of the SQR Language
reference version 4 manual I find the -DBconnection string (ODBC) argument.
 It uses the argument as follows:
DSN=data_source_name[;keyword=value[keyword=value[;...]]]
I have ODBC drivers for both the legacy database I am selecting from, and
the Oracle7 database I am writing to.
When I enter these arguments on the BEGIN-SELECT and BEGIN-SQL lines, I get
the dialog box for my Windows 32 bit ODBC drivers and asks me to select an
ODBC driver.  I thought I selected the ODBC driver in the BEGIN-SELECT and
BEGIN-SQL argument          -DB.  Oh, I just learned that there is a bug
(4748) in the BEGIN-SQR -DB argument:  you have to set a string variable to
the argument string and use the string variable in the -DB argument...but
guess what?  Doing this, I still have the same problem.

Can anyone help me out there...anyone with SQR for ODBC experience?


Tom Hippensteel
Applications Specialist
thippensteel@spectrumhealth.com 
314-919-9807