环境win2003,mssql2008,mysql odbc 5.1,
我在win2003上建立一个odbc源,然后在mssql中配置了一个数据连接测试是成功的,我可以select,update,delete,但是就不能insert,错误信息是
/* OLE DB provider "MSDASQL" for linked server "MYSQLAPP" returned message "[MySQL][ODBC 5.1 Driver][mysqld-5.0.52]Commands out of sync; you can't run this command now".Msg 7343, Level 16, State 2, Line 1The OLE DB provider "MSDASQL" for linked server "MYSQLAPP" could not INSERT INTO table "[MSDASQL]". */
我在win2003上建立一个odbc源,然后在mssql中配置了一个数据连接测试是成功的,我可以select,update,delete,但是就不能insert,错误信息是
/* OLE DB provider "MSDASQL" for linked server "MYSQLAPP" returned message "[MySQL][ODBC 5.1 Driver][mysqld-5.0.52]Commands out of sync; you can't run this command now".Msg 7343, Level 16, State 2, Line 1The OLE DB provider "MSDASQL" for linked server "MYSQLAPP" could not INSERT INTO table "[MSDASQL]". */
解决方案 »
- 请教复杂条件的查询优化问题
- MySQL an't connect to MySQL server on '192.168.73.110' (10061) Socket error on c
- 请问下如何在PHPMYADMIN中设置用户权限
- 一台linux上面安装多个mysql实例?
- 大家帮忙看看这个SQL查询怎么写
- 为什么只查出来一条记录?
- 在mysql 里实现 这两个表的合并。
- 请问mysql的触发器中如何调用dll?最好能有点例子,谢谢.
- 哪为高人做过DBMS啊?帮忙给指点一下,这学期我们课程设计要实现一个DBMS
- MySQL如何大批量更新?
- access 数据.mdb文件导入mysql数据库
- 编译mysql出错:Can't create/write to file '/usr/local/mysql/var/mysql/db.MYI' (Errcod
试试
insert into openquery(mysqlapp,'select id,name,code from temp') values(1,'1','2')
这个是我在mssql2008中运行代码时报的错误信息
这个SQL语句能在MYSQL正常执行?! 楼主没必要这样吧。
建表及插入记录的SQL贴出来
我在2005下测试一下
`ID` int(11) NOT NULL DEFAULT '0',
`NAME` varchar(100) DEFAULT NULL,
`CODE` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;INSERT INTO temp VALUES ('1', 'DifferentName', '2');
SELECT * FROM openquery(AA,'select id,name,code from temp')
1 DifferentName 2
1 1 2
1 1 2在2005下测试正常
贴结果
-> ;
+-------------------------------------------------------------------------------
---------------------------------------------------------+
| Grants for root@localhost
|
+-------------------------------------------------------------------------------
---------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*6BB
4837EB74329105EE4568DDA7DC67ED2CA2AD9' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
|
+-------------------------------------------------------------------------------
---------------------------------------------------------+
2 rows in set (0.00 sec)