R help - Jan 2009 - Faced Problems with RODBC package 1.2-5 and 1.2-4 for windows

Hi,

        I am facing problems with RODBC package 1.2-5 and 1.2-4  built for 
windows. I am using R  2.8.1 version.
        I faced some problems when I was trying to execute sql procedure 
from R  with exec/execute statement . 

        Stored procedure contains code/statements : 
        1) Call to another procedure (R calls one procedure which itself 
calls another procedure)
        2) Iteration (while loop) 
                   I created stored procedure in which I used while loop 
and while loop contains two insert statements.I executed procedure from R. 
I found that expected results are not matching with the   results I got. 
Also results are not consistent.
        3) SET QUOTED_IDENTIFIER OFF statement 

Please give me a solution 

regards,
Nikhil Ashok Bhide
Cell:- +919604848030
Mailto: nikhil.bhide@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty.   IT Services
                        Business Solutions
                        Outsourcing
____________________________________________
ForwardSourceID:NT00001B0E 
=====-----=====-----====Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you



	[[alternative HTML version deleted]]

You need to include much more information.

Try creating a reproducible example - you may find the answer in the
process of doing this.

You may find the posting guide for the mailing list to be helpful -
you've had no replies because you haven't explained your problem well
enough.

Mark

2009/1/28 Nikhil Bhide <nikhil.bhide at tcs.com>:
> Hi,
>
>        I am facing problems with RODBC package 1.2-5 and 1.2-4  built for
> windows. I am using R  2.8.1 version.
>        I faced some problems when I was trying to execute sql procedure
> from R  with exec/execute statement .
>
>        Stored procedure contains code/statements :
>        1) Call to another procedure (R calls one procedure which itself
> calls another procedure)
>        2) Iteration (while loop)
>                   I created stored procedure in which I used while loop
> and while loop contains two insert statements.I executed procedure from R.
> I found that expected results are not matching with the   results I got.
> Also results are not consistent.
>        3) SET QUOTED_IDENTIFIER OFF statement
>
> Please give me a solution
>
> regards,
> Nikhil Ashok Bhide
> Cell:- +919604848030
> Mailto: nikhil.bhide at tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.   IT Services
>                        Business Solutions
>                        Outsourcing
> ____________________________________________
> ForwardSourceID:NT00001B0E
> =====-----=====-----====> Notice: The information contained in this
e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>


-- 
Dr. Mark Wardle
Specialist registrar, Neurology
Cardiff, UK