Post reply

Use SQLOLEDB (not SQLNCLI) with SQL 2005

  • February 14, 2006 at 3:48 am

    #170595

    Hi to all, I want to retrieve data from sql  6.5 and insert it into SQL 2005. How can i do it ?

    If I use linkedserver or openrowset I obtain error "SQL Native Client doesn' t support connections to sql server 6.5 or earlier"

    How can I do it ? (not using SSIS and ODBC is just the last beach!)

    this is a statement:

    SELECT

    * FROM OPENROWSET ('SQLOLEDB.1', 'Server=np:10.80.19.11;UID=sa;pwd=mypwd', 'SELECT * FROM master.dbo.sysobjects') AS a

    that returns...

    OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Client unable to establish connection".

    Msg 22, Level 16, State 1, Line 0

    SQL Native Client does not support connections to SQL 6.5 or earlier versions.

    within SQL 2000 the same work greatly...

    Any help would be appreciated!


    "...e il mio maestro mi insegnò com'è difficile trovare l'alba dentro l'imbrunire" F.Battiato - Prospettiva Nevsky

  • February 15, 2006 at 6:36 am

    #621002

    Use the Integration Services (SSIS) Import and Export Wizard to copy data between multiple instances of SQL Server. For more information, see Creating Packages Using the SQL Server Import and Export Wizard.

    http://msdn2.microsoft.com/en-us/library/ms141209.aspx

    Migrate data from a SQL Server 6.0 or SQL Server 6.5 database by using bcpout to export the data into a data file in character mode Then, use bcpin with the -V option to import the data into a SQL Server 2005 database. For more information, see Importing Native and Character Format Data from Earlier Versions of SQL Server.

    http://msdn2.microsoft.com/en-us/library/ms191212.aspx

  • February 9, 2009 at 2:24 pm

    #940828

    To add SQL Server 6.5 linked server in SQL Server 2005 (especially 64bit), ODBC is the only solution what I found so far.

    The steps are little bit tricky as well.

    Add System DSN ODBC connection for the SQL Server 6.5 and then add linked server to us the ODBC OLE driver in SQL Server 2005.

    Please refer to this link.

    http://knol.google.com/k/jeyong-park/add-sql-server-65-linked-server-in-sql/3vywlm4f31xae/6#view

Viewing 3 posts - 1 through 2 (of 2 total)

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