Re: msdatashape provider error

wq352 wrote:
I usually used the MSDASQL.1 provider to access SQL Server

Well, then, you've been using a deprecated provider.
http://www.aspfaq.com/show.asp?id=2126

but now I
need to use the MSDatashape as the provider and used MSDASQL.as the
data provider. And here lies the problem, my codes which uses ADO
command refresh to get the parameters from store procedure does not
work in my vb code and return error message:

1: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'stored
procedure name' expects parameter 'parametername', which was not
supplied.

2: Data provider or other service returned an E_FAIL status.


Does anyone know why MSDatashape cannot seems to be able to detect
any of the in/out parameters of a stored procedures?

First, try changing to the SQLOLEDB provider. If that does not help, show us
some code to repro the symptom.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • ANN: UniDirect .NET Data Provider First Release
    ... Core Lab company has recently announced first release of UniDirect .NET, ... data provider to universal data access to different databases for the ... It supports most of major database servers ... The provider is completely based on ADO.NET ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: msdatashape provider error
    ... Well, then, you've been using a deprecated provider. ... Data provider or other service returned an E_FAIL status. ... Dim cmdProcedure As ADODB.Command ... Set cmdProcedure = New ADODB.Command ...
    (microsoft.public.data.ado)
  • Re: Is TDS used only if server is local?
    ... The ODBC .NET data provider does not depend on ... CFMX accessing SQL Server stored procedures via ODBC SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: .NET data provider or OLEDB provider?
    ... I have had a preliminary look at both the .NET provider and OLEDB provider. ... SQL compatible so we can easily port the database to SQL Server at sometime ... > A .NET data provider would be *much* easier. ...
    (microsoft.public.data.oledb)
  • C# and MySQL using ByteFX Data Provider
    ... I want to get an db connection to a mysql database, using the bytefx ... I want to use this provider because i have to migrate ... provider is based on the bytefx data provider. ...
    (microsoft.public.dotnet.framework.adonet)
Loading