freeTDS: OK, unixODBC: OK, DBD:ODBC: 95% OK !
Perl_to_SQL_Server <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi all, Thanks for your help. All freeTDS, unixODBC, DBD:ODBC now works. DBD:ODBC works perfect when executing the Perl script as the same user than the unixODBC 'user dsn' /opt/gnu/.odbc.ini was created with, by this command: odbcinst -i -s -f tds.datasource.template But it doesn't work when calling the same Perl script from a Web page, as 'Web' user on the Apache server where the script is. So I'm back in the unixODBC's documentation http://www.unixodbc.org/doc/FreeTDS.html that says: "Note; we have executed previous commands as root (denoted by leading '#' character on given commands) but here we execute the command as a regular user. This is significant. All users of the system share FreeTDS and the ODBC Drivers but each user has his/her own list of DSN's (view odbcinst output for help on registering as a system DSN available to all users). So create the DSN as the user who is going to be using it." and so I'm now adding this '-l' parameter to mean a 'system dsn' that all users can see, at least it's what I'd like to see happening ;) odbcinst -i -s -l -f tds.datasource.template but that doesn't seem to make the dsn available to all users. Or perhaps I shall recompile DBD:ODBC after this?