Connecting To A Database Without The Local Machines Odbc

[dwessell]

Hi,

I'm working on a spreadsheet that will connect to a firebird DB (Programmed using VBA and ADO intially).. The spreadsheet itself will reside on a in a server in a shared folder..

When a user opens the file up, I'd like for the spreadsheet to use the servers ODBC connection, and not the client machine.. This way we don't have to install the Firebird ODBC driver on each client workstation..

Is this possible?

Thanks
David

[Oorang]

I don't have a server to test this on, but what happens when you do this:[VBA]Dim oCnct As ADODB.Connection
Set oCnct = New ADODB.Connection
Set oCnct = VBA.CreateObject("ADODB.Connection", "YourServerName")
[/VBA]

[tstom]

If Oorang's suggestion does not work, Google "dsn-less connection ado". This is probably what you are looking for...