Hi!

When I try to run a stored procedure from a ASP page it gives me an error:
Microsoft OLE DB Provider for sql server (0X80040E30)
Type name is Invalid

How ever this code with the same database is running fine in the development
server.

Please help.

Regards,
Manish

Hi

Are the versions of MDAC the same? It could be that the ADO type definitions
(adovbs.inc) are different!!

John

[quoted text, click to view]

Manish Sinha (katfour_99@hotmail.com) writes:
[quoted text, click to view]

Yes, like John says, this sounds like an MDAC issue. What datatype is
the column in question?

I've seen this error when trying to tell SQLOLEDB to use the new datatypes
of SQL2005. So I would guess that the client you are running this from
has MDAC 2.5 or earlier, and you need to have at least 2.7.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at