Connecting to a DB without using 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 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

 

[PHV]

One way is to use a Citrix server.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dwessell]

Hi PHV,

I was hoping for something a little easier to implement Some way of handling the ADO DB connection that might let me do it.. Guess Im going to have to think some more about this one

Thanks
David

 

[dwessell]

Someone pointed me towards adding the driver (odbcjdbc.dll) as a reference in Excel.. Not having much luck with it, but it's a start..

Thanks
David

 

[jrbarnett]

Open the VBA editor (Alt F11) then go to Tools -> References and tick it in the list.

John

 

[dwessell]

Hi John,

Unfortunately that's where I'm running into the issue (Sorry, should have given more information).

When I attempt to add that file as a reference (odbcjdbc.dll) Excel tells me that it can't reference that file..

I'm not sure how to even begin troubleshooting it, but I'm checking into it, and trying to get some information from the makers of the driver. Any suggestions would be welcome..

Thanks
David