Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vu Dinh Hoang
  Where is Vu Dinh Hoang?
 Ha noi
 Vietnam
 Vu Dinh Hoang
 To: Thinh Khanh
  Where is Thinh Khanh?
 Qui nhon
 Vietnam
 Thinh Khanh
 Tags
Subject: RE: How to connect to Oracle using VFP without ...
Thread ID: 42782 Message ID: 54796 # Views: 4 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Tuesday, November 2, 2004 7:39:49 AM         
   


> 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


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