[sr-dev] [kamailio/kamailio] DB_UNIXODBC always changes language and context (#1993)

[Ben Kaufman]

**tl;dr:**  This is a minor bug report for Kamailio, and regarding access to SQL Azure, I'd be happy to finance an Azure SQL database for testing if desired.

<hr />

The issue is about _assumed_ behavior within the DB_UNIXODBC module.

The behavior in Azure SQL that is atypical, because trying to issue a ```USE``` query gives the following error:

```
USE statement is not supported to switch between databases. Use a new connection to connect to a different database.
```

I think @nakchak may be using an Azure SQL Server (managed instance) vs an Azure SQL Database (single database).  Here's my attempt and error trying to assign a default DB to a login in my Azure database:

Query:
```
Alter login kamailioRoTest  with default_database = ops-qa-sqldir1
```
Error:
```
Keyword or statement option 'default_database' is not supported in this version of SQL Server.
```


>From a purely functional standpoint (i.e. to get Kamailio **working** with the Azure DB), the solution is to specify the database in the connection string (see the ODBC.ini example in my original post).  The request is to have an option to just have the module use the default DB from the connection and not attempt to change to the DB once connected.  

Think of it like the following if using MySQL:

```
bash > mysql -D kamailio
mysql > USE kamailoio;
```

The second line is superfluous (but not problematic).  


For DB_UNIXODBC, setting the DB in the ODBC string WORKS currently.  It just clutters the log with errors. Thus, the bug report is not critical.





-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/1993#issuecomment-508170051
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-dev/attachments/20190703/4d276189/attachment.html>