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.
ODBC from UNIX to SQL Server on a cluster
Moderators: chulett, rschirm, roy
Hi,
In case you don't even have the SQLServer Entry as I had it once,
from solaris 2.8 DS 7.5:
IHTH,
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=NoIHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org