i want to pick data from oracle on different computer how can i make a connection to that oracle.
Printable View
i want to pick data from oracle on different computer how can i make a connection to that oracle.
Start button > Settings > Control Panel > ODBC Data >
Add button > Microsoft ODBC for Oracle
You can't set up the ODBC connection from inside VB, it has to be defined as above.
i use to define the connection in the same way . but i now want to connect on another computer.
what should i do now
please write full description.
thanks
What you have to do depends on which driver you're using.
If you're using native (orawin) drivers, just add the new computer as a server to the tnsnames.ora file.
If you're using ODBC, then what I showed you earlier will work.