| ODBC [message #52959] |
Wed, 21 August 2002 13:52  |
Venkat
Messages: 110
Registered: February 2001
|
Senior Member |
|
|
Hi Gurus,
Can any body list out the procedure to configure th ODBC in a oracle client PC(NT).
Thanks in advance,
Venkat
|
|
|
|
| Re: ODBC [message #52960 is a reply to message #52959] |
Wed, 21 August 2002 14:37  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Sure. Here is what you have to do:
1. Start the ODBC Administrator application to configure Data Source Name. You can find it in Start -> Programs -> Control Panel.
2. Select the System DSN tab. Then click on Add. Select Oracle8 ODBC driver.
3. Enter the server name in “Server Name”. Give it a meaningful Data Source Name and “Description”.
4. Click on the Advanced tab and give an Array size of 100,000.
5. To test your Data Service Name, click on “Test Connect” button.
You will be prompted to provide valid account information for the database you are trying to establish ODBC connections. Select the correct “Server Name” from the list. Fill the “User Name” and “Password” fields. Click on “OK” button to test the connection.
If provided information is correct then you have to establish ODBC connection to Oracle RDBMS.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
