|
Home > Archive > SQL Anywhere database > June 2005 > IP address of the server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
IP address of the server
|
|
| Igor Vodov 2005-06-15, 8:24 pm |
| Is it possible to use the IP address of the server machine in the parameter
string that
we pass to db_string_connect?
Right now our parameter string looks like this:
"UID=...;pwd=...;DBF=.....;ENG=......;CommLinks=all"
This cannot find the server which was already started.
However, if I use LINKS=TCPIP(HOST=123
.123.123.123) in the parameter list to
dbisql.exe, the server can be found.
I wanted to do something similar in the Parameter string to
db_string_connect.
Thanks,
Igor
| |
| Graeme Perrow 2005-06-15, 8:24 pm |
| Igor Vodov wrote:
> Is it possible to use the IP address of the server machine in the parameter
> string that
> we pass to db_string_connect?
> Right now our parameter string looks like this:
> "UID=...;pwd=...;DBF=.....;ENG=......;CommLinks=all"
>
> This cannot find the server which was already started.
>
> However, if I use LINKS=TCPIP(HOST=123
.123.123.123) in the parameter list to
> dbisql.exe, the server can be found.
> I wanted to do something similar in the Parameter string to
> db_string_connect.
You've answered your own question. Replace "CommLinks=all" with
" Links=TCPIP(Host=123
.123.123.123}" in the string you pass to
db_string_connect.
--
Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
iAnywhere Solutions Inc.
A Sybase company
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/
| |
| Greg Fenton 2005-06-16, 3:24 am |
| Graeme Perrow wrote:
>
> You've answered your own question. Replace "CommLinks=all" with
> " Links=TCPIP(Host=123
.123.123.123}" in the string you pass to
> db_string_connect.
Just to be clear, "CommLinks" and "Links" are synonyms. In the ASA 9.x
online docs, see:
ASA Database Administration Guide
Connection Parameters and Network Protocol Options
Connection parameters
- CommLinks connection parameter [LINKS]
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Ian McHardy 2005-06-17, 9:23 am |
| Note if you want to connect over either sharedmemory or TCP/IP (which is
what commlinks=all basically does, except it also tries SPX), you can use
Links=shmem,TCPIP(Ho
st=123.123.123.123} in your connection string.
--
Ian McHardy (iAnywhere Solutions)
Please reply only to the newsgroup.
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"Graeme Perrow" < gperrowNO@SPAMianywh
ere.PLEASEcom> wrote in message
news:42b085cf$1@foru
ms-1-dub...
> Igor Vodov wrote:
>
> You've answered your own question. Replace "CommLinks=all" with
> " Links=TCPIP(Host=123
.123.123.123}" in the string you pass to
> db_string_connect.
>
>
> --
> Graeme Perrow
> Senior Software Developer
> gperrow _at_ ianywhere _dot_ com
> iAnywhere Solutions Inc.
> A Sybase company
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer/
|
|
|
|
|