How to set schema in odbc.ini

[QuincyGao]

Hello, I want to specify a schema, how can I do this? I add "Schema = sbc" into "odbc.ini", But nothing happened.

odbc version

[root@sbc etc]# odbcinst -j 
unixODBC 2.3.12
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

cat odbc.ini 
[DM8]
Description = ODBC DRIVER FOR DM8
Driver = DM8 ODBC DRIVER
SERVER = 172.16.7.131 
DATABASE = sbc
UID = opensips
PWD = opensipsrw
TCP_PORT = 5230

[lurcher]

On 08/11/2024 02:20, gao114882 wrote: Hello, I want to specify a schema, how can I do this? I add "Schema = sbc" into "odbc.ini", But nothing happened. odbc version ***@***.*** etc]# odbcinst -j unixODBC 2.3.12 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /root/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8 | |cat odbc.ini [DM8] Description = ODBC DRIVER FOR DM8 Driver = DM8 ODBC DRIVER SERVER = 172.16.7.131 DATABASE = sbc UID = opensips PWD = opensipsrw TCP_PORT = 5230 | — Reply to this email directly, view it on GitHub <#200>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABYK62MU5XHXZ7IZZKT4Y4DZ7QNVXAVCNFSM6AAAAABRMQISDSVHI2DSMVQWIX3LMV43ASLTON2WKOZSGY2DENRUGMZDKOA>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

That's entirely down to the driver. Not the driver manager.