Where can I find a SQLanywhere 8 Native Driver

I am currently using an ODBC data source to connect to SQLanywhere 8 database. I have Googled trying to find a Native driver however, I cannot seem to find one. Any suggestions?

asa-8

asked 06 Nov '13, 10:43

drduquette
16●2●2●4
accept rate: 33%

Hi Jeff, I thought by using a Native driver I will get improved performance over ODBC. The is the reason for my Post.

Don

(06 Nov '13, 11:58) drduquette

Replies hidden

Our ODBC driver already directly communicates to the database server over our native database server protocol.

When looking at database performance issues, you should start with the database server itself, and work outwards towards your clients.

Have you looked at how busy the database server is in terms of CPU, I/O, and memory in returning these queries? If the database server cannot quickly generate the query responses locally, your clients will not be able to do any better.

Have you tried looking at the testing utilities Samples\PerformanceFetch and Samples\PerformanceInsert to see raw select/insert times against your database server locally?

(06 Nov '13, 12:17) Jeff Albion

flat view

One Answer:

active answers oldest answers newest answers popular answers

Which API are you using with your application? If you're using ODBC and you already have the ODBC driver installed (dbodbc8.dll), that is the correct driver for your scenario - why do you think you need a 'native driver'?

For the latest 8.0.3 version, you were able to use the following APIs:

ADO.NET
ADO / OLE DB
Embedded SQL (C/C++)
JDBC
ODBC

permanent link

answered 06 Nov '13, 11:52

Jeff Albion
10.8k●1●71●175
accept rate: 25%

Thanks Jeff.

(06 Nov '13, 12:25) drduquette

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

asa-8 ×34

question asked: 06 Nov '13, 10:43

question was seen: 1,821 times

last updated: 06 Nov '13, 12:38

SAP SQL Anywhere

Where can I find a SQLanywhere 8 Native Driver

Follow this question

Related questions