Hi..
I think that may not be so, because when used in the Linux prompt the isql, the driver unixODBC usually connects and I can generate queries within them. So can not be an error in the driver. This seems to be something with the module unixodbc.so of OpenSER. But I will look for more about it on the Internet today, if not find, return to the trivial MySQL.
Thanks.
-----Mensagem original----- De: Henning Westerholt [mailto:henning.westerholt@1und1.de] Enviada em: quarta-feira, 16 de janeiro de 2008 12:01 Para: users@lists.openser.org Cc: Alcindo Schleder Assunto: Re: [OpenSER-Users] RES: Problems with unixodbc driver
On Wednesday 16 January 2008, Alcindo Schleder wrote:
Hi Henning,
I thought this too ... But I connect with isql normally. See my DSN setup: [FBSipServer] Description = Firebird SipServer Driver = Firebird Dbname = localhost:/usr/local/database/FBSipServer.fdb Client = libfbclient.so User = SYSDBA Password = F60dA58 Role = CharacterSet = WIN1252 ReadOnly = No NoWait = No Dialect = 3 QuotedIdentifier = Yes SensitiveIdentifier = No AutoQuotedIdentifier = No
modparam("acc|usrloc|group|avpops|permissions|domain", "db_url", "unixodbc://SYSDBA:F60dA58@localhost/FBSipServer")
Please increase the debug level in the server config to 9, and try again. The connection string should be logged, perhaps there is something wrong with setup, or the driver?
Does your unixodbc driver links against the 'libfbclient.so' library? Could you check this with the 'ldd' command? Perhaps there is an error in the installation on your system?
I'm not an ODBC expert, but it is ok that the DBname in the DSN setup differs from the name in the openser config?
Cheers,
Henning