Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to connect to oracle dbf
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00230838
Message ID:
00230954
Views:
25
>>>>I am using trying to use the connection mgr to access my slq/oracle table but not having any luck following the online help and even bringing up the Remote Data Tab, Options Dialog Box. Is there a command I can execute that will do this for me quickly?
>>>Have you already established the connection using your windows ODBC?
>>
>>I have not but got lost trying to do that in connection mgr.
>O.K. Try this. map a drive to your oracle data source.Go to your windows control panel( or with your database open select Database/Connections - NEW- Will take you to same place) and open the ODBC administrator(User DSN tab)
>and select add then select the driver you want to use(if not installed go to previous screen and add )this will bring up a screen for Odbc setup - this screen is differt according to the driver you are using.If you have problems and filling out this form let me know which drive you are using - I have setups for microsoft, oracle73, visigenic 32 and oracle 8.00 so I may be able to help.

I am with oracle8, I went in like you said and selected "microsoft ODBC driver for oracle" although I could have chosen "microsoft ODBC for oracle".
I filled out the dialog and saw
--data source name
-description
-user name
-connect string
I was not sure what to put in connect string but in data source name I put the name of my oracle instance. What's next I wonder.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform