🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Id and Password Login

#1681
From: Viatcheslav V. Vassiliev
Date: Sat, 27 Mar 2004 06:30
73 lines
3324 bytes
Yes. It seems that you use Access and it often raises this error when
connection string is invalid (when you pass property name that does not
exists). There is no property Id, there is User ID, i.e.

User ID=;Password=;

Default user id for MS Access is Admin. You may omit both user id and
password and write

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp\Test.mdb;

//------------------------------------------
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)

"Kim Utley" <kim@simsware.com> �������/�������� � �������� ���������:
news:4064a666$1@newsgroups.borland.com...
> Viatcheslav,
>
> Thanks much. I appreciate it.
>
> BTW, if I don't have an Id and password assigned to the file and yet
include
> the string "Id=;Password=;" in the ConnectionString I get an exception
about
> ISAM or some such (when I attempt to connect to the database). Is this
> normal behavior?
>
> Kindest Regards,
>
>
> Kim L. Utley
>
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:406448ef@newsgroups.borland.com...
> > TADOConnection::LoginPrompt = false; (may be set in designer).
> >
> > //------------------------------------------
> > 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)
> >
> > "Kim Utley" <kim@simsware.com> �������/�������� � �������� ���������:
> > news:4064489c$1@newsgroups.borland.com...
> > > Hello,
> > >
> > > Re: Builder 6 and TADO...
> > >
> > > Is there anyway to bypass the log in and password dialog box when
> > connecting
> > > to a database? Currently there is no Id or password assigned so all I
> have
> > > to do is click the Ok button but would like to avoid even doing that
if
> > > possible.
> > >
> > > TIA,
> > >
> > > Kim L. Utley
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID: <40651f8f$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <4064489c$1@newsgroups.borland.com> <406448ef@newsgroups.borland.com> <4064a666$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,2d86706eee08b140
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-03-26 22:39:18 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4064489c$1@newsgroups.borland.com> <406448ef@newsgroups.borland.com> <4064a666$1@newsgroups.borland.com>
Subject: Re: Id and Password Login
Date: Sat, 27 Mar 2004 09:30:40 +0300
Lines: 75
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: <40651f8f$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1080369039 213.234.218.42 (26 Mar 2004 22:30:39 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail