Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MS SQL 2005 Express
Message
From
16/02/2008 14:49:38
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01293184
Message ID:
01293193
Views:
17
>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform