Skip to Content
avatar image
Former Member

BCP Utility - bypass lookup in interfaces file

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 27, 2015 at 09:19 AM

    Hi Naveen,

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

    described here:SyBooks Online

    regards,

    Harry

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2015 at 03:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 06:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded