Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lane0618
Posting Yak Master
134 Posts |
 Posted - 2003-06-11 : 21:55:38
|
| How do I import tables from a remote Oracle database?server name is AnEng, the database name is Ilink. When I try to test the connection i get: TNS: listener could not resolve SID ...I setup a DSN on the Oracle server. Is it possible to use that?Thanks,Lane |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-06-12 : 05:19:09
|
| Hello Lane!Have you got Oracle SQL Net set up on the machine?If you do, look into the tnsnames.ora file which should be setup on the server. You may have to alter some registry settings on the client to point to the correct tnsnames.ora file. |
 |
|
|
|
|
|
Connect to Oracle