powerbuilder application running in Linux connecting to mysql

------=_NextPart_000_0005_01C67F5C.9385DC20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have a powerbuilder program using MYSQL database running on a linux =
box. When the program is ran in the windows operating system, it uses a =
predefined DSN to connect to the database. The problem is that when i =
run the program in Linux, I cannot connect to the database even if i =
already installed MyODBC. I even tested the connection of the DSN I =
created in the Linux box and it is successful. However, when I ran the =
program in Linux, I am getting this message : " The allocation of the =
environment handle failed."

thank you for your help


JAY

------=_NextPart_000_0005_01C67F5C.9385DC20--

RE: powerbuilder application running in Linux connecting to mysql

On 24-May-2006 Gestalt Consulting Inc. wrote:
> I have a powerbuilder program using MYSQL database running on a linux box.
> When the program is ran in the windows operating system, it uses a predefined
> DSN to connect to the database. The problem is that when i run the program in
> Linux, I cannot connect to the database even if i already installed MyODBC. I
> even tested the connection of the DSN I created in the Linux box and it is
> successful. However, when I ran the program in Linux, I am getting this
> message : " The allocation of the environment handle failed."
>
> thank you for your help
>
>
> JAY

There is probably some sort of environment variable you need to set up and
export before you run your application - I'd check your powerbuilder docs for
linux. What ODBC driver manager are you using? If it is unixODBC you can add:

[ODBC]
TraceFile = /tmp/sql.log
Trace = yes

to the top of your odbcinst.ini file and it may log further information in
/tmp/sql.log.

Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org