In VB.NET 2002 I was using Multiple MS Access files to store data. Is it possible with VB.NET express 2005 and SQL Express 2005 ?
Parminder
Hope this helps,
Steve Hoag
Visual Basic Express
Dear ShoagMSFT,
Is it means that if there is three (or more) SQL Server Express files on remote computer and I can not open all of them simultaniously (Which I want) ?
Thanks
Parminder Singh Dhillon
To clarify - you can only open SQL Server databases on the computer where your application is running. You cannot open databases over a network; this is a limitation of the Express edition.
If you have three (or more) databases installed on the local computer, you can access all of them simultaneously from your application.
Steve Hoag
Hi There
Hey Steve
Are you saying VB Express will Not Generate a Client Server Application on a local Network? Say one Server and 3 clients...... IE. The SQL Express Server Database On one Computer and the other 3 Client computers using VB Express Apps cannot access the SQL Express Server Computer? Cheers
Bronco Billy
"Beer and Fast Women are Ok... No Cigarettes or Hard Liquor Allowed
That said, I have seen other posts on this forum suggesting that the limitation is simply at design time - once an application created with Express is deployed you could connect to a remote database by changing the connection string. I haven't tried this and don't know the details, but you might check it out.
- Steve
shoagMSFT wrote:
Yes - the Express Edition is not intended to create client-server applications; for that you would need the full version. The aim of Visual Basic Express is to provide a tool for beginning programmers to learn programming and for "hobbyists" that want to create apps for themselves and their friends. For this reason the data story is limited to local data - that is, a database on the same computer as the application. - Steve
Is this limitiation for Visual Basic .net Express 2005 or SQL Server Express 2005 ?
Can I use more then one MS Access data files from other computers in my application using Visual Basic Express 2005 ?
I have licenced copy of VB .net 2002, then If not why I should go for Express ?
Thanks
Parminder Singh Dhillon
As mentioned earlier, Visual Basic Express only supports local data. You can use more than one MS Access data file in your application only if those data files are installed on the same computer as your application.
If you are currently doing professional client-server development using Visual Studio .NET 2002, the Express Editions are not intended for you. For professional development you will need the full version of Visual Studio 2005, which has many improvements over Visual Studio .NET 2002. Of course, the decision to upgrade (or not) is entirely up to you.
Steve Hoag