| how to connect two database [message #52234] |
Wed, 10 July 2002 08:50  |
Nita
Messages: 34
Registered: March 2002
|
Member |
|
|
I'm using Oracle Database Server and Client.
The server database using 8i Enterprice and the client using 8i client.
I' Using VB. Can anyone help me how to configure it and connect it. Please....
|
|
|
|
| Re: how to connect two database [message #52249 is a reply to message #52234] |
Wed, 10 July 2002 21:37  |
santosh
Messages: 85
Registered: October 2000
|
Member |
|
|
Hi nita,
You can connect from client to server application . But first use SQL net easy configuration tool to configure your client to connect to running oracle server.You will be required to provide server tcp/ip address and oracle instance name. At the end of the tool it will try to connect to server using given information .If it doesnt show any error, you can connect from client to server on sqlplus application by giving valid oracle username ,password and connection string name u just have created using net easy config.
While connecting through vb u require to create a dsn and the procedure is given in any vb book in database connection chapters.
Wish u good luck
Santy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
