Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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
accept rate: 20%

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

Well, SQL Anywhere seems to treat the CON value with semicolon not consistent, as the following screenshot for DBSQL 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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 12 Feb '12, 16:07

question was seen: 1,798 times

last updated: 13 Feb '12, 03:55