1

I have an ODBC connection to a Firebird database that tests successfully. Is there a way to use this ODBC connection within SQL Server 2008 R2 to access the tables? I haven't used Linked Servers before and wasn't sure if that was an option...and if so, what would be the provider needed/desired?

2

You should be able to create a Linked Server to almost any ODBC data source.

I would suggest trying the Microsoft OLE DB Provider for ODBC Drivers.

While you need to enter something in the Product Name field, I believe you can enter anything, such as "Firebird".

For Data Source, enter the name of the ODBC System DSN you've previously created.

You'll need to confirm the other options for "Security" and "Server Options", and test to see if it works.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.