Intermittent problem in data transfer MSAccess to Oracle using VB
in [Visual Basic]
|
Prev: regular expression won't match single digit
Next: Intermittent problem in data transfer MSAccess to Oracle usingVB
From: ralph on 27 Jul 2010 21:03 On Tue, 27 Jul 2010 18:55:43 -0400, "Kevin Provance" <k(a)p.c> wrote: > >"Paul Clement" <UseAdddressAtEndofMessage(a)swspectrum.com> wrote in message >news:6ldu46tllij1ftuusdnimulmsiopk0miqp(a)4ax.com... >: On Tue, 27 Jul 2010 14:24:08 -0400, "Phil Hunt" <aaa(a)aaa.com> wrote: >: >: � Paul, I am curious what the SQL stmt looks like with connect striing in >it . >: � >: >: I'll see if I can come up with something functional. > >Didn't someone post a site that dealt with connection strings? Damn, I >should have bookedmarked it. no bookmark needed - easy to remember www.connectionstrings.com -ralph
From: phil hunt on 27 Jul 2010 21:24 I know connection string within a connect stmt. Paul was talking about an SQL Insert statement that has an connection string. 2 different thing. I know the syntax when dealing with 2 Access db, but never before between Access and Oracle. "Kevin Provance" <k(a)p.c> wrote in message news:i2no5b$1js$1(a)news.eternal-september.org... > > "Paul Clement" <UseAdddressAtEndofMessage(a)swspectrum.com> wrote in message > news:6ldu46tllij1ftuusdnimulmsiopk0miqp(a)4ax.com... > : On Tue, 27 Jul 2010 14:24:08 -0400, "Phil Hunt" <aaa(a)aaa.com> wrote: > : > : � Paul, I am curious what the SQL stmt looks like with connect striing > in > it . > : � > : > : I'll see if I can come up with something functional. > > Didn't someone post a site that dealt with connection strings? Damn, I > should have bookedmarked it. >
From: Paul Clement on 28 Jul 2010 14:31 On Tue, 27 Jul 2010 14:24:08 -0400, "Phil Hunt" <aaa(a)aaa.com> wrote: � Paul, I am curious what the SQL stmt looks like with connect striing in it . � � With a connection to the Access database this worked for me: INSERT INTO [ODBC;Driver={Microsoft ODBC For Oracle};Server=ServerName;Uid=userID;Pwd=password;].[ORDERS] (ORDERID, CUSTOMERID, EMPLOYEEID) SELECT ORDERID, CUSTOMERID, EMPLOYEEID FROM ORDERS Paul ~~~~ Microsoft MVP (Visual Basic)
From: Phil Hunt on 29 Jul 2010 14:17
Thanks Paul. "Paul Clement" <UseAdddressAtEndofMessage(a)swspectrum.com> wrote in message news:vlt0565gc0457injhfsd41j5scnij15his(a)4ax.com... > On Tue, 27 Jul 2010 14:24:08 -0400, "Phil Hunt" <aaa(a)aaa.com> wrote: > > � Paul, I am curious what the SQL stmt looks like with connect striing in > it . > � > � > > With a connection to the Access database this worked for me: > > INSERT INTO [ODBC;Driver={Microsoft ODBC For > Oracle};Server=ServerName;Uid=userID;Pwd=password;].[ORDERS] (ORDERID, > CUSTOMERID, EMPLOYEEID) > SELECT ORDERID, CUSTOMERID, EMPLOYEEID FROM ORDERS > > > Paul > ~~~~ > Microsoft MVP (Visual Basic) |