Hi, everyone,

I am new to firebird and eager to learn.

I have setup a firebird database server successfully already. I can connect from client machine using C# driver. But I failed in VBA. After installing ODBC driver, it still complaints "Provider cannot be found. It may not be properly installed." Can anyone give me some help? Thanks!

My code looks like this

Set conn = New ADODB.Connection
sConn = "DRIVER=Firebird/InterBase(r) driver;" + "DBNAME=" + FB_options + ";UID=sysdba; PWD=masterkey;"
conn.Open sConn