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

feelfly · #1 (**permalink**) 12-19-03, 06:59

3xs

omiossec · #2 (**permalink**) 12-19-03, 08:16

Could you be more explicit ?
Give us some clues

feelfly · #3 (**permalink**) 12-20-03, 03:39

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!

Internet Services

Web Development

Digital Marketing

Consumer Tech