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?

Hannah Vernon ♦
71.1k22 gold badges178 silver badges324 bronze badges
asked May 15, 2014 at 21:50

1 Answer 1

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.

answered May 16, 2014 at 17:13
0

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.