PDO under MSSQL
Good Day Everyone!
I am currently attempting to use PDO to connect to a MSSQL database.
In the code, I establish a connection to a system DSN (XAMPP under
Windows 2003 Server) and then execute my query which looks like this:
SELECT
*
FROM
dbo.WEBCUSTOMER
When I execute the code, I get the following error message:
'SQLSTATE[42S02]: Base table or view not found: 1146 Table
'dbo.webcustomer' doesn't exist'
The database and the table do exist, so I have to point to somekind of
syntax error. The query above works flawlessly using MySQL and even
other ODBC datasources, but for some reason, under MSSQL my database
declaration seems to be all wrong.
Does anyone know how to reference a DB/Table in a MSSQL query?
|