*******
Moderator asks this poster to post list messages from an email profile that does not include company messages.
*******
Dear Sir,

I have tried this





Set ACon = Nothing

Set ACmd = Nothing

Set ARec = Nothing



Set ACon = New ADODB.Connection

Set ACmd = New ADODB.Command

Set ARec = New ADODB.Recordset

sTemp =





ACon.ConnectionString = "DRIVER=Firebird/InterBase(r) driver;
UID=SYSDBA;PWD=masterkey;DBNAME=192.168.0.10:N:\FIREBIRD\MMC\MMC.gdb;"



ACon.Open

ACmd.ActiveConnection = ACon





but I get an error message [ODBC Firebird Driver]File Database is not found



This screenshot with IBExpert









From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Olaf Kluge
Sent: 16 Juni 2011 16:55
To: firebird-support@yahoogroups.com
Subject: [Spam] AW: [firebird-support] Firebird Connection String





Dear All

I am a newcomer here, how the connection string for firebird using adodb.

I've installed Firebird_ODBC_2.0.0.151 and VB 6

thanks

---

Hello,

here an example in VBA, should work in vb too:

Dim Conn As adodb.Connection

Dim strConn As String

strConn = "DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA;
PWD=masterkey; DBNAME=servername:d:\path\database.fdb;"

Set Conn = New adodb.Connection

Conn.ConnectionString = strConn

Conn.Open strConn

.

Best regards

Olaf

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






===============================================================================================
This e-mail transmission is intended solely for the ordinary user of the e-mail address
to which it was addressed. It may contain legally privileged and/or confidential information.
If you have received this e-mail in error or are not an intended recipient please inform
the sender with-out delay and delete this e-mail, attachments and possible copies immediately.
The unauthorized use, disclosure, distribution and/or copying of this e-mail or any information
it contains is prohibited

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