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

Re: [Firebird-odbc-devel] Alpha Five v11

[Alexander P. <ale...@gm...>]

On 20.01.2012 14:24, Bob Taylor wrote:
> Hi Alexander.
> I am on Windows 7 Enterprise 64-bit, so I am using the 64-bit ODBC driver.
> Can you create a 64-bit dll that I can test?
> Thanks.
>
>
AFAIK, Alpha Five v11 is an 32-bit application and it can use 32-bit 
ODBC driver (odbcfb.dll) only. You must replace 32-bit odbcfb.dll in the 
directory C:\WINDOWS\SysWOW64 .

-- 
Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru

Re: [Firebird-odbc-devel] Alpha Five v11

[Bob T. <web...@rw...>]

Hi Alexander.
 
 
I am on Windows 7 Enterprise 64-bit, so I am using the 64-bit ODBC driver.
 
 
Can you create a 64-bit dll that I can test?
 
 
Thanks.


On 1/10/2012 at 10:27 AM, Alexander Potapchenko
<ale...@gm...> wrote: 
On 10.01.2012 16:58, Bob Taylor wrote: 
I am using Alpha Five v11 to connect to a Firebird 2.5.1.26351 Server using
Firebird ODBC 2.0.0.151.
 
I can establish the connection, but this is the error that I get when
attempting to get a table list from the database.

Hi,

It is Firebird ODBC driver bug. I have created the issue here -
http://tracker.firebirdsql.org/browse/ODBC-135 and I have attached the fixed
32-bit driver (OdbcFb.dll) there for testing ..  

Regards,
Alexander


-- 

Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru

[Firebird-odbc-devel] Intermittent connection problems

[Kjell R. <kje...@da...>]

Hi,

I have a Win 2008 web server, 64 bit. On this system I have FB 2.1 64 
bit installed and a couple of sites that connect to those databases over 
ODBC from old-style ASP (not ASP.Net) using ADO objects in VBscript.

I have configured system ODBC datasources for this purpose.

It all usually works flawlessly, but on occasion, for no apparent 
reason, suddenly the db connections start failing.

It seems to be related to the ODBC driver because in this "failing state":

1. I can still connect using FlameRobin and the databaes have no 
validation errors.

2. If I bring up the ODBC system datasource and hit "Test connection" it 
fails. Also the services that can be executed from the ODBC driver 
settings dialog (backup, restore, stats etc) also fail with connection 
error.

The error I get when trying to connect from the ODBC driver services 
dialog is this:
sqlcode -904, fbcode 335544792 - Cannot attach to services manager.

And from "Test connection" in the data source:
Open database 'C:\.....\...fdb' failed

A system reboot always resolves the problem, but rebooting a web server 
is not very desirable. So:

1. Any ideas what might be causing this?

2. Any ideas how I can stop it from happening?

3. Anything I can do to get more info that might help locate the error 
in the driver, if there is such an error? E.g. trace/log mode, status 
reports from the driver, ...?

4. Is there any way I can reload just the driver without having to 
reboot the entire computer?

Thanks,
Kjell

-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@da...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

Re: [Firebird-odbc-devel] FW: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

[Tiesheng W. <t....@qm...>]

Dear All,

 

We have now solved the problem about running Firebird 64-bit ODBC on Windows
7 x64 by installing the Firebird 64-bit Server onto the PC running Windows 7
x64.

 

This is because Firebird 64-bit ODBC requires gds32.dll to be available.

 

We can run 32-bit application properly on Windows 7 x64 now.

 

Thank you very much for your kind help on this.

 

Kind regards,

 

Tee 

 

From: Tiesheng Wu [mailto:t....@qm...] 
Sent: 10 January 2012 19:51
To: sad...@gm...
Cc: 'M Joomun'; fir...@ya...;
fir...@li...
Subject: [Firebird-odbc-devel] FW: [firebird-support] ODBC connection to
Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

 

Dear Sadek,

 

Could you please let me know how to use the Firebird ADO.net provider?

 

We have to get the database connection working soon.

 

Kind regards,

 

Tee

 

From: Sadek Alaoui [mailto:sad...@gm...] 
Sent: 10 January 2012 19:39
To: fir...@li...
Cc: fir...@ya...; M Joomun
Subject: Re: [Firebird-odbc-devel] [firebird-support] ODBC connection to
Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

 

I had many issues with Firebird ODBC, especially when the OS is 64 bit. 

The only workaround I found, is to use the Firebird ADO.net provider and not
the ODBC

Best regards,
Sadek



2012/1/10 Tiesheng Wu <t....@qm...>

Dear Thomas,

 

Thanks a lot for your message. The application is 32 bit.

 

First I tried 64bit ODBC driver (2.0.0.151) on Windows 7 x64. The driver was
installed properly. Then I configured the ODBC connection via Control Panel
à Administrative tool à Data Source (ODBC). When I tried connection test it
gave the error message “sqlcode-904 fbcode 335544375 – Unable to connect to
data source: library ‘gds32.dll’ failed to load”.

 

I then removed the 64bit ODBC driver and installed 32bit ODBC driver
(2.0.0.151). The driver was installed properly. However it did not show up
in the ODBC Data Source Administrator using Control Panel à Administrative
tool à Data Source (ODBC). Therefore I did not know where and how I should
configure the ODBC connection.

 

Kind regards,

 

Tee

 

From: fir...@ya...
[mailto:fir...@ya...] On Behalf Of Thomas Steinmaurer
Sent: 10 January 2012 19:13
To: fir...@ya...
Subject: Re: [firebird-support] ODBC connection to Firebird (2.1.2.18118)
database on Windows Server 2003 from Windows 7 x64

 

  

> We try to connect a Firebird (2.1.2.18118) database on Windows Server 2003
> (32 bit) from Windows 7 x64.
>
>
>
> Which ODBC (version, x32 or x64) should we use?

This depends on your client application and not on your server. If your 
client application is 32-bit then the 32-bit ODBC driver, otherwise 64-bit.

-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/

__._,_.___

Reply to
<mailto:ts...@ib...?subject=Re%3A%20%5Bfirebird-support%5D%20ODBC%20
connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windo
ws%20Server%202003%20from%20Windows%207%20x64> sender | Reply to
<mailto:fir...@ya...?subject=Re%3A%20%5Bfirebird-support
%5D%20ODBC%20connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database
%20on%20Windows%20Server%202003%20from%20Windows%207%20x64> group | Reply
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyb2hxZ3FjBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5Mg
RzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI3OTY-?act=reply&messageNum=116492>
via web post |
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlazBjcjJvBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2
50cGMEc3RpbWUDMTMyNjIyMjc5Ng--> Start a New Topic 

Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4
aGhvZW03BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lk
AzExNjQ5MgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI3OTYEdHBjSWQDMTE2NDkx>
(2) 

Recent Activity: 

·
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmOWJiODR
uBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZtYnJzBHN0aW1lAzEzMjYyMjI3OTY-?o=6> New Members 10 

 
<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlZ3E0MzliBF9TAzk
3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHA
Ec3RpbWUDMTMyNjIyMjc5Ng--> Visit Your Group 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get
the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15obclrni/M=493064.14543979.14562481.132984
30/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229996/L=265f1e1a-3bbf-11e1-9c
eb-7b121b790cc2/B=12N1AdBDRvA-/J=1326222796720389/K=pMjnYcp5C2IO2aCIsSvxQA/A
=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj> 

 

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
.

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
__,_._,___

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>

----------------------------------------------------------------------------
--
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] FW: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

[Michael M. <m.m...@mb...>]

Installation Order for Windows 64 Bit – 32 Bit ODBC App:

-          Install Firebird Native Client 32 Bit by installing the Firebird
Server on this System and choosing “Only Client Install”

-          Install Firebird ODBC Driver 32 Bit

-          Go to Control Panel. There must be a Button “32-Bit Control
Panel”. Use the ODBC Manager from there.

-          Setup your connection

 

Regards Michael 

 

From: Tiesheng Wu [mailto:t....@qm...] 
Sent: Tuesday, January 10, 2012 8:51 PM
To: sad...@gm...
Cc: 'M Joomun'; fir...@ya...;
fir...@li...
Subject: [Firebird-odbc-devel] FW: [firebird-support] ODBC connection to
Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

 

Dear Sadek,

 

Could you please let me know how to use the Firebird ADO.net provider?

 

We have to get the database connection working soon.

 

Kind regards,

 

Tee

 

From: Sadek Alaoui [mailto:sad...@gm...] 
Sent: 10 January 2012 19:39
To: fir...@li...
Cc: fir...@ya...; M Joomun
Subject: Re: [Firebird-odbc-devel] [firebird-support] ODBC connection to
Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

 

I had many issues with Firebird ODBC, especially when the OS is 64 bit. 

The only workaround I found, is to use the Firebird ADO.net provider and not
the ODBC

Best regards,
Sadek



2012/1/10 Tiesheng Wu <t....@qm...>

Dear Thomas,

 

Thanks a lot for your message. The application is 32 bit.

 

First I tried 64bit ODBC driver (2.0.0.151) on Windows 7 x64. The driver was
installed properly. Then I configured the ODBC connection via Control Panel
à Administrative tool à Data Source (ODBC). When I tried connection test it
gave the error message “sqlcode-904 fbcode 335544375 – Unable to connect to
data source: library ‘gds32.dll’ failed to load”.

 

I then removed the 64bit ODBC driver and installed 32bit ODBC driver
(2.0.0.151). The driver was installed properly. However it did not show up
in the ODBC Data Source Administrator using Control Panel à Administrative
tool à Data Source (ODBC). Therefore I did not know where and how I should
configure the ODBC connection.

 

Kind regards,

 

Tee

 

From: fir...@ya...
[mailto:fir...@ya...] On Behalf Of Thomas Steinmaurer
Sent: 10 January 2012 19:13
To: fir...@ya...
Subject: Re: [firebird-support] ODBC connection to Firebird (2.1.2.18118)
database on Windows Server 2003 from Windows 7 x64

 

  

> We try to connect a Firebird (2.1.2.18118) database on Windows Server 2003
> (32 bit) from Windows 7 x64.
>
>
>
> Which ODBC (version, x32 or x64) should we use?

This depends on your client application and not on your server. If your 
client application is 32-bit then the 32-bit ODBC driver, otherwise 64-bit.

-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/

__._,_.___

Reply to
<mailto:ts...@ib...?subject=Re%3A%20%5Bfirebird-support%5D%20ODBC%20
connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windo
ws%20Server%202003%20from%20Windows%207%20x64> sender | Reply to
<mailto:fir...@ya...?subject=Re%3A%20%5Bfirebird-support
%5D%20ODBC%20connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database
%20on%20Windows%20Server%202003%20from%20Windows%207%20x64> group | Reply
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyb2hxZ3FjBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5Mg
RzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI3OTY-?act=reply&messageNum=116492>
via web post |
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlazBjcjJvBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2
50cGMEc3RpbWUDMTMyNjIyMjc5Ng--> Start a New Topic 

Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4
aGhvZW03BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lk
AzExNjQ5MgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI3OTYEdHBjSWQDMTE2NDkx>
(2) 

Recent Activity: 

·
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmOWJiODR
uBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZtYnJzBHN0aW1lAzEzMjYyMjI3OTY-?o=6> New Members 10 

 
<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlZ3E0MzliBF9TAzk
3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHA
Ec3RpbWUDMTMyNjIyMjc5Ng--> Visit Your Group 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get
the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15obclrni/M=493064.14543979.14562481.132984
30/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229996/L=265f1e1a-3bbf-11e1-9c
eb-7b121b790cc2/B=12N1AdBDRvA-/J=1326222796720389/K=pMjnYcp5C2IO2aCIsSvxQA/A
=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj> 

 

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
.

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
__,_._,___

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>

----------------------------------------------------------------------------
--
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Firebird-odbc-devel] FW: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

[Tiesheng W. <t....@qm...>]

------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create 
new or port existing apps to sell to consumers worldwide. Explore the 
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev

Re: [Firebird-odbc-devel] [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

[Sadek A. <sad...@gm...>]

I had many issues with Firebird ODBC, especially when the OS is 64 bit.

The only workaround I found, is to use the Firebird ADO.net provider and
not the ODBC

Best regards,
Sadek



2012/1/10 Tiesheng Wu <t....@qm...>

> Dear Thomas,****
>
> ** **
>
> Thanks a lot for your message. The application is 32 bit.****
>
> ** **
>
> First I tried 64bit ODBC driver (2.0.0.151) on Windows 7 x64. The driver
> was installed properly. Then I configured the ODBC connection via Control
> Panel à Administrative tool à Data Source (ODBC). When I tried connection
> test it gave the error message “sqlcode-904 fbcode 335544375 – Unable to
> connect to data source: library ‘gds32.dll’ failed to load”.****
>
> ** **
>
> I then removed the 64bit ODBC driver and installed 32bit ODBC driver
> (2.0.0.151). The driver was installed properly. However it did not show up
> in the ODBC Data Source Administrator using Control Panel àAdministrative tool
> à Data Source (ODBC). Therefore I did not know where and how I should
> configure the ODBC connection.****
>
> ** **
>
> Kind regards,****
>
> ** **
>
> Tee****
>
> ** **
>
> *From:* fir...@ya... [mailto:
> fir...@ya...] *On Behalf Of *Thomas Steinmaurer
> *Sent:* 10 January 2012 19:13
> *To:* fir...@ya...
> *Subject:* Re: [firebird-support] ODBC connection to Firebird
> (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64****
>
> ** **
>
>   ****
>
> > We try to connect a Firebird (2.1.2.18118) database on Windows Server
> 2003
> > (32 bit) from Windows 7 x64.
> >
> >
> >
> > Which ODBC (version, x32 or x64) should we use?
>
> This depends on your client application and not on your server. If your
> client application is 32-bit then the 32-bit ODBC driver, otherwise 64-bit.
>
> --
> With regards,
> Thomas Steinmaurer (^TS^)
> Firebird Technology Evangelist
>
> http://www.upscene.com/
> http://www.firebirdsql.org/en/firebird-foundation/****
>
> __._,_.___****
>
> Reply to *sender*<ts...@ib...?subject=Re%3A%20%5Bfirebird-support%5D%20ODBC%20connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windows%20Server%202003%20from%20Windows%207%20x64>| Reply
> to *group*<fir...@ya...?subject=Re%3A%20%5Bfirebird-support%5D%20ODBC%20connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windows%20Server%202003%20from%20Windows%207%20x64>| Reply
> *via web post*<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyb2hxZ3FjBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5MgRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI3OTY-?act=reply&messageNum=116492>|
> *Start a New Topic*<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlazBjcjJvBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTMyNjIyMjc5Ng-->
> ****
>
> Messages in this topic<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4aGhvZW03BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5MgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI3OTYEdHBjSWQDMTE2NDkx>(
> *2*) ****
>
> *Recent Activity:* ****
>
> **·         ***New Members<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmOWJiODRuBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEzMjYyMjI3OTY-?o=6>
> ** 10 *
>
> Visit Your Group<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlZ3E0MzliBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTMyNjIyMjc5Ng-->
> ****
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu.  Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> ****
>
> *MARKETPLACE*
>
> *Stay on top of your group activity without leaving the page you're on -
> Get the Yahoo! Toolbar now.<http://global.ard.yahoo.com/SIG=15obclrni/M=493064.14543979.14562481.13298430/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229996/L=265f1e1a-3bbf-11e1-9ceb-7b121b790cc2/B=12N1AdBDRvA-/J=1326222796720389/K=pMjnYcp5C2IO2aCIsSvxQA/A=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj>
> *
>
> **
>
> [image: Yahoo! Groups]<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
> ****
>
> Switch to: Text-Only<fir...@ya...?subject=Change%20Delivery%20Format:%20Traditional>,
> Daily Digest<fir...@ya...?subject=Email%20Delivery:%20Digest>•
> Unsubscribe<fir...@ya...?subject=Unsubscribe>• Terms
> of Use <http://docs.yahoo.com/info/terms/>****
>
> .****
>
> ****
>
> __,_._,___****
>
>
> ------------------------------------------------------------------------------
> Write once. Port to many.
> Get the SDK and tools to simplify cross-platform app development. Create
> new or port existing apps to sell to consumers worldwide. Explore the
> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
> http://p.sf.net/sfu/intel-appdev
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>

Re: [Firebird-odbc-devel] [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

[Tiesheng W. <t....@qm...>]

Dear Thomas,

 

Thanks a lot for your message. The application is 32 bit.

 

First I tried 64bit ODBC driver (2.0.0.151) on Windows 7 x64. The driver was
installed properly. Then I configured the ODBC connection via Control Panel
à Administrative tool à Data Source (ODBC). When I tried connection test it
gave the error message “sqlcode-904 fbcode 335544375 – Unable to connect to
data source: library ‘gds32.dll’ failed to load”.

 

I then removed the 64bit ODBC driver and installed 32bit ODBC driver
(2.0.0.151). The driver was installed properly. However it did not show up
in the ODBC Data Source Administrator using Control Panel à Administrative
tool à Data Source (ODBC). Therefore I did not know where and how I should
configure the ODBC connection.

 

Kind regards,

 

Tee

 

From: fir...@ya...
[mailto:fir...@ya...] On Behalf Of Thomas Steinmaurer
Sent: 10 January 2012 19:13
To: fir...@ya...
Subject: Re: [firebird-support] ODBC connection to Firebird (2.1.2.18118)
database on Windows Server 2003 from Windows 7 x64

 

  

> We try to connect a Firebird (2.1.2.18118) database on Windows Server 2003
> (32 bit) from Windows 7 x64.
>
>
>
> Which ODBC (version, x32 or x64) should we use?

This depends on your client application and not on your server. If your 
client application is 32-bit then the 32-bit ODBC driver, otherwise 64-bit.

-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/

__._,_.___

Reply to
<mailto:ts...@ib...?subject=Re%3A%20%5Bfirebird-support%5D%20ODBC%20
connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windo
ws%20Server%202003%20from%20Windows%207%20x64> sender | Reply to
<mailto:fir...@ya...?subject=Re%3A%20%5Bfirebird-support
%5D%20ODBC%20connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database
%20on%20Windows%20Server%202003%20from%20Windows%207%20x64> group | Reply
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyb2hxZ3FjBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5Mg
RzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI3OTY-?act=reply&messageNum=116492>
via web post |
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlazBjcjJvBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2
50cGMEc3RpbWUDMTMyNjIyMjc5Ng--> Start a New Topic 

Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4
aGhvZW03BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lk
AzExNjQ5MgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI3OTYEdHBjSWQDMTE2NDkx>
(2) 

Recent Activity: 

·
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmOWJiODR
uBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZtYnJzBHN0aW1lAzEzMjYyMjI3OTY-?o=6> New Members 10 

 
<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlZ3E0MzliBF9TAzk
3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHA
Ec3RpbWUDMTMyNjIyMjc5Ng--> Visit Your Group 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get
the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15obclrni/M=493064.14543979.14562481.132984
30/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229996/L=265f1e1a-3bbf-11e1-9c
eb-7b121b790cc2/B=12N1AdBDRvA-/J=1326222796720389/K=pMjnYcp5C2IO2aCIsSvxQA/A
=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj> 

 

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
Yahoo! Groups

Switch to:
<mailto:fir...@ya...?subject=Change%20Delive
ry%20Format:%20Traditional> Text-Only,
<mailto:fir...@ya...?subject=Email%20Delivery:%20
Digest> Daily Digest •
<mailto:fir...@ya...?subject=Unsubscribe>
Unsubscribe •  <http://docs.yahoo.com/info/terms/> Terms of Use

.

 
<http://geo.yahoo.com/serv?s=97359714/grpId=2442406/grpspId=1705115386/msgId
=116492/stime=1326222796/nc1=5898817/nc2=4025373/nc3=3848644> 

__,_._,___

Re: [Firebird-odbc-devel] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

[Alexander P. <ale...@gm...>]

On 10.01.2012 22:11, Tiesheng Wu wrote:
>
> Dear colleagues,
>
> We try to connect a Firebird (2.1.2.18118) database on Windows Server 2003
> (32 bit) from Windows 7 x64.
>
> Which ODBC (version, x32 or x64) should we use?
>
> Kind regards,
>
> Tee
>
>
It depends on what application (32 or 64 bit) will use ODBC driver. 
Windows doesn't matter.

-- 
Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru

[Firebird-odbc-devel] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

[Tiesheng W. <t....@qm...>]

Dear colleagues,

We try to connect a Firebird (2.1.2.18118) database on Windows Server 2003
(32 bit) from Windows 7 x64.

Which ODBC (version, x32 or x64) should we use?

Kind regards,

Tee

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Tiesheng Wu

Computer Manager

Wolfson Institute of Preventive Medicine

Queen Mary, University of London

Charterhouse Square

London EC1M 6BQ

Tel: 020 7882 6285

Fax: 020 7882 6270

Email: <mailto:t....@qm... <mailto:t.wu%40qmul.ac.uk> > t....@qm...
<mailto:t.wu%40qmul.ac.uk> 

Web: <http://www.wolfson.qmul.ac.uk/> http://www.wolfson.qmul.ac.uk/

[Non-text portions of this message have been removed]

__._,_.___

Reply to
<mailto:t....@qm...?subject=Re%3A%20ODBC%20connection%20to%20Firebird%20
%282%2E1%2E2%2E18118%29%20database%20on%20Windows%20Server%202003%20from%20W
indows%207%20x64> sender | Reply to
<mailto:fir...@ya...?subject=Re%3A%20ODBC%20connection%2
0to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windows%20Server%
202003%20from%20Windows%207%20x64> group | Reply
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyOGJoc3VrBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5MQ
RzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI2NDQ-?act=reply&messageNum=116491>
via web post |
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlNGdtNGw3BF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2
50cGMEc3RpbWUDMTMyNjIyMjY0NA--> Start a New Topic 

Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4
bm5iczZ1BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lk
AzExNjQ5MQRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI2NDQEdHBjSWQDMTE2NDkx>
(1) 

Recent Activity: 

.
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmanIxMGV
xBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZtYnJzBHN0aW1lAzEzMjYyMjI2NDQ-?o=6> New Members 10 

 
<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlNmtoaGg4BF9TAzk
3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHA
Ec3RpbWUDMTMyNjIyMjY0NA--> Visit Your Group 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get
the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15olu3vms/M=493064.14543979.14562481.132984
30/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229844/L=cbbe3360-3bbe-11e1-bb
fd-9bd994106983/B=uiZ0AWKJiUY-/J=1326222644641320/K=LhXmRKRnUGhqLz.AETPQsg/A
=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj> 

 

 
<http://groups.yahoo.com/;_ylc=X3oDMTJkODBuNG1oBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNjQ0>
Yahoo! Groups

Switch to:
<mailto:fir...@ya...?subject=Change%20Delive
ry%20Format:%20Traditional> Text-Only,
<mailto:fir...@ya...?subject=Email%20Delivery:%20
Digest> Daily Digest .
<mailto:fir...@ya...?subject=Unsubscribe>
Unsubscribe .  <http://docs.yahoo.com/info/terms/> Terms of Use

.

 
<http://geo.yahoo.com/serv?s=97359714/grpId=2442406/grpspId=1705115386/msgId
=116491/stime=1326222644/nc1=4025338/nc2=5741391/nc3=3848640> 

__,_._,___

Re: [Firebird-odbc-devel] Alpha Five v11

[Alexander P. <ale...@gm...>]

On 10.01.2012 16:58, Bob Taylor wrote:
> I am using Alpha Five v11 to connect to a Firebird 2.5.1.26351 Server 
> using Firebird ODBC 2.0.0.151.
> I can establish the connection, but this is the error that I get when 
> attempting to get a table list from the database.

Hi,

It is Firebird ODBC driver bug. I have created the issue here - 
http://tracker.firebirdsql.org/browse/ODBC-135 and I have attached the 
fixed 32-bit driver (OdbcFb.dll) there for testing ..

Regards,
Alexander

-- 
Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru

[Firebird-odbc-devel] Alpha Five v11

[Bob T. <web...@rw...>]

I am using Alpha Five v11 to connect to a Firebird 2.5.1.26351 Server using
Firebird ODBC 2.0.0.151.
 
I can establish the connection, but this is the error that I get when
attempting to get a table list from the database.
 

 
Is this a problem with the ODBC driver or Alpha Five?
 
Thanks.

Re: [Firebird-odbc-devel] Building Firebird/ODBC on Linux

[Philippe M. <mak...@fi...>]

Sidney Cadot  [2011-11-07 12:46] :
> Thanks, I'll check it out. is there any build-from-source
> documentation? I'll probably figure it out anyway, but it could be
> helpful.
> 
cd ./Builds/Gcc.lin
make -f makefile.linux

that's all

-- 
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel +33 (0) 561058813

Re: [Firebird-odbc-devel] Building Firebird/ODBC on Linux

[Sidney C. <si...@ji...>]

> This compilation problem are fixed in CVS only.

Thanks, I'll check it out. is there any build-from-source
documentation? I'll probably figure it out anyway, but it could be
helpful.

Sidney

Re: [Firebird-odbc-devel] Building Firebird/ODBC on Linux

[Alexander P. <ale...@gm...>]

On 07.11.2011 13:18, Sidney Cadot wrote:
> Hi all,
>
> I am trying to build the Firebird/ODBC link on Linux/AMD64 from source.
>
> First, are there any instructions in the package or anywhere else how
> to do this? I could not find them.
>
> After unpacking the " OdbcFb-LIB-2.0.0151.amd64.tar.gz" file, I did
> find OdbcJdbc/Builds/Gcc.lin. When I execute "make -f makefile.linux "
> there with appropriate valiues for the FBINCDIR and FBLIBDIR
> environment variables, I see some compile progression but the process
> halts on (what seem to be) genuine C++ problems (see below), in
> MainUnicode.cpp:
>
> How should I proceed?
>
> Best regards, Sidney
>
>
>
Hi,

This compilation problem are fixed in CVS only.
http://sourceforge.net/scm/?type=cvs&group_id=9028
http://firebird.cvs.sourceforge.net/viewvc/firebird/OdbcJdbc/?pathrev=B2_0_0

-- 
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru

[Firebird-odbc-devel] Building Firebird/ODBC on Linux

[Sidney C. <si...@ji...>]

Hi all,

I am trying to build the Firebird/ODBC link on Linux/AMD64 from source.

First, are there any instructions in the package or anywhere else how
to do this? I could not find them.

After unpacking the " OdbcFb-LIB-2.0.0151.amd64.tar.gz" file, I did
find OdbcJdbc/Builds/Gcc.lin. When I execute "make -f makefile.linux "
there with appropriate valiues for the FBINCDIR and FBLIBDIR
environment variables, I see some compile progression but the process
halts on (what seem to be) genuine C++ problems (see below), in
MainUnicode.cpp:

How should I proceed?

Best regards, Sidney




g++ -fPIC -m64 -DNDEBUG -c ../../MainUnicode.cpp -o
Release_x86_64/obj/MainUnicode.o
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLColAttributesW(SQLHSTMT, SQLUSMALLINT, SQLUSMALLINT, SQLPOINTER,
SQLSMALLINT, SQLSMALLINT*, SQLLEN*)’:
../../MainUnicode.cpp:269:43: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:263:23: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:68:12: error:   initializing argument 4 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlColAttribute(int, int,
SQLPOINTER, int, SQLSMALLINT*, SQLPOINTER)’
../../MainUnicode.cpp: In function ‘SQLRETURN SQLConnectW(SQLHDBC,
SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT)’:
../../MainUnicode.cpp:293:54: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:288:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcConnection.h:64:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcConnection::sqlConnect(const SQLCHAR*,
int, SQLCHAR*, int, SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLDescribeColW(SQLHSTMT, SQLUSMALLINT, SQLWCHAR*, SQLSMALLINT,
SQLSMALLINT*, SQLSMALLINT*, SQLULEN*, SQLSMALLINT*, SQLSMALLINT*)’:
../../MainUnicode.cpp:328:38: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:322:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:103:12: error:   initializing argument 3 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlDescribeCol(int,
SQLCHAR*, int, SWORD*, SWORD*, SQLULEN*, SWORD*, SWORD*)’
../../MainUnicode.cpp: In function ‘SQLRETURN SQLErrorW(SQLHENV,
SQLHDBC, SQLHSTMT, SQLWCHAR*, SQLINTEGER*, SQLWCHAR*, SQLSMALLINT,
SQLSMALLINT*)’:
../../MainUnicode.cpp:349:32: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:342:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcObject.h:64:20: error:   initializing argument 4 of ‘virtual
SQLRETURN OdbcJdbcLibrary::OdbcObject::sqlError(UCHAR*, int*, UCHAR*,
int, SWORD*)’
../../MainUnicode.cpp:356:32: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:342:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcObject.h:64:20: error:   initializing argument 4 of ‘virtual
SQLRETURN OdbcJdbcLibrary::OdbcObject::sqlError(UCHAR*, int*, UCHAR*,
int, SWORD*)’
../../MainUnicode.cpp:360:31: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:342:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcObject.h:64:20: error:   initializing argument 4 of ‘virtual
SQLRETURN OdbcJdbcLibrary::OdbcObject::sqlError(UCHAR*, int*, UCHAR*,
int, SWORD*)’
../../MainUnicode.cpp: In function ‘SQLRETURN SQLExecDirectW(SQLHSTMT,
SQLWCHAR*, SQLINTEGER)’:
../../MainUnicode.cpp:374:79: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:372:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:100:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlExecDirect(SQLCHAR*,
int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLGetCursorNameW(SQLHSTMT, SQLWCHAR*, SQLSMALLINT, SQLSMALLINT*)’:
../../MainUnicode.cpp:389:88: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:386:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:90:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlGetCursorName(SQLCHAR*,
int, SQLSMALLINT*)’
../../MainUnicode.cpp: In function ‘SQLRETURN SQLPrepareW(SQLHSTMT,
SQLWCHAR*, SQLINTEGER)’:
../../MainUnicode.cpp:402:76: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:400:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:119:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlPrepare(SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLSetCursorNameW(SQLHSTMT, SQLWCHAR*, SQLSMALLINT)’:
../../MainUnicode.cpp:415:76: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:413:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:93:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlSetCursorName(SQLCHAR*,
int)’
../../MainUnicode.cpp: In function ‘SQLRETURN SQLColumnsW(SQLHSTMT,
SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT, SQLWCHAR*, SQLSMALLINT)’:
../../MainUnicode.cpp:437:36: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:429:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:121:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlColumns(SQLCHAR*, int,
SQLCHAR*, int, SQLCHAR*, int, SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLDriverConnectW(SQLHDBC, SQLHWND, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT, SQLSMALLINT*, SQLUSMALLINT)’:
../../MainUnicode.cpp:456:32: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:450:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcConnection.h:74:12: error:   initializing argument 3 of
‘SQLRETURN OdbcJdbcLibrary::OdbcConnection::sqlDriverConnect(SQLHWND,
const SQLCHAR*, int, SQLCHAR*, int, SQLSMALLINT*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLGetConnectOptionW(SQLHDBC, SQLUSMALLINT, SQLPOINTER)’:
../../MainUnicode.cpp:493:43: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:489:23: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcConnection.h:55:12: error:   initializing argument 3 of
‘SQLRETURN OdbcJdbcLibrary::OdbcConnection::sqlGetConnectAttr(int,
SQLPOINTER, int, SQLINTEGER*)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLSetConnectOptionW(SQLHDBC, SQLUSMALLINT, SQLULEN)’:
../../MainUnicode.cpp:601:48: error: conversion from
‘ConvertingString<>’ to ‘SQLINTEGER {aka int}’ is ambiguous
../../MainUnicode.cpp:598:23: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘SQLINTEGER
{aka int}’
../../OdbcConnection.h:80:12: error:   initializing argument 3 of
‘SQLRETURN OdbcJdbcLibrary::OdbcConnection::sqlSetConnectAttr(SQLINTEGER,
SQLPOINTER, SQLINTEGER)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLSpecialColumnsW(SQLHSTMT, SQLUSMALLINT, SQLWCHAR*, SQLSMALLINT,
SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT, SQLUSMALLINT,
SQLUSMALLINT)’:
../../MainUnicode.cpp:628:30: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:620:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:125:12: error:   initializing argument 3 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlSpecialColumns(short
unsigned int, SQLCHAR*, int, SQLCHAR*, int, SQLCHAR*, int, short
unsigned int, short unsigned int)’
../../MainUnicode.cpp: In function ‘SQLRETURN SQLStatisticsW(SQLHSTMT,
SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT, SQLUSMALLINT, SQLUSMALLINT)’:
../../MainUnicode.cpp:649:31: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:642:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:108:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlStatistics(SQLCHAR*,
int, SQLCHAR*, int, SQLCHAR*, int, int, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN SQLTablesW(SQLHSTMT,
SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT, SQLWCHAR*, SQLSMALLINT)’:
../../MainUnicode.cpp:671:34: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:663:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:122:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlTables(SQLCHAR*, int,
SQLCHAR*, int, SQLCHAR*, int, SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLForeignKeysW(SQLHSTMT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT,
SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT)’:
../../MainUnicode.cpp:739:39: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:727:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:106:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlForeignKeys(SQLCHAR*,
int, SQLCHAR*, int, SQLCHAR*, int, SQLCHAR*, int, SQLCHAR*, int,
SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN SQLNativeSqlW(SQLHDBC,
SQLWCHAR*, SQLINTEGER, SQLWCHAR*, SQLINTEGER, SQLINTEGER*)’:
../../MainUnicode.cpp:763:41: error: conversion from
‘ConvertingString<>’ to ‘SQLINTEGER {aka int}’ is ambiguous
../../MainUnicode.cpp:757:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘SQLINTEGER
{aka int}’
../../OdbcConnection.h:79:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcConnection::sqlNativeSql(SQLCHAR*,
SQLINTEGER, SQLCHAR*, SQLINTEGER, SQLINTEGER*)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLPrimaryKeysW(SQLHSTMT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT, SQLWCHAR*, SQLSMALLINT)’:
../../MainUnicode.cpp:782:35: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:776:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:107:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlPrimaryKeys(SQLCHAR*,
int, SQLCHAR*, int, SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLProcedureColumnsW(SQLHSTMT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT)’:
../../MainUnicode.cpp:804:39: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:796:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:94:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlProcedureColumns(SQLCHAR*,
int, SQLCHAR*, int, SQLCHAR*, int, SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN SQLProceduresW(SQLHSTMT,
SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT)’:
../../MainUnicode.cpp:823:35: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:817:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:95:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlProcedures(SQLCHAR*,
int, SQLCHAR*, int, SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLTablePrivilegesW(SQLHSTMT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT, SQLWCHAR*, SQLSMALLINT)’:
../../MainUnicode.cpp:842:36: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:836:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:123:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlTablePrivileges(SQLCHAR*,
int, SQLCHAR*, int, SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLColumnPrivilegesW(SQLHSTMT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*,
SQLSMALLINT, SQLWCHAR*, SQLSMALLINT, SQLWCHAR*, SQLSMALLINT)’:
../../MainUnicode.cpp:864:39: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:856:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:124:12: error:   initializing argument 2 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlColumnPrivileges(SQLCHAR*,
int, SQLCHAR*, int, SQLCHAR*, int, SQLCHAR*, int)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLColAttributeW(SQLHSTMT, SQLUSMALLINT, SQLUSMALLINT, SQLPOINTER,
SQLSMALLINT, SQLSMALLINT*, SQLPOINTER)’:
../../MainUnicode.cpp:920:40: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:914:23: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:68:12: error:   initializing argument 4 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlColAttribute(int, int,
SQLPOINTER, int, SQLSMALLINT*, SQLPOINTER)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLGetConnectAttrW(SQLHDBC, SQLINTEGER, SQLPOINTER, SQLINTEGER,
SQLINTEGER*)’:
../../MainUnicode.cpp:949:61: error: conversion from
‘ConvertingString<int>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:945:33: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen = int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcConnection.h:55:12: error:   initializing argument 3 of
‘SQLRETURN OdbcJdbcLibrary::OdbcConnection::sqlGetConnectAttr(int,
SQLPOINTER, int, SQLINTEGER*)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLGetDescFieldW(SQLHDESC, SQLSMALLINT, SQLSMALLINT, SQLPOINTER,
SQLINTEGER, SQLINTEGER*)’:
../../MainUnicode.cpp:988:61: error: conversion from
‘ConvertingString<int>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:984:33: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen = int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcDesc.h:90:12: error:   initializing argument 4 of ‘SQLRETURN
OdbcJdbcLibrary::OdbcDesc::sqlGetDescField(int, int, SQLPOINTER, int,
SQLINTEGER*)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLGetDiagFieldW(SQLSMALLINT, SQLHANDLE, SQLSMALLINT, SQLSMALLINT,
SQLPOINTER, SQLSMALLINT, SQLSMALLINT*)’:
../../MainUnicode.cpp:1042:67: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:1038:23: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcObject.h:55:20: error:   initializing argument 4 of ‘virtual
SQLRETURN OdbcJdbcLibrary::OdbcObject::sqlGetDiagField(int, int,
SQLPOINTER, int, SQLSMALLINT*)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLGetDiagRecW(SQLSMALLINT, SQLHANDLE, SQLSMALLINT, SQLWCHAR*,
SQLINTEGER*, SQLWCHAR*, SQLSMALLINT, SQLSMALLINT*)’:
../../MainUnicode.cpp:1074:38: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:1069:21: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcObject.h:57:12: error:   initializing argument 6 of
‘SQLRETURN OdbcJdbcLibrary::OdbcObject::sqlGetDiagRec(int, int,
SQLCHAR*, SQLINTEGER*, SQLCHAR*, int, SQLSMALLINT*)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLGetStmtAttrW(SQLHSTMT, SQLINTEGER, SQLPOINTER, SQLINTEGER,
SQLINTEGER*)’:
../../MainUnicode.cpp:1100:61: error: conversion from
‘ConvertingString<int>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:1096:33: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen = int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcStatement.h:91:12: error:   initializing argument 3 of
‘SQLRETURN OdbcJdbcLibrary::OdbcStatement::sqlGetStmtAttr(int,
SQLPOINTER, int, SQLINTEGER*)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLSetConnectAttrW(SQLHDBC, SQLINTEGER, SQLPOINTER, SQLINTEGER)’:
../../MainUnicode.cpp:1127:50: error: conversion from
‘ConvertingString<>’ to ‘SQLINTEGER {aka int}’ is ambiguous
../../MainUnicode.cpp:1124:23: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘SQLINTEGER
{aka int}’
../../OdbcConnection.h:80:12: error:   initializing argument 3 of
‘SQLRETURN OdbcJdbcLibrary::OdbcConnection::sqlSetConnectAttr(SQLINTEGER,
SQLPOINTER, SQLINTEGER)’
../../MainUnicode.cpp: In function ‘SQLRETURN
SQLSetDescFieldW(SQLHDESC, SQLSMALLINT, SQLSMALLINT, SQLPOINTER,
SQLINTEGER)’:
../../MainUnicode.cpp:1172:49: error: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:1169:23: note: candidates are:
../../MainUnicode.cpp:120:2: note:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen
= short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with
TypeRealLen = short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen =
short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
../../MainUnicode.cpp:115:2: note:   no known conversion for implicit
‘this’ parameter from ‘SQLCHAR* {aka unsigned char*}’ to ‘int’
../../OdbcDesc.h:91:12: error:   initializing argument 4 of ‘SQLRETURN
OdbcJdbcLibrary::OdbcDesc::sqlSetDescField(int, int, SQLPOINTER, int)’
make: *** [Release_x86_64/obj/MainUnicode.o] Error 1

[Firebird-odbc-devel] building firebird/odbc on Linux

[Sidney C. <si...@ji...>]

OdbcFb-LIB-2.0.0151.amd64.tar.gz

Re: [Firebird-odbc-devel] Accessing Firebird using ODBC from Python

[Sidney C. <si...@ji...>]

Hi Werner,

> Have you looked at SQLalchemy and using the native drivers to connect to
> this different db's?

Not really. I would prefer to use ODBC at this time, although
SQLAlchemy is on my list of things to investigate. For now, I'd like
to get a fix for my ODBC problem.

Re: [Firebird-odbc-devel] Accessing Firebird using ODBC from Python

[Werner F. B. <wer...@fr...>]

Sidney,

On 11/01/2011 11:34 AM, Sidney Cadot wrote:
> Hello,
>
> I am trying to get the Firebird/ODBC link to work via pyodbc (v2.1.7)
> and unixodbc (v2.2.14), under linux (amd64).
Can't help with your real problem, but I am curios why you are going 
down the ODBC route instead of using native drivers.
> It is noted that I am able to use pyodbc to connect to other databases
> (SQL server, mysql; postgresql).
>
Have you looked at SQLalchemy and using the native drivers to connect to 
this different db's?

http://www.sqlalchemy.org/docs/

Werner

[Firebird-odbc-devel] Accessing Firebird using ODBC from Python

[Sidney C. <si...@ji...>]

Hello,

I am trying to get the Firebird/ODBC link to work via pyodbc (v2.1.7)
and unixodbc (v2.2.14), under linux (amd64).

I am using "libOdbcFb.so" that I extracted from
OdbcFb-LIB-2.0.0151.amd64.tar.gz, as provided on the Firebird ODBC
download page from SourceForge. It is possible for me to connect the
remote Firebird server using the unixodbc-provided "isql" program, and
do queries, so I know the ODBC link can work properly.

However, when I try to contact the database from python using pyodbc,
things start to go awry:

import pyodbc
conn = pyodbc.connect("dbname=remote:/the/db/name.fdb;user=XXX;password=YYY;driver=Firebird")
Traceback (most recent call last):
  File "./get_db_info.py", line 81, in <module>
    dbConnection = pyodbc.connect(dsn)
pyodbc.Error: ('H', '[H] [unixODBC][ (0) (SQLDriverConnectW)')

I tried to supply the "ansi = True" option to pyodbc.connect(), but
the result is even less encouraging; it yields a segmentation fault.

It is noted that I am able to use pyodbc to connect to other databases
(SQL server, mysql; postgresql).

Does anybody have ideas what may be going wrong here? Any suggestions
on what to try next?

Sidney

[Firebird-odbc-devel] creating rpm for Mageia and Fedora

[Philippe M. <mak...@fi...>]

Hi,

I would like to create a rpm for Mageia and for Fedora

First problem :
setting FBINCDIR and FBLIBDIR
for Mageia and Fedora they have to be set to :

FBINCDIR=/usr/include/firebird/
FBLIBDIR=/usr/lib64/

or
FBINCDIR=/usr/include/firebird/
FBLIBDIR=/usr/lib/


makefile.environ seems to be modified for that

after a ugly patch
(just putting FBINCDIR=/usr/include/firebird/
FBLIBDIR=/usr/lib64/ after line 40 in makefile.environ)


the build fail :

cd ./Builds/Gcc.lin
make -f makefile.linux
../makefile.environ:12: ARCH is x86_64
../makefile.environ:27: ODBCMANAGER is unixODBC in /usr/lib64
../makefile.environ:48: FBINCDIR is /usr/include/firebird/
../makefile.environ:54: FBLIBDIR is /usr/lib64/

...

../../MainUnicode.cpp: In function ‘SQLRETURN SQLSetDescFieldW(void*,
SQLSMALLINT, SQLSMALLINT, void*, SQLINTEGER)’:
../../MainUnicode.cpp:1172:49: erreur: conversion from
‘ConvertingString<>’ to ‘int’ is ambiguous
../../MainUnicode.cpp:120:2: note: candidats sont:
ConvertingString<TypeRealLen>::operator SQLINTEGER() [with TypeRealLen =
short int, SQLINTEGER = int]
../../MainUnicode.cpp:119:2: note:
ConvertingString<TypeRealLen>::operator SQLSMALLINT() [with TypeRealLen
= short int, SQLSMALLINT = short int]
../../MainUnicode.cpp:117:2: note:
ConvertingString<TypeRealLen>::operator int() [with TypeRealLen = short int]
../../MainUnicode.cpp:115:2: note:
ConvertingString<TypeRealLen>::operator SQLCHAR*() [with TypeRealLen =
short int, SQLCHAR = unsigned char] <near match>
make: *** [Release_x86_64/obj/MainUnicode.o] Erreur 1



info :
$ gcc -v
Utilisation des specs internes.
COLLECT_GCC=gcc
COLLECT_LTO_WRAPPER=/usr/lib/gcc/x86_64-mageia-linux-gnu/4.5.2/lto-wrapper
Target: x86_64-mageia-linux-gnu
Configuré avec: ../configure --prefix=/usr --libexecdir=/usr/lib
--with-slibdir=/lib64 --with-bugurl=http://bugs.mageia.org/
--mandir=/usr/share/man --infodir=/usr/share/info
--enable-checking=release
--enable-languages=c,c++,ada,fortran,objc,obj-c++,java
--build=x86_64-mageia-linux-gnu --host=x86_64-mageia-linux-gnu
--with-cpu=generic --with-system-zlib --enable-threads=posix
--enable-shared --enable-objc-gc --enable-long-long
--enable-__cxa_atexit --disable-libunwind-exceptions
--enable-clocale=gnu --enable-java-awt=gtk
--with-java-home=/usr/lib/jvm/java-1.5.0-gcj-1.5.0.0/jre
--with-ecj-jar=/usr/share/java/eclipse-ecj.jar --enable-gtk-cairo
--disable-libjava-multilib --enable-ssp --disable-libssp
--disable-werror --with-ppl --with-cloog
--with-python-dir=/lib/python2.7/site-packages --enable-lto
Modèle de thread: posix
gcc version 4.5.2 (GCC)

Re: [Firebird-odbc-devel] SSIS ODBC ISSUE

[Hussein, E. <EHu...@ap...>]

I ended up creating linked server and then wrote a script to get all
tables and their data from the linked server into a my database. As soon
as I have everything on my database, I can use SSIS with no problem.

Hope that help.



This e-mail transmission may contain information that is privileged,
confidential and/or exempt from disclosure under applicable law. If you
are not the intended recipient, you are herby notified that any
disclosure, copying, distribution, or use of the information contained
herein is STRICTLY PROHIBITED. If you received this transmission in
error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format. 
Thank you.

-----Original Message-----
From: sadek [mailto:sad...@gm...] 
Sent: Sunday, August 28, 2011 10:30 AM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] SSIS ODBC ISSUE

Hello,

I have the same issue using SSIS 2008, ZZ did you find a workaround.

Thanks,
Sadek

--
View this message in context:
http://firebird.1100200.n4.nabble.com/SSIS-ODBC-ISSUE-tp3497997p3774454.
html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.

------------------------------------------------------------------------
------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] ODBC driver 2.0.151 / database growth / Oldest active transaction updated late

[Alexander P. <ale...@gm...>]

On 05.09.2011 13:20, Franz Batik wrote:
> This behaviour differs from the old ODBC driver version 2.0.0.142.
> When I use the old driver, the next transaction will increment in the 
> same way, but the oldest transaction will also do, so that the 
> difference willl normally be only 3.
> 1. How can I overcome this situation?
> 2. Is there a possibilty to specify a connection parameter to achieve 
> the old behaviour?
> 3. I have not found a way to directly issue ODBC statements over the 
> Delphi ADODB. This component seems to encapsulate ODBC completely. So 
> it might be difficult to do this, if this is the solution.
>
Please test 32-bit driver build that fixes this problem probably - 
http://tracker.firebirdsql.org/secure/attachment/12007/OdbcFb.zip

Alexander

-- 
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru

Re: [Firebird-odbc-devel] ODBC driver 2.0.151 / database growth / Oldest active transaction updated late

[Alexander P. <ale...@gm...>]

On 05.09.2011 13:20, Franz Batik wrote:
> Hi all,
> Since I use ODBC driver WI_T2.0.0.151 = OdbcFb.dll = v2-0 I encounter 
> the behaviour described below.
> This is different from the previous version I have used, OdbcFb32.dll 
> = WI_T2.0.0.142 = v2-0-beta
> I use Delphi 7 or XE (does not matter) and odbcfb.dll, Firebird 2.1.4
> Host system is Windows XP or Win7, does not matter.
> For test purpose I have also used Firebird 2.5, but this does not 
> change the situation.
> It rather seems to be a matter of the ODBC driver than the DB 
> (=datbase) version.
> The DB is accessed from Delphi via ADO and ODBC using the Delphi ADODB 
> components.
Hi,

Give me please sources of your test application (for Delphi 7) and the 
test database.


Alexander
-- 
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru

[Firebird-odbc-devel] ODBC driver 2.0.151 / database growth / Oldest active transaction updated late

[Franz B. <fra...@sp...>]

Hi all,
 
Since I use ODBC driver WI_T2.0.0.151 = OdbcFb.dll = v2-0 I encounter the
behaviour described below.
This is different from the previous version I have used, OdbcFb32.dll =
WI_T2.0.0.142 = v2-0-beta
 
I use Delphi 7 or XE (does not matter) and odbcfb.dll, Firebird 2.1.4
Host system is Windows XP or Win7, does not matter.
For test purpose I have also used Firebird 2.5, but this does not change the
situation. 
It rather seems to be a matter of the ODBC driver than the DB (=datbase)
version.
 
The DB is accessed from Delphi via ADO and ODBC using the Delphi ADODB
components.
 
Situation:
I create a test DB, an appropriate ODBC connection to it, and start 2 (test-)
programs acessing the same table concurrently through Delphi ADO Query like
"select * from users"
and display the contents on a Delphi TDbGrid and a TDbNavigator.
the I enter some records, and modify them.
 
The connection string for the TADOConnection is:
Provider=MSDASQL.1;Password=masterkey;Persist Security Info=True;User
ID=SYSDBA;Data Source=TRANSACTION_TEST
 
When I start 2 programs concurrently which access the same table, and modify som
records with the firtst program, the oldest transaction does not increment. 
The consequece (my assumption) seems to be that the database grows rapidly.
 
I have originally observed this in a production environment, where records are
updated very frequently, and read by a second program for evaluation purpose.
There I became aware of the unusual growth.
 
I could reproduce the situation with a small test program. In the production
environment the difference between oldest and next transaction grows to e.g.
100000, but the situation is basically the same as with the test programs.
 
This can be observerved with:
 
> gstat -h
D:\FUJITSO\G\SyLab\BT4300\DB_Firebird_uppercase_II\TRANSACTION_TEST.FDB
 
Database
"D:\FUJITSO\G\SyLab\BT4300\DB_Firebird_uppercase_II\TRANSACTION_TEST.FDB"

Database header page information:
        Flags                   0
        Checksum                12345
        Generation              188
        Page size               4096
        ODS version             11.2
        Oldest transaction      149
        Oldest active           150
        Oldest snapshot         150
        Next transaction        181
        Bumped transaction      1
        Sequence number         0
        Next attachment ID      22
        Implementation ID       16
        Shadow count            0
        Page buffers            0
        Next header page        0
        Database dialect        3
        Creation date           Sep 1, 2011 16:13:59
        Attributes              force write
 
    Variable header data:
        *END*
 
This behaviour differs from the old ODBC driver version 2.0.0.142.
When I use the old driver, the next transaction will increment in the same way,
but the oldest transaction will also do, so that the difference willl normally
be only 3.
 
1. How can I overcome this situation?
2. Is there a possibilty to specify a connection parameter to achieve the old
behaviour?
3. I have not found a way to directly issue ODBC statements over the Delphi
ADODB. This component seems to encapsulate ODBC completely. So it might be
difficult to do this, if this is the solution.
 
Thank you very much 
Best regards 
Franz Batik