SQL Anywhere database - OLEDB

Author

OLEDB - Frontpage 2003

Brian Greiman

2005-10-27, 7:41 am

We are using ASA v9.01.2052 on WinXP.

We are attempting to access Sharepoint Services using Frontpage 2003. To do
this we are trying to use OLEDB provider for ASA.
In Frontpage 2003, we are attempint to add a dataview webpart. We Click on
the Database Connections, add to catalog, configure database connection,

use custom connection string.

This is the connection string:

" Provider=ASAProv;Dat
a Source=Central
Database;DatabaseNam
e=Central01;UID=xxxx
x;pwd=xxxxx"

We then get a Frontpage Error:

Server Error: An error occurred while retrieving a list of Databases from
Central Database: The server for the data source returned a non-specific
error when trying to execute your query. check the format and content of
your query and try again. If the problem persists, contact the server
administrator.

Can anyone give us some hints as to what we are doing wrong here? Is ASA
OLEDB supported for Frontpage 2003?

We were doing some research and a possible workaround might be using
Microsoft OLE DB Provider for ODBC (MSDASQL)?

Any suggestions or help would be greatly appreciated!!!

Thanks,

Brian

Greg Fenton

2005-10-27, 7:41 am

Brian Greiman wrote:
>
> " Provider=ASAProv;Dat
a Source=Central
> Database;DatabaseNam
e=Central01;UID=xxxx
x;pwd=xxxxx"
>
> We then get a Frontpage Error:
>
> Server Error: An error occurred while retrieving a list of Databases from
> Central Database: The server for the data source returned a non-specific
> error when trying to execute your query.

I don't know too much about OLEDB nor FrontPage, but from the above I
gather that service is attempting to connect to the "server" and get a
list of "databases" running on it. This is an ASE concept (MSSQL sorta
works this way too ;-) ), with ASA you connect directly to a database,
not to a "server".

So you need to find a way to convince FP (or Share Point services) that
the connection string you are providing connects directly to a database.

Hopefully someone else has experience with ASA and this technologies?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links