Calling stored procedures in VB 6

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

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
(e-mail address removed)
 
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
 
* "Bruce said:
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.
Click to expand...

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

ADO.NET group:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>
 
Back
Top