Connect Laravel with vertica Database

Question

I have problems linking my Project to my database. I want to select stuff from a vertica database into my project. In normal PHP it works, but the same code does not work in Laravel:

# Connect to the Database
$dsn = "VerticaDSN";
$conn = odbc_connect($dsn,'','') or die ("<br/>CONNECTION ERROR");
echo "<p>Connected with DSN: $dsn</p>";

# Get the data from the table and display it
$sql = "SELECT column FROM table";
if($result = errortrap_odbc($conn, $sql))
{
    echo "<pre>";
    while($row = odbc_fetch_array($result) )
    {
        echo "hi";
        print_r($row);
    }
    echo "</pre>";
}

Is there a method that this code works inside my Laravel Controller?

I read them, but there is no support for vertica database, thats my problem — Jonas Goebel, Jan 19 '18 at 13:00
write the code yourself then if it doesn't exist or search the web for it ;-) — ZF007, Jan 19 '18 at 13:06

score 1 · Answer 1 · edited Sep 20 '18 at 20:28

1

What exact error have you? Is your $dns correct? It must look like:

$dsn = 'Driver=Vertica;Servername=xxx;Port=5433;Database=yyy';
odbc_connect($dsn,'usr','pwd');

In my Github repository there are detailed instructions for the use of Vertica in Laravel.

edited Sep 20 '18 at 20:28

Antoine Zimmermann

5,314
18
36

answered Sep 20 '18 at 19:50

Mike Artemiev

28
1
6

Connect Laravel with vertica Database

1 Answers1