DSXchange

Posted: **Thu Mar 10, 2005 4:29 pm**

We cannot get ODBC to connect to SQL Server on a cluster from UNIX. The server name is something like SqlServer1\SqlServer1 in the DSN for Windows. It works fine. You cannot use this in UNIX. I think that name represents ClusterName\ServerName. Not sure. We have a support ticket open. Just wondering if anyone has solved this issue.

We have had similar issues in the past with SQL Server. The UNIX drivers are always behind the DOS ones. When SQL Server went to mutiple instances on one server then we could not connect from UNIX. This works now. Back then we had to create a database link from a SQL Server box which we could connect to and have it point to the SQL Server 7 box.

We could do this here but the customer would prefer not to. If you have the .odbc.ini setup please post it.

Posted: **Wed Mar 16, 2005 7:44 am**

Hi,
In case you don't even have the SQLServer Entry as I had it once,
from solaris 2.8 DS 7.5:

Code: Select all

[SQLServer]
Driver=/soft/DataStage/Ascential/DataStage/branded_odbc/lib/VMmsss19.so
Description=DataDirect SQL Server Wire Protocol
Database=db
LogonID=uid
Password=pwd
Address=sqlserverhost,1433
QuotedId=No
AnsiNPW=No

IHTH,

Posted: **Wed Mar 16, 2005 9:16 am**

Roy

Thanks but we have it working to ordinary SQL Server. It is the cluster which is the problem.

DSXchange

ODBC from UNIX to SQL Server on a cluster

ODBC from UNIX to SQL Server on a cluster