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

Re: [Firebird-odbc-devel] Firebird ODBC and Access

[ionutz g. <ion...@ya...>]

What about the Firebird server...is it installed on the same pc?..or are you planning to use the embedded version?




________________________________
From: blueskyabove <chr...@ne...>
To: fir...@li...
Sent: Thu, 22 October, 2009 3:32:46 AM
Subject: [Firebird-odbc-devel]  Firebird  ODBC and Access


I have installed the Firebird ODBC driver on an XP SP2 pc.
When I try configure the link in the ODBC Data Source Administrator and test
the connection to the database I get the following error message:

Open database 'C:\Program Files\OpenLM Server\db\OPENLM_DB.GDB' failed

I browsed to the database to set up the database location on my hard drive
so the database exists.
I have tried it with the database account, password and role all blank and
with values in these fields but always get the error when I try to test
connect.

Can anyone help please?

Thanks


-- 
View this message in context: http://www.nabble.com/Firebird--ODBC-and-Access-tp26002364p26002364.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



      __________________________________________________________________________________
Get more done like never before with Yahoo!7 Mail.
Learn more: http://au.overview.mail.yahoo.com/

Re: [Firebird-odbc-devel] "Driver" entry at ODBC.INI registry key

[Jorge A. B. <li...@da...>]

Roman:

Thanks for answering. I´ll try to be more specific:

- To use a ODBC DSN, you need:
  1) The ODBC driver registered (and the fbclient, etc)
  2) The DSN (Control Panel/Administrative Tools/Data Sources 
(ODBC)/System DSN

**** For (1) the following is created at registry:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Firebird/InterBase(r) driver]
"UsageCount"=dword:00000001
"Driver"="C:\\WINDOWS\\system32\\OdbcFb.dll"
"Setup"="C:\\WINDOWS\\system32\\OdbcFb.dll"
"FileExtns"="*.fdb,*.gdb"
"APILevel"="1"
"ConnectFunctions"="YYY"
"FileUsage"="0"
"DriverODBCVer"="03.51"
"SQLLevel"="1"

**** For (2) registry is filled with:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MyDSN]
"Description"="Test"
"CharacterSet"="ISO8859_1"
"ReadOnly"="N"
"NoWait"="N"
"Dialect"="3"
"QuotedIdentifier"="N"
"SensitiveIdentifier"="N"
"AutoQuotedIdentifier"="N"
"UseSchemaIdentifier"="0"
"LockTimeoutWaitTransactions"=""
"Driver"="C:\\WINDOWS\\system32\\OdbcFb.dll"
"SafeThread"="Y"
"Dbname"="192.168.1.59:C:\\fbdata\\TEST.FDB"
"Client"=""
"User"="SYSDBA"
"Role"=""
"JdbcDriver"="IscDbc"
"Password"="<encrypted-password-string>"

My question is at (2), specifically the value 
"Driver"="C:\\WINDOWS\\system32\\OdbcFb.dll". Thay value, is used or 
not? (at the C++ driver code, I'm not a C programmer and I wasn't able 
to check if it is used somewere).

Regards!

Roman Simakov escribió:
> That value is used by ODBC manager when you connect to the database and 
> provide described DSN. ODBC manager find necessary library.
>
> Or I still don't understand your question.
>
> You program can work in other way. I can't tell you. Maybe your driver 
> is self-registered in installer?
>
> You can start debug ODBC and look into messages. What driver is really used.
>
> --
> Roman
>
>
> Jorge Andrés Brugger wrote:
>   
>> Roman, I'm not talking about the driver install, but the DSN data. If 
>> you install the driver, and then create a ODBC DSN (for example, 
>> "TestDSN"), a new registry key is created at 
>> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TestDSN
>>
>> Inside that key, there is a value named "Driver", containing 
>> "C:\WINDOWS\system32\OdbcFb.dll" (if DSN was created in a WinXP box, 
>> change "windows" by "winnt" if using win2000).
>>
>> How is that value used by the driver? (I create the DSN inside my app 
>> installer, by adding the necessary registry entries, but today I've 
>> realized I was creating always "Driver=C:\WINDOWS\system32\OdbcFb.dll" 
>> but there is no such path on win2000).
>>
>> Roman Simakov escribió:
>>   
>>     
>>>> Jorge Andrés Brugger wrote:
>>>>
>>>> The "driver" value at the DSN saved into registry (pointing generally to
>>>> C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used?
>>>>
>>>> (I´ve configured a Windows 2000 with that value - Win2000 doesnt get
>>>> installed at \windows, but \winnt - ... however, driver seems to work
>>>> anyway)
>>>>
>>>> Regards!
>>>>
>>>>     
>>>>       
>>>>         
>>> How did you install odbc driver? While installing it is registered in
>>> registry, AFAIK.
>>> Run odbcad32.exe and look for driver location.
>>>
>>>   
>>>     
>>>       
>>   
>>     
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay 
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
>
>   

-- 
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar

Re: [Firebird-odbc-devel] "Driver" entry at ODBC.INI registry key

[Alan B. <_@_._>]

Jorge,

Read the "Driver" value from 
"HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Firebird/InterBase(r) driver" 
first

Then use this value when creating your own DSN  inside your app.

HTH

Alan



""Jorge Andrés Brugger"" <li...@da...> wrote in message 
news:4AE...@da......
> Roman, I'm not talking about the driver install, but the DSN data. If =
>
> you install the driver, and then create a ODBC DSN (for example, =
>
> "TestDSN"), a new registry key is created at =
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TestDSN
>
> Inside that key, there is a value named "Driver", containing =
>
> "C:\WINDOWS\system32\OdbcFb.dll" (if DSN was created in a WinXP box, =
>
> change "windows" by "winnt" if using win2000).
>
> How is that value used by the driver? (I create the DSN inside my app =
>
> installer, by adding the necessary registry entries, but today I've =
>
> realized I was creating always "Driver=3DC:\WINDOWS\system32\OdbcFb.dll" =
>
> but there is no such path on win2000).
>
> Roman Simakov escribi=F3:
>>> Jorge Andr=E9s Brugger wrote:
>>>
>>> The "driver" value at the DSN saved into registry (pointing generally to
>>> C:\WINDOWS\system32\OdbcFb32.dll), how and where it=B4s used?
>>>
>>> (I=B4ve configured a Windows 2000 with that value - Win2000 doesnt get
>>> installed at \windows, but \winnt - ... however, driver seems to work
>>> anyway)
>>>
>>> Regards!
>>>
>>>     =
>
>>
>> How did you install odbc driver? While installing it is registered in
>> registry, AFAIK.
>> Run odbcad32.exe and look for driver location.
>>
>>   =
>
>
> -- =
>
> Jorge Andr=E9s Brugger
> Inform=E1tica
> DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
> Comodoro Rivadavia, Chubut, Argentina
> Tel=E9fono (0297) 446-4444 int. 103
> Correo electr=F3nico: jbr...@da...
> Website: www.dasu.com.ar
>
>
>
> ---------------------------------------------------------------------------=
> ---
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay 
> =
>
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
> 

Re: [Firebird-odbc-devel] "Driver" entry at ODBC.INI registry key

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

That value is used by ODBC manager when you connect to the database and 
provide described DSN. ODBC manager find necessary library.

Or I still don't understand your question.

You program can work in other way. I can't tell you. Maybe your driver 
is self-registered in installer?

You can start debug ODBC and look into messages. What driver is really used.

--
Roman


Jorge Andrés Brugger wrote:
> Roman, I'm not talking about the driver install, but the DSN data. If 
> you install the driver, and then create a ODBC DSN (for example, 
> "TestDSN"), a new registry key is created at 
> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TestDSN
>
> Inside that key, there is a value named "Driver", containing 
> "C:\WINDOWS\system32\OdbcFb.dll" (if DSN was created in a WinXP box, 
> change "windows" by "winnt" if using win2000).
>
> How is that value used by the driver? (I create the DSN inside my app 
> installer, by adding the necessary registry entries, but today I've 
> realized I was creating always "Driver=C:\WINDOWS\system32\OdbcFb.dll" 
> but there is no such path on win2000).
>
> Roman Simakov escribió:
>   
>>> Jorge Andrés Brugger wrote:
>>>
>>> The "driver" value at the DSN saved into registry (pointing generally to
>>> C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used?
>>>
>>> (I´ve configured a Windows 2000 with that value - Win2000 doesnt get
>>> installed at \windows, but \winnt - ... however, driver seems to work
>>> anyway)
>>>
>>> Regards!
>>>
>>>     
>>>       
>> How did you install odbc driver? While installing it is registered in
>> registry, AFAIK.
>> Run odbcad32.exe and look for driver location.
>>
>>   
>>     
>
>   

Re: [Firebird-odbc-devel] "Driver" entry at ODBC.INI registry key

[Jorge A. B. <li...@da...>]

Roman, I'm not talking about the driver install, but the DSN data. If 
you install the driver, and then create a ODBC DSN (for example, 
"TestDSN"), a new registry key is created at 
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TestDSN

Inside that key, there is a value named "Driver", containing 
"C:\WINDOWS\system32\OdbcFb.dll" (if DSN was created in a WinXP box, 
change "windows" by "winnt" if using win2000).

How is that value used by the driver? (I create the DSN inside my app 
installer, by adding the necessary registry entries, but today I've 
realized I was creating always "Driver=C:\WINDOWS\system32\OdbcFb.dll" 
but there is no such path on win2000).

Roman Simakov escribió:
>> Jorge Andrés Brugger wrote:
>>
>> The "driver" value at the DSN saved into registry (pointing generally to
>> C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used?
>>
>> (I´ve configured a Windows 2000 with that value - Win2000 doesnt get
>> installed at \windows, but \winnt - ... however, driver seems to work
>> anyway)
>>
>> Regards!
>>
>>     
>
> How did you install odbc driver? While installing it is registered in
> registry, AFAIK.
> Run odbcad32.exe and look for driver location.
>
>   

-- 
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar

Re: [Firebird-odbc-devel] "Driver" entry at ODBC.INI registry key

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

> Jorge Andrés Brugger wrote:
>
> The "driver" value at the DSN saved into registry (pointing generally to
> C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used?
>
> (I´ve configured a Windows 2000 with that value - Win2000 doesnt get
> installed at \windows, but \winnt - ... however, driver seems to work
> anyway)
>
> Regards!
>

How did you install odbc driver? While installing it is registered in
registry, AFAIK.
Run odbcad32.exe and look for driver location.

-- 
Roman Simakov

[Firebird-odbc-devel] "Driver" entry at ODBC.INI registry key

[Jorge A. B. <li...@da...>]

The "driver" value at the DSN saved into registry (pointing generally to 
C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used?

(I´ve configured a Windows 2000 with that value - Win2000 doesnt get 
installed at \windows, but \winnt - ... however, driver seems to work 
anyway)

Regards!

-- 
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar

[Firebird-odbc-devel] Firebird ODBC and Access

[blueskyabove <chr...@ne...>]

I have installed the Firebird ODBC driver on an XP SP2 pc.
When I try configure the link in the ODBC Data Source Administrator and test
the connection to the database I get the following error message:

Open database 'C:\Program Files\OpenLM Server\db\OPENLM_DB.GDB' failed

I browsed to the database to set up the database location on my hard drive
so the database exists.
I have tried it with the database account, password and role all blank and
with values in these fields but always get the error when I try to test
connect.

Can anyone help please?

Thanks


-- 
View this message in context: http://www.nabble.com/Firebird--ODBC-and-Access-tp26002364p26002364.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.

[Firebird-odbc-devel] Problem with SQLBulkOperations

[Kirill M. <kir...@on...>]

Hi, all.

    See following code:

int main()
{
   SQLHENV envH;
   SQLHDBC dbcH;
   SQLHSTMT statH;
   SQLRETURN ret;
   SQLCHAR rstr[1024];
   int a1[100];
   int i;
   int rstrl;
   SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE, &envH);
   SQLSetEnvAttr(envH, SQL_ATTR_ODBC_VERSION, (void *) SQL_OV_ODBC2, 0);
   SQLAllocHandle(SQL_HANDLE_DBC,envH,&dbcH);
   ret=SQLDriverConnect(dbcH, NULL, "DSN=mytest;", SQL_NTS,
                            rstr, sizeof(rstr), &rstrl, 
SQL_DRIVER_COMPLETE);
   if (!SQL_SUCCEEDED(ret))
   	      {
            extract_error("SQLDriverConnect", dbcH, SQL_HANDLE_DBC);
            SQLFreeHandle(SQL_HANDLE_DBC,statH);
            SQLFreeHandle(SQL_HANDLE_ENV,envH);
            return 1;
           }
    SQLAllocHandle(SQL_HANDLE_STMT,dbcH,&statH);
    ret=SQLExecDirect(statH,"select * from test1",SQL_NTS);
    if (!SQL_SUCCEEDED(ret))
    	      {
    	       extract_error("SQLExecDirect", statH, SQL_HANDLE_STMT);
    	       return 1;
    	      }
    for (i=0;i<100;i++) a1[i]=i*10;
    SQLSetStmtAttr(statH,SQL_ATTR_ROW_ARRAY_SIZE,2,0);
    SQLBindCol(statH,1,SQL_C_SLONG,a1,sizeof(int),NULL);
    ret=SQLBulkOperations(statH,SQL_ADD);
    if (!SQL_SUCCEEDED(ret))
    	      {
    	       extract_error("SQLBulkOperations", statH, SQL_HANDLE_STMT);
    	       return 1;
    	      }
    SQLFreeHandle(SQL_HANDLE_STMT,statH);
    SQLFreeHandle(SQL_HANDLE_DBC,dbcH);
    SQLFreeHandle(SQL_HANDLE_ENV,envH);
    return 0;	
}

It executes ok, but I always have SQL_ERROR on SQLBulkOperations. What's 
wrong? Can't think of anything. Works fine on MySQL.
extract_error - it's just a function that prints out error text, but 
when SQLBulkOperations returns SQL_ERROR, SQLGetDiagRec returns error 
too and I don't know why error keeps happening.

Thanks.

[Firebird-odbc-devel] IIS 5 log via odbc to Firebird SQL

[Ann L. <an...@hr...>]

Hi,

Does anyone know of a successful case of using Firebird ODBC with 
Microsoft IIS on Win2000, such that web traffic logs are written 
directly to a Firebird database?  I tried.  I got to the point of 
having no errors listed in the event viewer but did not get any data logged.

I did not try on any machines with a later version of IIS.  The 
problem might be particular to Win2000.

I documented my steps here:
http://webhub.com/dynhelp:alias::iislogodbcfirebirdsql

As that did not work for us, we are working on a utility to import 
our .log files as a separate step, which is better in that it allows 
us to use more fields.

Nonetheless, I was curious whether anyone had tried this, and whether 
there was some way of turning on a verbose log for the odbc driver, 
to look for clues when the client software reports nothing.

Ann Lynnworth
HREF Tools Corp.
Member of Firebird Foundation

[Firebird-odbc-devel] RC2 or 2.0 status

[Jorge A. B. <li...@da...>]

149 build works fine for me, but it´s unavailable at Firebird website. 
Maybe a 2.0 RC2 could be released, and deleted all obsolete things 
existing at http://firebirdsql.org/index.php?op=files&id=odbc?

We don't need:

- Version 2.0 Beta
- Version 1.x Beta, Most Recent
- Version 1.2 (1.2.00.0070 and 1.2.0.69, both tagged as 1.2.1 even when 
version in name is 1.2.0)

Maintaining the site as is is just adding confusion to new visitors 
searching just an odbc driver.

Regards.

-- 
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar

[Firebird-odbc-devel] Firebird ODBC + Acrobat + JavaScript

[Mike M. <ma...@st...>]

Hello,

has anyone used JavaScript in PDF-Forms with the ODBC driver?

I can?t retrieve any values from the database.

This is my JavaScript code:

console.show();
console.clear();

var aList = ADBC.getDataSourceList();
for (var i = 0; i < aList.length; i++) {
console.println(aList[i].name);
console.println(aList[i].description);
}

try {
var sqlCon = ADBC.newConnection("db");

if (sqlCon == null)
throw "Connection failed";
} catch(e) {
console.println(e);
}

var stmt = sqlCon.newStatement();
stmt.execute("select g.gemeindename, g.gemeindehausnr,
g.gemeindeplz, g.gemeindeort from gemeinde g");

stmt.nextRow();

var row = stmt.getRow();

console.println("Gemeindename: " + row.GEMEINDENAME.value);
console.println("Gemeindehausnr: " + row.GEMEINDEHAUSNR.value);
console.println("Gemeindeort: " + row.GEMEINDEORT.value);

this.getField("gemeinde").value = row.GEMEINDENAME.value;
this.getField("gemeindeshausnr").value = row.GEMEINDEHAUSNR.value;
this.getField("gemeindeort").value = row.GEMEINDEORT.value;

Thanks for your help,

Mike

Re: [Firebird-odbc-devel] URGENT HELP REQUIRED:- Linux ODBC Driver for Interbase 5.5

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

On Wednesday 20 May 2009, Anuradha Chaturvedi wrote:
>
> I need to know from where can I get the Interbase5.5 ODBC driver which
> can be installed on SuSE Linux.
>

Maybe embarcadero/codegear can help. InterBase is their product. But I don't 
recall there was ever an odbc driver that worked on linux against IB 5.5.

This list is for primarily for discussing development of the Firebird odbc 
driver. Support InterBase 5.5 is way off our radar. 

You are welcome to check out the code and see if you can recompile it to 
work with IB 5.5 on SuSe linux. And if you need help I'm sure someone here 
will reply. We would even consider a patch if you wanted to contribute one.


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

Re: [Firebird-odbc-devel] URGENT HELP REQUIRED:- Linux ODBC Driver for Interbase 5.5

[Anuradha C. <Anu...@in...>]

Any updates on this please?

 

________________________________

From: Anuradha Chaturvedi 
Sent: Wednesday, May 20, 2009 1:51 PM
To: 'fir...@li...'
Cc: Anuradha Chaturvedi
Subject: RE: URGENT HELP REQUIRED:- Linux ODBC Driver for Interbase 5.5 

 

Just to add on to this I had downloaded this OdbcJdbc_1.2.0.69.tar from
IBPhoenix site 

http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc that lists IBPhoenix
Open Source ODBC Drivers

 

 

Thanks,

Anuradha.

 

________________________________

From: Anuradha Chaturvedi 
Sent: Wednesday, May 20, 2009 1:04 PM
To: 'fir...@li...'
Cc: 'Anu...@in...'
Subject: URGENT HELP REQUIRED:- Linux ODBC Driver for Interbase 5.5 

 

All,

 

I need to know from where can I get the Interbase5.5 ODBC driver which
can be installed on SuSE Linux.

I am currently trying to use OdbcJdbc_1.2.0.69.tar. This works for
connecting Interbase 2007 from SuSE Linux box.

But its not working for Interbase5.5. Its giving an error while I am
trying to connect from my application.

 

Would appreciate if somebody can help me in locating the correct driver
for Interbase 5.5 that can installed on SuSE Linux.

 

Thanks & Regards,

Anuradha.

Re: [Firebird-odbc-devel] URGENT HELP REQUIRED:- Linux ODBC Driver for Interbase 5.5

[Anuradha C. <Anu...@in...>]

Just to add on to this I had downloaded this OdbcJdbc_1.2.0.69.tar from
IBPhoenix site 

http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc that lists IBPhoenix
Open Source ODBC Drivers

 

 

Thanks,

Anuradha.

 

________________________________

From: Anuradha Chaturvedi 
Sent: Wednesday, May 20, 2009 1:04 PM
To: 'fir...@li...'
Cc: 'Anu...@in...'
Subject: URGENT HELP REQUIRED:- Linux ODBC Driver for Interbase 5.5 

 

All,

 

I need to know from where can I get the Interbase5.5 ODBC driver which
can be installed on SuSE Linux.

I am currently trying to use OdbcJdbc_1.2.0.69.tar. This works for
connecting Interbase 2007 from SuSE Linux box.

But its not working for Interbase5.5. Its giving an error while I am
trying to connect from my application.

 

Would appreciate if somebody can help me in locating the correct driver
for Interbase 5.5 that can installed on SuSE Linux.

 

Thanks & Regards,

Anuradha.

[Firebird-odbc-devel] URGENT HELP REQUIRED:- Linux ODBC Driver for Interbase 5.5

[Anuradha C. <Anu...@in...>]

All,

 

I need to know from where can I get the Interbase5.5 ODBC driver which
can be installed on SuSE Linux.

I am currently trying to use OdbcJdbc_1.2.0.69.tar. This works for
connecting Interbase 2007 from SuSE Linux box.

But its not working for Interbase5.5. Its giving an error while I am
trying to connect from my application.

 

Would appreciate if somebody can help me in locating the correct driver
for Interbase 5.5 that can installed on SuSE Linux.

 

Thanks & Regards,

Anuradha.

[Firebird-odbc-devel] ODBC driver on XP 64bit

[Marek M. <mar...@at...>]

Hi,

I have problem to use ODBC 64bit driver on Win XP 64. I used 2.0.0.148 version a tried this test:

public void Test()
{
    string cn = "DRIVER={Firebird/InterBase(r) driver};Dialect=3;PASSWORD=sysdba;User=sysdba;Database=database.fdb;ServerType=1";
    
    using (OdbcConnection conn = new OdbcConnection(cn))
    {
        conn.Open();

        OdbcCommand cmd = new OdbcCommand();
        cmd.Connection = conn;
        cmd.CommandText = "select * from tbl_test";

        using (OdbcDataReader reader = cmd.ExecuteReader())
        {
            while (reader.Read())
            {
                long id = reader.GetInt64(reader.GetOrdinal("ID"));
                string nazev = reader.GetString(reader.GetOrdinal("nazev"));

                string poznamka = "null";
                if (!reader.IsDBNull(reader.GetOrdinal("poznamka")))
                {
                    poznamka = reader.GetString(reader.GetOrdinal("poznamka"));
                }
            }
        }
    }
}

But it throws exception when in column "poznamka" is null value:

---------------------------
System.OverflowException: Arithmetic operation resulted in an overflow.
   at System.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, Int32 cb, Int32& cbActualOut)
   at System.Data.Odbc.OdbcDataReader.internalGetString(Int32 i)
   at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
   at System.Data.Odbc.OdbcDataReader.IsDBNull(Int32 i)
   at FbTest.Form1.Test()
---------------------------

Could you advice me where is a problem? Is it a bug in Firebird ODBC driver or do I something wrong? (It works fine with 32bit driver on 32bit windows.)

Thanks,

Smoke

Re: [Firebird-odbc-devel] Help Required with odbc x64

[Nikolay S. <nik...@re...>]

Hello, Simon!

Can you please dig the problem a bit deeper?
What tool are you using with the x64 driver? What does the ODBC SQL 
trace look like?
Maybe you can point to a function call where the driver gives wrong result?

Simon Watkins wrote:
> I'm having trouble using the newly released odbc 64 bit windows 
> Firebird Driver.
>
>
> I'm trying to connect to a number of firebird databases (vers 1.5.4 on 
> Windows 32 op sys).
> The client machine I'm using is running database software called 
> Intersytsems Caché, but that's not relevant. The point is that it's 
> using Miscorosft Windows Server 2003 R2 x64, service Pack 2. That 
> means I have to use the newly released 2.00.00.148 odbc x64 driver (19 
> Nov 2008).
> (The client DLL I use is the fbclient.dll from 
> Firebird-2.1.2.18118-0_x64 download)
>
> The problem;
> The connection is succesful when tested. However, the tables and views 
> are not exposed. All you manage to see is "no schema".
> In order to debug this, I downloaded and installed the 32 bit odbc 
> driver on to another windows box. This driver displays the schema as 
> "null schema" and when selected you are able to see the views and 
> tables correctly. It seems to definitely be a problem swith the 64 bit 
> driver.
> Is there a patch ?
>
> --
> Simon
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image 
> processing features enabled. http://p.sf.net/sfu/kodak-com
> ------------------------------------------------------------------------
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>   


-- 
Nikolay Samofatov, MBA
Red Soft Corporation
+1 416 710 6854
+7 495 721 3537

[Firebird-odbc-devel] Help Required with odbc x64

[Simon W. <sim...@ya...>]

I'm having trouble using the newly released odbc 64 bit windows Firebird Driver.


I'm trying to connect to a number of firebird databases (vers 1.5.4 on Windows 32 op sys).
The client machine I'm using is running database software called Intersytsems Caché, but that's not relevant. The point is that it's using Miscorosft Windows Server 2003 R2 x64, service Pack 2. That means I have to use the newly released 2.00.00.148 odbc x64 driver (19 Nov 2008).
(The client DLL I use is the fbclient.dll from Firebird-2.1.2.18118-0_x64 download)

The problem;
The connection is succesful when tested. However, the tables and views are not exposed. All you manage to see is "no schema".
In order to debug this, I downloaded and installed the 32 bit odbc driver on to another windows box. This driver displays the schema as "null schema" and when selected you are able to see the views and tables correctly. It seems to definitely be a problem swith the 64 bit driver.
Is there a patch ?

--
Simon


      

Re: [Firebird-odbc-devel] Using the ODBC Driver on Vista 64

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

Kevin,

Kevin Preston wrote:
> HI,
...
> 
> ERROR [08004] [ODBC Firebird Driver]Unable to connect to data source: 
> library 'gds32.dll' failed to load
> 
>  
> 
> There is a gds32.dll file in the system32 folder (version 6.0.1.0) and 
> also one in the sysWOW64 (version 6.3.5.13206)
> 
>  
I would make sure to point ODBC to the Firebird client library, either 
using the Windows Datasource admin tool or by setting it using your 
installer (e.g. InnoSetup), i.e.:

; ODBC entries
Root: HKLM; SubKey: Software\ODBC\ODBC.INI\ODBC Data Sources; ValueType: 
string; ValueName: YourDataSourceName; ValueData: Firebird/InterBase(r) 
driver; Flags: createvalueifdoesntexist uninsdeletevalue
Root: HKLM; SubKey: Software\ODBC\ODBC.INI\YourDataSourceName; Flags: 
createvalueifdoesntexist uninsdeletevalue; ValueName: Driver; ValueType: 
string; ValueData: C:\WINDOWS\System32\OdbcFb32.dll
Root: HKLM; SubKey: Software\ODBC\ODBC.INI\YourDataSourceName; Flags: 
createvalueifdoesntexist uninsdeletevalue; ValueName: Dbname; ValueType: 
string; ValueData: {code:GetDataDir}\twcb.fdb
Root: HKLM; SubKey: Software\ODBC\ODBC.INI\YourDataSourceName; Flags: 
createvalueifdoesntexist uninsdeletevalue; ValueName: Client; ValueType: 
string; ValueData: {app}\prog\fbclient.dll

The last line sets the client library.

You might want to manually set it using the datasource admin tool and 
then extract all the HKLM entries and then adjust your installer.

Note sure this will correct all your problems, but at least you use a 
more up to date client.


Werner

Re: [Firebird-odbc-devel] Using the ODBC Driver on Vista 64

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

On Thursday 30 April 2009, Kevin Preston wrote:
>
> I have tried both the 32 and 64 bit version of the Firebird ODBC driver
> on my Vista64 OS.

I can't say I've ever really used Vista seriously so my comments my not be 
of much help, but...
>
> The 32 bit version is not even recognised while I try to run my
> application.
>

Can you see the 32-bit driver in the 32-bit ODBC admin app in the 32-bit 
control panel?


> When I use the 64 bit version the driver is recognised but a get the
> following error:
>
> ERROR [08004] [ODBC Firebird Driver]Unable to connect to data source:
> library 'gds32.dll' failed to load
>
> There is a gds32.dll file in the system32 folder (version 6.0.1.0) and
> also one in the sysWOW64 (version 6.3.5.13206)
>

I wonder how the gds32.dll v.6.0.1.0 got into the system32 folder? Did you 
copy it there? From the version string it is probably from InterBase 6.0, 
or perhaps an early version of Firebird 1.0. It is certainly a 32-bit 
library. 


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

[Firebird-odbc-devel] Compiling under windows... testing?

[Gabriel C. <gab...@x-...>]

Hi

I donwload obdc source code to make a little change.
I compilted with Dev-C++5 and I obtain "OdbcFB32.dll"

How can I Tested?

I'm using "OdbcFb v.RC1-2.0.0148" . I only found this dll in 
\windows\sytem32:

IscDbc.dll
OdbcFb.dll
OdbcJdbc.dll
OdbcJdbcSetup.dll

I must replace "OdbcFb.dll" for "OdbcFB32.dll"  (changing the name to 
"OdbcFb.dll") ?


Sorry for my ignorance, I'm really very new in this stuff and sorry for 
my English.

Thanks a lot

Gabriel Centenari

[Firebird-odbc-devel] Compiling under windows

[Gabriel C. <gab...@xs...>]

Hi

I donwload firebird odbc source code to make some litle change.
I compiled with Dev-C++ 5 and I obtain  "OdbcFb32.dll".

How can I test ?

I Think I 'll have  "IscDbc.dll" or "OdbcFB.dll" or "OdbcJdbc.dll" or 
maybe "OdbcJdbcSetup.dll" .

Sorry for my ignorance, I'm really new in this stuff and Sorry for my 
English.

Thanks a lot.

Gabriel Centenari

[Firebird-odbc-devel] Using the ODBC Driver on Vista 64

[Kevin P. <kev...@pc...>]

HI,

 

I am developing an application using VS2008 on vista 64. I will be targeting
32 os when distributing.

 

I have tried both the 32 and 64 bit version of the Firebird ODBC driver on
my Vista64 OS.

 

The 32 bit version is not even recognised while I try to run my application.

 

When I use the 64 bit version the driver is recognised but a get the
following error: 

 

ERROR [08004] [ODBC Firebird Driver]Unable to connect to data source:
library 'gds32.dll' failed to load

 

There is a gds32.dll file in the system32 folder (version 6.0.1.0) and also
one in the sysWOW64 (version 6.3.5.13206)

 

below is the connection string I am using: 

 

DRIVER=Firebird/InterBase(r) driver; DBNAME=MIRROR:C:\MT32\Data\MT32.IB;
UID=SYSDBA; PWD=masterkey;

 

this is a valid connection string as far as connecting to the target
database is concerned as it works in an earlier version using a 32-bit
development environment.

 

Any help would be very much appreciated.

 

Cheers,

Kevin.

 

Re: [Firebird-odbc-devel] [Suspected Spam] Re: Firebird ODBC: x64data lengthcompatibility

[Engineering <eng...@as...>]

   I tried to attach the patch, however for some reason the "attach" did
not work (was using Google Chrome at the time, I think). I have attached
the patch here, however with some reservations:
  - this patch just makes SQL_C_BIT treatment as a TinyInt for output.
This may work in Windows, because of BOOL == int, however I do not know
if this is the general case. May be a better idea to have BOOL == char
(and at least on little-endian systems will not really care).
  - the change would assume that only 1 or 0 can be inside the
selection, however it will happily transfer 2,3,4 and so on (which is
hardly a BIT). I did consider writing a "tinyIntAsBit" which would make
0 == 0 and non-zero == 1, however for our internal functions we did not
need it so I ended up with this fairly dirty hack.

Regards,
Andrei

-----Original Message-----
From: Nikolay Samofatov [mailto:nik...@re...] 
Sent: Thursday, April 23, 2009 2:36 PM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] [Suspected Spam] Re: Firebird ODBC:
x64data lengthcompatibility

Andrei,

Engineering wrote:
>
> I found the JIRA tracker after a while (did submit a SQL_BIT support 
> patch in the mean time there) .. however that was quite hard to find 
> and I found the ODBC devel list instead. Since I got the message from 
> Nikolay that the patch was applied to 2.0, I guess I can skip the 
> posting in the tracker, however I will add any new patches there. 
> Thank you for the info.
>
> What are firebird developers likely to check - the devel list or the 
> tracker? The tracker seems to have few issues, but some of them seem 
> really ancient.
>
Myself and other guys from our lab (e.g. Roman Simakov) I know read odbc

devel mailing list regularly. However if everyone is busy, some messages

may be left unprocessed.
If an item is posted to the tracker only it will get some attention for 
sure, but it is checked less frequently.

Re SQL_BIT, I may apply this patch to HEAD. But could you please attach 
patch file to an issue instead of placing it inline as comments - it 
does not apply cleanly at this moment.

> Regards,
>
> Andrei
>


-- 
Nikolay Samofatov, MBA
Red Soft Corporation
+1 416 710 6854
+7 495 721 3537



------------------------------------------------------------------------
------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally facing

server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel