Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VB.net 10 express sqlclient blues
Message
De
13/08/2013 16:46:55
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 6.5 and older
Application:
Web
Divers
Thread ID:
01580428
Message ID:
01580430
Vues:
46
It has nothing to do with the Express VS SKUs and everything to do with the EDITION of SQL Server you installed and how it's configured.

There is a "local database" that is essentially a version that only allows local connections. You give a filename in the connection string and your application attaches to it.
Then there's SQL Express that does allow for remote connections. BUT, you can configure it to not allow remote connections or only allow certain protocols to connect (for example, named pipes or TCP/IP) . Look for SQL Server Configuration Manager on the box to see how it's configured.


>One of my uncountable blind spots is sql server client and connections, but this seems to be a resilient one. :)
>
>If I get this right, in .net express 2010 you have limited access, i.e. you can only connect to a "local" sql server, i.e. one that is not located on another server in the network.
>
>Now in net express 2012 I can see all the sql servers that are running on the company's LAN. So (1) is that a change in policy by Microsoft, or is this me having installed my .net 2010 wrongly, and (2) can I still connect to non "local sqlserver" via odbc or oledb ?
>
>Thank you so much for any light you could shed on this ...
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform