Oracle Connection

[arunbalait]

Hi

I have a doubt that...

I want my database to be in the server. I mean LAN server..

My project is distributable. The database at Server should be connected with Lan clients.

Is it possible to use Oracle at Lan server?

Do I have to use Ip Address of that server?

Give me some ideas please..

I dont know much about it.

Oracle might be 8 or 9i.

Plz guide me detailly plz

Thanx

[debasisdas]

you just need to specify the host string for the conection along with usename and password.

[arunbalait]

you just need to specify the host string for the conection along with usename and password.

Hi I need connection string for Oracle..
I want to connect Oracle with VB through Lan. Not directly with oracle by entering Username, Password and Host String.

CN.Open "Provider=MSDAORA.1;Password=manager;User ID=system;Persist Security Info=True"

I tried the above connection string but no result...

Thanx....

[debasisdas]

Hi I need connection string for Oracle..
I want to connect Oracle with VB through Lan. Not directly with oracle by entering Username, Password and Host String.

CN.Open "Provider=MSDAORA.1;Password=manager;User ID=system;Persist Security Info=True"

I tried the above connection string but no result...

Thanx....

Kindly post the exact error message with error number for the above connection string.

[arunbalait]

Kindly post the exact error message with error number for the above connection string.

Run Time Error: 91
 
 Object or With Block Variable not set

Here I tried for local Oracle connection not with Lan Server.

If I give data source =Ipaddress

Am getting error like

Run-Time Error '-2147217805(80040e73)
Format of the initialization string does not conform to the OLEDB specification

Thanks.

[arunbalait]

Hi

I solved the Oracle Connection problem

I tried by installing MSDAC. After installing this component its working.

But am unable to connect with remote systems.

strConn = "UID=system;PWD=manager;" & _
                "driver={Microsoft ODBC for Oracle};" & _
                "SERVER=;"

Am using connection string like given above.

If I want to connect with remote systems what changes do i have to make with the Connection String..

Thanx

[debasisdas]

Are you able to connect to the remote server using SQL * PLUS ?

[arunbalait]

Are you able to connect to the remote server using SQL * PLUS ?

Nope... I couldnt.. Thats what my doubt... I want to connect with remote system.

How to make connection with Remote systems?

Thanx

[debasisdas]

Nope... I couldnt.. Thats what my doubt... I want to connect with remote system.

How to make connection with Remote systems?

Thanx

You need to modify the entries in the TNSNAMES.ORA file.

[arunbalait]

You need to modify the entries in the TNSNAMES.ORA file.

Hi

I dont know much in Oracle

Please let me know how and what to modify in the TNSNAMES.ORA?

Thankx

[debasisdas]

usually the file contains somthing like this

MES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.3)(PORT = 1521))
)
(CONNECT_DATA =
(SID = MES)
)
)
BDCORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.12.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl1)
)
)
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.12.220)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)

try to add the name,ipaddress of the remote server to your file

the TNSNAME.ORA file is located at folllwing path in 10g.

\oracle\product\10.2.0\db_1\NETWORK\ADMIN

[arunbalait]

try to add the name,ipaddress of the remote server to your file

the TNSNAME.ORA file is located at folllwing path in 10g.

\oracle\product\10.2.0\db_1\NETWORK\ADMIN

But as a client How could I configure the Ip address?

Actually Oracle 10g was installed in the server. The database I want to connect also there. Am running as client, so if i want to connect with the database for my application then what changes do I have to make.

I tried using DSN (ODBC) and Oracle provider they all showing errors like couldnot connect.

If i opened SQL*Plus how sould I have to connect with the database in the server?

Thanx

[debasisdas]

Do you have oracle client installed on your PC or not ?

You need to make changess to the TNSNAME.ORA fiel in your PC not in the server.

[arunbalait]

Do you have oracle client installed on your PC or not ?

You need to make changess to the TNSNAME.ORA fiel in your PC not in the server.

Oh.. Thanks. And I have Installed Oracle 10g client. I shall try changing that TNSNAME.ORA file.

Actually am creating a workbench for DataEntry Operators, after completing the project I should deploy the project to all of them. Should I have to install Oracle client to all the Machines?

Thanks

[amitpatel66]

Oh.. Thanks. And I have Installed Oracle 10g client. I shall try changing that TNSNAME.ORA file.

Actually am creating a workbench for DataEntry Operators, after completing the project I should deploy the project to all of them. Should I have to install Oracle client to all the Machines?

Thanks

If you want to access oracle from all those machines then yes you have to install client in all the machines with proper TNS entry

[debasisdas]

Actually am creating a workbench for DataEntry Operators, after completing the project I should deploy the project to all of them. Should I have to install Oracle client to all the Machines?

Yes you need to install oracle client in all the machines from where you want to run the application and also you need to configure the file to connect to the desired oracle server.

[arunbalait]

Yes you need to install oracle client in all the machines from where you want to run the application and also you need to configure the file to connect to the desired oracle server.

Yep I configured that file. But I couldnt connect with the database

Am getting error message that ORA-12560 TNS: Protocol adapter error

I searched for the listener service to start. But I found nowhere.

Whats the problem with it?
Thanx

[amitpatel66]

Yep I configured that file. But I couldnt connect with the database

Am getting error message that ORA-12560 TNS: Protocol adapter error

I searched for the listener service to start. But I found nowhere.

Whats the problem with it?
Thanx

symptom: TNS-00530: TNS: Protocol adapter error

symptom: Local connections can be established

cause: The listener has been started using a different (e.g. local
System)
account while the OracleService has been started using another (e.g.
a named
Administrator) account. In that situation the listener may not be
allowed to
create dedicated server processes which are under Windows created as
threads
within the Oracle.exe.

fix:

Verify that the OracleService and the ListenerService have been started
using
the same account. Unless for special reasons, the default local System
account
should not be changed.

[arunbalait]

fix:

Verify that the OracleService and the ListenerService have been started
using
the same account. Unless for special reasons, the default local System
account
should not be changed.

HI,

Thanx for the reply.
I found those services have been started and running. But when am trying to connect with the server it says that error(protocol adapter error).

I have installed Oracle 10g database at server side.

Even the oracle doesnt connect with localhost.

[debasisdas]

Are you able to connect to the oracle server through SQL*PLUS from the server system itself. Just try once.

[arunbalait]

Are you able to connect to the oracle server through SQL*PLUS from the server system itself. Just try once.

Ya I have tried to connect to the oracle server through SQL *PLUS from the server system. And its connecting.

But when am trying to connect from the remote system it doesnt connect. It says Protocol adapter error.

I am stuck up in this stage. I have finished all other works in my project.

Thanx

[arunbalait]

Hi

Somebody help me please

Its urgent for me

thanx