I have setup the DSN but when I try and connect through Excel I get the following message "Drivers SQLSetConnectAttr has failed".
Has this happenned to anyone before? I have setup a Sytem DSN. I think there might be a hotfix for this but there is nothing in the download section.
I'm using SP1.
It connects ok using the database which comes with the software but I'm trying to connect to another database now.