>Want to run some upsizing tests with the new Sedna Upsizing Wizard , but am having difficulty with MS SQL 2005 Express. Anyone had any experience with this product?
>
>I've used MS SQL in the past (with VB6 & VFP & SQL2000), but this beast seems to not want to allow me to access it.
>
>I've done a default install, with Windows Authentication, and I can't seem to get any access to it outside of the MS SQL Server Management Studio Express.
>
>Cannot even create a DSN with Administration Tools.Data Sources (ODBC) - no server is listed. Neither can I create a connection from VFP DataBrowser
>
>I've attached the AdventureWorksLT sample database so there should be something there but all I get is blank...
>
>Any pointers appreciated.
>
>TIA
>
>Malc
Malcolm,
I can easily connect like this:
handle = SQLStringConnect(;
"Driver={SQL Native Client};server=.\sqlexpress;Trusted_connection=yes")
? m.handle
SQLDisconnect(0)
If it fails, check aerror().
Cetin