| ODBC - Connection [message #100026] |
Sun, 23 June 2002 02:01  |
Ibrahim
Messages: 16
Registered: October 2001
|
Junior Member |
|
|
Hi All,
I was trying to get connected with the Oracle Database through VB. I am not well in Oracle. But I know VB well. I tried to create a new System DSN thorugh Oracle ODBC Driver but failed. I struck with the UserID and Service Name that to be filled while creating the DSN.
I am using Oracle 8 Enterprise Edition which installed in my PC. I am used to Login to Oracle by default user name and password that scott and tiger. I created a table and inserted data directly from SQL prompt. How I can connect with that table through VB? what user ID and Server Name (Service Name) should I enter while creating System DSN?
Your help and support would be appreciated.
Thanks and regards
|
|
|
|
| Re: ODBC - Connection [message #100031 is a reply to message #100026] |
Mon, 24 June 2002 04:47  |
Jamal
Messages: 15
Registered: March 2002
|
Junior Member |
|
|
Hi,
Service Name is combination of oracle client and server machine names.This is created when you connect an oracle client machine with the oracle server machine.If you are in client/server, then you can follow the steps to create a SERVICE NAME, in my reply to JYOTHI ABRAHAM query.
Once you create the SERVICE NAME you provide this name in creating ODBC.
Hope it will help you.
Thanks
|
|
|
|
| Re: ODBC - Connection [message #100033 is a reply to message #100031] |
Mon, 24 June 2002 21:06 |
Ibrahim
Messages: 16
Registered: October 2001
|
Junior Member |
|
|
Hi Jamal,
Thanks for your reply.
There is no client installed in my pc. In this case, what should do to get connected to Oracle?
Thanks and regards,
Ibrahim
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
