vb.net and stored procedures on SQL Server 2000

rdshultz

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

Subscribe Post Reply

1652

Tom van Stiphout

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

Similar topics

Stored procedures and CTRL+ALT+DEL

by: Ryan | last post by:

We have a suppliers application that runs a stored procedure (one of many). This stored procedure then calls various other ones etc... and the final number of stored procedures run is 11. Now,...

Microsoft SQL Server

Inter-database stored procedures and permissions

by: TJ Olaes | last post by:

Hello all, this is my second post to this newsgroup. It's a question about stored procedures and permissions and how these behave between databases. Here's the scenario. I have a database that...

Microsoft SQL Server

Fastest way to delete hundreds of table triggers and hundreds of stored procedures?

by: serge | last post by:

How can i delete all user stored procedures and all table triggers very fast in a single database? Thank you

Microsoft SQL Server

Stored Procedure Source Control

by: Karl | last post by:

Hi, I am trying to put SQL Server Stored Procedures into Sourcesafe as per the Microsoft Knowledge Base article 818368, but have run into a problem. The web server is SQL Server 2000 running on...

Microsoft SQL Server

Oracle Stored Procedures VERSUS SQL Server Stored Procedures

by: jrefactors | last post by:

I want to know the differences between SQL Server 2000 stored procedures and oracle stored procedures? Do they have different syntax? The concept should be the same that the stored procedures...

Microsoft SQL Server

Best way to call a stored procedure

by: mike | last post by:

H There are two ways to execute a stored procedure using ADO.NE - call "exec sp_myproc val1,val2" statement over SqlCommand myCommand = new SqlCommand(SQLQuery, mySqlConnection) - use...

C# / C Sharp

SELECTs vs Stored Procedures

by: John | last post by:

Hi When developing vb.bet winform apps bound to sql server datasource, is it preferable to use SELECTs or stored procedure to read and write data from/to SQL Server? Why? Thanks Regards

Visual Basic .NET

Copying encrypted stored procedures.

by: nickwilson.nick | last post by:

I have several stored procedures, created in a development environment, that I need to move to a 'QA' environment, and then in turn, to various production environments. When I move these stored...

Microsoft SQL Server

configuring sqldatasource to use a stored procedure from the aspnetdb

by: Ryan | last post by:

PLEASE HELP!! I am trying to do what I think should be the simplest thing. In Visual Studio 2005, I set up a datagrid and then went ot configure a datasource for it. I made my connection to...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA