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.3k430600866
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: 699 times

last updated: 13 Feb '12, 03:55