Page 1 of 1
error viewing oracle stage
Posted: Thu Feb 22, 2007 10:59 am
by kirankota79
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.
Posted: Thu Feb 22, 2007 12:40 pm
by Krazykoolrohit
How exactly are you trying to view data from datastage?
Posted: Thu Feb 22, 2007 12:49 pm
by narasimha
Do an exact search on "Missing server name", you will get your solution.
Posted: Thu Feb 22, 2007 2:56 pm
by goriparthi
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
Posted: Thu Feb 22, 2007 2:59 pm
by narasimha
Check this
post
Edited to add: Add www to the link
Posted: Thu Feb 22, 2007 3:01 pm
by DSguru2B
narasimha, add www in your sited post, otherwise it takes you to the login page.
Posted: Thu Feb 22, 2007 4:52 pm
by narasimha
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.
Posted: Thu Feb 22, 2007 5:03 pm
by chulett
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.
Posted: Thu Feb 22, 2007 5:11 pm
by narasimha
I had missed that conversation, thanks for the clarification.