🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #72

Re: Crate a MS Access database at runtime

#72
From: Viatcheslav Valerievitch Vassili...
Date: Wed, 12 Dec 2007 08:01
41 lines
2833 bytes
Look at connection string on http://www.connectionstrings.com/ . For your 
case connection string should be:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\risksk\rsisks01.mdb;User 
ID=boris;Password=letmein

I am not sure that Access database can be encrypted.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Mark Richards" <markcr@wapthespamntlworld.com> �������/�������� � �������� 
���������: news:475d86a4$1@newsgroups.borland.com...
>>  CatalogPtr cat = CoCatalog::Create();
>>  cat->Create(strConn);
>
> How do I set strConn to custom values?
>
> On a TForm i have several controls, which the user can enter details about 
> where to create the new database
>
> TEdit txtDatabasepath   Fully qualified file name entered here
> TEdit txtUserName       User name is entered here
> TEdit txtPassword         Password is entered here
> TCheckBox chkEncrypt If Checked then the database should be encrypted
>
> So for example
> txtDatabasepath->Text = "f:\risks\rsisks01.mdb";
> txtUserName->Text = "boris";
> txtPassword->Text = "letmein";
> chkEncrypt->Checked = true;
>
> What would I need to do to build the strConn for this?
>
>
> 
Technical Details
Message-ID: <475f9586$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!83.80.28.12.MISMATCH!multikabel.net!newsfeed10.multikabel.net!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <47598d82$1@newsgroups.borland.com> <475a8e59$1@newsgroups.borland.com> <475d86a4$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,2cb0116f91136979
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII
From: "Viatcheslav Valerievitch Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <47598d82$1@newsgroups.borland.com> <475a8e59$1@newsgroups.borland.com> <475d86a4$1@newsgroups.borland.com>
In-Reply-To: <475d86a4$1@newsgroups.borland.com>
Subject: Re: Crate a MS Access database at runtime
Date: Wed, 12 Dec 2007 11:01:37 +0300
Lines: 42
MIME-Version: 1.0
Content-Type: text/plain;
 format=flowed;
 charset="koi8-r";
 reply-type=response
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
X-Antivirus: avast! (VPS 071211-0, 11.12.2007), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 85.93.138.132
Message-ID: <475f9586$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1197446534 85.93.138.132 (12 Dec 2007 00:02:14 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!83.80.28.12.MISMATCH!multikabel.net!newsfeed10.multikabel.net!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail