How to use SA database as a data source in Excel 2010

I would like to use a SA 11.0.1 database as a datasource for Excel 2010 or InfoPath 2010 When I use the data connection wizard of Excel or InfoPath I can choose the Sybase ODBC DSN, connection test succeeds but after that a message appears reading:

The Data Connection Wizard cannot obtain a list of databases from the specificed data source

Any recommendations?

msoffice excel sa-11

asked 18 Aug '10, 10:26

Martin
9.0k●130●169●257
accept rate: 14%

edited 15 Mar '13, 19:05

Mark Culp
24.9k●10●141●297

I've had this issue with InfoPath 2007, as it doesn't seem to like anything except SQL Server based sources. This is with SA 10.0.1, however, and I haven't tried Excel.

(19 Aug '10, 00:34) Calvin Allen

After a quick web search it seems, that for people using mySQL it is possible to do it that way

(19 Aug '10, 07:47) Martin

flat view

2 Answers:

active answers oldest answers newest answers popular answers

Just a thought, but the issue may simply be due to the fact that SA does not support catalogs and Excel/InfoPath does not know what to do with a data source that returns errors for catalog metadata. No guarantees, but you might consider setting the "Prevent driver not capable errors" check box in your SA DSN and see if that gets you further.

permanent link

answered 27 Aug '10, 13:41

Karim Khamis
5.7k●5●38●70
accept rate: 40%

I have tried this without success. Anyway your explanation, that SA soes not support catalogs seems to be the reason.

(08 Sep '10, 07:18) Martin

flat view

1	A workaround is using Microsoft Query instead of direct ODBC connection. But this works only with Excel not with InfoPath (this seems to be a limitation by design of Microsoft) permanent link answered 19 Aug '10, 07:49 Martin 9.0k●130●169●257 accept rate: 14% 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:

sa-11 ×143
excel ×14
msoffice ×2

question asked: 18 Aug '10, 10:26

question was seen: 4,483 times

last updated: 15 Mar '13, 19:05

SAP SQL Anywhere

How to use SA database as a data source in Excel 2010

Follow this question

Related questions