cancel
Showing results for 
Search instead for 
Did you mean: 

BCP Utility - bypass lookup in interfaces file

0 Kudos

Hi ASE community,

For BCP utility, I am trying to connect with physical host and port # (in -S option).

But it is failing with error "Requested server name not found" (means it is going through interfaces file)

Whereas isql utility is able to connect with host and port# (and not going through interfaces file)

isql -STEST_ASE_HOST:1234

Is there any option to do the same with BCP utility?

Thanks,

Naveen Yakkala.

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member188958
Active Contributor
0 Kudos

The BCP utility does not currently support the new "host:port" convention, not even in the latest 16.0 release.   You might open a support incident to have a feature enhancement CR opened.

-bret

former_member89972
Active Contributor
0 Kudos

Are you facing restrictions in updating central interface file ?

Or is there a clash of server names ?

If you want to use your own server name  then only way out is

- create your own interface/ini file with a logical server name with correct host and port number.

- then use -I option for bcp to specify your own version of interface/ini file

- you can also use this interfaces/ini file for isql -I option

HTH

Avinash

Former Member
0 Kudos

Hi Naveen,

not that i know of. You could use the -I interfacesfile option.

described here:SyBooks Online

regards,

Harry