Calling stored procedures in VB 6

[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)

 

[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

 

[Herfried K. Wagner [MVP]]

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:

<
Web interface:

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

 

[Cor]

Hi Herfried,

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

)))

Cor

 

[Herfried K. Wagner [MVP]]

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

Sorry :-(...