error while connecting to db

[Anon]

hi,

i'm working with php in a linux box.
the database is IBM db2,
earlier i connect to the db via odbc drivers,
but studdently it is giving a error message while connecting, i dont know why but hoping it is not getting the dsn name from proper file,
i have test the connection with other program and it is working.
my odbc.ini file is in /etc and ODBCINI have the value of /etc
the error message i'm getting is Warning: SQL error: , SQL state $ in SQLConnect in

hoping it is not a driver problem because if it is a driver problem it will give some other error message like [odbc]....

does any one know where php search for dsn?
normally it search in odbc.ini file.

what may be the cause of this error.

any one know this pls advice me

thanks

nedu

[Anon]

hi,

i found it, that is apache is started before the other variables are exported, after i restart the apache it is working

thanks

nedu wrote:

hi,

i'm working with php in a linux box.
the database is IBM db2,
earlier i connect to the db via odbc drivers,
but studdently it is giving a error message while connecting, i dont know why but hoping it is not getting the dsn name from proper file,
i have test the connection with other program and it is working.
my odbc.ini file is in /etc and ODBCINI have the value of /etc
the error message i'm getting is Warning: SQL error: , SQL state $ in SQLConnect in

hoping it is not a driver problem because if it is a driver problem it will give some other error message like [odbc]....

does any one know where php search for dsn?
normally it search in odbc.ini file.

what may be the cause of this error.

any one know this pls advice me

thanks

nedu