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

Calling stored procedures in VB 6

P: n/a
I have a good connection to the SQL Server but, it can't
find the stored procedures that I wrote and placed there.
They are in the Master DB and work. The connection method
and open recordsets work, but when I add the command "EXEC
sp_name " into the open statement it keeps saying it can't
find the stored Procedure. Obviously it knows to expect
the SP but the method of defining it is wrong. I'be tried
variations of BMname..SPname and none work? Help.

Bruce Gilbert
so********@msn.com
Nov 20 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Cor
Hi Bruce,

I do not know what it is in VB6 it is something as this in VB.net

Dim cmd As New SqlCommand("EXECUTE MyDatabase.dbo.SelectProc", conn)

But maybe you can get your answer for VB6 in one of the VB classic
newsgroups

microsoft.public.VB*

Cor
I have a good connection to the SQL Server but, it can't
find the stored procedures that I wrote and placed there.
They are in the Master DB and work. The connection method
and open recordsets work, but when I add the command "EXEC
sp_name " into the open statement it keeps saying it can't
find the stored Procedure. Obviously it knows to expect
the SP but the method of defining it is wrong. I'be tried
variations of BMname..SPname and none work? Help.

Nov 20 '05 #2

P: n/a
* "Bruce" <so********@msn.com> scripsit:
I have a good connection to the SQL Server but, it can't
find the stored procedures that I wrote and placed there.
They are in the Master DB and work. The connection method
and open recordsets work, but when I add the command "EXEC
sp_name " into the open statement it keeps saying it can't
find the stored Procedure. Obviously it knows to expect
the SP but the method of defining it is wrong. I'be tried
variations of BMname..SPname and none work? Help.


Notice that there is a separate group available for ADO.NET questions:

ADO.NET group:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #3

P: n/a
Cor
Hi Herfried,

I thought VB6 did not work with Ado.net is there a new release?

:-))))

Cor

Notice that there is a separate group available for ADO.NET questions:

ADO.NET group:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Nov 20 '05 #4

P: n/a
* "Cor" <no*@non.com> scripsit:
I thought VB6 did not work with Ado.net is there a new release?


Sorry :-(...

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.