I need to include ' inside a string literal in isql. for example, CREATE SERVER remote_db2 CLASS 'saodbc' USING 'DRIVER=SQL Anywhere 11;DBN=remote_db2;INT=Yes;dbfile=d:\db2;dbkey=whateverwith ending in single quote'

I know I can use '' in other string literal but ''' in above

confuses isql in the use with dbkey.

asked 23 Apr '15, 11:52

gg99's gravatar image

gg99
193192129
accept rate: 0%

Possibly Nick's answer may be of help:

Trouble connecting to dbisql with special characters

(FWIW, I won't comment on the secrecy of a DBKEY in a USING clause... - so you need to autostart the second database from the current one?)

(23 Apr '15, 12:05) Volker Barth

thx no I don't have to start the 2nd database but some reason(probably my mistake somewhere along) I failed to connect to started db w/o the dbkey.

(26 Apr '15, 01:57) gg99

Use ''
e.g. Using 'Driver...dbkey=''whatever'''

permanent link

answered 24 Apr '15, 10:32

Martin's gravatar image

Martin
8.6k114149237
accept rate: 14%

edited 24 Apr '15, 10:34

Your answer
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:

×28
×20

question asked: 23 Apr '15, 11:52

question was seen: 658 times

last updated: 26 Apr '15, 01:57