-
I created a SQL server database, and I try to use vb to create a dll file to open the database. and then I want to call that DLL file from an ASP so I can output the table on the web page.
but I always got this error message:
"Object variable or With block variable not set"
please help me, I have been working on this for a very long time, and it's driving me crazy.
this error happens when I try to call the function.
ASP code:
'<%
set t=server.createobject("dbt.table")
response.write t.getRS
'%> ^^^^^
please help me.
Thanks
Cerebrate@
-
I bet you've got an unhandled error in your dll. Recompile your dll with CTRL + F5 and make sure your Error Checking is set to Break on all errors. You can also unregister your dll(assuming the dll is not running under mts), run the project from the VBIDE, set a break point somewhere in the component. Run the asp page and it will break in your project. You're better off just testing the DLL from a standard exe project and then when all of the glaring errors are takin care of, fully compile it(CTRL+F5) and test from the asp page.