Menu
▾
▴
firebird-odbc-devel
|
From: Bart S. <bar...@gm...> - 2011-03-05 10:22:48
|
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 |
|
From: Peter G. <pe...@go...> - 2011-03-05 10:50:18
|
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:bar...@gm...] Sent: 05 March 2011 10:23 To: fir...@li... 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 Fir...@li... 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 |
|
From: Bart S. <bar...@gm...> - 2011-03-05 11:13:10
|
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 <pe...@go...> wrote: > 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:bar...@gm...] > Sent: 05 March 2011 10:23 > To: fir...@li... > 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 > Fir...@li... > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
|
From: Peter G. <pe...@go...> - 2011-03-05 11:18:58
|
The parameters you selected are the key ones and will certainly suffice for your evaluation. -----Original Message----- From: Bart Smissaert [mailto:bar...@gm...] Sent: 05 March 2011 11:13 To: fir...@li... 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 <pe...@go...> wrote: > 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:bar...@gm...] > Sent: 05 March 2011 10:23 > To: fir...@li... > 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 > Fir...@li... > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > ---------------------------------------------------------------------------- -- 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 Fir...@li... 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 |
|
From: Bart S. <bar...@gm...> - 2011-03-05 11:29:38
|
OK, thanks. How did you find IBProvider compared to the ODBC driver? RBS On Sat, Mar 5, 2011 at 11:18 AM, Peter Gore <pe...@go...> wrote: > The parameters you selected are the key ones and will certainly suffice for > your evaluation. > > -----Original Message----- > From: Bart Smissaert [mailto:bar...@gm...] > Sent: 05 March 2011 11:13 > To: fir...@li... > 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 > <pe...@go...> wrote: >> 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:bar...@gm...] >> Sent: 05 March 2011 10:23 >> To: fir...@li... >> 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 >> Fir...@li... >> 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 >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> > > ---------------------------------------------------------------------------- > -- > 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 > Fir...@li... > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
|
From: Peter G. <pe...@go...> - 2011-03-06 07:05:38
|
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:bar...@gm...] Sent: 05 March 2011 11:30 To: fir...@li... 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 <pe...@go...> wrote: > The parameters you selected are the key ones and will certainly suffice for > your evaluation. > > -----Original Message----- > From: Bart Smissaert [mailto:bar...@gm...] > Sent: 05 March 2011 11:13 > To: fir...@li... > 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 > <pe...@go...> wrote: >> 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:bar...@gm...] >> Sent: 05 March 2011 10:23 >> To: fir...@li... >> 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 >> Fir...@li... >> 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 >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> > > ---------------------------------------------------------------------------- > -- > 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 > Fir...@li... > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > ---------------------------------------------------------------------------- -- 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 Fir...@li... 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 |
|
From: Bart S. <bar...@gm...> - 2011-03-06 09:25:04
|
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 <pe...@go...> wrote: > 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:bar...@gm...] > Sent: 05 March 2011 11:30 > To: fir...@li... > 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 > <pe...@go...> wrote: >> The parameters you selected are the key ones and will certainly suffice > for >> your evaluation. >> >> -----Original Message----- >> From: Bart Smissaert [mailto:bar...@gm...] >> Sent: 05 March 2011 11:13 >> To: fir...@li... >> 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 >> <pe...@go...> wrote: >>> 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:bar...@gm...] >>> Sent: 05 March 2011 10:23 >>> To: fir...@li... >>> 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 >>> Fir...@li... >>> 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 >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> >> >> > ---------------------------------------------------------------------------- >> -- >> 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 >> Fir...@li... >> 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 >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> > > ---------------------------------------------------------------------------- > -- > 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 > Fir...@li... > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X