Re: $$Excel-Macros$$ Oralce Connection

2012-05-24 Thread t vinay
e times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* t vinay > *To:* excel-macros@googlegroups.com > *Sent:* Wed, May 23, 2012 4:41:42 PM > > *Subject:* Re: $$Excel-Macros$$ Oralce Connection > > Hi Paul, > > i ha

Re: $$Excel-Macros$$ Oralce Connection

2012-05-23 Thread Paul Schreiner
can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: t vinay To: excel-macros@googlegroups.com Sent: Wed, May 23, 2012 4:41:42 PM Subject: Re: $$Excel-Macros$$ Oralce

Re: $$Excel-Macros$$ Oralce Connection

2012-05-23 Thread t vinay
ll the times you can, >> To all the people you can, >> As long as ever you can.” - John Wesley >> *- >> >> >> -- >> *From:* t vinay >> *To:* excel-macros@googlegroups.com >&

Re: $$Excel-Macros$$ Oralce Connection

2012-05-23 Thread t vinay
you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *----- > > > ------ > *From:* t vinay > *To:* excel-macros@googlegroups.com > *Sent:* Wed, May 23, 2012 3:29:10 PM &g

Re: $$Excel-Macros$$ Oralce Connection

2012-05-23 Thread Paul Schreiner
the people you can, As long as ever you can.” - John Wesley - From: t vinay To: excel-macros@googlegroups.com Sent: Wed, May 23, 2012 3:29:10 PM Subject: Re: $$Excel-Macros$$ Oralce Connection Hi Paul, please find

Re: $$Excel-Macros$$ Oralce Connection

2012-05-23 Thread Paul Schreiner
- From: t vinay To: excel-macros@googlegroups.com Sent: Wed, May 23, 2012 3:29:10 PM Subject: Re: $$Excel-Macros$$ Oralce Connection Hi Paul, please find the below vba code. Dim Database_Name As String     Dim User_ID As String     Dim

Re: $$Excel-Macros$$ Oralce Connection

2012-05-23 Thread t vinay
Hi Paul, please find the below vba code. Dim Database_Name As String Dim User_ID As String Dim Password As String Dim SQLStr As String Dim OraDynaSet As Object Dim objSession As Object Dim objDataBase As Object Dim i As Integer 'Create a reference to my database

Re: $$Excel-Macros$$ Oralce Connection

2012-05-23 Thread Paul Schreiner
Can you show what your tnsnames.ora entry looks like? And what your VBA connect string looks like?   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people y