SQL Server Performance Forum – Threads Archive
Sql server and visual basic 6, .NET, VBA
Hi there, I don’t know if I’m posting in the good forum. I want to develop an application that connects and call procedures to a SQL SERVER database. For my application, I have the choice beetween Visual Basic 6, VBA Access and Visual Basic .NET. I’m totally new to visual basic .NET, so I’m not sure if I’ll use that one. VBA Access is good because I can make sub-forms easily. But I’m afraid the mde application might be bigger than a exe VB6 application. As for the VB6, I don’t know much about SQL Server and VB6. Can you advise me or give me some ressources links about VB6, VBA Access or VB.NET and Sql server ? Is there any known performance issue with VB6 and SQL Server or VBA Access and Sql Server? Thankx a lot. Dan Phomphad[email protected]
Check:
http://www.tek-tips.com/ HTH Luis Martin
Moderator
SQL-Server-Performance.com
msdn is a good place to find performance differences between various programming languages. VB .NET is my pick…. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
VB6 was the language of choice to use with SQL server…till DOT Net came into picture.
Microsoft has done considerable effort to boost the SQL Server performance in DOT NET Applicaoins. VB.NET is very powerful language (If you consider the capabilities of VB.NET, VB6 looks like mere tool rather than language), and as always easy to use like any other MS technology. There is lot of stuff written about .NET and how its gonna be tool of future develpoment, like Gaurav suggsted MSDN. With my development experience with .NET, I’d recommend it strongly for any new development. Harsh
Now the .NET is in swing its better to use and get acquaintance with the current trend and as of now I don’t see any drawbacks or issues with VB or .NET on SQL Server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Also with .NET support enables in SQL Server 2005, it makes sense to start learning about .NET. And I don’t think there is a better way to learn a technology than actually making a project on the same…. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
]]>