be
something like this (check for errors):
open
database data1
LOCAL lcCursorName, lnreturn
lcCursorName = "SQLRESULT"
gcODBCDataSource = 'odbcname'
gcSQLUserID = 'oracleuser'
gcSQLPassword = 'oraclepass'
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
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.)
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
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 REQUIREDHi 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