🚀 go-pugleaf

> Silly question: How do I tell what authentication I'm using?

Connection string with Windows authentication:

Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=DbName;

Connection string with user name and password:

Provider=SQLOLEDB;User ID=sa;Password=XXX;Initial Catalog=DbName;

DbName is name of database. You may need to add "Data Source=XXX" if MSDE is
not installed as default server. XXX is name of the server.

You can use TADOConnection and TADOQuery (or better, TADODataSet). You will
need to create database with CREATE DATABASE statement. Does MSDE installs
Books Online - help files? If so, all SQL is described there. If not - use
MSDN, it contains help for MS SQL Server.

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


"Simon Elliott" <Simon at ctsn.co.uk> �������/�������� � �������� ���������:
news:40b46a56@newsgroups.borland.com...
> On 26/05/2004, Viatcheslav V. Vassiliev wrote:
> > This could depend on installation - if you are using Windows
> > authentication - connection string in ADO should include "Integrated
> > Security=SSPI;" and no UserID and Password.
>
> Silly question: How do I tell what authentication I'm using?
>
> > Another option is SQL
> > Server authentication - by default user "sa" is installed with blank
> > password (if you did not entered password while setup process) - try
> > user name "sa" (without quotes) and your password or empty password.
> >
> > Service should be started too - reboot or start service manually. You
> > do not need domain controller or netword at all. However Windows 2000
> > or Windows XP may be needed - I am not sure that MSDE will run on
> > Win9X.
>
> I'm running on XP SP1. (I think there are some issues with SP2.)
>
> Although I can't get in via osql, MSDE manager from
> http://www.whitebearconsulting.com seems to be able to log me in. So I
> assume that things are OK so far. Now to write some code to access it.
>
> For a quick app, I can use TADOConnection and TADOquery, and use some
> make-table SQL statements to create my tables? I think  that the
> make-table syntax is slightly different between MS Access and SQL
> Server?
> -- 
> Simon Elliott    http://www.ctsn.co.uk