on 10-27-2015 9:09 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naveen,
not that i know of. You could use the -I interfacesfile option.
described here:SyBooks Online
regards,
Harry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.