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 Reply

1665

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

2271

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, some of our users have been having problems and deciding for themselves to CTRL+ALT+DEL the application. This is the first thing we will stop. However, we have had some error messages indicating that the previous transaction is blocking them...

Microsoft SQL Server

7973

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 stores information for a system "A", and I have a different database on the same SQL server that stores the login and other info "LOGIN". I write a stored procedure in the "A" database that checks some tables in the "LOGIN" database, let's call...

Microsoft SQL Server

2202

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

2354

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 Windows 2003 Server. The client dev environment is Visual Studio 2003 Enterprise Developer Edition. I have carried out the following steps successfully:-

Microsoft SQL Server

10750

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 execute in the database server with better performance? Please advise good references for Oracle stored procedures also. thanks!!

Microsoft SQL Server

3245

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 Command/Parameters objects to initialize and call the stored procedure Which is a efficient way and wh Appreciate your respons

C# / C Sharp

3398

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

3785

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 procedures, I would like to encrypt them, using the 'WITH ENCRYPTION' clause. My question is, how do I copy these stored procedures from development to their target SQL server environment in an encrypted state? Up until now, we have been moving...

Microsoft SQL Server

1653

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 the database using the same connection string as I used to view the databse in server explorer. (In server explorer I see all stored procedures). I then go through the wizard and choose "Specify a custom SQL Statement or Stored Procedure." Then...

ASP.NET

8685

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8612

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8905

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8880

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6532

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5869

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4373

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2342

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2008

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General