qry.connection = ac1;
ds1.dataset = qry;ADO连接Oracle数据库时,测试时讲连接好了。程序运行时出现:
Debugger Exception Notification
---------------------------
Project Project1.exe raised exception class EOleException with message 'ORA-06413: 连接未打开'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------
也就是我想知道怎么使用ADO连接Oracle数据库,希望兄弟姐妹告知。
小弟我刚开始接触Oracle与delphi希望大家讲明白点。谢谢。
unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, StdCtrls;type
TForm1 = class(TForm)
Button1: TButton;
Edit1: TEdit;
ds1: TDataSource;
ac1: TADOConnection;
qry: TADOQuery;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}function OpenQuery(query:TADOQuery;SqlStr:string;ShowMsg:boolean=true):boolean;
begin
query.close;
query.Filter := '';
query.Filtered := false;
query.sql.clear;
query.sql.add(sqlstr);
try
query.open;
except
if ShowMsg then ShowMessage('打开'+query.name+'出错,sql语句为:'+sqlstr);
result := false;
exit;
end;
result := true;
end;
procedure TForm1.Button1Click(Sender: TObject);
var
str : string;
begin
str := 'select * from tin_cm ';
if not OpenQuery(qry,str) then exit;
with qry do
begin
edit1.Text := fieldbyname('cm_name').AsString;
end;
end;end.
ds1.dataset = qry;ADO连接Oracle数据库时,测试时讲连接好了。程序运行时出现:
Debugger Exception Notification
---------------------------
Project Project1.exe raised exception class EOleException with message 'ORA-06413: 连接未打开'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------
也就是我想知道怎么使用ADO连接Oracle数据库,希望兄弟姐妹告知。
小弟我刚开始接触Oracle与delphi希望大家讲明白点。谢谢。
unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, StdCtrls;type
TForm1 = class(TForm)
Button1: TButton;
Edit1: TEdit;
ds1: TDataSource;
ac1: TADOConnection;
qry: TADOQuery;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}function OpenQuery(query:TADOQuery;SqlStr:string;ShowMsg:boolean=true):boolean;
begin
query.close;
query.Filter := '';
query.Filtered := false;
query.sql.clear;
query.sql.add(sqlstr);
try
query.open;
except
if ShowMsg then ShowMessage('打开'+query.name+'出错,sql语句为:'+sqlstr);
result := false;
exit;
end;
result := true;
end;
procedure TForm1.Button1Click(Sender: TObject);
var
str : string;
begin
str := 'select * from tin_cm ';
if not OpenQuery(qry,str) then exit;
with qry do
begin
edit1.Text := fieldbyname('cm_name').AsString;
end;
end;end.
解决方案 »
- 难题,一个OCX的参数是WideString,我传递空的WideString进去导致了这个OCX 崩溃
- 如何得到ClientDataSet的Delta中的每条记录的更新状态??
- 简单问题!
- TNMHTTP,TIdHTTP组件POST XML到ASP无法接手!!!!!!!!!$#@%$@%
- 请教一个简单问题
- 100分求:TWebBrowser打开的网页里面如果有IFRAME怎么判断OnDocumentComplete事件!
- 哪里有联通或移动的发短消息的代码? 谢谢告诉我啊!
- 大量业务单据生成凭证有没有好的方案。。。。
- 如何调用SUM统计字段
- 如何用自定义函数对SQL进行控制?
- 放分
- fsMDIChild子窗體不能關閉,只能最小化,請高手幫忙!!!
你是怎么连接数据库的就是那段connectionstring
可能是那里有错数据库是在本地还是在远程?
msn:[email protected]
http://wwdn.kmip.net
问一下要想让dxDBEdit只能输入数字,应该怎么设置