Home » Developer & Programmer » Forms » problem in connectign sqlserver with develoepr6i forms
icon10.gif  problem in connectign sqlserver with develoepr6i forms [message #117962] Mon, 02 May 2005 03:10 Go to next message
dstech
Messages: 7
Registered: May 2005
Junior Member
hello

i wann to connect sql server with developer6i forms.

afetr creatign odbc dsn whtn i tried to connect d2k 6i form with sqlserver it gives the error message
ORA:06401:NETCMN:invalid driver designer

can any1 solve this problem
plz reply as soon as possible as its very urgent
i iwll be very thank ful to u

dstech.
Re: problem in connecting sqlserver with developer6i forms [message #117976 is a reply to message #117962] Mon, 02 May 2005 06:21 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
dstech wrote on Mon, 02 May 2005 10:10

hello

i wann (want) to connect sql server with developer6i forms.

afetr creatign odbc dsn whtn (???) i tried to connect d2k 6i form with sqlserver it gives the error message
ORA:06401:NETCMN:invalid driver designer

can any1 (anyone) solve this problem (?)
plz (please) reply as soon as possible as its very urgent
i iwll (will) be very thank ful (thankful) to u (you.)

dstech.

If you type your code like your question, no doubt there's a typo somewhere http://www.orafaq.com/forum/images/message_icons/icon10.gif
Breathe deep and try to form an English question. The site has a spell-check feature, which works very well.

Your message (ORA-06401) gives the following in OERR:
06401, 00000, "NETCMN: invalid driver designator"
// *Cause:  The login (connect) string contains an invalid driver designator.
// *Action: Correct the string and re-submit.


So, look carefully at your connect string, and figure out where you went wrong. If you can't figure it out, post some sample of your code.

Regards,
MHE

[EDIT: Moved topic to Forms]

[Updated on: Mon, 02 May 2005 06:22]

Report message to a moderator

Re: problem in connecting sqlserver with developer6i forms [message #117977 is a reply to message #117976] Mon, 02 May 2005 06:33 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Update, I read in the Oracle Forums that OCA (Oracle Client Adaptor) must be installed for SQL Server.

MHE
Re: problem in connecting sqlserver with developer6i forms [message #117983 is a reply to message #117977] Mon, 02 May 2005 07:14 Go to previous messageGo to next message
dstech
Messages: 7
Registered: May 2005
Junior Member
hi

can u plz tell me, from where can u download OCA.is it free to download from net or we have to buy it.or it comes alo
ng with oracle 9i.do reply me m wtng.
Re: problem in connecting sqlserver with developer6i forms [message #118011 is a reply to message #117983] Mon, 02 May 2005 10:41 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Try again. I don't get the question. Use ENGLISH, not u plz rgnt abbreviations 'plz'.

On second thought, never mind.

OCA comes with your installation cds. Put them in, start the installer and look for 'open client adapter for ODBC'


MHE

[Updated on: Mon, 02 May 2005 10:44]

Report message to a moderator

Re: problem in connecting sqlserver with developer6i forms [message #118113 is a reply to message #118011] Tue, 03 May 2005 02:47 Go to previous messageGo to next message
dstech
Messages: 7
Registered: May 2005
Junior Member
hello

i uninstalled developer6i and then again installed it,and folder of OCA6.0 os also available in the folser of ORANT,but after installing it when i again tried to connect d2k with sqlserver its giving the same error message.

when i tried to connect d2k forms(6i) with sqlserver
it askd me 3 things

USERNAME

PASSWORD

HOSTSTRING

in username i m giving the default username i.e SA
and passward ,i m using the password whihc i have given at the time of installation

and in place of hoststring i m giving sqlserver:odbc

sqlserver is the sanem of my dsn connection and im connecting it thru odbc.

USERNAME:- sa

passward:-test

HOSTSTRING:-sqlserver:odbc

in host string i have also tried mssqlserver:odbc
as in sourcefile its given as mssqlserver

plz tell me where i m wrong.
Re: problem in connectign sqlserver with develoepr6i forms [message #118117 is a reply to message #117962] Tue, 03 May 2005 02:55 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do you have 'odbctest' (or some name similar) on your PC? It should be in the OBDC sub-menu. Use it to prove that the OBDC is working on your PC.

David
Re: problem in connectign sqlserver with develoepr6i forms [message #118124 is a reply to message #118117] Tue, 03 May 2005 03:11 Go to previous messageGo to next message
dstech
Messages: 7
Registered: May 2005
Junior Member
odbc is working in this pc ,as i had created datasource in odbc only and had connected sqlserver with odbc only ,the problem is when i tried to connect developer form6i with sqlserver thru odbc its giving the error.

tell me some other option ,what shd i do now.
Re: problem in connectign sqlserver with develoepr6i forms [message #118253 is a reply to message #117962] Tue, 03 May 2005 19:32 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do you have anything in your tnsnames.ora file?

Have a look at http://www.lazydba.com/oracle/0__70783.html.

David
Re: problem in connectign sqlserver with develoepr6i forms [message #118723 is a reply to message #118253] Sat, 07 May 2005 05:51 Go to previous messageGo to next message
dstech
Messages: 7
Registered: May 2005
Junior Member
hello
can u plz tell me how to connect d2k forms(6i) with sqlserver without autocommit.
reply as its very urgent.
Re: problem in connectign sqlserver with develoepr6i forms [message #118797 is a reply to message #117962] Sun, 08 May 2005 20:01 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I think the autocommit is a sqlserver problem,not an Oracle problem.

David
Re: problem in connecting sqlserver with developer6i forms [message #119986 is a reply to message #117976] Tue, 17 May 2005 02:28 Go to previous messageGo to next message
sanjay_r
Messages: 4
Registered: May 2005
Location: india
Junior Member

plz send me details of
Correct the string and re-submit.



Re: problem in connecting sqlserver with developer6i forms [message #119992 is a reply to message #119986] Tue, 17 May 2005 02:38 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I assume that you know that you have 'zero'dbc in your script. Should that be odbc? And the usernames and passwords are correct? Right?
how webpages can be designed using developer forms6i [message #120325] Thu, 19 May 2005 03:01 Go to previous messageGo to next message
sanjay_r
Messages: 4
Registered: May 2005
Location: india
Junior Member

plz,
thanks for last solns.
send me how i can develop webpages using oracle & developer 2000
forms 6i
sanjay
Re: how webpages can be designed using developer forms6i [message #120330 is a reply to message #120325] Thu, 19 May 2005 03:18 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
That's a fairly large question ... basically create a form and test locally using the Developer Server, then deploy in production using the Application Server. A Java applet then runs in the browser environment to display the form which is handled on the Application Server.

David
Previous Topic: ora_ffi working example req
Next Topic: ORA - 01403 no data found
Goto Forum:
  


Current Time: Mon Nov 04 13:43:37 CST 2024