Re: OLEDB Driver - another problem

Posted in 2004

Sathyanesh Krishnan — Thu, 2 Sep 2004 11:35:30 -0500 — source: Usenet: comp.databases.informix

--0__=08BBE590DFC901828f9e8a93df938690918c08BBE590DFC90182 Content-type: multipart/alternative; Boundary="1__=08BBE590DFC901828f9e8a93df938690918c08BBE590DFC90182" --1__=08BBE590DFC901828f9e8a93df938690918c08BBE590DFC90182 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi Piotr, There is a solution for thIS problem (VB/ADO/OLEDB/decimal). In case of OLEDB we can give decasr8=3D1 through extended property. Please add the following extended property to the connection string. Extended Properties=3D'decasr8=3D1' Then the connection string may look like this ConnectionString =3D "Provider=3DIfxoledbc;Password=3Dinfo123;Persist S= ecurity Info=3DTrue;User ID=3Dinformix;Data Source=3Dnic@ol_evo;Extended Proper= ties=3D''; Extended Properties=3D'decasr8=3D1'" Regards, Satyan Software Engineer R&D - IBM Data Management Group 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8792 (T/L: 337-8792) = "Piotr = Wierzchowski" = <piotrw@bonair.co = To m.pl> Sathyanesh = Krishnan/Lenexa/IBM@IBMUS = 09/01/2004 09:41 = cc AM = Subj= ect OLEDB Driver - another problem = = = = = = = Hi Satyan, While testing our software, we have ancountered another problem. I think this is connected with VB/ADO/OLEDB/decimal handling problems. We have quite sophisticated piece of SQL code which agregates some deci= mal columns and pack them in a temp table. Then in VB we are retriving valu= es from this table. And we recive an error saying "Multiple-step operation generated errors= . Check each status value" I have reduced the problem to simple form and now the extracted SQL loo= ks like: CREATE TEMP TABLE xx (col1 DECIMAL); INSERT INTO xx VALUES (100);SELECT sum(col1) FROM xx; While using ODBC connection the errro can be avioded by setting extende= d property 'Describe Decimal Floating Point As SQL_REAL/SQL_DOUBLE'. But in OLEDB connect string we cannot set this property... And again - the problem disapears when seting CursorLocation property t= o 'adUseServer'... Regards, Piotr Wierzchowski Technologist Bonair SA ul. Rzymowskiego 34, 02-697 Warsaw ----- Original Message ----- From: Sathyanesh Krishnan To: Piotr Wierzchowski Sent: Wednesday, September 01, 2004 1:10 AM Subject: Re: OLEDB Driver (back from holiday) Hi Piotrek, Thanks Very Much for sending the reproduction material. I tested it with the latest Client SDK (2.90 TC1) that is currently on beta, I could not reproduce the problem. Since you have run it against Client SDK 2.81 TC2, I will try to reprod= uce this by installing exactly the same version what you were using it and also setting all the environment you have specified. I will do this testing tomorrow and give you the feedback. I already log a bug against the product, and get the fix scheduled for = the current release. If I could reproduce the problem, then the coming release of Client SDK= 2.90 (schedule to be next quarter) will have the fix. We really appreciate your help. Regards, Satyan Software Engineer R&D - IBM Data Management Group 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8792 (T/L: 337-8792) [attachment "Inf_err2.vbp" deleted by Sathyanesh Krishnan/Lenexa/IBM] [attachment "Form1.frm" deleted by Sathyanesh Krishnan/Lenexa/IBM]= --1__=08BBE590DFC901828f9e8a93df938690918c08BBE590DFC90182 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> Hi <tt>Piotr</tt>, There is a solution for thIS problem (VB/ADO/OLEDB/decimal). In case of OLEDB we can give decasr8=3D1</fo= nt> through extended property. Please add the following extended property to the connection string.<br= > Extended Properties=3D'decasr8=3D1'</= b> Then the connection string may look like this ConnectionString =3D "Provider=3DIfxoledbc;Password=3Dinfo123;Pers= ist Security Info=3DTrue;User ID=3Dinformix;Data Source=3Dnic@ol_evo;Ex= tended Properties=3D'';Extended Properties=3D'd= ecasr8=3D1'" Regards, Satyan Software Engineer R&D - IBM Data Management Group 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8792 (T/L: 337-8792) <img src=3D"cid:10__=3D08BBE590DFC901828f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Piotr Wierzch= owski" <piotrw@bonair.com.pl>">"Piotr Wierzchowski&quot= ; <piotrw@bonair.com.pl> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE59= 0DFC901828f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul>"Piotr Wierzchowski" <piotrw@bonai= r.com.pl> 09/01/2004 09:41 AM</ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE590DFC901828f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">To</div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE590DFC901828f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> <fo