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

[Peter G. <pe...@go...>]

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