You used:

> conn.ConnectionString = "Provider=MSDASQL.1;Persist Security
> Info=False;Extended Properties='DSN=MyERP;Driver=Firebird/InterBase(r)
>

driver;Dbname=C:\data\firebird\MYERP.FDB;CHARSET=NONE;UID=SYSDBA;Role=admin;Client=C:\fbembedded\fbembed.dll'"

I have unsuccessfully been trying to use the following in my D7 app
connecting thru an ADOConnection, using a UDL containing the following:

Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties="DSN=ALF_SU;Driver=Firebird/InterBase(r)
driver;Dbname=C:\ALF_SU\ALF.FDB;CHARSET=NONE;UID=SYSDBA;Role=admin;Client=C:\ALF_SU\FBClient.dll"

I'm getting a "can't connect to localHost, or something like this.

What am I doing wrong.
Sam