error viewing oracle stage

kirankota79 · Post by **kirankota79** » Thu Feb 22, 2007 10:59 am

I have oracle as input stage. My ODBC connection is working well and also i can connect from sqlplus on my machine to remote database through ODBC. I was also able to import the tables into datastage through the same ODBC connection.....but when i try to view data from datastage it is giving

"missing server name, can't connect"

Can u please tell me the reason?

Thanks,
kiran.

Krazykoolrohit · Post by **Krazykoolrohit** » Thu Feb 22, 2007 12:40 pm

How exactly are you trying to view data from datastage?

narasimha · Post by **narasimha** » Thu Feb 22, 2007 12:49 pm

Do an exact search on "Missing server name", you will get your solution.

goriparthi · Post by **goriparthi** » Thu Feb 22, 2007 2:56 pm

Check your Paramters if anything is fishy there. If u can view the data from sql plus u shoukd have tns entry, aslo see if u have select permission enabled for ur datastage id on that table

narasimha · Post by **narasimha** » Thu Feb 22, 2007 2:59 pm

Check this post

Edited to add: Add www to the link

DSguru2B · Post by **DSguru2B** » Thu Feb 22, 2007 3:01 pm

narasimha, add www in your sited post, otherwise it takes you to the login page.

narasimha · Post by **narasimha** » Thu Feb 22, 2007 4:52 pm

Something that I got to know today -

Every know that we can log on to DSXchange either by using

http://dsxchange.com/
(or)
http://www.dsxchange.com/

If you log in with the second address, you can directly copy the web address and post as the Url link.
But if you have logged in using the first address you will need to put in the the www. before dsxchange.com while giving reference to the URL links.

HTH.

chulett · Post by **chulett** » Thu Feb 22, 2007 5:03 pm

narasimha wrote:If you log in with the second address, you can directly copy the web address and post as the Url link.
But if you have logged in using the first address you will need to put in the the www. before dsxchange.com while giving reference to the URL links.

We've had this conversation before, but it's all about the domains matching - not second address versus first address, per se. URLs posted without the 'www.' will work fine for people that log onto the domain without the 'www.', but not for people that include it. And vice versa.

Since the vast majority of peoples connect to 'www.dsxchange.com' it's best to post links using that domain. So, simple answer is to log on to 'www.dsxchange.com' just like everyone else.

narasimha · Post by **narasimha** » Thu Feb 22, 2007 5:11 pm

I had missed that conversation, thanks for the clarification.