Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    18

    Unanswered: can ' insert into table select from....' connect remote database

    3xs

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Could you be more explicit ?
    Give us some clues
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Dec 2003
    Posts
    18
    sorry,my problem is not be expressed clearly.indeed ,I am trying to insert data from an MS-SQL Server database into a MySQL database ,MS-SQL use odbc or ado
    but Mysql I use embedded mysql so i don't if i can insert data from a remote MS-SQL Server database into a embedded MySQL database in batch.
    samely like 'insert into test01 selcct FROM Fund IN [ODBC] [ODBC;Driver=SQL Server;UID=admin;PWD=;Server=lacal);DataBase=CMBX
    MDM;]' can i realize it ? thanks!

Posting Permissions

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