VB Component not runningproperly in ASP

[p1j]

Hi,

One of the components (ActivX Dll developed in VB6) is not behaving
properly in ASP pages, while the same is running fine when called from
a VB Programs.. .

Here is the ASPCode

dim objTemplateMgr, tmplFileNemewithPath, sfilename, stemplcode
Set objTemplateMgr = Server.CreateObject("TmplMgr.T2DB")
Set objTemplateMgr.gMyConn = dbconn

objTemplateMgr.Tmpl2DB tmplfilenamewithpath, stmplcode
Response.write "<BR>Bytes Written : " & objTemplateMgr.BytesWritten
Response.write "<BR>Err : " & objTemplateMgr.Errno

The same code is runnign fine in VB.. (one change)
Set objTemplateMgr as new TmplMgr.T2DB
Set objTemplateMgr.gMyConn = dbconn
objTemplateMgr.Tmpl2DB tmplfilenamewithpath, stmplcode
Msgbox "Bytes Written : " & objTemplateMgr.BytesWritten
MsgBox "Err : " & objTemplateMgr.Errno

The VB code inserts a Template fine in IMAGE filed of SQL server,
while the ASP page inserts a NULL without giving any error...

Can anyone help why its not working? has it to do with security
permissions (though I have tried setting permissions for IUSR_MyPC on
the component dll)

Any idea how to check if the component is failing.. ?

thanks

P1

[Manohar Kamath [MVP]]

You can enable the server-side debugging for ASP and check variables at each
step:

http://support.microsoft.com/default...b;en-us;192011
--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"p1j" <p1*@operamail.com> wrote in message
news:a0*************************@posting.google.co m...

Hi,

One of the components (ActivX Dll developed in VB6) is not behaving
properly in ASP pages, while the same is running fine when called from
a VB Programs.. .

Here is the ASPCode

dim objTemplateMgr, tmplFileNemewithPath, sfilename, stemplcode
Set objTemplateMgr = Server.CreateObject("TmplMgr.T2DB")
Set objTemplateMgr.gMyConn = dbconn

objTemplateMgr.Tmpl2DB tmplfilenamewithpath, stmplcode
Response.write "<BR>Bytes Written : " & objTemplateMgr.BytesWritten
Response.write "<BR>Err : " & objTemplateMgr.Errno

The same code is runnign fine in VB.. (one change)
Set objTemplateMgr as new TmplMgr.T2DB
Set objTemplateMgr.gMyConn = dbconn
objTemplateMgr.Tmpl2DB tmplfilenamewithpath, stmplcode
Msgbox "Bytes Written : " & objTemplateMgr.BytesWritten
MsgBox "Err : " & objTemplateMgr.Errno

The VB code inserts a Template fine in IMAGE filed of SQL server,
while the ASP page inserts a NULL without giving any error...

Can anyone help why its not working? has it to do with security
permissions (though I have tried setting permissions for IUSR_MyPC on
the component dll)

Any idea how to check if the component is failing.. ?

thanks

P1