Results 1 to 3 of 3

Thread: Opendatasource

  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Angry Unanswered: Opendatasource

    I'm trying to use OPENDATASOURCE in t-sql to update data on our AS/400 from MSSQL but don't know the property value for provider_name. Please help!!!

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    "Control Panel"\"Administrative Tools"\"Data Sources(ODBC)"
    Select a tab "File DSN", click "Add..", select server and click "Advanced".
    Now you see sub-driver for ODBC (MSDASQL)

    For MS SQL Server in MS SQL Server
    select *
    from OpenRowset('MSDASQL', 'Driver={SQL Server};Server=MyServer;User=MyUser','select * from sysobjects')

    I do not have A/400 driver installed, that is why I cannot test this for A/400.

    Good luck !

  3. #3
    Join Date
    Feb 2003
    Posts
    109

    my diagnosis

    my diagnosis is the your transactional properties of your neural defilibrator is going to require that you just replace the AS400 with SQL Server.

    you better get to work.
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

Posting Permissions

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