Article View: borland.public.cppbuilder.database.ado
Article #72Re: Crate a MS Access database at runtime
From: Viatcheslav Valerievitch Vassili...
Date: Wed, 12 Dec 2007 08:01
Date: Wed, 12 Dec 2007 08:01
41 lines
2833 bytes
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-mailReferences:
<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