Code: 80040e14 Code meaning: IDispatch error #3092

[Luis Porras]

Hi,

I'm having this error inside my VC++ application, the error window appears
but after that the information is displayed correctly!

I'm working with OLEDB Sybase Provider 12.5 (latest EBF)...

Code: 80040e14
Code meaning: IDispatch error #3092
Source: ASE OLE DB Provider
Description: [Native Error code: 207]
Invalid column name 'job_id'

Any ideas?

~Luis

P.D.
I also posted this message at sybase.public.connectivity.oledb.

[Jason L. Froebe [TeamSybase]]

Luis Porras wrote:

Hi Luis,

Looks like it is trying ot bind the 'job_id' column to a native data
type in your application... but there isn't a job_id column. To fix it,
you will have to either add the job_id column or change your code.. you
do know that Sybase ASE is case-sensitive by default? (job_id != Job_ID)

jason

--
Jason L. Froebe

"There is usually a balance between the left and the right... checks &
balances... the bane of the government but the boon of the people" -
Jason L. Froebe

Bookcrossing (http://www.bookcrossing.com)
WebBlog http://www.livejournal.com/users/jfroebe

TeamSybase (http://www.teamsybase.com)
ISUG member (http://www.isug.com)
Chicago Sybase Tools User Group (http://www.cpbug.com)

[Luis Porras]

Jason:

The column job_id exists!! If I comment the job_id column, the error
message changes to the next column, I mean: Invalid column name 'ICN'. I
tried to execute the select within the application instead of the view and I
had the same error message!!

This what I'm trying to do:

select * from TAC_joblist -- BTW TAC_joblist is a view...

And the code of the view is simple...

create view TAC_joblist
as
select
job_id=jt.job_id,
ICN=(SELECT distinct imprinter_no FROM dcn_table WHERE dcn=ds.dcn),
DCN=ds.dcn,
OCR=ds.ocred,
Edit=ds.edited,
Verify=ds.verified,
ToPostEdit=ds.to_post_edit,
ToPostVerify=ds.to_post_verify,
Inserted=ds.inserted,
Upload=ds.uploaded,
Reject=ds.rejected,
SiteID=ds.lastserver,
PathID=jt.path_id,
Key_1=jk.key1,
Key_2=jk.key2,
Key_3=jk.key3,
Key_4=jk.key4,
PageNo=ds.page_no
from job_table jt,dcn_status ds,job_key_table jk
where ds.dcn between jt.from_dcn and jt.to_dcn
and jt.job_id = jk.job_id
go

"Jason L. Froebe [TeamSybase]" <ja...@NOSPAMMY.froebe.net> wrote in message
news:411b7fbf$1@forums-1-dub...