dll 中使用ADOQuery 访问数据库,出错,错在那里?再帮看看
library dll;
uses
Windows, StrUtils, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, ADODB, DB, DBCtrls, ExtCtrls, Grids, DBGrids ,ActiveX;
{$R *.res}
var
ADOQuery: TADOQuery;
begin
CoInitialize(nil);
try
ADOQuery:=TADOQuery.Create(nil);
With ADOQuery do
begin
ADOQuery.ConnectionString:= 'Provider=MSDASQL.1;Persist Security Info=False;Data Source=MS Access Database;Initial Catalog=D:\data.mdb';
Close;
SQL.Clear;
SQL.Add('Select type,path From path');//出错在这个地方,还有什么我没引用?
Open;
ShowMessage('kkkkkk');
SQL.Clear;
Close;
end;
finally
CoUninitialize;
end;
end.
[解决办法]
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\data.mdb;Persist Security Info=True
你的连接串不对用这个协议Microsoft.Jet.OLEDB.4.0。建议在设计期你做好连接串,再放到临时创建时使用。