The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

The Help topic Using connection parameters and connection strings seems to answer "Yes": a semicolon separates each connection parameter

I need to pick a character to delimit individual entries in a string of connection names used for another purpose.

asked 12 Feb '12, 16:07

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%

Obviously, when masked, they can:

"%SQLANY12%\Bin32\dbisql" -c "DBN=demo;ENG=demo12;UID=DBA ;PWD=sql;CON='MyApp;App'"

creates an DBISQL connection named "MyApp;App". When using APP='MyApp;App' the behaviour is different: the semicolon and the following texts seems to be ignored, as APPINFO just returns "MyApp".


Well, no actual code, but real command lines:)

(12 Feb '12, 17:35) Volker Barth
Replies hidden

Should there be a backslash in the first statement?

(13 Feb '12, 02:40) Martin

Well, there are two backslashes in the path - otherwise, I would not know where to add one?

(I've just noticed that there's a blank behind the DBA - but that doesn't seem to do harm:)

(13 Feb '12, 03:49) Volker Barth
1

Well, SQL Anywhere seems to treat the CON value with semicolon not consistent, as the following screenshot for DBSQL 12.0.1.3554 shows:

alt text

(13 Feb '12, 03:52) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×9

question asked: 12 Feb '12, 16:07

question was seen: 655 times

last updated: 13 Feb '12, 03:55