Article View: borland.public.cppbuilder.database.ado
Article #1681Re: Id and Password Login
From: Viatcheslav V. Vassiliev
Date: Sat, 27 Mar 2004 06:30
Date: Sat, 27 Mar 2004 06:30
73 lines
3324 bytes
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-mailReferences:
<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