470,591 Members | 1,759 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

bdp ms access connection string ?

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.
Nov 12 '05 #1
2 2195
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
Nov 12 '05 #2
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Andrew Arace | last post: by
13 posts views Thread by Zlatko Matić | last post: by
2 posts views Thread by Chuck Ritzke | last post: by
3 posts views Thread by sammyloo | last post: by
7 posts views Thread by Tony K | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.