Hardcoding servers driver in connection string



Hi,

I'm writing some spreadsheets using VBA, and I'm connecting to a
Firebird DB via ADO..

The spreadsheets are going to reside on a server as a shared file, and
when a client opens up the spread***, I would like for it to use the
ODBC driver on the server, not on the client opening the file..

What I'm hoping to be able to do is hardcode the servers driver into
the connection string, but I'm not sure of the syntax. Can someone
point me in the right direction, or is this even possible?

Or does anyone have any other suggestions? Here's the connection
string that I"m using now:

Dim dbMain As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim rs1 As New ADODB.Recordset
dbMain.Open "Driver=Firebird/InterBase(r)
driver;Uid=SYSDBA;Pwd=masterkey;DbName=\\server\export\export.fdb;"


Thanks
David

.