I'm not sure if I've done something wrong during setup but, if I try to build a new Windows application in VB Express, the data window won't let me make a new connection to one of our existing SQL servers. It insists upon opening only an .mdf file which, of course, one doesn't normally have access to on an actual server.
What makes me think there's a problem in setup is that I can easily open an SQL connection is Visual Web Designer Express. Why the ability in one and not the other
Thanks,
Art Martin
VB Express and existing SQL server connections
Xclaim22
Thanks for the clarification. Once you hand code a connection to a remote database, is it then possible to put that connection object into the user instance system We'll probably upgrade to the standard edition soon so it's not that big of a deal but it'd be nice to be able to see how the functionality works without replicating our existing data into the SQL2005 Express database before we make the purchase.
Art
Chris_21
If you can describe more what you and your application is doing it will help other to help you.
I am not sure this is an installation issue and you should not be surprised if it is moved to the Visual Basic express editon forum.
Lierni
From what I can see your express system is running properly.... The Express language specific systems can only connect to the local Express editions through the User Instance system and can not connect to remote Database systems. This is by Design and is one of the limitations to the express products. Although remember that with the VWD System you are able to connect to other database systems, this is also by design.
If you do want to connect to other database engines or on remote systems you will have to code the data objects by hand.