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

[tom i. <to...@in...>]

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

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



__________ Information from ESET Smart Security, version of virus signature database 4656 (20091202) __________

The message was checked by ESET Smart Security.

http://www.eset.com