Subject RE: [firebird-support] VB6 Connection String
Author Max Renshaw-Fox
From "README.TXT"

INSTALLATION:


1. Unpack "ibprov.zip" to any folder. Run "ibolereg.bat" to register
IB OLE DB Provider (It will be registered and added to the list of
available OLE DB Providers as "ZStyle IBOLE Provider")

Now you can run and explore ibdemo - "ibdemo.exe", and use provider
in your own applications.
2. Connection String for IB OLE DB driver should looks like this:

sConnStr = "Provider=ZStyle IBOLE Provider;Password=masterkey;User
ID=SYSDBA;SQL Dialect=3; Logging Level=0;Silent mode=True;Character
Set=WIN1251;Data Source=:c:\ibprov\Samples\Data\IBDEMO.GDB;Open Mode=0"

Where:

Provider - Your OLE DB driver name

Password - Database password

User ID - Database user

SQL Dialect - Client dialect to connect to database (1-3)

Open Mode - Define wether database assigned in "Data Source" should be
created (Value=1) or simply opened (Value=0 :Default)

Max

> Thank you Amarjit,
>
> I've downloaded as you said, I got the IBOLE.DLL and 2 batch files, one to
> register the dll in the registry & the other one is to unregister, then
> there is two text files one is the version update the other one is for
> license agreement. I could't find any connection sting here for vb6 to use
> with IBOLE.DLL
>
> Thank you
>
> Regards
> Visa
>
> AJS <softhut@...> wrote: Hello
> There,
>
> download the zip file:
>
> http://jupiter.host.ac/~amarjits/ibfree5.zip
>
> It has all the guddies and demos u need for VB6 to connect to FIREBIRD .
>
> Happy coding
>
> Amarjit Singh
>
> Voice: +91-98766-39035
>
> Yahoo!!!: amarjit_mayfair@...
>
> skype: amarjit_mayfair
>
> _____
>
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of visakan13
> Sent: Tuesday, May 08, 2007 6:49 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] VB6 Connection String
>
> Hi There,
>
> Does anyone know the connections String through vb6 for firebird &
> what is the ODBC driver I need to use?
>
> Thank you
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Yahoo! Mail is the world's favourite email. Don't settle for less, sign
> up for your freeaccount today.
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>