Intermittent odbc_connect() problem with iodbc/openlink

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm having intermittent problems with odbc_connect().  Here's the
situation....

 

I'm trying to connect to a Sybase Adaptive Server Anywhere database
running on Win2K from my web server using Solaris, Apache, PHP, iODBC,
and OpenLink's ODBC universal data access driver for MSSQL/Sybase.
About 75% of the time, my php scripts talk to the Sybase system fine.
However, the other 25% of the time nothing really happens.  IE reports a
"Page cannot be displayed" error, while Firefox acts like it may do
something for a fraction of a second, but then just stays on the
currently loaded page.

 

I have tracing turned on in iODBC.  When things work fine, a lengthy
trace file is generated and everything seems to be in order.  When
things don't work, all I get is the following:

----------------------------------

 

** iODBC Trace file **

** started on Wed Feb 16, 20:29 **

 

 

Application     00000001 ENTER SQLAllocEnv

                SQLHENV         * 2f3158

 

Application     00000001 EXIT  SQLAllocEnv with return code 0
(SQL_SUCCESS)

                SQLHENV         * 2f3158 (30af78)

 

Application     00000001 ENTER SQLAllocConnect

                SQLHENV           30af78

                SQLHDBC         * 2f315c

 

Application     00000001 EXIT  SQLAllocConnect with return code 0
(SQL_SUCCESS)

                SQLHENV           30af78

                SQLHDBC         * 2f315c (2dbbc8)

 

Application     00000001 ENTER SQLConnect

                SQLHDBC           2dbbc8

                SQLCHAR         * 30c7e0

                                  | PF32
|

                SQLSMALLINT       -3 (SQL_NTS)

                SQLCHAR         * 2f5b10

                                  | viewaward
|

                SQLSMALLINT       -3 (SQL_NTS)

                SQLCHAR         * ff0c4a28

                                  | ****
|

                SQLSMALLINT       -3 (SQL_NTS)

 

----------------------------------

 

No connect errors are generated either in the trace file or in the
browser's display.  It's almost as if the process just dies without
saying anything about why it happened.

 

Any ideas?

 

Thanks,

Jim

__________________________________________
Jim Crone
Electronic Communications Manager

Bradley University
E-mail: jcrone@xxxxxxxxxxx
Phone: 1-800-447-6460
Fax: 309-677-2797

Discover a university experience that will prepare you for a lifetime of
personal and professional achievement at:
http://admissions.bradley.edu/ <http://admissions.bradley.edu/> 

 


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux