PDA

View Full Version : Connecting To A Database Without The Local Machines Odbc



dwessell
05-03-2007, 11:58 AM
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
05-10-2007, 07:18 AM
I don't have a server to test this on, but what happens when you do this:Dim oCnct As ADODB.Connection
Set oCnct = New ADODB.Connection
Set oCnct = VBA.CreateObject("ADODB.Connection", "YourServerName")

tstom
05-10-2007, 02:41 PM
If Oorang's suggestion does not work, Google "dsn-less connection ado". This is probably what you are looking for...