OraFAQ Forum: Forms » error on connect sqlserver

Home » Developer & Programmer » Forms » error on connect sqlserver

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error on connect sqlserver [message #159423]

Sun, 19 February 2006 03:09

rnemkul
Messages: 35
Registered: February 2006

Member

Hi all

I am using forms6i and my new server is sql server 2000.
When I try to connect sqlserver through forms 6i I had got an error message
"Error while trying to retrieve text for error ORA-06401 ".

I try to connect by this way hrms/h@:ODBC.hrms

user: HRMS
password: H
ODBC: HRMS

So please help me to solve my problem

Regards
Rajendra

Report message to a moderator

Re: error on connect sqlserver [message #159452 is a reply to message #159423]

Sun, 19 February 2006 15:13

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

ORA-06401 NETCMN: invalid driver designator

Cause: The login (connect) string contains an invalid driver designator.

Action: Correct the string and re-submit.

[Updated on: Sun, 19 February 2006 15:14]

Report message to a moderator

Re: error on connect sqlserver [message #159471 is a reply to message #159452]

Sun, 19 February 2006 23:53

rnemkul
Messages: 35
Registered: February 2006

Member

I used connect string is valid But there was a problem so please any sugesstion.

Rajendra

Report message to a moderator

Re: error on connect sqlserver [message #159481 is a reply to message #159471]

Mon, 20 February 2006 00:30

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Can you connect via SQL*Plus?

David

Report message to a moderator

Re: error on connect sqlserver [message #159483 is a reply to message #159481]

Mon, 20 February 2006 00:36

rnemkul
Messages: 35
Registered: February 2006

Member

Hi
I need to connect through Forms6i

Rajendra

Report message to a moderator

Re: error on connect sqlserver [message #159485 is a reply to message #159483]

Mon, 20 February 2006 00:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I KNOW that, but can you connect through SQL*Plus?

David

Report message to a moderator

Re: error on connect sqlserver [message #159487 is a reply to message #159485]

Mon, 20 February 2006 00:43

rnemkul
Messages: 35
Registered: February 2006

Member

I had also try through sql but there was same error message
ORA-06401

Report message to a moderator

Re: error on connect sqlserver [message #159489 is a reply to message #159487]

Mon, 20 February 2006 00:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I don't think Oracle Products can connect to SQL Server. Do you have any documentation that says that SQL*Plus will connect to SQL Server?

David

Report message to a moderator

Re: error on connect sqlserver [message #159495 is a reply to message #159489]

Mon, 20 February 2006 01:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay. You can connect to SQL Server.

You install V6.0.5.35 of the Oracle Client Adapter. It is available on CD from Patch 1 of 6i onwards.

David

Report message to a moderator

Previous Topic:	how get selected data at opening time
Next Topic:	Pre-delete trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:33:12 CDT 2024