Re: [Firebird-odbc-devel] Connect IBProvider in VB

[Bart S. <bar...@gm...>]

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
>