[DUG] A problem with ODBCExpress. HELP! :)

[Neven MacEwan]

Struan

Do you have any user defined function calls, I've found functions that 
error can cause strange behaviour, pain of it is they are silent, you 
cant PRINT from them either, The connection just dies

HTH

Neven

Struan Judd wrote:
> We're using ODBCExpress v5.07 to talk to a SQL Server 2000 database.
> 
> Up until recently this all worked just fine.
> 
> However we now get an application hang. (luckily this is against the Testing
> database and Production is running fine)
> 
> We are running a sequence of SQL statements (some SELECTS, some Stored
> procedure calls) though the same THstmt in a single transaction.
> 
> Most run fine, but there is one particular Stored procedure call that runs
> but doesn't appear to pass it's results back through ODBC correctly causeing
> the aforementioned application hang.
> 
> Using SQL profiler I can see that the SQL server has finished processing the
> SQL statement, it's just waiting for the front end application (service
> actually) to retrieve the data rows.
> 
> By judicious placing of logging statements (cause this problem also doesn't
> ocurr in the development environment) I've determined that the SQL execute
> method call is returning and the hang is when the application calls
> "FetchNext" of the ODBC statement handle.
> 
> I've tried using the ODBC trace functionality in the testing environment,
> but this doesn't seem to want to capture the ODBC calls made by Services.
> 
> I've also traced back and reviewed the changes made to the Testing database
> around the time the problem surfaced but they are all unrelated.
> 
> Any other Ideas?
> 
> Unfortunately I can't easily reboot/reinstall the Testing server as it is a
> shared environment box.
> 
> Help?
> 
> Struan Judd                                 Mailto:struan.judd at ecargo.co.nz
> Developer                                   Phone:   +64 (9) 368 9368
> eCargo                                      Fax:     +64 (9) 368 9369
> Visibility - Communication - Measurement    Mobile:  +64 (21) 685 335
> Private & Confidential                      http://www.ecargo.co.nz
> 
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
> 

-- 
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062

New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland

Ph 620 1356
Fx 620 1336