Re: SQR for ODBC connectivity

[Fredrik Mansfeld <fredrik@ABARIS.SE>]

Tom,

at my company we are using SQR 4.3.2 for ODBC in an Windows NT environment.
We soon ran into problems when calling stored procedures and I had a rather
lengthy conversation with the technical support department at SQRiBE. They
had no solution for us. Here are what they finally said:

Me:
"Our systems need ODBC 3.5 to run. Doesn't SQRW.EXE support ODBC 3.5? If
not, when will it do?"

SQRiBE Technical Support:
"I don't think we ever will because there are too many problems with it."


To me it seems like SQRiBE has given up ODBC as a supported method to access
databases.

Regards,
Fredrik Mansfeld


> 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 tothe 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