SQLSTATE[IMSSP] - cant see my driver

Problems with the Windows version of XAMPP, questions, comments, and anything related.

SQLSTATE[IMSSP] - cant see my driver

Postby hackoa » 16. March 2015 08:50

HI, i have installed sqlsrv driver in my php ext directory and write two line of this code in my php.ini file: extension = php_sqlsrv_54_ts.dll, extension = php_pdo_sqlsrv_54_ts.dll.
I have this in my php info:
Image
and
Image

My code for connection:
Code: Select all
$serverName = "192.168.40.12\SQLExpress";

try

{

  $conn = new PDO("sqlsrv:server=$serverName;Database=VertiDFS", "", "");

  $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

}

catch(Exception $e)

{

  die( print_r( $e->getMessage() ) );

}


And i see this error in my browser:
SQLSTATE[IMSSP]: This extension requires the ODBC Driver 11 for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=1637121
hackoa
 
Posts: 3
Joined: 10. March 2015 15:52
Operating System: Windows 8.1 Pro

Re: SQLSTATE[IMSSP] - cant see my driver

Postby Nobbie » 16. March 2015 12:08

hackoa wrote:And i see this error in my browser:
SQLSTATE[IMSSP]: This extension requires the ODBC Driver 11 for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=1637121


I dont understand your question - the message tells you to install the ODBC Driver 11 for SQL Server (this seems to be required), did you follow that advice?
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: SQLSTATE[IMSSP] - cant see my driver

Postby hackoa » 16. March 2015 12:34

Yes i make clean install and now work fine.
thank you
hackoa
 
Posts: 3
Joined: 10. March 2015 15:52
Operating System: Windows 8.1 Pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: hthnightwolf and 64 guests