Re: Ado Password Question



Add "Jet OLEDB:Database Password=<Your password>;" to connection string.
User name and password are for case when you have and use workgroup file.

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


"John Killian" <johnpkillian@xxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:44edce2d$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi all,
D7, W2k, Ado, Access2000, MS Jet 4.0 Ole DB Provider
The database resides on a server and is password protected. Any
user that knows the password has access to this application.
I'm looking at the ado connection string data link properties
connection page. The connection string is there but what needs to
be entered in section 2 of this page? Username? Password is the
database password? Blank Password? Allow saving password?

Thanks
John




.



Relevant Pages

  • Re: Could not Update; Currently Locked
    ... Connection string should not contain these properties: ... Vassiliev V. V. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase ...
    (borland.public.delphi.database.ado)
  • Re: Connection String in SQL Server 2005 giving errors
    ... I am using SQLOLEDB and can connect to a SQL 2005 DB? ... SQLOLEDB as for MS SQL Server 2000. ... Vassiliev V. V. ... How can I find out what is wrong with my connection string? ...
    (borland.public.delphi.database.ado)
  • Re: Connection String in SQL Server 2005 giving errors
    ... Do you use new provider name for MS SQL Server 2005? ... SQLOLEDB as for MS SQL Server 2000. ... Vassiliev V. V. ... How can I find out what is wrong with my connection string? ...
    (borland.public.delphi.database.ado)
  • Re: One Connection String for Multiple Users (SQL)
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ... This uses the> same connection string for all instances of the application. ...
    (microsoft.public.sqlserver.connect)
  • RE: How do I configure Analysis Services for Excel 2003 users?
    ... they had had Office 2003 installed AFTER SQL Server. ... > I have been preparing a set of cubes in Analysis Services 2005 to be viewed ... > Excel reports have been designed as pivot tables based on AS cubes, ... > Surely it must be that the connection string is incorrect but I seem to have ...
    (microsoft.public.sqlserver.olap)