Had a look at the info but it is mainly tailored to SQL Server 2005 and remote servers, which SQL Server 2005 only support as a backward compatibility.
As you mentioned it does indeed appear to be something to do with rights on the actual Windows Server regarding access to the system DSN.
If...
Not 100% sure, I must apologise I am a bit of a newcomer when it comes to SQL full stop. Only had very limited exposure to SQL2000 and 2005.
As I mentioned in the post the issue appears to be when using a Windows authenticated account rather than a SQL account.
We need to access an Informix database residing on a SCO Unix server.
We were provided with a 32bit ODBC driver (part of the Esker Tun Plus Suite) by the people who look after our Informix and Sco Unix. We were advised to use this particular ODBC driver as the official IBM Informix ODBC driver...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.