Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    3

    Unanswered: Problem during data porting using Linked Server

    Hi All,

    I have problems while using the Linked Server in MS SQL Server 2000 for data porting.

    The Scenario :

    I have about 900 hundred tables created in SQL Server database. These tables are freshly created and has no records.

    I have created a Linked Server with a DSN connecting to a Sybase database from which the data has to be ported to the newly created tables in SQL Server.

    The database creation as well as data porting is done by a Delphi application by executing the scripts in several .sql files.

    I have shown an example script below which does the data porting.

    INSERT INTO TEST_DATA (COL1,COL2,COL3)
    SELECT COL1,COL2,COL3 FROM [LINK_SYBASEDB]..[DBA].[TEST_DATA]


    The Issue :

    I often get the below error which stops the data porting process ( the error is logged in the Errorlog by the Delphi application )


    D:\DB\Port\TEST_DATA.SQL
    [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]


    NOTE : This error is NOT COMING CONSISTENTLY.Often I get this error and sometimes all the data is ported without this error.

    It will be great if any of you can help me to resolve this issue.

    Thanks in advance !!!

    regards,

    Hari Haran Arulmozhi

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I would bcp the data out and then back in...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •