遵循以下操作方法:
https://docs.snowflake.net/manuals/user-guide/odbc-linux.html#step-2-install-the-odbc-driver 和 https://docs.snowflake.net/manuals/user-guide/odbc-linux.html#step-3-configure-the-environment-tgz-only
我正在使用unixODBC,并已完成列出的安装和配置,但在步骤5中,出现错误:
$ isql -v snowflake_dev my_username my_password
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
我的调试/配置/连接信息如下:
$ which odbcinst
/usr/bin/odbcinst
$ which isql
/usr/bin/isql
$ odbcinst -j
unixODBC 2.3.4
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/vagrant/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
我运行了unixodbc_setup.sh脚本来初始化。 simba.snowflake.ini看起来像这样:
ANSIENCODING=UTF-8
DriverManagerEncoding=UTF-16
DriverLocale=en-US
ErrorMessagesPath=/var/snowflake_odbc/ErrorMessages/
LogLevel=0
LogNamespace=
LogPath=/var/snowflake_odbc/log
CURLVerboseMode=false
CABundleFile=/var/snowflake_odbc/lib/cacert.pem
ODBCInstLib=libodbcinst.so
ODBCINST.ini看起来像这样:
[ODBC]
Trace=no
TraceFile=
[ODBC Drivers]
SnowflakeDSIIDriver=Installed
[SnowflakeDSIIDriver]
APILevel=1
ConnectFunctions=YYY
Description=Snowflake DSII
Driver=/var/snowflake_odbc/lib/libSnowflake.so
DriverODBCVer=03.52
SQLLevel=1
ODBC.ini 看起来像这样:
[ODBC Data Sources]
snowflake_dev = SnowflakeDSIIDriver
[snowflake_dev]
Driver = /var/snowflake_odbc/lib/libSnowflake.so
Description = Snowflake Dev
server = My_Server
role = My_Role
database = My_Database
任何帮助将不胜感激。
我正在编辑/var/snowflake_odbc/conf 中的 odbc.ini 和 odbcinst.ini 文件,应该一直在编辑/etc 中的文件。