[Firebird-odbc-devel] Connect IBProvider in VB

Discussion:

Bart Smissaert

2011-03-05 10:22:42 UTC

I know this is somewhat off-topic, but maybe somebody could tell me
where to get clear instructions how to connect to
Firebird (1.5) with IBProvider in VB, using ADO. I am trying to test
out the free version to see if it might be faster than the
IB Phoenix ODBC driver, but sofar I have been unable to connect.
I copied cc3250mt.dll and _IBProvider_x3_free_i.dll to
C:\WINDOWS\SYSTEM32\ and did a Regsvr32 on the last file.
I have tried various connection strings similar and with all kind of
variations to this one:

Provider=LCPI.IBProvider.3;
Data Source=localhost:C:\\DB\S6.FDB;
User id=UN;
password=PW;
ctype=win1251;
auto_commit=true

But sofar no success at all.
I am sure there must be something simple I am doing wrong, but I can't see it.

RBS

Peter Gore

2011-03-05 10:30:05 UTC

Permalink

Why the double backslash in the Data source?

I use IBProvider and find it great. I use Delphi myself and here is a
typical connection string

Provider=LCPI.IBProvider.2;Password=MYPASSWORD;Persist Security
Info=True;User ID=MYUSER;Data
Source=MyFBData;Location=MyServer:d:\data\fbdata\myfbdata.fdb;ctype=WIN1252;
garbage_collect=True;dialect=3;auto_commit=True;auto_commit_level=65536;bicu
rsor=False;free_threading=True;array_vt_type=True;inner_trans=True;truncate_
char=True;schema_cache=1;support_odbc_query=False;force_prepare_stmt=False;u
nicode_mode=True;unicode_stmt=True;std_exec_sp=True;clear_param_info=True;au
to_param_describe=True;force_param_describe=True;named_param_prefix=:;ignore
_unprepare=True;exec_sp_named_param=False;odbc_call_sp=0;auto_commit_ddl=0;a
uto_commit_ddl_level=4096;query_pool_size=8;auto_insert_field_rule=0;auto_up
date_field_rule=0;modify_trans_type=0;modify_trans_level=65536

Hope this helps

Regards
peter

-----Original Message-----
From: Bart Smissaert [mailto:***@gmail.com]
Sent: 05 March 2011 10:23
To: firebird-odbc-***@lists.sourceforge.net
Subject: [Firebird-odbc-devel] Connect IBProvider in VB

I know this is somewhat off-topic, but maybe somebody could tell me
where to get clear instructions how to connect to
Firebird (1.5) with IBProvider in VB, using ADO. I am trying to test
out the free version to see if it might be faster than the
IB Phoenix ODBC driver, but sofar I have been unable to connect.
I copied cc3250mt.dll and _IBProvider_x3_free_i.dll to
C:\WINDOWS\SYSTEM32\ and did a Regsvr32 on the last file.
I have tried various connection strings similar and with all kind of
variations to this one:

Provider=LCPI.IBProvider.3;
Data Source=localhost:C:\\DB\S6.FDB;
User id=UN;
password=PW;
ctype=win1251;
auto_commit=true

But sofar no success at all.
I am sure there must be something simple I am doing wrong, but I can't see
it.

RBS

----------------------------------------------------------------------------
--
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Bart Smissaert

2011-03-05 11:13:00 UTC

Permalink

Thanks, I figured this out now.
I connected from a string in a text file and that had linebreaks.
I thought these linebreaks were dealt with in my code, but they
weren't and clearing these
linebreaks sorted it out and I can connect fine now.
Will have a look at your connection string. Did you find that you
needed all those extra parameters or did you find they were
beneficial?

Do you find that IBProvider is faster than the IB Phoenix ODBC driver?

RBS

On Sat, Mar 5, 2011 at 10:30 AM, Peter Gore

Post by Peter Gore
Why the double backslash in the Data source?
I use IBProvider and find it great. I use Delphi myself and here is a
typical connection string
Provider=LCPI.IBProvider.2;Password=MYPASSWORD;Persist Security
Info=True;User ID=MYUSER;Data
Source=MyFBData;Location=MyServer:d:\data\fbdata\myfbdata.fdb;ctype=WIN1252;
garbage_collect=True;dialect=3;auto_commit=True;auto_commit_level=65536;bicu
rsor=False;free_threading=True;array_vt_type=True;inner_trans=True;truncate_
char=True;schema_cache=1;support_odbc_query=False;force_prepare_stmt=False;u
nicode_mode=True;unicode_stmt=True;std_exec_sp=True;clear_param_info=True;au
to_param_describe=True;force_param_describe=True;named_param_prefix=:;ignore
_unprepare=True;exec_sp_named_param=False;odbc_call_sp=0;auto_commit_ddl=0;a
uto_commit_ddl_level=4096;query_pool_size=8;auto_insert_field_rule=0;auto_up
date_field_rule=0;modify_trans_type=0;modify_trans_level=65536
Hope this helps
Regards
peter
-----Original Message-----
Sent: 05 March 2011 10:23
Subject: [Firebird-odbc-devel] Connect IBProvider in VB
I know this is somewhat off-topic, but maybe somebody could tell me
where to get clear instructions how to connect to
Firebird (1.5) with IBProvider in VB, using ADO. I am trying to test
out the free version to see if it might be faster than the
IB Phoenix ODBC driver, but sofar I have been unable to connect.
I copied cc3250mt.dll and _IBProvider_x3_free_i.dll to
C:\WINDOWS\SYSTEM32\ and did a Regsvr32 on the last file.
I have tried various connection strings similar and with all kind of
Provider=LCPI.IBProvider.3;
Data Source=localhost:C:\\DB\S6.FDB;
User id=UN;
password=PW;
ctype=win1251;
auto_commit=true
But sofar no success at all.
I am sure there must be something simple I am doing wrong, but I can't see it.
RBS
----------------------------------------------------------------------------
--
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Peter Gore

2011-03-05 11:18:29 UTC

Permalink

The parameters you selected are the key ones and will certainly suffice for
your evaluation.

-----Original Message-----
From: Bart Smissaert [mailto:***@gmail.com]
Sent: 05 March 2011 11:13
To: firebird-odbc-***@lists.sourceforge.net
Subject: Re: [Firebird-odbc-devel] Connect IBProvider in VB

Thanks, I figured this out now.
I connected from a string in a text file and that had linebreaks.
I thought these linebreaks were dealt with in my code, but they
weren't and clearing these
linebreaks sorted it out and I can connect fine now.
Will have a look at your connection string. Did you find that you
needed all those extra parameters or did you find they were
beneficial?

Do you find that IBProvider is faster than the IB Phoenix ODBC driver?

RBS

On Sat, Mar 5, 2011 at 10:30 AM, Peter Gore

Source=MyFBData;Location=MyServer:d:\data\fbdata\myfbdata.fdb;ctype=WIN1252;
garbage_collect=True;dialect=3;auto_commit=True;auto_commit_level=65536;bicu
rsor=False;free_threading=True;array_vt_type=True;inner_trans=True;truncate_
char=True;schema_cache=1;support_odbc_query=False;force_prepare_stmt=False;u
nicode_mode=True;unicode_stmt=True;std_exec_sp=True;clear_param_info=True;au
to_param_describe=True;force_param_describe=True;named_param_prefix=:;ignore
_unprepare=True;exec_sp_named_param=False;odbc_call_sp=0;auto_commit_ddl=0;a
uto_commit_ddl_level=4096;query_pool_size=8;auto_insert_field_rule=0;auto_up

Post by Peter Gore
date_field_rule=0;modify_trans_type=0;modify_trans_level=65536
Hope this helps
Regards
peter
-----Original Message-----
Sent: 05 March 2011 10:23
Subject: [Firebird-odbc-devel] Connect IBProvider in VB
I know this is somewhat off-topic, but maybe somebody could tell me
where to get clear instructions how to connect to
Firebird (1.5) with IBProvider in VB, using ADO. I am trying to test
out the free version to see if it might be faster than the
IB Phoenix ODBC driver, but sofar I have been unable to connect.
I copied cc3250mt.dll and _IBProvider_x3_free_i.dll to
C:\WINDOWS\SYSTEM32\ and did a Regsvr32 on the last file.
I have tried various connection strings similar and with all kind of
Provider=LCPI.IBProvider.3;
Data Source=localhost:C:\\DB\S6.FDB;
User id=UN;
password=PW;
ctype=win1251;
auto_commit=true
But sofar no success at all.
I am sure there must be something simple I am doing wrong, but I can't see it.
RBS

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

Post by Peter Gore
--
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com

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

Post by Peter Gore
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Bart Smissaert

2011-03-05 11:29:32 UTC

Permalink

OK, thanks.
How did you find IBProvider compared to the ODBC driver?

RBS

On Sat, Mar 5, 2011 at 11:18 AM, Peter Gore

Post by Peter Gore
The parameters you selected are the key ones and will certainly suffice for
your evaluation.
-----Original Message-----
Sent: 05 March 2011 11:13
Subject: Re: [Firebird-odbc-devel] Connect IBProvider in VB
Thanks, I figured this out now.
I connected from a string in a text file and that had linebreaks.
I thought these linebreaks were dealt with in my code, but they
weren't and clearing these
linebreaks sorted it out and I can connect fine now.
Will have a look at your connection string. Did you find that you
needed all those extra parameters or did you find they were
beneficial?
Do you find that IBProvider is faster than the IB Phoenix ODBC driver?
RBS
On Sat, Mar 5, 2011 at 10:30 AM, Peter Gore

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

signature

Post by Peter Gore
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus

signature

Post by Peter Gore
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com

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

----------------------------------------------------------------------------
--
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Peter Gore

2011-03-06 07:05:05 UTC

Permalink

Haven't really used ODBC much. All I can say is that IBProvider "does what
it says on the tin".
regards

-----Original Message-----
From: Bart Smissaert [mailto:***@gmail.com]
Sent: 05 March 2011 11:30
To: firebird-odbc-***@lists.sourceforge.net
Subject: Re: [Firebird-odbc-devel] Connect IBProvider in VB

OK, thanks.
How did you find IBProvider compared to the ODBC driver?

RBS

On Sat, Mar 5, 2011 at 11:18 AM, Peter Gore

Post by Peter Gore

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

Post by Peter Gore

signature

Post by Peter Gore
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus

signature

Post by Peter Gore
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com

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

Post by Peter Gore
--

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

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

----------------------------------------------------------------------------
--
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5929 (20110305) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Bart Smissaert

2011-03-06 09:24:53 UTC

Permalink

Have done a bit of testing and found that IBProvider was about a third
slower than
the ODBC driver. Will have a go now with fbdll4vb, which is a VB dll
based on the
IBPP Library. If anybody on this list has experience with that then I
would be very
interested.

RBS

On Sun, Mar 6, 2011 at 7:05 AM, Peter Gore

Haven't really used ODBC much. All I can say is that IBProvider "does what
it says on the tin".
regards
-----Original Message-----
Sent: 05 March 2011 11:30
Subject: Re: [Firebird-odbc-devel] Connect IBProvider in VB
OK, thanks.
How did you find IBProvider compared to the ODBC driver?
RBS
On Sat, Mar 5, 2011 at 11:18 AM, Peter Gore

Post by Peter Gore
The parameters you selected are the key ones and will certainly suffice

for

Post by Peter Gore
your evaluation.
-----Original Message-----
Sent: 05 March 2011 11:13
Subject: Re: [Firebird-odbc-devel] Connect IBProvider in VB
Thanks, I figured this out now.
I connected from a string in a text file and that had linebreaks.
I thought these linebreaks were dealt with in my code, but they
weren't and clearing these
linebreaks sorted it out and I can connect fine now.
Will have a look at your connection string. Did you find that you
needed all those extra parameters or did you find they were
beneficial?
Do you find that IBProvider is faster than the IB Phoenix ODBC driver?
RBS
On Sat, Mar 5, 2011 at 10:30 AM, Peter Gore

Post by Peter Gore

see

Post by Peter Gore

Post by Peter Gore
it.
RBS

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

Post by Peter Gore

signature

Post by Peter Gore
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus

signature

Post by Peter Gore
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com

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

Post by Peter Gore
--

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

signature

Post by Peter Gore
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus

signature

Post by Peter Gore
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com

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

----------------------------------------------------------------------------
--
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5929 (20110305) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel