I use:

Dim Conn As adodb.Connection
Set Conn = New adodb.Connection

With Conn
.CursorLocation = adUseClient
.Open "DRIVER=Firebird/InterBase(r) driver; UID=name_user; PWD=password_user; DBNAME=IP_Server/Port_Server:Path+name_bd; CHARACTERSET=ISO8859_1; DIALECT=3;"

or

.Open "DRIVER=Firebird/InterBase(r) driver; UID=name_user; PWD=password_user; DBNAME=LocalHost:Path+name_bd; CHARACTERSET=ISO8859_1; DIALECT=3;"

End With

I do not work with UTF8 because VB6 works with ANSI

Regards
=========
|| ISMAEL ||
=========

----- Original Message -----
From: Jaison Joseph
To: firebird-support@yahoogroups.com
Sent: Thursday, June 16, 2011 6:12 AM
Subject: Re: [firebird-support] Firebird Connection String



On 16/06/2011 15:11, wiyono wrote:
> Dear All
>
> I am a newcomer here, how the connection string for firebird using adodb.
This is a sample connection string. You have to change the parameters
according to your need.

Provider=MSDASQL.1;Persist Security Info=False;User
ID=sysdba;Mode=ReadWrite;Extended
Properties="Driver={Firebird/InterBase(r)
driver};Dbname=localhost:D:\Data\MYDB.FDB;CHARSET=UTF8;UID=SYSDBA;Client=fbclient.dll;"

> I've installed Firebird_ODBC_2.0.0.151 and VB 6
>
> thanks
>
>
>
> ===============================================================================================
> Company privacy notice removed by Moderator
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>





[Non-text portions of this message have been removed]