firebird-odbc-devel — All about development of Firebird ODBC driver donated by IBPhoenix

[Firebird-odbc-devel] Problem with special transaction settings

[Marco H. <mh...@de...>]

Hello,

 

up to now we used the Gemini ODBC driver within our software successfully.
Due to it seems that this driver is not supported anymore we tested the
native ODBC driver with our software. We had some problems with a special
requirement:

 

It exists a situation to get a global lock to some tables. We do this by
using some special transaction settings. Here the statement:

 

#define LOCK_STMT (UCHAR*) "set transaction READ WRITE NO WAIT READ
COMMITTED RESERVING  ch_pos FOR PROTECTED WRITE, ch_pos_charge FOR PROTECTED
WRITE, ch_daten FOR PROTECTED WRITE, wb_prg_run FOR PROTECTED WRITE,
wb_schritt_run FOR PROTECTED WRITE, auftrags_daten_run FOR PROTECTED WRITE,
cmd FOR PROTECTED WRITE"

 

#define LOCK_STMT (UCHAR*) "set transaction READ WRITE NO WAIT READ
COMMITTED RESERVING " \

                                     " ch_pos FOR PROTECTED WRITE"
\

                                     ", ch_pos_charge FOR PROTECTED WRITE"

 

SQLExecDirect(hStmt, LOCK_STMT, SQL_NTS);

 

The execution of this statement is possible, but the following prepare of
any statement fails:

 

FEHLER: in SQLxxx call: E:\Tool Projects\odbc-test\test\dbcnv.cpp line 191:
sqlstate HY000; rsqlcode 4294966395; [ODBC Firebird Driver][Firebird]invalid
parameter in transaction parameter block 

table ch_pos is not defined

 

 

Is this transaction setting not supported?

 

Thanks in advance,

 

 

Marco Held

 



-- 
***********************************************************************
*    demig Prozessautomatisierung GmbH  *  demig Anlagentechnik GmbH  *
*                                       *                             *
* Anschrift:          Haardtstrasse 40  *  Haardtstrasse 40           *
*                       D-57076 Siegen  *  D-57076 Siegen             *
* Registergericht:     Siegen HRB 2819  *  Siegen HRB 5532            *
* Geschaeftsfuehrer:   Joachim Herbst,  *  Joachim Herbst,            *
*                        Winfried Held  *  Winfried Held              *
* Telefon:              +49 271 772020  *  +49 271 772020             *
* Telefax:              +49 271 74704   *  +49 271 74704              *
* E-Mail:                in...@de...  *  at...@de...                *
*                  http://www.demig.de  *  http://www.demig.de        *
***********************************************************************

Re: [Firebird-odbc-devel] odbc download

[Helen B. <he...@ii...>]

At 09:23 PM 28/12/2009, Roman Simakov wrote:
>There was a serious problem with server. I think all will be restored 
>soon but you can try to download 
>http://www.red-soft.biz/files/downloads/odbc/Firebird_ODBC_2.0.0.148_x64.exe.
>
>AFAIU this is the same build.

Thanks, Roman.  The files are all now restored to the download/prerelease/odbc area of the firebird website so the links on the RC1 download page should be working now.

Helen

Re: [Firebird-odbc-devel] odbc download

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

There was a serious problem with server. I think all will be restored 
soon but you can try to download 
http://www.red-soft.biz/files/downloads/odbc/Firebird_ODBC_2.0.0.148_x64.exe.

AFAIU this is the same build.

--
Roman Simakov

On 12/19/2009 04:09 AM, Phil Goulson wrote:
> Hi
> Could someone please help me.
> I am having problems downloading the win 64 bit Firebird ODBC driver.
> The following link does not appear to work:
> http://www.firebirdsql.org/download/prerelease/odbc/Firebird_ODBC_2.0.0.148_x64.exe
> Does anyone know where I can download it.
> Thanks
> Phil
> ----------
> Phil Goulson
> Rubysun Ltd

[Firebird-odbc-devel] odbc download

[Phil G. <Ph...@go...>]

Hi
Could someone please help me.
I am having problems downloading the win 64 bit Firebird ODBC driver.
The following link does not appear to work:
http://www.firebirdsql.org/download/prerelease/odbc/Firebird_ODBC_2.0.0.148_x64.exe

Does anyone know where I can download it.
Thanks
Phil
----------
Phil Goulson
Rubysun Ltd

Re: [Firebird-odbc-devel] new fbclient for new FBServer does not work with ODBC

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

André Knappstein wrote:
> Thanks Paul,
> I got the wording wrong. I meant of course that the client-dll had
> been installed using InstClient.exe from the server's \BIN folder.
> 
> But now that you say it... I will ask my friend if he really really
> did the install...

I guess Paul talked about problem with manifest. FB 2.1 is built by 
VS.2005 but 2.0 by VS.2003. VS.2005 uses dll manifests and if you don't 
have manifest or correctly installed vcredist (w\o VC.2005 SP1) you 
can't use binaries built by VS.2005.

So correctly installed fbclient in your case is not installed by 
InstClient.exe but with correct vcredist or with needed dll's and manifests.

--
Roman Simakov

Re: [Firebird-odbc-devel] new fbclient for new FBServer does not work with ODBC

[André K. C. <Kna...@be...>]

Thanks Paul,
I got the wording wrong. I meant of course that the client-dll had
been installed using InstClient.exe from the server's \BIN folder.

But now that you say it... I will ask my friend if he really really
did the install...

  
  
-- 


~~~Ihre Nachricht~~~

PR> On Wednesday 09 December 2009, André Knappstein, Controlling wrote:
>> - copied fbclient.dll from new 2.1.3 Server to local clients

PR> You can't do that. Or rather you can but it probably won't work on its own
PR> due to missing run time libraries. It would probably be quicker just to do
PR> an install of the client from the binary installer. Alternatively you can
PR> play around with installing the vcredist for VS2005. It is documented in
PR> the installation_readme.txt


PR> Paul

Re: [Firebird-odbc-devel] new fbclient for new FBServer does not work with ODBC

[André K. C. <Kna...@be...>]

The fbclient had indeed been just *copied* in all cases, not
*installed*. My friend says that he is always doing it like this and
that it never made any problem until now.

Sorry that I bothered you and did not think of this possibility myself
before.

ciao,
André

  
  
-- 


~~~Ihre Nachricht~~~

PR> On Wednesday 09 December 2009, André Knappstein, Controlling wrote:
>> - copied fbclient.dll from new 2.1.3 Server to local clients

PR> You can't do that. Or rather you can but it probably won't work on its own
PR> due to missing run time libraries. It would probably be quicker just to do
PR> an install of the client from the binary installer. Alternatively you can
PR> play around with installing the vcredist for VS2005. It is documented in
PR> the installation_readme.txt


PR> Paul

Re: [Firebird-odbc-devel] new fbclient for new FBServer does not work with ODBC

[Paul R. <pr...@ib...>]

On Wednesday 09 December 2009, André Knappstein, Controlling wrote:
> - copied fbclient.dll from new 2.1.3 Server to local clients

You can't do that. Or rather you can but it probably won't work on its own 
due to missing run time libraries. It would probably be quicker just to do 
an install of the client from the binary installer. Alternatively you can 
play around with installing the vcredist for VS2005. It is documented in 
the installation_readme.txt


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support

[Firebird-odbc-devel] new fbclient for new FBServer does not work with ODBC

[André K. C. <Kna...@be...>]

Dear all,

I am trying to help a friend who experiences a strange problem, but
can't pin it down so I am asking here if someone might have a hint
what's going on.

Situation:
- installed additional 2.1.3 Server (so far only 1.5.x has been
installed in network) on a Win32 machine (Server2005)
- copied fbclient.dll from new 2.1.3 Server to local clients
- when selecting the new fbclient.dll in ODBC-DSN, connection to the
server will be rejected. Selecting the old fbclient.dll again will
work.
- happens only on some machines, on some others, both versions of
fbclient.dll will connect
- no problems when using .net provider, only with ODBC (IIRC, .net
provider does not use fbclient.dll???)

We already checked the following:
- All components are 32-Bit
- No personal AV or Firewall is installed at all
- Tried after fresh reboot of system
- ODBC drivers are up to date

Where can I go on searching for the problem? I never experienced
anything like this.

Please excuse me, if this is the wrong list. I am afraid that Helen
would send me here anyway if I would ask in "general".

thanks!

André



  

-- 

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

[Paul R. <pr...@ib...>]

On Tuesday 08 December 2009, Roman Simakov wrote:
> AFAIK nmake is not used for Firebird builds but .sln projects. Right?
> Why do we need to build ODBC with nmake? AFAIU Potapchenko built driver by
> Visual Studio solutions. No? 

It is a long while since I did the builds for the driver but it looks as if 
we have always used nmake for generating the official binaries. The VS .sln 
files are there for development.

I'll make some time tomorrow to do some more work on this.

Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support

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

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

Paul Reeves wrote:
> But that is not the only problem with the nmake builds. There is also the 
> fact that there are several nmake makefiles, all of them in different 
> directories. There really should just be the one, along with an intelligent 
> batch file to set the appropriate environment. We should also separate the 
> nmake builds from the Visual Studio builds. Having build.bat in the same 
> directory as a .sln file is confusing as the batch file calls nmake not the 
> appropriate version of devenv.

AFAIK nmake is not used for Firebird builds but .sln projects. Right? 
Why do we need to build ODBC with nmake? AFAIU Potapchenko built driver 
by Visual Studio solutions. No?

--
Roman Simakov

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

[Paul R. <pr...@ib...>]

On Tuesday 08 December 2009, Roman Simakov wrote:
> It seems to me Paul is right but zip for win32 contains the same files
> for x64. diff says that x64 and win32 files have no differences.
>
> We need more fresh snapshot.
>

I've been looking at the build system for the driver recently. It is not 
broken, but it is definitely in a mess.

I brought the makefile for linux builds up-to-date. That works fine and can 
now produce 32-bit and 64-bit libraries. However, each build needs to be 
done separately. There is not a controlling script that generates both 
drivers.

OTOH, the windows builds are a little more complicated. AFAICT, the nmake 
builds are definitely broken - they include makefile.environ which now only 
works with gmake. I'm going to upload a new namefile.win_environ to fix 
this.

But that is not the only problem with the nmake builds. There is also the 
fact that there are several nmake makefiles, all of them in different 
directories. There really should just be the one, along with an intelligent 
batch file to set the appropriate environment. We should also separate the 
nmake builds from the Visual Studio builds. Having build.bat in the same 
directory as a .sln file is confusing as the batch file calls nmake not the 
appropriate version of devenv.

To summarize, we don't have a one-click solution to generate working 
snapshots. They need to be prepared manually. This all goes some way to 
explaining why the most recent snapshots may not be correct. 


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support

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

[Paul R. <pr...@ib...>]

On Tuesday 08 December 2009, Paul Reeves wrote:
> On Tuesday 08 December 2009, stevyn dembo wrote:
> > Hi:
> >  
> > The error shows up in the application event log as the ODBC driver is
> > being called in a COM+ applcation. Always same error.
> > Environment is 32-bit 2003R2 in production environment ie; not a test
> > or development machine.
>
> This is most definitely a different error to the one reported by Tom.

Although now that I think about it, you are referring to the first error he 
mentioned, not the second. 

We'll have to get an updated snapshot out.


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support

Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on2003server

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

I think you should to try a new version with debug information and it's 
very good to see variable values inside the call of OdbcFb function.

--
Roman Simakov

tom interface wrote:
> do you know if snapshot will be update to try to replace the dll ?
> 
> Tom
> 
> ----- Original Message ----- 
> From: "Roman Simakov" <rom...@gm...>
> To: <fir...@li...>
> Sent: Tuesday, December 08, 2009 8:11 PM
> Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP 
> on2003server
> 
> 
> It seems to me Paul is right but zip for win32 contains the same files
> for x64. diff says that x64 and win32 files have no differences.
> 
> We need more fresh snapshot.
> 
> --
> Roman Simakov
> 
> 
> tom interface wrote:
>> I'm sure i download (i check on my server) :
>>
>> 2009-03-05 11:30:00 OdbcFb_DLL_2-0-0149_Win32.zip 965 KB
>>
>> and I replace dll version 148 with dll version 149 in *windows\system32* 
>> ???
>>
>> Tom
>> ----- Original Message -----
>> From: "Paul Reeves" <pr...@ib... <mailto:pr...@ib...>>
>> To: <fir...@li...
>> <mailto:fir...@li...>>
>> Sent: Tuesday, December 08, 2009 6:12 PM
>> Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on
>> 2003server
>>
>> On Monday 07 December 2009, tom interface wrote:
>>
>>  >
>>  > Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
>>  > (Firebird/InterBase(r) driver).
>>  >
>>
>> This indicates you may have a mismatch between a 32-bit app and a 64-bit
>> driver, or vice-versa.
>>
>>
>> Paul
>> -- 
>> Paul Reeves
>> http://www.ibphoenix.com
>> Specialists in Firebird support
>>

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

[Paul R. <pr...@ib...>]

On Tuesday 08 December 2009, stevyn dembo wrote:
> Hi:
>  
> The error shows up in the application event log as the ODBC driver is
> being called in a COM+ applcation. Always same error. 
> Environment is 32-bit 2003R2 in production environment ie; not a test or
> development machine. 

This is most definitely a different error to the one reported by Tom. In his 
case the driver fails to load. Under the circumstances I guess he might 
feel lucky to have an error that only occurred once in every 1000 - 10,000 
transactions :-)


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support

Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on2003server

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

do you know if snapshot will be update to try to replace the dll ?

Tom

----- Original Message ----- 
From: "Roman Simakov" <rom...@gm...>
To: <fir...@li...>
Sent: Tuesday, December 08, 2009 8:11 PM
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP 
on2003server


It seems to me Paul is right but zip for win32 contains the same files
for x64. diff says that x64 and win32 files have no differences.

We need more fresh snapshot.

--
Roman Simakov


tom interface wrote:
> I'm sure i download (i check on my server) :
>
> 2009-03-05 11:30:00 OdbcFb_DLL_2-0-0149_Win32.zip 965 KB
>
> and I replace dll version 148 with dll version 149 in *windows\system32* 
> ???
>
> Tom
> ----- Original Message -----
> From: "Paul Reeves" <pr...@ib... <mailto:pr...@ib...>>
> To: <fir...@li...
> <mailto:fir...@li...>>
> Sent: Tuesday, December 08, 2009 6:12 PM
> Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on
> 2003server
>
> On Monday 07 December 2009, tom interface wrote:
>
>  >
>  > Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
>  > (Firebird/InterBase(r) driver).
>  >
>
> This indicates you may have a mismatch between a 32-bit app and a 64-bit
> driver, or vice-versa.
>
>
> Paul
> -- 
> Paul Reeves
> http://www.ibphoenix.com
> Specialists in Firebird support
>


------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

__________ Information from ESET Smart Security, version of virus signature 
database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com

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

[stevyn d. <sr...@ya...>]

Hi:
 
The error shows up in the application event log as the ODBC driver is being called in a COM+ applcation. Always same error.
 
Environment is 32-bit 2003R2 in production environment ie; not a test or development machine.
 
This is error:
 
Faulting application dllhost.exe, version 5.2.3790.3959, faulting module OdbcFb.dll, version 2.0.0.148, fault address 0x00022cc4.
 
The system has called a custom component and that component has failed and generated an exception. This indicates a problem with the custom component. Notify the developer of this component that a failure has occurred and provide them with the information below. 
Component Prog ID: 
Server Application ID: {6EA2FA28-A7F8-4BA7-97FD-FEC4901A2248}
Server Application Instance ID:
{077FB5FF-90D9-463B-9DE7-EEAE0723E219}
Server Application Name: LSMSWAPP
The serious nature of this error has caused the process to terminate.
Exception: C0000005
Address: 0x10022CC4
Call Stack: 
OdbcFb!SQLSetStmtAttrW + 0x204
　
It is clear that the error is in the driver in the function call SQLSetStmtAttrW at offset 0x204.
 
I have not been able to figure out a solution and trying to capture the failure is difficult because it is so intermittent (but annoying for the users!)
 
regards

This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended you are hereby notified
that any dissemination, distribution or copying of this 
communication is strictly prohibited. If you are not the intended reader, then you must destroy this communication immediately.

--- On Tue, 12/8/09, tom interface <to...@in...> wrote:


From: tom interface <to...@in...>
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003server
To: sr...@ya..., fir...@li...
Received: Tuesday, December 8, 2009, 1:10 AM





Hi,
 
Can you send me your post and did you solve this ? Did you find the problem ?
 
Thanks
 

----- Original Message ----- 
From: stevyn dembo 
To: fir...@li... 
Sent: Tuesday, December 08, 2009 7:57 PM
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003server





Hello:

I have been experiencing as similar problem with Firebird_ODBC_2.0.0.148 on 2003 server.
I too get the in memory access violation.  But it is very intermittent. Possibly once in every 1000 - 10,000 transactions.  I did post this earlier but the post doesn't seem to have made it onto the forum.

regards,
stevyn

This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended you are hereby notified
that any dissemination, distribution or copying of this 
communication is strictly prohibited. If you are not the intended reader, then you must destroy this communication immediately.

--- On Tue, 12/8/09, tom interface <to...@in...> wrote:


From: tom interface <to...@in...>
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 server
To: fir...@li...
Received: Tuesday, December 8, 2009, 12:14 AM


is it possible that a hardware problem can cause this crash (memory, HDD, 
processor ??)

The config of my server is :

Windows server 2003 - service pack 2
Intel xeon 2.8 Ghz (bi-processor) with 3.25 Go RAM

Thanks

----- Original Message ----- 
From: "Roman Simakov" <rom...@gm...>
To: <fir...@li...>
Sent: Tuesday, December 08, 2009 7:01 PM
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 
server


Paul Reeves wrote:
> On Monday 07 December 2009, tom interface wrote:
>
>> Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
>> (Firebird/InterBase(r) driver).
>>
>
> This indicates you may have a mismatch between a 32-bit app and a 64-bit
> driver, or vice-versa.

Looking on address with error "access violation exception (0xC0000005)"
I guess that Tom is using win32. In either case in snapshot there is
another set of files for another platform:) It's easy to check:)

--
Roman Simakov

>
>
> Paul


------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

__________ Information from ESET Smart Security, version of virus signature 
database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com




------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! 



------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev



__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com





_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com



__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com



      __________________________________________________________________
The new Internet Explorer® 8 - Faster, safer, easier.  Optimized for Yahoo!  Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/

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

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

It seems to me Paul is right but zip for win32 contains the same files 
for x64. diff says that x64 and win32 files have no differences.

We need more fresh snapshot.

--
Roman Simakov


tom interface wrote:
> I'm sure i download (i check on my server) :
>  
> 2009-03-05 11:30:00 OdbcFb_DLL_2-0-0149_Win32.zip 965 KB
>  
> and I replace dll version 148 with dll version 149 in *windows\system32* ???
>  
> Tom
> ----- Original Message -----
> From: "Paul Reeves" <pr...@ib... <mailto:pr...@ib...>>
> To: <fir...@li... 
> <mailto:fir...@li...>>
> Sent: Tuesday, December 08, 2009 6:12 PM
> Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 
> 2003server
> 
> On Monday 07 December 2009, tom interface wrote:
> 
>  >
>  > Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
>  > (Firebird/InterBase(r) driver).
>  >
> 
> This indicates you may have a mismatch between a 32-bit app and a 64-bit
> driver, or vice-versa.
> 
> 
> Paul
> -- 
> Paul Reeves
> http://www.ibphoenix.com
> Specialists in Firebird support
> 

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

[Paul R. <pr...@ib...>]

On Tuesday 08 December 2009, tom interface wrote:
> I'm sure i download (i check on my server) :
>
> 2009-03-05 11:30:00 OdbcFb_DLL_2-0-0149_Win32.zip 965 KB
>
> and I replace dll version 148 with dll version 149 in windows\system32
> ???
>
If the O/S is 64-bit then you need to put the 32-bit driver into the 
windows/SysWOW64 directory. 

If the O/S is 32-bit then the error might indicate some sort of file 
corruption.

This is the error code:

  ERROR_BAD_EXE_FORMAT 193 (0xC1) - %1 is not a valid Win32 application.

Hence my initial guess that there is a bitness mismatch.


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support

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

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

Hi,

Can you send me your post and did you solve this ? Did you find the problem ?

Thanks

  ----- Original Message ----- 
  From: stevyn dembo 
  To: fir...@li... 
  Sent: Tuesday, December 08, 2009 7:57 PM
  Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003server


        Hello:

        I have been experiencing as similar problem with Firebird_ODBC_2.0.0.148 on 2003 server.
        I too get the in memory access violation.  But it is very intermittent. Possibly once in every 1000 - 10,000 transactions.  I did post this earlier but the post doesn't seem to have made it onto the forum.

        regards,
        stevyn

        This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended you are hereby notified
        that any dissemination, distribution or copying of this 
        communication is strictly prohibited. If you are not the intended reader, then you must destroy this communication immediately.

        --- On Tue, 12/8/09, tom interface <to...@in...> wrote:


          From: tom interface <to...@in...>
          Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 server
          To: fir...@li...
          Received: Tuesday, December 8, 2009, 12:14 AM


          is it possible that a hardware problem can cause this crash (memory, HDD, 
          processor ??)

          The config of my server is :

          Windows server 2003 - service pack 2
          Intel xeon 2.8 Ghz (bi-processor) with 3.25 Go RAM

          Thanks

          ----- Original Message ----- 
          From: "Roman Simakov" <rom...@gm...>
          To: <fir...@li...>
          Sent: Tuesday, December 08, 2009 7:01 PM
          Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 
          server


          Paul Reeves wrote:
          > On Monday 07 December 2009, tom interface wrote:
          >
          >> Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
          >> (Firebird/InterBase(r) driver).
          >>
          >
          > This indicates you may have a mismatch between a 32-bit app and a 64-bit
          > driver, or vice-versa.

          Looking on address with error "access violation exception (0xC0000005)"
          I guess that Tom is using win32. In either case in snapshot there is
          another set of files for another platform:) It's easy to check:)

          --
          Roman Simakov

          >
          >
          > Paul


          ------------------------------------------------------------------------------
          Return on Information:
          Google Enterprise Search pays you back
          Get the facts.
          http://p.sf.net/sfu/google-dev2dev
          _______________________________________________
          Firebird-odbc-devel mailing list
          Fir...@li...
          https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

          __________ Information from ESET Smart Security, version of virus signature 
          database 4668 (20091207) __________

          The message was checked by ESET Smart Security.

          http://www.eset.com




          __________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

          The message was checked by ESET Smart Security.

          http://www.eset.com




          ------------------------------------------------------------------------------
          Return on Information:
          Google Enterprise Search pays you back
          Get the facts.
          http://p.sf.net/sfu/google-dev2dev
          _______________________________________________
          Firebird-odbc-devel mailing list
          Fir...@li...
          https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
       


------------------------------------------------------------------------------
  The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free!


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


  ------------------------------------------------------------------------------
  Return on Information:
  Google Enterprise Search pays you back
  Get the facts.
  http://p.sf.net/sfu/google-dev2dev



  __________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

  The message was checked by ESET Smart Security.

  http://www.eset.com




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


  _______________________________________________
  Firebird-odbc-devel mailing list
  Fir...@li...
  https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



  __________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

  The message was checked by ESET Smart Security.

  http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com

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

[stevyn d. <sr...@ya...>]

Hello:

I have been experiencing as similar problem with Firebird_ODBC_2.0.0.148 on 2003 server.
I too get the in memory access violation.  But it is very intermittent. Possibly once in every 1000 - 10,000 transactions.  I did post this earlier but the post doesn't seem to have made it onto the forum.

regards,
stevyn

This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law.  If the reader of this message is not the intended you are hereby notified

that any dissemination, distribution or copying of this 

communication is strictly prohibited.  If you are not the intended reader, then you must destroy this communication immediately.

--- On Tue, 12/8/09, tom interface <to...@in...> wrote:

From: tom interface <to...@in...>
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 server
To: fir...@li...
Received: Tuesday, December 8, 2009, 12:14 AM

is it possible that a hardware problem can cause this crash (memory, HDD, 
processor ??)

The config of my server is :

Windows server 2003 - service pack 2
Intel xeon 2.8 Ghz (bi-processor) with 3.25 Go RAM

Thanks

----- Original Message ----- 
From: "Roman Simakov" <rom...@gm...>
To: <fir...@li...>
Sent: Tuesday, December 08, 2009 7:01 PM
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 
server


Paul Reeves wrote:
> On Monday 07 December 2009, tom interface wrote:
>
>> Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
>> (Firebird/InterBase(r) driver).
>>
>
> This indicates you may have a mismatch between a 32-bit app and a 64-bit
> driver, or vice-versa.

Looking on address with error "access violation exception (0xC0000005)"
I guess that Tom is using win32. In either case in snapshot there is
another set of files for another platform:) It's easy to check:)

--
Roman Simakov

>
>
> Paul


------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

__________ Information from ESET Smart Security, version of virus signature 
database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com




------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



      __________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr! 

http://www.flickr.com/gift/

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

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

is it possible that a hardware problem can cause this crash (memory, HDD, 
processor ??)

The config of my server is :

Windows server 2003 - service pack 2
Intel xeon 2.8 Ghz (bi-processor) with 3.25 Go RAM

Thanks

----- Original Message ----- 
From: "Roman Simakov" <rom...@gm...>
To: <fir...@li...>
Sent: Tuesday, December 08, 2009 7:01 PM
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003 
server


Paul Reeves wrote:
> On Monday 07 December 2009, tom interface wrote:
>
>> Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
>> (Firebird/InterBase(r) driver).
>>
>
> This indicates you may have a mismatch between a 32-bit app and a 64-bit
> driver, or vice-versa.

Looking on address with error "access violation exception (0xC0000005)"
I guess that Tom is using win32. In either case in snapshot there is
another set of files for another platform:) It's easy to check:)

--
Roman Simakov

>
>
> Paul


------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

__________ Information from ESET Smart Security, version of virus signature 
database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com

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

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

sorry i forgot : 

i installed Firebird_ODBC_2.0.0.148_win32.exe on my server

Tom

----- Original Message ----- 
From: "Paul Reeves" <pr...@ib...>
To: <fir...@li...>
Sent: Tuesday, December 08, 2009 6:12 PM
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003server


On Monday 07 December 2009, tom interface wrote:

>
> Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
> (Firebird/InterBase(r) driver).
>

This indicates you may have a mismatch between a 32-bit app and a 64-bit 
driver, or vice-versa.


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support

------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com

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

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

I'm sure i download (i check on my server) : 

2009-03-05 11:30:00 OdbcFb_DLL_2-0-0149_Win32.zip 965 KB

and I replace dll version 148 with dll version 149 in windows\system32 ???

Tom

----- Original Message ----- 
From: "Paul Reeves" <pr...@ib...>
To: <fir...@li...>
Sent: Tuesday, December 08, 2009 6:12 PM
Subject: Re: [Firebird-odbc-devel] Firebird_ODBC_2.0.0.148 and ASP on 2003server


On Monday 07 December 2009, tom interface wrote:

>
> Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
> (Firebird/InterBase(r) driver).
>

This indicates you may have a mismatch between a 32-bit app and a 64-bit 
driver, or vice-versa.


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support

------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com

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

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

Paul Reeves wrote:
> On Monday 07 December 2009, tom interface wrote:
> 
>> Le pilote spécifié n'a pas été chargé en raison de l'erreur système 193
>> (Firebird/InterBase(r) driver).
>>
> 
> This indicates you may have a mismatch between a 32-bit app and a 64-bit 
> driver, or vice-versa.

Looking on address with error "access violation exception (0xC0000005)" 
I guess that Tom is using win32. In either case in snapshot there is 
another set of files for another platform:) It's easy to check:)

--
Roman Simakov

> 
> 
> Paul