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