search

lurcher / unixODBC

The unixODBC Project goals are to develop and promote unixODBC to be the definitive standard for ODBC on non MS Windows platforms.
GNU Lesser General Public License v2.1
102 stars 52 forks source link

How to set schema in odbc.ini #200

Open gao114882 opened 2 weeks ago

gao114882 commented 2 weeks ago

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 commented 2 weeks ago

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 https://github.com/lurcher/unixODBC/issues/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.