OLE DB connection string in SharePoint for Sybase ASA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Beth (Beth_at_discussions.microsoft.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 06:53:02 -0800

I'm trying to use an "OLE DB custom connection string" as required in
SharePoint to connect to my Sybase Adaptive Server Anywhere database. I have
tried EVERY syntax possible, and depending on which syntax I use, I get
different errors. According to http://www.connectionstrings.com, the syntax
for OLE DB should be a simple:

Provider=ASAProv;Data Source=amaasa1

As I understand it, the Data Source is the server name, and NOT an ODBC dsn.
 I ddo have system dsn's set up on both machines. I've tried adding all the
other possible parameters such as uid, pwd, etc. etc. I even set up a MS udl
and let it "build" a string from that, and tried that, but it didn't work
either. Sybase has a dbping utility that I can ping that ASA server from the
SharePoint box, of course, that doesn't use OLE DB (or any provider). I have
checked the settings and added the required info for the Proxy Server and
configured the data retrieval services. All to no avail. Does anyone have
ANY suggestions on how to use a custom OLE DB connection string to connect to
a database in SharePoint? This was SO EASY via ODBC in regular FP. HEP! :)
 Thanks!

Quantcast