I need this to use PowerPivot to get data from SQL Anywhere server?

asked 11 Feb '15, 21:23

mysorian's gravatar image

mysorian
1187913
accept rate: 0%

2

Are you sure you really want the ASEOLEDB provider? It's used to connect with SAP Adaptive Server Enterprise (ASE) databases. For SQL Anywhere you'd need the OLEDB-Driver that comes with the SQLA client/personal/server installation package. See http://scn.sap.com/docs/DOC-35857

(12 Feb '15, 06:31) Reimer Pods

Assuming you are connecting to SQL Anywhere and do want to just register the SQL Anywhere OLE DB driver (SAOLEDB), you can do this by using:

regsvr32 dboledb16.dll
regsvr32 dboledba16.dll

You can obtain a copy of the SQL Anywhere 16 OLEDB provider at the link Reimer provided: http://scn.sap.com/docs/DOC-35857

permanent link

answered 17 Feb '15, 11:34

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

edited 17 Feb '15, 11:35

Actually if install the free version of SQL Anywhere 16 the SAOLEDB is also installed. Are SAOLEDB and ASEOLEDB the same? I did not think they are

(19 Feb '15, 15:17) mysorian
Replies hidden

free version of SQL Anywhere 16 the SAOLEDB is also installed.

Yes, the SQL Anywhere Developer Edition also contains a copy of the OLE DB provider.

Are SAOLEDB and ASEOLEDB the same?

They are not the same and they are not interchangeable. SAOLEDB is used to connect to SQL Anywhere only, ASEOLEDB to Adaptive Server Enterprise (ASE) only. My answer above is assuming you are really trying to use SAOLEDB to connect to SQL Anywhere.

(19 Feb '15, 16:35) Jeff Albion

@mysorian: If you really relate to the OLEDB driver for SAP Sybase ASE (ASEOLEDB), I guess there are better places to ask than this this forum - see the FAQ...

(20 Feb '15, 03:50) Volker Barth
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:

×13

question asked: 11 Feb '15, 21:23

question was seen: 4,805 times

last updated: 20 Feb '15, 03:50