bdp ms access connection string ?

[Skybuck Flying]

Hi,

I would like to build the connection string for the Borland Data Provider
(bdpConnection) class.

The ConnectionString property and if needed the ConnectionOptions.

Later I would like to switch to for example SQL server.

I know I can use delphi 8 for .net connection editor.

But I would like to do it manually (by hand) and I would like some
information about this.

It appears that for each database the connection string is different ? (also
for components it s different)

Where can I find information how to build these strings ? ;)

Bye,
Skybuck.

[Skybuck Flying]

Hmm

This seems a good one.

OLE DB is probably what I need.

( Microsoft Jet is for ms access.. I happen to know that ;) )

http://www.able-consulting.com/ADO_Conn.htm

[Skybuck Flying]

Unfortunately this is not enough...

More info is needed:

// unfortunately this is not enough:
{
Connection.ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;' +
'Data Source=C:\YourFolder\YourDatabase.mdb;' +
'User Id=;' +
'Password=';
}
// full string should look like this:
Connection.ConnectionString :=
'assembly=Borland.Data.Msacc,' +
'Version=1.5.0.0,' +
'Culture=neutral,' +
'PublicKeyToken=91d62ebb5b0d1b1b;' +
'vendorclient=msjet40.dll;' +
'database=C:\YourFolder\YourDatabase.mdb;' +
'provider=MSAccess;' +
'username=admin;' +
'password=';
So I still had to use the connection editor to get this string ;)

Skybuck.
"Skybuck Flying" <no****@hotmail.com> wrote in message
news:c4**********@news4.tilbu1.nb.home.nl...

Hmm

This seems a good one.

OLE DB is probably what I need.

( Microsoft Jet is for ms access.. I happen to know that ;) )

http://www.able-consulting.com/ADO_Conn.htm