By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,460 Members | 1,167 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,460 IT Pros & Developers. It's quick & easy.

vb.net and stored procedures on SQL Server 2000

P: n/a
Good morning everyone. Could someone tell me if there is a book out
there which gives examples of both VB.net code and creating SQL Server
2000 stored procedures and how you get them to work together in the
most efficient way.

Right now we have a server at our Philadelphia office and I am in our
St. Louis office we are connected with a T1 line. We have several
Access 2000 applications on the Philly server but when you try to run
them from St. Louis it takes forever.

I was hoping using VB.Net with stored procedures would increase the
performance. Am I correct in this assumtion? And please let me know
of any good books that I had mentioned early. Thanks for any help.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 7 Jul 2004 09:28:28 -0700, rd******@nooter.com (rdshultz) wrote:

The programming language is not very relevant to this problem: whether
Access displays the rows returned from your select statement, or
VB.NET's data grid does, doesn't make too much difference. What *does*
make a difference is the data access methods (DAO, ADO, ADO.NET), and
whether or not you use a file system database like Access or a server
database like SQL Server. Also database design may make a difference:
be sure your tables are correctly indexed.

So test those aspects first. Access ADP can actually run stored
procedures against a SQL back-end. You can use this to time the
various permutations.

-Tom.

Good morning everyone. Could someone tell me if there is a book out
there which gives examples of both VB.net code and creating SQL Server
2000 stored procedures and how you get them to work together in the
most efficient way.

Right now we have a server at our Philadelphia office and I am in our
St. Louis office we are connected with a T1 line. We have several
Access 2000 applications on the Philly server but when you try to run
them from St. Louis it takes forever.

I was hoping using VB.Net with stored procedures would increase the
performance. Am I correct in this assumtion? And please let me know
of any good books that I had mentioned early. Thanks for any help.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.