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?

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!