Hi All:
I have a ASP page which use external DLL load data from SQL 2000 server, but it keeps give me error as following:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Microsoft OLE DB Provider for SQL Server (0x8004000)
the line cause the error is as:
<%
dim newRS
dim visiter = Server.CreateObject("ExternalDLL.visit")
newRS = visiter.enews.getENews
%>
visit and enews are all class file inside ExternalDLL.
any body can help me out what's wrong with my page? the external DLL and sqloledb.dll are both registed on the machine.
Your help is great appreciate 
Regards
Echo
Echo,
"Microsoft OLE DB Provider for SQL Server (0x8004000)" is related to the forum. However, for ASP related issue, you might want to check ASP forum as well.
|||Hi !
As another poster said, this is defintely not a SQL Server related problem. You are loading an external DLL which does some SQL stuff and which has probably a bug inside or is not configured probably. So ask the vendor how to trace or how to configure this the right way. If you have no support, you can go the long way, tracking the users which try to login to SQL Server (if the server is configured the right way for this application) and see what statement are executed for the server. As I said thats the long way using the profiler. :-(
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment