RE: URGENT ODBC HELP REQUIRED

From: Shaw, John B <jbshaw_at_ingr.com>
Date: Thu, 31 May 2001 07:59:46 -0700
Message-ID: <F001.0031579B.20010531054623@fatcity.com>

be
something like this (check for errors):
<SPAN

class=121353612-31052001> 
open
database data1LOCAL  lcCursorName, lnreturnlcCursorName = "SQLRESULT"gcODBCDataSource = 'odbcname'gcSQLUserID = 'oracleuser'gcSQLPassword = 'oraclepass'  
<SPAN

class=121353612-31052001>gnConnHandle = SQLCONNECT(gcODBCDataSource, gcSQLUserID, gcSQLPassword) IF gnConnHandle <= 0  = mbox('Cannot make connection', 16, 'SQL Connect Error')  RETURN ENDIFSET DATABASE TO
data1  CREATE CONNECTION mytest DATASOURCE &gcODBCDataSource USERID &gcSQLUserID PASSWORD &gcSQLPasswordcreate sql view tmp remote connection odbcname as select * from tmp
 
<SPAN

class=121353612-31052001>   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 realENDIFIF !USED("tmp") USE tmp IN 0 ALIAS tmpENDIFSELECT tmpSCAN SELECT real replace all real.col with tmp.col ;    for real.key =
tmp.key ENDSCAN

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Arslan Dar   [mailto:arslandar_at_skm.org.pk]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 <FONT face=Arial
  size=2>Arslan Received on Thu May 31 2001 - 09:59:46 CDT