I can add an ODBC connection to my access db (C:\SW.mdb) on the share point server. The problem is, no data is returned. I keep getting an unspecified error.
I am running the query against linked tables to a Firebird database. There are no usernames or passwords set on the MDB.
Does ODBC/SharePoint support queries against these linked tables or do I need to search elsewhere?
By the way, I am doing this in SharePoint Designer 2007 and running WSS 3.0.
Also, this is my first question on here so, what would be the appropriate amount of points for a question like this?