Re: Paradox 11 and sql links to Informix

Am Mon, 18 Feb 2008 13:16:06 -0700 schrieb Rick Rans:

Dirk

Did you give the ODBC driver the same alias name as the SQL Links driver?

If you did give it the same name, do the table names show up differently via
the ODBC driver?

I would have thought that using the same alias for the ODBC driver wouldn't
break the data model, unless the table names change to
"Something.TableName", with the "Something" being a schema name. I would
have though that would also be the case in SQL Links.

As an aside, what version of the BDE and SQL Links did you try?

Rick

"Dirk Schnorpfeil" <D.Schnorpfeil@xxxxxx> wrote in message
news:onycz9wg1s2j.npic9c4aa9ju$.dlg@xxxxxxxxxxxxx
Am Sun, 17 Feb 2008 17:11:20 -0700 schrieb Rick Rans:

Are you trying to use SQL links or an Informix ODBC driver?

Can you use an Informix ODBC driver? I've had compatiblility problems
with
SQL links using Oracle and have found the ODBC driver the way to go to
get
around a number of anomolies.

Just a WAG

"Dirk Schnorpfeil" <D.Schnorpfeil@xxxxxx> wrote in message
news:cua3qjhuxdcl$.1cm7ewvqmanw2.dlg@xxxxxxxxxxxxx
Hi Folks,

i am trying to port an application from paradox 5 to paradox 11 with sql
links to informix. My problem:

Whenever i get an informix error paradox crashes immediate. Informix
ilogin
works and connects to the database. I attached a debugger to paradox and
found out that the crash is in the informix connection library at
_issek64.
But this crash is only with paradox.

Any help desperatly needed!

Thanks, Dirk.

Yes, i tried using the ODBC driver. That one works but all the data models
are lost when switching to the odbc driver. Also the programs do not
behave
the same way as with informix sql links. To get the forms and reports
running again would mean to go through every form and to fix the behaviour
which is too much effort for staying in paradox.

Ciao, Dirk.

Hi Rick,

i use the version that cam with paradox 11. I used the same alias name for
the odbc driver. The problem with the informix odbc driver is that the odbc
driver sets the user name infront of the informix table name (e.g.
"informix.table1") while the sql link only shows the table name. After
switching to the odbc alias (same name) i lost all relational connections
between the tables. When trying to recreate them it simply did no work. I
needed to delete the tables in the data model and add them again to connect
them. This leads to unbound fields that must be bound again to the newly
inserted table.

If anyone can give me a hint how to simply switch to odbc tables i would be
very very glad. Otherwise the effort for porting the solution from paradox
5 to paradox 13 is too high.

Many thanks in advance,

Dirk.
.

Relevant Pages

  • Re: Paradox 11 and sql links to Informix
    ... Did you give the ODBC driver the same alias name as the SQL Links driver? ... Can you use an Informix ODBC driver? ... i am trying to port an application from paradox 5 to paradox 11 with sql ...
    (comp.databases.paradox)
  • Re: Paradox 11 and sql links to Informix
    ... Can you use an Informix ODBC driver? ... SQL links using Oracle and have found the ODBC driver the way to go to get ... i am trying to port an application from paradox 5 to paradox 11 with sql ...
    (comp.databases.paradox)
  • Re: Paradox 11 and sql links to Informix
    ... and left paradox for good.. ... Can you use an Informix ODBC driver? ... SQL links using Oracle and have found the ODBC driver the way to go to ...
    (comp.databases.paradox)
  • Re: Paradox 11 and sql links to Informix
    ... Are you trying to use SQL links or an Informix ODBC driver? ... i am trying to port an application from paradox 5 to paradox 11 with sql ...
    (comp.databases.paradox)
  • RE: infromix license question
    ... I mean, when you buy an IDS its includes free informix connect product, ... to client this is the product that you need. ... Subject: Re: infromix license question ... I don't understand your words "ODBC driver is not charged ". ...
    (comp.databases.informix)