>>>>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."