-
I want to access a SQLServer database via ODBC.
Metalink suggests using Merant or Intersolve ODBC drivers and says that the ODBC agent is already on the Oracle Server.
Has anyone done this and can you offer recommendations on setup and which ODBC driver is best.
David Knight
OCP DBA 8i, 9i, 10g
-
check out the prev thread...
http://www.dbasupport.com/forums/sho...threadid=22282
that one is a intersolv driver cro8. and works fine.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
This example of generic connectivity should sort you out. The example is for 9i to Access but it is fine for 8i to SQL Server also. I've used the standard SQL Server driver with no problems:
http://www.oracle-base.com/Articles/...ectivity9i.asp
I've not used it but I would have thought the transparent gateway for SQL Server was better??
-
Whichever driver works is the best driver. You can quote that one if you like... :-)
If you need one-time access, MS Access is a good tool.
I recommend the Transparent Gateway for MS SQL if you want some permanent access to a defined SQL Server database.
Setting it up is a bit of a bugger, but once it's up and running, it's quite amazing.
-Ken
-
Thanks for the responses.
We are interested in OTG. We use it for DB2.
Do you have any ideas about the cost?
David Knight
OCP DBA 8i, 9i, 10g
-
The transparent gateways are included in the database now.
What'll they think of next!
-Ken
-
for tim
hi tim,
I used ur URL used to connect from oracle to non-oracle database.The non oracle database i use is sql server but i am not able to connect. It gives me this error
ORA-28509: unable to establish a connection to non-Oracle system
ORA-02063: preceding line from LINKS
where LINKS is the name of the database link.I checked the orcle doc and checked on all the suggested method and the configuration is done as told by u.But still i am not able to connect.Could u please help me id solving this problem
cheese
anandkl
anandkl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|