Hi all,
I am trying to set up a connection to a Visual Foxpro 9.0 database through OLE DB (ODBC isn't working as there seems to be no recent ODBC-driver anymore). I have set up this step as follows:
fdb.udl:
[oledb]
; Everything after this line is an OLE DB initstring
Provider=VFPOLEDB.1;Data Source=E:\FDB\BOOKS.DBC;Mode=Share Deny None;Password=" ";Collating Sequence=MACHINE
ORACLE_HOME\hs\admin\initfdb.ora
HS_FDS_CONNECT_INFO="UDLFILE=E:\oracle10g\db\hs\admin\fdb.udl"
HS_FDS_TRACE_LEVEL = debug
listener.ora:
(SID_DESC =
(SID_NAME = fdb)
(ORACLE_HOME = E:\oracle10g\db)
(program = hsolesql)
)
tnsnames.ora
fdb =
(description =
(address = (protocol=tcp)(host=localhost)(port=1521))
(connect_data = (sid=fdb))
(hs=ok)
)
In the end I have tried to create a database link, but I keep on getting the following error message (It's in Dutch, sorry for that):
.ORA-28500: Verbinding van ORACLE met een niet-Oracle systeem heeft het volgende
bericht geretourneerd.
[Generic Connectivity Using OLEDB_SQL]DRV_InitTdp:
(pIDataInitialize->LoadStringFromStorage:rc=-2147287038):Extended =
ORA-02063: Voorgaande 2 lines uit FDB.
I have read that there might be an issue with the usage of '\' in initfdb.ora and that I might need to escape them in the following thread:
250155
but when I change the '\', I get the following error message:
.ORA-28500: Verbinding van ORACLE met een niet-Oracle systeem heeft het volgende
bericht geretourneerd.
[Generic Connectivity Using OLEDB_SQL]DRV_InitTdp:
(pIDataInitialize->GetDataSource:rc=-2147221164):Extended =
ORA-02063: Voorgaande 2 lines uit FDB.
I have also tried to set up my database link in several ways (without any user info, with user info and empty password, with user info and actual password) as was mentioned in the same thread, but to no avail. It keeps on returning the same error.
I am running out of options in how to set this up for Foxpro. I have done it for an Access database (both using ODBC and OLE DB) and it works like charm. Can anybody help me any further?
Thanks in advance,
Benny