Max columns in record set?

[blueindian1]

Hello All,

Here is my situation. I have a query that runs and will always get 1 record returned. The record has about 150 columns in it, however not all columns will always have a value. Sometimes only 1 has a value and the rest are null, sometimes they all have a value.

Now, Here's the problem. When I pull back a record with only 1 column that has a value, everything is fine. If I pull back a record where all the columns have a value, i get an error. I don't know exactly how many columsn have to contain a value before I get an error..I haven't figured that out yet. The errors I get are listed below:

1. Error when using an OLEDB connection

OraOLEDB error '80040e4b' 

Accessor is not a parameter accessor. 

D:\WEBSITES\SAMPLE_DEV\PAGES\../includes/nylon_update.asp, line 68

This error is actually listed on oracle's metalink support site. It says that it is a known bug and that I need to patch the server. that has been done and I still get the error. So I tried and odbc connection.....


2. Error when using an ODBC connection

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Oracle][ODBC][Ora]ORA-02041: client database did not begin a transaction 

D:\WEBSITES\SAMPLE_DEV\PAGES\../includes/nylon_update.asp, line 117

any help would be much appreciated...i need to go live in 2 days.

thanks,

rich

 

[maskofsanto]

Hey, how did you resolve this? I am having a somewhat similar problem - I can retirieve upto 12 PLSQ OUT parameters into ASP, but when I make it 13, the ASP page shows the following error, but everything is fine on the SQL Plus end:

Microsoft OLE DB Provider for Oracle error '80004005'

 

[blueindian1]

upgraded oledb to 8.1 (or perphaps 8.7...can't remember)...but it was an upgrade none the less