Sqlserver=SAS Institute, Inc 7.1.5 SQL Server Wire Protocol I have set things up so that I can use either reference DSNs in an odbc.ini file or do DSN-less connections. I have set up a test environment on a Linux server here and the following shows how I got this to work.
When doing DSN-less connections with Progress/Data Direct ODBC client components (we bundle these in with SAS ACCESS TO MS SQL Server), you do not have to have an odbc.ini file with DSN entries for SQL Server data bases but you must create an entry in an odbcinst.ini and you must set the ODBCINST environment to point to this odbcinst.ini file. Whereas you can do DSN-less connections when using a unixODBC driver manager and not reference any INI files at all, Progress/Data Direct requires that you at least reference an odbcinst.ini file entry. I think what may throw some folks off is that Progress/Data Direct does DSN-less connections a bit differently than when using a unixODBC driver manager. In case you all were not able to get DSN-less connections working and need additional clarification, I have included a section from an email which I recently sent to a customer.
0 kommentar(er)
