I want know if we can use visual studio express to connect to other database like oracle, foxpro... than than acess and sql sever express
thanks!
I want know if we can use visual studio express to connect to other database like oracle, foxpro... than than acess and sql sever express
thanks!
Visual studio express using visual database tools
Grandpa4075
Thank you for your response but if i don't want to do it by code how can i do it directly in the IDE. For example in the enterprise edition you go to server explorer to connect to a database you have several choices.
I want to know if i must install additionals coponants in order see the others type database sources rather than sql server and access.
thanks!
MarkWHaroldson
One of the limitations of the product is that the express systems can only connect to certain database engines, by this we mean that the Wizards that are built in to the systems can only connect to certain databases. If you want to connect to other sources using the express products you will have to build the data layer manually and connect to the data source in code.
You can get around this by creating your data layer to expose some objects, then using the data wizards you would bind to these objects.
Stahn
No the system will not allow you to connect using the wizards, you have to do it in code. If you do not want to do it in code and prefer the wizards I would suggest that you look at the standard edition of Visual Studio.
If you have a look at the Personal Web site starter kit it has an example of an object based system that connects to the sql express system.