laravel on opensuse connecting to microsoft SQL server

posted 10 years ago

Hi.. I am getting very confused at present at what is need to connect a linux laravel to a microsoft sql server...

I have read lot on inet about "freetds", "PDO" etc... (lots out there but all diferent versions of os etc...) and i cannot seem to find a working example

freetds installed ok and connects fine but i cannot see what is needed to set in config/database.php

if i use 'driver' => 'mssql', i get "Unsupported driver [mssql]" so i asume mssql is a windows driver.. if i use 'driver' => 'sqlsrv', i get "PDOException could not find driver" so i assume PDO is missing something.. is this coorect...

Last updated 2 years ago.

fluzo

replied 10 years ago

see if php5-pdo is installed

'default' => 'sqlsrv',

and

		'sqlsrv' => array(
			'driver'   => 'sqlsrv',
			'host'     => 'localhost',
			'database' => 'database',
			'username' => 'root',
			'password' => '',
			'prefix'   => '',
		),

Last updated 2 years ago.

absentdream

replied 10 years ago

yep php5-pdo installed...

zypper se PDO

Loading repository data... Reading installed packages...

and database config

'hr' => array( 'driver' => 'sqlsrv', 'host' => 'XXX.XXX.XXX.XXX', 'database' => '', 'username' => '', 'password' => '********', 'prefix' => '', ),

but page shows...

PDOException could not find driver

trying a brand new server at moment

Last updated 2 years ago.

absentdream

replied 10 years ago

update i can confirm freeTDS is working using tsql and also unixOBDC using isql ...

Last updated 2 years ago.

absentdream

replied 10 years ago

Solution

ok i win at last using laravel 4.1 and https://github.com/ccovey/odbc-driver... but now have issue with 3rd party db using spaces in field names aaaarrrrggghhh....

close this

Last updated 2 years ago.

Moderators