This topic is locked

ODBC Connection Question

2/25/2019 7:37:53 PM
PHPRunner General questions
M
michaelmac author

Hey Everyone
I am having an issue with MSSQL on a webhost and it will NOT CONNECT to my table
How can I get this to connect to MSSQL using ODBC on the server
$connection = odbc_connect("Driver={ODBC Driver 13 for SQL Server};Server=$server;Database=$database;", $user, $pass);
It works in PHPRunner, but I build and upload it and I get the following error
Fatal error:

Source: Microsoft SQL Server Native Client 11.0

Description: TCP Provider: An existing connection was forcibly closed by the remote host.

Source: Microsoft OLE DB Provider for SQL Server

Description: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

Source: ADODB.Connection

Description: Provider cannot be found. It may not be properly installed. in \connections\Connection.php on line 661
Why can't I get the ODBC 13 Driver to load
Thanks

Admin 2/25/2019

Not sure I understand the question. Are you saying you opening connection manually using this code?

M
michaelmac author 2/27/2019



Not sure I understand the question. Are you saying you opening connection manually using this code?


I am trying to create a Connection String using the info I listed
hope this clears up some things