Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MS SQL 2005 Express
Message
De
16/02/2008 14:49:38
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01293184
Message ID:
01293193
Vues:
18
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform