The special "DRIVER=SQL Anywhere Native" syntax is briefly described in the CREATE SERVER Help topic.

What are the advantages to using this syntax? Performance?

Is it OK to use it for a SQL Anywhere 16 database that is creating remote server connections to earlier versions of SQL Anywhere? E.g. V16 connecting to V12, to V11, to V10, to ... ?

How far back is OK?

asked 14 Dec '14, 15:43

Breck%20Carter's gravatar image

Breck Carter
26.9k437609883
accept rate: 21%


It also has a mention in the SQL Anywhere New Features article as well.

This feature permits you to use our driver even when the driver is not registered. It loads the driver version that matches the database server version. It is not required to have DSN-less connections {since ODBC Driver Managers normally can facilitate that with the ServerName='Driver=...' usage}.

Some performance differences come about by not doing the DRIVER and DSN lookups during the connection phase. Further each ODBC SQL*() function call has a little less overhead since it is not passing through the Platform/3rd party(on Unix/Linux) driver manager.

It will also get some advantages of loading the Driver version matched to the server version. And, with that, backward compatibility with other (older) server versions should carry the day their as well; something we've usually done quite well if I may say so. So that part is okay too.

I won't use the "varying mileage" parable to describe the degree of benefit but I do suspect performance differences to only be modest in most instances.

I'm sure you will let us know if you discover any significant difference or instabilities but I suspect this to be mostly transparent.

The main caveat here is that an ODBC Driver Manager will used under the documented restrictions so the above will not apply in that case.

HTH

permanent link

answered 15 Dec '14, 11:12

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 31%

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:

×47

question asked: 14 Dec '14, 15:43

question was seen: 4,223 times

last updated: 15 Dec '14, 11:12