set ansi_nulls on
set ansi_warnings on
goselect * into tempTbl from OPENDATASOURCE("DRIVER={MySQL ODBC 3.51 Driver}",
"SERVER=192.168.1.6;DATABASE=mysql;USER ID=root;PASSWORD=123456;OPTION=3").mysql.MyISAM.testtable;go
set ansi_nulls off
set ansi_warnings off注:
.mysql.dbo.testtable;//这个是SQL SERVER里面指定数据库中testtable表的语句,在MySQL中我不会目前报错:未能找到 OLE DB 提供程序‘DRIVER={MySQL ODBC 3.51 Driver}’的注册表项
set ansi_warnings on
goselect * into tempTbl from OPENDATASOURCE("DRIVER={MySQL ODBC 3.51 Driver}",
"SERVER=192.168.1.6;DATABASE=mysql;USER ID=root;PASSWORD=123456;OPTION=3").mysql.MyISAM.testtable;go
set ansi_nulls off
set ansi_warnings off注:
.mysql.dbo.testtable;//这个是SQL SERVER里面指定数据库中testtable表的语句,在MySQL中我不会目前报错:未能找到 OLE DB 提供程序‘DRIVER={MySQL ODBC 3.51 Driver}’的注册表项
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=ServerName;User ID=MyUID;Password=MyPass'
).Northwind.dbo.Categories下面是个查询的示例,它通过用于 Jet 的 OLE DB 提供程序查询 Excel 电子表格。SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions