I am getting problem in connecting vertica database with php using pdo it's throwing me error
[unixODBC][Driver Manager]Data source name not found, and no default driver specified' SQLSTATE SQLSTATE[IM002]
My connection string is as follows :-
$conn = new PDO('odbc:DRIVER={SOURCENAME};Server=localhost;Database=dashboard', "yogesh", "");
The same dsn works with isql utility but not with pdo .
Most probably it is looking for the ini files in the wrong place, do an strace on the php file, and see if it tries to access the ini files from the correct path
Have you tried changing
DRIVER={SOURCENAME};
to
Driver=Vertica
?