Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to a DB without using the local machines ODBC

Status
Not open for further replies.

dwessell

Programmer
Jan 26, 2006
114
US
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
 
One way is to use a Citrix server.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
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
 
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
 
Open the VBA editor (Alt F11) then go to Tools -> References and tick it in the list.

John
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top