Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 server

[Roman S. <rom...@gm...>]

tom interface wrote:
> Thanks Roman for your answer
> 
> I put a dump generated when the first database connection is opened on my 
> application on : www.interface.nc/dump.zip
> 
> When i activate debug in ODBC manager the log is always empty ?

Not sure. It must trace every function call. I'm in linux now. When I 
will in Windows I'll try to open your dump and will take a look into 
ODBC debug again.

> 
> Tom
> 
> ----- Original Message ----- 
> From: "Roman Simakov" <rom...@gm...>
> To: <fir...@li...>
> Sent: Friday, December 04, 2009 8:42 PM
> Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 
> server
> 
> 
>> Hi tom!
>>
>> It would be good to look at call stack. Can you get it on your machine?
>> Maybe userdump can help. Also odbc debug can be useful. It can trace
>> call of every function in ODBC driver with parameters.
>>
>> Without that it's difficult to understand what's happen.
>>
>>
>> --
>> Roman Simakov
>>
>> tom interface wrote:
>>> Hi,
>>>
>>> i'm french so excuse me for my english.
>>>
>>> I have a classic ASP application with Firebird server (1.5.5.4926) with
>>> ODBC 2.0.0.148
>>>
>>> There's only one server for IIS and Firebird and i've 60 users, and each
>>> have his connection string (so i can't use pooling)
>>>
>>> My connection string is :
>>>
>>> "Driver=Firebird/InterBase(r)
>>> driver;Uid=mylogin;Pwd=mypass;DbName=127.0.0.1:d:\database\xxxxxx.fdb"
>>>
>>> Sometimes, when the connection is opened i have intermittent 800a01fb
>>> error and by day it represents hundreds of error 500. I look in the IIS
>>> log and when i try the page that cause error, no problem for me. Users
>>> told me that when they refresh sometimes it works sometimes not.
>>>
>>> I'm using lots of response.redirect but always close and set nothing for
>>> connection and recordset before.
>>>
>>> I use debugdiag and have always this message (sometimes very quickly
>>> when i open connection to firebird):
>>>
>>> In w3wp__PID__2620__Date__12_02_2009__Time_01_19_58PM__499__First Chance
>>> Access Violation.dmp the assembly instruction at
>>> *OdbcFb!SQLSetDescFieldW+5478* in *C:\WINDOWS\system32\OdbcFb.dll* from
>>> *IBPhoenix Inc* has caused an *access violation exception (0xC0000005)*
>>> when trying to *read from* memory location *0x0c641000* on thread *67*
>>> <mhtml:file://C:\Program
>>> Files\DebugDiag\Reports\CrashHang_Report__PID_2620__PID_5852(1_dumps)__120220091506084.mht#2620:25382Thread4468>
>>>
>>> I look for a solution for a long time but can't find a solution to solve
>>> this
>>>
>>> Can anyone help me ?? security rights problem ? Too many connections ?
>>>
>>> I hope someone can help
>>>
>>> Thanks
>>>
>>> Tom
>>>
>>