🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: How to connect to password protected *.MDB via ADO (without ODBC)

#1853
From: Viatcheslav V. Vassiliev
Date: Sat, 24 Jan 2004 07:38
29 lines
2134 bytes
Workgroup file stores user names and passwords and is needed only if you are
use user name and password in connection string. If your database has
password, use

Jet OLEDB:Database Password=XXX

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

"Vladimir Stefanovic" <antivari@ptt.yu> �������/�������� � ��������
���������: news:4011298f$2@newsgroups.borland.com...
> When I try with...
> Provider=Microsoft.Jet.OLEDB.4.0
> ...it asks for a workgroup file when I 'Test connection'.
>
> When I try with...
> Provider=MSDASQL.1  (Microsoft OLE DB Provider for ODBC Drivers)
> ...it doesn't ask for a workgroup file, but asks for ODBC (logically).
>
>
> Thanks,
> Vladimir Stefanovic.
>
>
>
Technical Details
Message-ID: <401222a0$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!zeus.visi.com!priapus.visi.com!orange.octanews.net!news.octanews.net!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!newshosting.com!nx02.iad01.newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <4011298f$2@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,b8fb53ef03c550e7
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-01-23 23:57:41 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4011298f$2@newsgroups.borland.com>
Subject: Re: How to connect to password protected *.MDB via ADO (without ODBC)
Date: Sat, 24 Jan 2004 10:38:13 +0300
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 213.234.218.42
Message-ID: <401222a0$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1074930336 213.234.218.42 (23 Jan 2004 23:45:36 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!zeus.visi.com!priapus.visi.com!orange.octanews.net!news.octanews.net!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!newshosting.com!nx02.iad01.newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail