Can't connect to SQL Server 5 database from VB 2008 Express

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
<p align=left><font face=Arial size=2></font> 
In the beta version of Beta2 of Visual Studio Professional, when I choose add new connections, I can select a I can select a " SQL Server (SQL Client)" datasource, which works great with my SQL Server Express DB running on the local machine.
<p align=left> 
<p align=left>In VB2008 Express, though, I cant select a "SQL Server" in the datasource dropdown.  I can only try to connect to a Microsoft SQL Server Database File. 
<p align=left> 
<p align=left>When I actually try to connect using the .mdf file that is being managed by my local SQL Server, I get an connection error -- cant make connection to the server (and the usual message about enabling remote connections".
<p align=left> 
<p align=left>I know my server is properly configured -- I can connect to it from another PC running Visual Studio 2008 on a different machine.
<p align=left> 
<p align=left>Is there a way to get the SQL Server (SQL Client) datasource added to the VB Express 2008 dropdown, or some other way to fix this problem?
<p align=left> 
<p align=left> 

View the full article
 
Back
Top