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

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

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
>