on 01-29-2016 9:30 AM
Thanks to the help here I have successfully installed the database driver and can now perform connections.
Sadly I'm not quite getting my syntax right on the connection so I need a little bit of help...
Our server is publicly addressable (but firewall etc) and requires us to use port 2640
Initially I tried:
sasql_connect("Dbn=TestData;UID=myuser;PWD=SuperSecretPa55word;ServerName=remotehost.mycustomer.co.uk:264");
but I get the following error:
sasql_connect(): SQLAnywhere: [-100] Database server not found
I have the following connection string which I have found by searching on here and stackoverflow
sasql_connect("Dbn=TestData;Uid=myuser;Pwd=SuperSecretPa55word;CommLinks=tcpip(host=remotehost.mycustomer.co.uk:2640)");
But now it gives me the following error:
sasql_connect(): SQLAnywhere: [-832] Connection error: Error in TCPIP port options
Any help gratefully received!
Hi Alun,
The connection string requires the port as a separate parameter:
sasql_connect("Dbn=TestData;Uid=myuser;Pwd=SuperSecretPa55word;CommLinks=tcpip(host=remotehost.mycustomer.co.uk;port=2640)");
Thanks,
Mikel
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 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.