Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: How to connect to Oracle using VFP without ...
Thread ID: 42782 Message ID: 54988 # Views: 4 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, November 03, 2004 11:27:01 PM         
   


> > > I try to change from SQL Server to Oracle
> > > But I don't know how to connect to Oracle without ODBC
> > > Who can help me???
> > > Thank
> > > Email: thinhknk_bdpt@yahoo.com
> >
> > After installing Oracle Driver
> > In VFP you must use:
> > Systax: handle = SQLSTRINGCONNECT(STRCONN)
> > in that: STRCONN is string connection
> > STRCONN = "UID= ab;PWD=cd;DRIVER={Microsoft ODBC For Oracle}; SERVER=DB"
> > username is ab
> > password is cd
> > server is DB
> >
> > I hope that you will success
>
> Hi,
> You can check my past theads on this using keyword "Oracle". I have not been able to update a
> Oracle table using ODBC (both Oracle and Microsoft ODBC drivers) from within a VFP 6.0, 7.0, and VFP version
> 8.0. I can connect and read data, but every effort to change the backend failed.
> This only happens with Oracle, not SQL-Server. If I use the same ODBC connection within MS Access,
> Visual Basic, Delphi, etc...etc... it works. I have tried the SQLSTRINGCONNECT() approach as well,
> to no success. Looks like the changes went through OK, no error messages. Just close the table and
> re-open and the changes are not committed to the backend. SQL pass through fails as well, but only
> from within VFP. You can use ADO to connect as well to connect to Oracle. Regardless of what
> I tried, no updating, no errors and forced to use a different development language for Oracle.
> If you get this to work please post as I have numerous threads to several forums and this is a known
> problem with VFP. Experts at UniversalThread.com supported this as a known issue.
> Pete from the Great White North. (Only in Canada, ay.) Over and Out ...

I just contacted a mate who has VFP updating an Oracle backend using cursoradapters in VFP8. This is for a system at a bank so it has been tested thoroughly. It can therefore work ! Have you tried using cursoradapters ?

Cheers,
Jamie
jamie.osborn@foxite.com

ENTIRE THREAD

How to connect to Oracle using VFP without ODBC Posted by Thinh Khanh @ 5/11/2004 3:40:48 AM
RE: How to connect to Oracle using VFP without ... Posted by Boudewijn Lutgerink @ 5/11/2004 7:31:37 AM
RE: How to connect to Oracle using VFP without ... Posted by Vu Dinh Hoang @ 11/2/2004 7:39:49 AM
RE: How to connect to Oracle using VFP without ... Posted by Pete Sass @ 11/2/2004 8:05:55 PM
RE: How to connect to Oracle using VFP without ... Posted by Jamie Osborn @ 11/3/2004 11:27:01 PM
RE: How to connect to Oracle using OO40 Posted by Sivaramakrishnan Parameswaran @ 11/4/2004 4:34:13 AM
RE: How to connect to Oracle using VFP without ... Posted by Pete Sass @ 11/4/2004 9:30:59 PM
RE: How to connect to Oracle using VFP without ... Posted by Ken Blum @ 11/5/2004 4:15:41 PM
RE: How to connect to Oracle using VFP without ... Posted by Pete Sass @ 11/6/2004 2:14:43 PM
RE: How to connect to Oracle using VFP without ... Posted by Ken Blum @ 11/8/2004 4:40:49 PM
RE: How to connect to Oracle using VFP without ... Posted by Pete Sass @ 11/9/2004 6:41:17 PM