jcrodriguezt / laravel-sybase

Connection and Laravel Eloquent driver for Sybase
GNU General Public License v2.0
2 stars 1 forks source link

Problem with connection #6

Open dotenvsolutions opened 1 year ago

dotenvsolutions commented 1 year ago

Describe the bug

Can't Connect to sybase 17 using laravel 10 and php 8.2

Hi, i just installed laravel 10x on a windows machine and i'm trying to connect to sysbase 17 but keep getting the following error "SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server."

I have to manually installed php_sqlsrv on my xampp, because by default is not in the php ext folder and you use sql server driver and i tried to define an odbc connection but it does not work either. Please can you help me.

jcrodriguezt commented 1 year ago

Hi, the thing with windows machine is that you will not be able to connect. I recommend using Laravel Homestead (https://laravel.com/docs/10.x/homestead#first-steps), where you can and should install freetds package and like the song says "everything is going to be all right"

Check out this reply: https://github.com/jcrodriguezt/laravel-sybase/issues/5#issuecomment-1685038869

This post is still incomplete, but might shed a light https://dev.to/jcrodsolutions/my-laravel-homestead-setup-4c72?preview=49d71538c7721afe7961d76bf8804b92c3e7fc19f9454f8c4e4a5d94ca9656648747cb082dc9e2495e5f46eee53d21c52dc4320ef8b09fb087580346