Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
webspeaks opened this issue May 24, 2017 · 4 comments

Comments

@webspeaks
Copy link

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
Copy link
Collaborator

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
Copy link

ArielPremiumSupply commented Jan 18, 2018

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
Copy link
Contributor

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
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants