search

uepg / laravel-sybase

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

SQLSTATE[HY000]: [Microsoft][ODBC Driver 13 for SQL Server]Protocol error in TDS stream #33

Closed webspeaks closed 6 years ago

webspeaks commented 7 years ago

Hi, When I use this connector to connect with sybase db (SAP ASE) I get the following error:

SQLSTATE[HY000]: [Microsoft][ODBC Driver 13 for SQL Server]Protocol error in TDS stream

I have installed all required drivers and extensions in my PHP installation.

OS - Windows 10 Platform- Wampp 64 Bit PHP - 7.0

Please let me know if you have any idea about this error.

Thanks

mainginski commented 7 years ago

At the moment, it is necessary for the package to run in the Linux environment, since it natively uses the dblib connection to the sqlserver. In that case, you can use the Vagrant machine (I as a developer on Windows, I do this). Nothing prevents you from developing using Windows, but you need to create the interface for ODBC, I mentioned something like that in the issue #32, but I did not test it.

ArielPremiumSupply commented 6 years ago

I get the same issue regardless of whether I am on Windows or Linux. On Linux the error is: SQLSTATE[HY000]: [unixODBC][Microsoft][ODBC Driver 13 for SQL Server]Protocol error in TDS stream (SQL: SELECT ...) I am trying to connect using Laravel as my secondary DB

nunomazer commented 6 years ago

Hi, have you tryied use the dblib driver instead ODBC? Install php-sybase and freetds-bin packages, and config it as described at https://github.com/uepg/laravel-sybase#configuration-of-freetds-driver

Since we don't use ODBC connections, we still didn't test it in any O.S., Windows or Linux.

vkrtecek commented 6 years ago

Check if you have specified right port number. I had 3306 instead of 1433