Problem with Connection String & Data Direct!

[Booker Mpando via DBMonster.com]

I am on a Windows system, trying to connect via the internet to an Oracle
database with a Connection String. I have absolutely no experience with
Oracle, and I have no problems with my SQL Server connection string.

This is the string I am using:

DRIVER=DataDirect 5.0 Oracle Wire Protocol; UID=user_name; PWD=password;
HOST=host_name; PORT=port_num; SN=service_name

The error I am getting is this:

[DataDirect][ODBC Oracle Wire Protocol driver]Optional feature not
implemented.

This only happens when I try adding the SN or SID to my string. However, if
I leave them out, I get THIS error:

[DataDirect][ODBC Oracle Wire Protocol driver]Insufficient information to
connect to the data source.

Does anyone have any suggestions for me?? I read the Data Direct
documentation, and it leads me to believe I need either the SID or the SN in
the string, to identify the database I want to use, but it just doesn't seem
to be working.

Thanks in advance for any suggestions anyone has for me!
-Jamie

[DA Morgan]

Jamie M via DBMonster.com wrote: I am on a Windows system, trying to connect via the internet to an Oracle database with a Connection String. I have absolutely no experience with Oracle, and I have no problems with my SQL Server connection string. This is the string I am using: DRIVER=DataDirect 5.0 Oracle Wire Protocol; UID=user_name; PWD=password; HOST=host_name; PORT=port_num; SN=service_name The error I am getting is this: [DataDirect][ODBC Oracle Wire Protocol driver]Optional feature not implemented. This only happens when I try adding the SN or SID to my string. However, if I leave them out, I get THIS error: [DataDirect][ODBC Oracle Wire Protocol driver]Insufficient information to connect to the data source. Does anyone have any suggestions for me?? I read the Data Direct documentation, and it leads me to believe I need either the SID or the SN in the string, to identify the database I want to use, but it just doesn't seem to be working. Thanks in advance for any suggestions anyone has for me! -Jamie

Is this an unsecured database with no firewall just waiting to be
broken into and the server trashed? Also need Oracle version.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Booker Mpando via DBMonster.com]

Everything is running on a server internal to the company, not connected to
the outside world. So yes, it's unsecured, and no, it's not just 'waiting to
be trashed'. The Oracle version is 9.2.


DA Morgan wrote:Is this an unsecured database with no firewall just waiting to bebroken into and the server trashed? Also need Oracle version.


--
Message posted via http://www.dbmonster.com

[DA Morgan]

Jamie M via DBMonster.com wrote: Everything is running on a server internal to the company, not connected to the outside world. So yes, it's unsecured, and no, it's not just 'waiting to be trashed'. The Oracle version is 9.2. DA Morgan wrote:Is this an unsecured database with no firewall just waiting to bebroken into and the server trashed? Also need Oracle version.

The reason I asked is that often Oracle servers are protected by
firewalls and you need to use Connection Manager, CMAN, to tunnel
through the firewall.

In your case ... your confidence in your fellow employees is
commendable. You do realize, I hope, that about 80% of all hacking
is internal to an organization.

In any case if the issue is not related to a FireWall then my
recommendation would be that you perform connection tracing. You
can trace ODBC as well as SQL*Net.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Booker Mpando via DBMonster.com]

What tool would I want to be using to trace a connection??

DA Morgan wrote: Everything is running on a server internal to the company, not connected to the outside world. So yes, it's unsecured, and no, it's not just 'waiting to be trashed'. The Oracle version is 9.2.Is this an unsecured database with no firewall just waiting to bebroken into and the server trashed? Also need Oracle version.The reason I asked is that often Oracle servers are protected byfirewalls and you need to use Connection Manager, CMAN, to tunnelthrough the firewall.In your case ... your confidence in your fellow employees iscommendable. You do realize, I hope, that about 80% of all hackingis internal to an organization.In any case if the issue is not related to a FireWall then myrecommendation would be that you perform connection tracing. Youcan trace ODBC as well as SQL*Net.


--
Message posted via http://www.dbmonster.com

[Booker Mpando via DBMonster.com]

Nevermind!

It was simply that the username/password account I was trying to use is
corrupt in some way. I tried using several different users and it works
properly. The error messages were just not describing the problem very well.


--
Message posted via http://www.dbmonster.com