[unixODBC][Driver Manager]Data source name not found.
Posted: Fri Oct 04, 2013 1:25 pm
Hi,
I'm unable to connect vertica through php.I'm getting below error
php > $conn = odbc_connect('odbc:DRIVER={verticaDSN};Server=192.168.85.129;Database=dbadmin',"dbadmin", "password");
PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in php shell code on line 1
php > $conn = odbc_connect('odbc:DRIVER={VerticaDSN};Server=192.168.85.129;Database=dbadmin',"dbadmin", "password");
PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in php shell code on line 1
my odbc.ini file
cat /usr/local/etc/odbc.ini
[VerticaDSN]
Description = VerticaDSN ODBC driver
Driver = /opt/vertica/lib64/libverticaodbc.so.6.1.2
Database = dbadmin
Servername = 192.168.85.129
UserName = dbadmin
Password = password
Port = 5433
#ConnSettings =
SSLKeyFile = /home/dbadmin/client.key
SSLCertFile = /home/dbadmin/client.crt
Locale = en_US
And
cat /usr/local/etc/odbcinst.ini
[VerticaDSN]
Description = ClickStream example database
Driver = /opt/vertica/lib/libverticaodbc.so.6.1.2
[ODBC]
Threading = 1
cat /etc/vertica.ini
[Driver]
Locale = en_US
DriverManagerEncoding=UTF-16
ODBCInstLib=/usr/lib64/libodbcinst.so
ErrorMessagesPath=/opt/vertica/lib64
LogLevel=4
LogPath=/tmp
Please help me
Thanks
I'm unable to connect vertica through php.I'm getting below error
php > $conn = odbc_connect('odbc:DRIVER={verticaDSN};Server=192.168.85.129;Database=dbadmin',"dbadmin", "password");
PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in php shell code on line 1
php > $conn = odbc_connect('odbc:DRIVER={VerticaDSN};Server=192.168.85.129;Database=dbadmin',"dbadmin", "password");
PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in php shell code on line 1
my odbc.ini file
cat /usr/local/etc/odbc.ini
[VerticaDSN]
Description = VerticaDSN ODBC driver
Driver = /opt/vertica/lib64/libverticaodbc.so.6.1.2
Database = dbadmin
Servername = 192.168.85.129
UserName = dbadmin
Password = password
Port = 5433
#ConnSettings =
SSLKeyFile = /home/dbadmin/client.key
SSLCertFile = /home/dbadmin/client.crt
Locale = en_US
And
cat /usr/local/etc/odbcinst.ini
[VerticaDSN]
Description = ClickStream example database
Driver = /opt/vertica/lib/libverticaodbc.so.6.1.2
[ODBC]
Threading = 1
cat /etc/vertica.ini
[Driver]
Locale = en_US
DriverManagerEncoding=UTF-16
ODBCInstLib=/usr/lib64/libodbcinst.so
ErrorMessagesPath=/opt/vertica/lib64
LogLevel=4
LogPath=/tmp
Please help me
Thanks