ADO newby ODBC error
From: Frits v/d Laan (F.vd.laan)
Date: 11/27/03
- Previous message: Mike Collier: "Re: Can I access oracle using Oracle's OLEDB Provider on Win98?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 27 Nov 2003 22:30:59 +0100
as a newby on ADO I get errorsmessages from the ODBC
Is (unlike the BDE) the ODBC not always availible??
When I test this procedure on my computer it works fine
but on another machine I get an errormessage
from the ODBC
and is this the way to make a (flexible) connection?
procedure TForm1.testconnectClick(Sender: TObject);
var mypath:string;
begin
mypath:=extractfilepath(application.exename)
mypath:=pad:=copy(pad,1,length(pad)-1); //get rid off the backslash
adotable1.active:=false;
adoconnection1.connected:=false;
adoconnection1.defaultdatabase:=mypath;
adoconnection1.connectionstring:='Provider=MSDASQL.1;Persist Security
Info=False;Data Source=dBASE Files;Mode=Read|Write'; //(no pathname
here)
adoconnection1.connected:=true;
adotable1.tablename:='myfile'; //an existing dBase4 file
adotable1.active:=true; // here the errormessage shows up
end;
- Previous message: Mike Collier: "Re: Can I access oracle using Oracle's OLEDB Provider on Win98?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
