Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle LONG data in a web page problem

Status
Not open for further replies.
goldenlam

goldenlam

MIS
Feb 28, 2000
12
US
Help,

We are trying to retrieve an Oracle long data field into a web page and are getting the following errors:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)
 Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/khhr/Postings/jobdetail.asp, line 25

 Browser Type:
Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)


 Page:
GET /khhr/Postings/jobdetail.asp

 Time:
Thursday, December 21, 2000, 7:26:39 AM


Help me if you can.

Thanks and Merry Holidays.
 
Sort by date Sort by votes
it would be helpful if you posted the code of /khhr/Postings/jobdetail.asp, or at least line 25 of that page. Ruairi
ruairi@logsoftware.com
Experienced with:

VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions

ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications
 
Upvote 0 Downvote
Here is the code you asked about:

<html>

<head>
<title>Job Description Detail</title>
</head>

<body>
<%
On Error Resume Next

if request.querystring(&quot;jobcode&quot;) <> &quot;&quot; THEN
jobcode = request.querystring(&quot;jobcode&quot;)
elseif jobcode = &quot;&quot; THEN
jobcode = request.form(&quot;jobcode&quot;)
end if

sqlstr=&quot;select * from ps_rf_job_descr_vw WHERE jobcode = '&quot; &amp; jobcode &amp; &quot;';&quot;
set dbcon=server.createobject(&quot;ADODB.connection&quot;)
dbcon.connectionstring=&quot;DSN=hr; Uid=abc; Password=123&quot;
dbcon.open
set dbrec=server.createobject(&quot;ADODB.recordset&quot;)
dbrec.open sqlstr, dbcon
If dbrec.eof then
response.write &quot;EOF&quot;
dent1 = &quot;EOF&quot;
end if
testa = dbrec(&quot;descrlong&quot;)

if not dbrec.eof then
response.write &quot;<hr width=&quot;&quot;80%&quot;&quot;>&quot;
response.write &quot;<div align=&quot;&quot;center&quot;&quot;><center>&quot;
response.write &quot;<table border=&quot;&quot;0&quot;&quot; width=&quot;&quot;80%&quot;&quot; cellpadding=&quot;&quot;1&quot;&quot; cellspacing=&quot;&quot;0&quot;&quot;>&quot;
response.write &quot;<tr><td width=&quot;&quot;27%&quot;&quot;><p align=&quot;&quot;right&quot;&quot;><strong>Job Code #:&amp;nbsp&amp;nbsp</strong></td><td>&quot; &amp; dbrec(&quot;jobcode&quot;)
response.write &quot;<tr><td><p align=&quot;&quot;right&quot;&quot;><strong>Title:&amp;nbsp&amp;nbsp</strong></td><td>&quot; &amp; dbrec(&quot;jobcode_descr&quot;)
response.write &quot;<tr><td><p align=&quot;&quot;right&quot;&quot;><strong>Job Family:&amp;nbsp&amp;nbsp</strong></td><td>&quot; &amp; dbrec(&quot;descr&quot;)
response.write &quot;</table>&quot;
response.write &quot;<hr width=&quot;&quot;80%&quot;&quot;>&quot;
response.write &quot;<div align=&quot;&quot;center&quot;&quot;><center>&quot;
response.write &quot;<table border=&quot;&quot;0&quot;&quot; width=&quot;&quot;80%&quot;&quot; cellpadding=&quot;&quot;0&quot;&quot; cellspacing=&quot;&quot;0&quot;&quot;>&quot;
response.write &quot;<tr><td><strong>Description: </strong></td>&quot;
response.write &quot;<tr><td>&quot; &amp; dbrec(&quot;descrlong&quot;) &amp; &quot;</td>&quot;
response.write &quot;</table>&quot;
response.write &quot;</div>&quot;
dbrec.close
end if
%>
</body>
</html>


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mslko
  • Locked
  • Question
Interdev vs6 NTLM authentication failed (code 2146893042) on connecting to existing Project
Replies
0
Views
551
mslko
mslko
WinCareIT
  • Locked
  • Question
Error starting VB 6: Data View window, &quot;Method of '~' of object '~' failed.&quot;
Replies
0
Views
542
WinCareIT
WinCareIT
szoora
  • Locked
  • Question
Sub/Function that allows me to run various MSSQLServer 2008 stored procedures using vb.net
Replies
3
Views
531
szoora
szoora
jledhead
  • Locked
  • Question
Data Environment Problems
Replies
0
Views
413
jledhead
jledhead
victork
  • Locked
  • Question
Data Connection problem with SQL2005
Replies
0
Views
444
victork
victork

Part and Inventory Search

Sponsor

Back
Top