ADO Connection

Hi,

I'm trying to connect to acces database from delphi.
I tried different examples, but each time when I connect
appear ado login dialog and prompt me for a user and
password. After pressing OK without any input the connection is
created successfull.

How is possible to skip this dialog. I tried with different DB without
success - each time appear this dialog.

Also I have not installed access on my machine. Maybe this is the reason?

Thanks in advance!

best regards

Ivan Krastev


----------------------------------------------------------------------------
--
here is a part of my source code

var
MyDBConnection : TADOConnection;
begin
// create the connection object
MyDBConnection := TADOConnection.Create(Application);
try
// set the connectionstring
MyDBConnection.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;'
+ 'Data Source=' + PrgDir +
'pcbis_sort.mdb;'
+ 'Persist Security Info=False';
// open the connection
MyDBConnection.Open;
// do whatever you want with this connection
// (...)
// close the connection
MyDBConnection.Close;
finally
// in all cases, free the object
MyDBConnection.Free;
end;
end;


.

Relevant Pages

  • Dialup connection - Netscape.net and Linux?
    ... Has anyone been successfull getting a dialup connection to Netscape.net ... as an internet service for a Linux box? ...
    (comp.os.linux.networking)
  • Re: Size
    ... >using the URLConnection how do i get the size of the above file in bytes ... >assuming the connection is successfull? ... the problem is the server might not tell you or might not even know. ...
    (comp.lang.java.programmer)
  • Re: Port 25 unstable
    ... At the same time I did it on another local server to the same ip. ... thoes were returned successfull. ... other times the port connection fails. ...
    (microsoft.public.exchange.admin)
  • Size
    ... using the URLConnection how do i get the size of the above file in bytes ... assuming the connection is successfull? ... Prev by Date: ...
    (comp.lang.java.programmer)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.ado)