How do I get ASEOLEDB provider and register it on my Windows 7 machine?

[Former Member]

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

[reimer_pods]

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

[jeff_albion]

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

[Former Member]

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

[jeff_albion]

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.

[VolkerBarth]

@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...