RE: URGENT ODBC HELP REQUIRED

[Shaw, John B]

Title: URGENT ODBC HELP REQUIRED

be something like this (check for errors):

 

open database data1
LOCAL  lcCursorName, lnreturn
lcCursorName = "SQLRESULT"
gcODBCDataSource = 'odbcname'
gcSQLUserID = 'oracleuser'
gcSQLPassword = 'oraclepass'

 

gnConnHandle = SQLCONNECT(gcODBCDataSource, gcSQLUserID, gcSQLPassword)
 IF gnConnHandle <= 0
  = mbox('Cannot make connection', 16, 'SQL Connect Error')
  RETURN
 ENDIF
SET DATABASE TO data1
  CREATE CONNECTION mytest DATASOURCE &gcODBCDataSource USERID &gcSQLUserID PASSWORD &gcSQLPassword
create sql view tmp remote connection odbcname 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")
 USE real IN 0 ALIAS real
ENDIF
IF !USED("tmp")
 USE tmp IN 0 ALIAS tmp
ENDIF
SELECT tmp
SCAN
 SELECT real
 replace all real.col with tmp.col ;
    for real.key = tmp.key 
ENDSCAN

-----Original Message-----
From: Arslan Dar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 8:55 PM
To: Multiple recipients of list ORACLE-L
Subject: 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