Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connection error for Sybase

Author  Topic 

chirag.patel2121
Starting Member

2 Posts

Posted - 2012-11-21 : 18:43:38

Hi,

I got this error:
----------------------------------
CTLIB Message: - L6/O8/S5/N3/5/0:
ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
Establishing connection failed.
------------------------------------
I have one Sybase database installed at diff place and SQL server 2005 locally. I have one SQL.Ini file which have sybase database entry inside.I don't know how to set the path? What exact name of path itself 'path' or 'sybase' in my computer->advanced->enviroment variable.

I have credential for sybase database not for server and also using windows authentication for SQL server 2005.

I don't i have to run bcp command my local pc command prompt or from where sybase database stored?

I using the following command to create output file(.dat),later i use this file for input to SQL as import.

From my local pc's command prompt :
bcp [database_s6.maxima.com.llinv002].dbo.domstats out C:\data\file1.dat -n -t

every time it's asking for password, i don't to give. What to do?

Please any help?

Thanks,

Chirag Patel
   

- Advertisement -