I am having a problem using the Data Source Configuration Wizard in vb 2010 express to connect to a remote SQL server database. The weird thing is that I can connect to it just fine if I manually dimension the sqlcommand, sqlconnection and set up the sql
connectionstring. So I know the connectivity is possible, but I would like to use the functionality of the Data Source Configuration Wizard.
Here's what happens when I attempt to add a connection via the Database Explorer:
I only get two SQL Server options. Neither will let me connect to a remote database.
I know that Microsoft SQL Server Compact 3.5 isn't what I want, but I have tried it anyway. It will only let me connect to a database on my computer. An 'ActiveSync' option is greyed out.Microsoft SQL Server Database File would appear to be what I want, but when I select this option, it informs me ...
Go to the complete details ...