RE: URGENT ODBC HELP REQUIRED

2001-05-31 Thread Shaw, John B 
Title: URGENT ODBC HELP REQUIRED



be 
something like this (check for errors):

open 
database data1LOCAL lcCursorName, lnreturnlcCursorName = 
"SQLRESULT"gcODBCDataSource = 'odbcname'gcSQLUserID = 
'oracleuser'gcSQLPassword = 'oraclepass'

gnConnHandle = SQLCONNECT(gcODBCDataSource, 
gcSQLUserID, gcSQLPassword)IF gnConnHandle = 0= 
mbox('Cannot make connection', 16, 'SQL Connect 
Error')RETURNENDIFSET DATABASE TO 
data1CREATE CONNECTIONmytest DATASOURCE 
gcODBCDataSource USERID gcSQLUserID PASSWORD 
gcSQLPasswordcreate sql view tmp remote connectionodbcname as 
select * from tmp

DBSETPROP('TMP', "VIEW", 
"MAXRECORDS", -1) DBSETPROP('TMP', "VIEW", "FETCHMEMO", 
.T.)DBSETPROP('TMP', "VIEW", "FETCHSIZE", 
50)USE 
'tmp'CURSORSETPROP("KeyFieldList", 'prime_id) 
CURSORSETPROP("Tables", 'tmp') 
CURSORSETPROP("SendUpdates", .T.)

IF 
!USED("real")USEreal IN 0 ALIAS realENDIFIF 
!USED("tmp")USEtmp IN 0 ALIAS tmpENDIFSELECT 
tmpSCANSELECTrealreplace all real.col with tmp.col 
; for real.key = 
tmp.keyENDSCAN

  -Original Message-From: Arslan Dar 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 8:55 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  URGENT ODBC HELP REQUIRED
  Hi dba's, I want 
  to communicate between Oracle 8 and Clipper.I want to get data from 
  Clipper/Foxpro Dbf file into oracle through ODBC.
  can anybody guide me how to do that. 
  Any links, ? 
  TIA Arslan

RE: URGENT ODBC HELP REQUIRED

2001-05-30 Thread Reardon, Bruce (CALBBAY) 
Title: URGENT ODBC HELP REQUIRED



What 
version of Oracle?
What 
OS?

If the 
need is one off maybe use MS Access to link both Oracle and Clipper via 
ODBC.

If 
regular need and on 816 or above on NT then you can use Heterogeneous 
services.

See 
Metalink notes:
I 
found note 114820.1 helpful - "QUICK START GUIDE: WIN NT - Generic Connectivity 
using ODBC"Also note 109730.1 - How to setup generic connectivity 
(Heterogeneous Services) for Windows NT 
Other 
options include, use say Visual Basic - read from Clipper via ODBC and insert 
into Oracle via (say) OCI.

Regards,
Bruce

  -Original Message-From: Arslan Dar 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, 31 May 2001 11:55 
  To: Multiple recipients of list ORACLE-LSubject: URGENT 
  ODBC HELP REQUIRED
  Hi dba's, I want 
  to communicate between Oracle 8 and Clipper.I want to get data from 
  Clipper/Foxpro Dbf file into oracle through ODBC.
  can anybody guide me how to do that. 
  Any links, ? 
  TIA Arslan