Post reply

Linked server connection issue.

  • April 26, 2010 at 3:55 pm

    #140082

    Hi all,

    I have an issue with creating a linked server.

    I need to create a linked server from sql to a teradata db.

    I dont have oledb provider for teradata installed on my server.

    Can I do that with any other provider?

  • April 27, 2010 at 2:46 am

    #1158033

    Do you have the Teradata ODBC driver?

    Can't speak for SQL2K5 but on SQL2K we use MS OLEDB for ODBC to connect with Teradata ODBC.

    Phil

  • April 27, 2010 at 5:57 am

    #1158132

    SQL 2k5 has dropped support for a lot of the older or "other" database types in linked server OLE DB availability. Also in SSIS, unfortunately.

    If you don't have a Teradata ODBC, you might have to call Microsoft on this one and ask them how to get around this issue.

    Does Jet work with Teradata?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • April 27, 2010 at 6:37 am

    #1158160

    I tried to use MS OLEDB provider for odbc devices....

    and it gives me the following error.

    any ideas on this error.?

    OLE DB provider "MSDASQL" for linked server "TERADATA" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

    Msg 7303, Level 16, State 1, Procedure sp_testlinkedserver, Line 1

    Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "TERADATA".

  • April 27, 2010 at 6:47 am

    #1158169

    yes, this means that you don't have a data source named 'TERADATA' available.

    For this to work you do still need to have the Teradata ODBC driver installed and an appropriate ODBC datasource configured.

  • April 27, 2010 at 6:51 am

    #1158173

    Teradata is the name of the linked server that I provided...

    its not the data source.

  • April 27, 2010 at 8:02 am

    #1158249

    What is Data Provider "MSDASQL"?

    I've never heard of this one before.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • April 27, 2010 at 8:04 am

    #1158250

    If you're using MS OLEDB for ODBC the config for your linked server needs to point to an ODBC data source name that's already configured on your server.

    In turn, that ODBC data source needs to be configured with an appropriate ODBC driver, in this case the Teradata ODBC driver.

    Hope that's clearer.

    Rgds

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply