i guess u need a product update, go to microsoft.com and

look for updates, mdac, jet engine or whatever,

usually such types of unusal errors get solved by updates

i had faced...

its ur recordset method,  try changing that to accept a large string, or maybe

ur textbox set it to multline

debug the application

check the value of the field how much is...

u mean , u want some method by which u can get the table name and stored procedure name , in which the err occured.

or u just want to debug...

pls help me in thsi

did u tried what i said, did u use sql-profiler, it will give u better description for u r error

select * from table1 where col1 like '%''%'

this will do it

what is deterministic and non deterministic?

whats diff between them,

i guess its non-deterministic, becoz the value get is not certain or fixed

its value changes

that was not much of a help, what i expected was u should guide me in doing, this

actually it is more directed towards ppl in india, becoz iam not sure...

well i guess, first you should find out what is causing the error, for that u have to use sqlserver profiler, and then make it to check on stored procedure,...

OPTION 1 Solution looks very complicated solution to me, becoz i will have to find a way to transfer data from sql to oracle, i will need to create ajob...

but dear, ur forgetting 1 thing, its 2 different data server, one is oracle and another is sql server

i dont know how to attach sqlserver to oracle,sp_addlinkedserver in oracle

becoz the...

my final question

how do i write this query to show results with the left join in oracle 8i

select syspolicy_no,ref_no from policy p join COINSURANCE_DETAILS c on p.syspolicy_no=c.ref_no

any idea?

hey dont include...

my final question

how do i write this query to show results with the left join in oracle 8i

select syspolicy_no,ref_no from policy p join COINSURANCE_DETAILS c on l.syspolicy_no=c.ref_no

any idea?

union and all these things are not possible, becoz 2 different servers,oracle & sql, 2 diff tables with different data structures.

the possible solution i can think of is to make...

select syspolicy_no,ref_no from policy p join COINSURANCE_DETAILS c on l.syspolicy_no=c.ref_no

i dont know whats wrong in this query, but even such a simple query doesn't work in oracle 8i.

such type of...