Re: Problem with Connection String & Data Direct!

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

[Quoted] 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_at_x.washington.edu
(replace x with u to respond)