🚀 go-pugleaf

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