Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 Tags
Subject: RE: How to connect to Oracle using VFP without ...
Thread ID: 42782 Message ID: 55079 # Views: 4 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, November 04, 2004 9:30:59 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

Hi,
I initially gave it a try but ran into the 255 schema character length error. Know there is a work around
the "BL" posted and just have not got to it yet. Information from UT advised me it was due to
trailing blanks left on the char fields in my Oracle backend, and what I should do is go in the
backend and change all the char fields. I tried a couple of backend changes and my $27,000.00 3rd
party exe and then it failed with my Oracle backend field changes and I have to change them back.
Due to this problem I just by passed VFP on this one and code it in VB.net using ADO and all worked
as planned.
Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


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