labview与mysql数据库连接,利用navicat连接,新手求助,希望知道怎么修改能够运行
时间:10-02
整理:3721RD
点击:
ADO Error: 0x80040E14
NI_Database_API.lvlib:Rec Create - Command.vi->NI_Database_API.lvlib:Cmd Execute.vi->NI_Database_API.lvlib:DB Tools Insert Data.vi->连接MySQL.vi中的Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 5.3(w) Driver][mysqld-5.0.96-community-nt]Table 'test.test' doesn't exist
NI_Database_API.lvlib:Rec Create - Command.vi->NI_Database_API.lvlib:Cmd Execute.vi->NI_Database_API.lvlib:DB Tools Insert Data.vi->连接MySQL.vi中的Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 5.3(w) Driver][mysqld-5.0.96-community-nt]Table 'test.test' doesn't exist
字段名与表中的名称一致:WW,WWW
Table 'test.test' doesn't exist,表test.test不存在,表好像是test.123。表名不是test,改成123。
可能原因
ADO Error: 0x80040E14
NI_Database_API.lvlib:Rec Create - Command.vi->NI_Database_API.lvlib:Cmd Execute.vi->NI_Database_API.lvlib:DB Tools Insert Data.vi->连接MySQL.vi中的Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 5.3(w) Driver][mysqld-5.0.96-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '123(序号,名称) values (?,?)' at line 1 在程序框图中改了又有新错误,是否和我建的表内容不对有关?程序框图老师给的,可能我的修改问题,谢谢