Solved

Vb and SQl Server

Posted on 2000-03-30
1
152 Views
Last Modified: 2010-05-02
Hi
I want to call a stored procedure from Vb.I want to invoke the stored procedure with an input parameter (integer) with out using the command object.How is it done.
Sample code is what i am looking for

I am using vb6 and sql 7
Thanks
0
Comment
Question by:sramkris
1 Comment
 
LVL 1

Accepted Solution

by:
mr_krishna earned 50 total points
ID: 2671234
You can excute a stored proceudure using connection object. Sample code is as follows.

Dim cnn As New ADODB.Connection
'Your stored procedure name and any parameters.

cnn.sp_yourStoredProcedureName "param1"

0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now