January 19, 2002 at 1:26 pm
Hi,
I am rying to set up a linked server with sybase. I created a system DSN on sql server machine with Intersolv 3.01 OEM Sybase driver. In EM i gave the DSN as Datasource and Provider string as
DRIVER={Intersolv 3.01 OEM Sybase};SERVER=Servername;UID=Usrnam;PWD=Pass
In catalog I gave databse name.
But when I click on tables under the linked server name the process hangs without any error message. I can't even kill the process.
What are the other things I need to check?
Do I need Sybase client components installed on the SQl server? THe sybase runs on Unix box.Do i need my sql server service to run on domain account? I greatly appreciae any help. I am really struck here.
thanks in advance
Mohan
January 19, 2002 at 8:50 pm
I have no experience with Sybase - perhaps other readers do? Steve will be back next week, he might have some ideas too. In the interim I'd suggest double checking connectivity at the network level and verifying that you're connecting with a userid/password that has access permissions on the remote server.
Andy
January 20, 2002 at 3:34 pm
Thanks a lot Andy! I did check the connectivity.I will wait for Steve or any response from others.
I appreciate your response.
January 21, 2002 at 6:14 am
You might also check the Sybase site, also the newsgroups at groups.google.com (my favorite for research).
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply