Quantcast

Connect IBProvider in VB

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Connect IBProvider in VB

Bart Smissaert
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect IBProvider in VB

Peter Gore-2
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:[hidden email]]
Sent: 05 March 2011 10:23
To: [hidden email]
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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect IBProvider in VB

Bart Smissaert
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
<[hidden email]> 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:[hidden email]]
> Sent: 05 March 2011 10:23
> To: [hidden email]
> 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
> [hidden email]
> 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
> [hidden email]
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect IBProvider in VB

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

-----Original Message-----
From: Bart Smissaert [mailto:[hidden email]]
Sent: 05 March 2011 11:13
To: [hidden email]
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
<[hidden email]> 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:[hidden email]]
> Sent: 05 March 2011 10:23
> To: [hidden email]
> 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
> [hidden email]
> 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
> [hidden email]
> 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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect IBProvider in VB

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

RBS


On Sat, Mar 5, 2011 at 11:18 AM, Peter Gore
<[hidden email]> wrote:

> The parameters you selected are the key ones and will certainly suffice for
> your evaluation.
>
> -----Original Message-----
> From: Bart Smissaert [mailto:[hidden email]]
> Sent: 05 March 2011 11:13
> To: [hidden email]
> 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
> <[hidden email]> 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:[hidden email]]
>> Sent: 05 March 2011 10:23
>> To: [hidden email]
>> 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
>> [hidden email]
>> 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
>> [hidden email]
>> 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
> [hidden email]
> 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
> [hidden email]
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect IBProvider in VB

Peter Gore-2
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:[hidden email]]
Sent: 05 March 2011 11:30
To: [hidden email]
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
<[hidden email]> wrote:
> The parameters you selected are the key ones and will certainly suffice
for

> your evaluation.
>
> -----Original Message-----
> From: Bart Smissaert [mailto:[hidden email]]
> Sent: 05 March 2011 11:13
> To: [hidden email]
> 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
> <[hidden email]> 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:[hidden email]]
>> Sent: 05 March 2011 10:23
>> To: [hidden email]
>> 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
>> [hidden email]
>> 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
>> [hidden email]
>> 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
> [hidden email]
> 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
> [hidden email]
> 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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect IBProvider in VB

Bart Smissaert
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
<[hidden email]> 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:[hidden email]]
> Sent: 05 March 2011 11:30
> To: [hidden email]
> 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
> <[hidden email]> wrote:
>> The parameters you selected are the key ones and will certainly suffice
> for
>> your evaluation.
>>
>> -----Original Message-----
>> From: Bart Smissaert [mailto:[hidden email]]
>> Sent: 05 March 2011 11:13
>> To: [hidden email]
>> 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
>> <[hidden email]> 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:[hidden email]]
>>> Sent: 05 March 2011 10:23
>>> To: [hidden email]
>>> 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
>>> [hidden email]
>>> 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
>>> [hidden email]
>>> 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
>> [hidden email]
>> 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
>> [hidden email]
>> 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
> [hidden email]
> 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
> [hidden email]
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Loading...