dbTalk Databases Forums  

D3 stored Proc won't execute from ASP

comp.databases.pick comp.databases.pick


Discuss D3 stored Proc won't execute from ASP in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
deermouse (Offline)
Junior Member
 
Posts: 2
Join Date: Apr 2006

Default D3 stored Proc won't execute from ASP - 04-29-2006 , 11:54 AM






I'm having a problem getting procedures stored in D3 to execute from ASP. The procedure executes in immediate mode, but not under program control. TCL commends execute fine. I suspect this is a configuration problem, but I don't have a clue as to what or where.

D3 is running under Redhat 9 and ASP.NET is on Win2K using ODBC. Has anyone run into a problem like this?

thanks,

paul


Bucky Goldstein's
GW Deer Mouse Ranch
http://mouseranch.com

Reply With Quote
  #2  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: D3 stored Proc won't execute from ASP - 04-29-2006 , 08:28 PM






deermouse wrote:
Quote:
I'm having a problem getting procedures stored in D3 to execute from
ASP. The procedure executes in immediate mode, but not under program
control. TCL commends execute fine. I suspect this is a configuration
problem, but I don't have a clue as to what or where.

D3 is running under Redhat 9 and ASP.NET is on Win2K using ODBC. Has
anyone run into a problem like this?

thanks,
paul
I might be missing something but I think a lot more information than
this is necessary to diagnose a problem. Since you're running what
seems to be a current D3 release you should contact RD Support or try
posting to the RD connectivity forum where RD people and others can
comment on this. I seem to recall someone else in the forum saying
they had an issue with that and ASP.NET. ASP.NET is not ASP and the
problem might be different depending on the technology being used. By
specifying you're using ODBC I'd guess you're using the D3 Class
Library. I never use the D3 Class Library and consider it woefully
inadequate compared to more modern tools like mv.NET. But whatever
tools you're using you probably need to provide some code and tell how
you're trying to do this.

Sorry this isn't more helpful.
T



Reply With Quote
  #3  
Old   
jra
 
Posts: n/a

Default Re: D3 stored Proc won't execute from ASP - 04-30-2006 , 04:56 AM



The problem is "data types". The D3Rulemodule, is a VARIANT TYPE. It
works with ASP an VBS. It cannot work in ASP.NET where there no are
VARIANTS.
It is similar to the D3write and ASP. It does not work in ASP because
in MUST be an INTEGER and VBS only works with variants.



You can go around the problem using a workfile, the d3write and a
trigger in the file. It's quite easy.

But i agree with Tony. If you want to use .net, you should not use the
"old" library. It is not for .net. You can use MV.net or PDP.net. They
are ACTUAL .net products.

Hope this help

joseba


Reply With Quote
  #4  
Old   
deermouse (Offline)
Junior Member
 
Posts: 2
Join Date: Apr 2006

Default 04-30-2006 , 05:41 PM



Thanks for the replies. I agree about posting on Raining Data's forum. I've registered, but they haven't approved me yet.

I will look at the VARIANT data type issue and MV.net and PDP.net and see if that helps.

thanks,

paul


Bucky Goldstein's
GW Deer Mouse Ranch
http://mouseranch.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.