OraFAQ Forum: Forms » Check how oracle developer connect with ms asccess or sqlserver(Very intresting)

Home » Developer & Programmer » Forms » Check how oracle developer connect with ms asccess or sqlserver(Very intresting)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Check how oracle developer connect with ms asccess or sqlserver(Very intresting) [message #118009]

Mon, 02 May 2005 10:08

fahedakhter
Messages: 39
Registered: March 2005
Location: Pakistan

Member

I had notice that every body intresting in conenct oralce develoepr with third party database.Here is the solution check this and pray for me.If any question mail me.

Step to follow.
1) Make a System odbc attach a database file and name the odbc "test".Do not configure password to that file.
2) make a table name "emp" in msaccess database with two column
"empno number","ename text".
3) Open fmb and attach EXEC_SQL.pll.
4) Connnect by this scott/tiger
not
scott/tiger@odbc.test(this is wrong)

Note:
I attach oca.fmb file with this topic.
Regard's
Fahed

Attachment: OCA.fmb
(Size: 64.00KB, Downloaded 1694 times)

Report message to a moderator

Re: Check how oracle developer connect with ms asccess or sqlserver(Very intresting) [message #118335 is a reply to message #118009]

Wed, 04 May 2005 08:21

KashifDBA
Messages: 1
Registered: May 2005

Junior Member

Hello

Can u tell me about the procedure that how can i connect to Foxpro dbf files.
I want to load my all data from Foxpro to Oracle Database.
How can i connect to it.
dbf Files a made in Visual Foxpro 6.0

thanks in Advance.

Best regards

Muhammad Kashif

Report message to a moderator