| Re: Connecting Between SQL Server-ODBC-Discoverer [message #99365] |
Tue, 02 October 2001 22:18 |
Nick Macolino
Messages: 1
Registered: October 2001
|
Junior Member |
|
|
Hi,
I have been asked to enable connectivity between discoverer and SQL Server objects while maitaining access to Oracle objects.
Discoverer allows connection to SQL Server simply by creating the appropriate ODBC connection (for example "TESTDB" ) and then using the following connect string :
ODBC:TESTDB
You'll have to connect to each SQL Server instance to create the EUL before connecting any users.
In my case I plan to create views of SQL tables using Oracle SQL Server gateway and then granting access to the views within Discoverer.
I hope this helps
Cheers
Nick
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
