Paradox 11 and sql links to Informix

#1

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.

#2

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 (AT) web (DOT) de> wrote

Quote:

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.

#3

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 (AT) web (DOT) de> wrote

Quote:

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.

#4

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 (AT) web (DOT) de> wrote

Quote:

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.

#5

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 (AT) web (DOT) de> wrote

Quote:

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.

#6

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 (AT) web (DOT) de> wrote

Quote:

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.

#7

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 (AT) web (DOT) de> wrote

Quote:

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.

#8

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 (AT) web (DOT) de> wrote

Quote:

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.

#9

Am Sun, 17 Feb 2008 17:11:20 -0700 schrieb Rick Rans:

Quote:

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 (AT) web (DOT) de> wrote in message
news:cua3qjhuxdcl$.1cm7ewvqmanw2.dlg (AT) 40tude (DOT) net...
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.

#10

Am Sun, 17 Feb 2008 17:11:20 -0700 schrieb Rick Rans:

Quote:

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 (AT) web (DOT) de> wrote in message
news:cua3qjhuxdcl$.1cm7ewvqmanw2.dlg (AT) 40tude (DOT) net...
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.