On Sep 7, 7:45 am, d-f3x <faub...@gmail.com> wrote:
> 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?


Resolved... no issue... just programmer oversight. Thanks!