Re: SQR for ODBC connectivity

["Walcker, Paul" <pwalcker@ISD.CO.SAN-BERNARDINO.CA.US>]

I agree with Wayne about the ODBC Spy.  A very nice product.  If you can't
find that, you can turn on ODBC tracing from the ODBC manager and wade
through all of the API calls...not a pretty sight.

If you have an extra 100 dollars and this is a one time transfer between
systems, I would try Microsoft Access.  We have done our entire legacy to
PeopleSoft conversion using Access.  Good response time, user friendly, a
few quircks, but much more managable then SQR.

I examined some ODBC problems generated from SQR workbench a while ago and
wasn't real impressed.  If I had to do it, I would either choose a more ODBC
friendly product or download to a flat file, then use SQR to apply to the
data base.

Paul

> -----Original Message-----
> From: Tom Hippensteel [SMTP:THippensteel@SPECTRUMHEALTH.COM]
> Sent: Monday, November 16, 1998 12:25 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      SQR for ODBC connectivity
>
> 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