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?

asked 18 Aug '10, 10:26

Martin's gravatar image

Martin
8.6k114149237
accept rate: 14%

edited 15 Mar '13, 19:05

Mark%20Culp's gravatar image

Mark Culp
22.7k9129266

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

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%20Khamis's gravatar image

Karim Khamis
5.6k53870
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

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's gravatar image

Martin
8.6k114149237
accept rate: 14%

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:

×137
×13
×2

question asked: 18 Aug '10, 10:26

question was seen: 2,518 times

last updated: 15 Mar '13, 19:05