PDA

View Full Version : Oracle <crazy> Forms Developer 6i



CollegeGirl
04-29-2002, 04:37 PM
I'm trying to use this "lovely" thing on windows 2000 but it won't connect to my database!! ugh & i think i have to change the TNS settings or something but i don't know how.
so does anyone know how??

Barjor
04-29-2002, 04:43 PM
Congratulation. You win the price for most confusing question today. And the price is a diesel powered toaster.

incognito
04-29-2002, 06:00 PM
It's been ages since I heard from college girl, she's finally back at least on this board anyways, and about your Q, I have no idea. It might help if you state what the "lovely" thing is, wait never mind I still wouldn't understand.

Aran
04-29-2002, 06:44 PM
read the topic. it says it there.

i have never used oracle... i never plan on it... sorry.

CompiledMonkey
04-29-2002, 08:23 PM
Originally posted by Aran Elus
i have never used oracle... i never plan on it... sorry.

You never plan on working in IT?

As for the main question, when I had Oracle setup on my workstation at work the DBAs did it. I do remember them changing the TNS but I can't remember what they did.

Xmevs
04-30-2002, 06:46 AM
I haven't tried Oracle yet. Although I hope I will in near future, because it seems stable and stuff like that. What is Oracle used for?

Xmevs
04-30-2002, 06:48 AM
BTW: is Oracle "Open Source" database?

nvoigt
04-30-2002, 07:48 AM
Oracle is one of the largest database corporations. I haven't worked with the Forms Developer, but I have done enough other stuff to know what to tweak to connect to an instance ;) What is the error you get ? "Cannot resolve service name" ?

CompiledMonkey
04-30-2002, 09:15 AM
Originally posted by Xmevs
BTW: is Oracle "Open Source" database?

No. It's probably the most expensive one.

CollegeGirl
04-30-2002, 10:17 AM
>>Congratulation. You win the price for most confusing question today. <<

thank you, thank you, thank you!!

>>It's been ages since I heard from college girl, she's finally back at least on this board anyways, and about your Q, I have no idea. It might help if you state what the "lovely" thing is, wait never mind I still wouldn't understand.<<

i'm here but i don't post much <that if i had time to read anything anyways :P>

& the lovely thing is that i'm about to blow my head off! or maybe blowing oracle is better...

>>As for the main question, when I had Oracle setup on my workstation at work the DBAs did it. I do remember them changing the TNS but I can't remember what they did.<<

can you ask them?? please, please, PLEASE!!!

>>What is the error you get ? "Cannot resolve service name" ?<<

exactly! now what to do??

P.S: for anyone that knows the answer please explain in details because i asked someone at oracle and he replied that he needs more info & want tnsnames.ora to fix it & i sent him all these stuff & i didn't get an answer *sigh*...

taylorguitarman
04-30-2002, 10:19 AM
Originally posted by Xmevs
I haven't tried Oracle yet. Although I hope I will in near future, because it seems stable and stuff like that. What is Oracle used for?
Anyone else find this amusing? If you're not sure what the product is, what seems stable about it, the name?

Originally posted by Xmevs
BTW: is Oracle "Open Source" database?
MySQL is open source, Oracle is very expensive.

To CG:
I'd love to help but all of my DB work was with Microsoft stuff.

nvoigt
04-30-2002, 11:12 AM
I don't know Oracle Forms Developer, so I have to take some guesses here ;)

You connect to a datasource by giving three things:

Username, Password, Datasource
(USR;PWD;DSN)

tnsnames.ora is a text file that specifies where to find the database server that belongs to the Datasource name you gave.
It's a config file that lists names and technical descriptions ( host name, IP maybe, probably Port etc )

Example:

You want to connect as "CG" to the database named "X" with a given password. The program now looks up X in the tnsnames.ora. If there is no entry like "X = ...", the client won't know where to connect to, and will fail with the message you got, which means it could not resolve the name you gave into a technical description that could be used for connecting.

It's next to impossible to give a correct description without the technical data of your installation of the server, the host name etc. To be honest, when this happens at work, we always have one file where it is correct and copy&paste that part.

Oracle Support is ok. They will most likely point you to a page ( or rather two or three chapters ) of the manual that tells what to do in detail.

If you need more info, you can send me the file by PM ( shouldn't be large and I'm not at work for two days, so not available at the mail address given here ).