Discussion: PDO under MSSQL
Afficher un message
Vieux 07/09/2007, 12h45   #1
d-f3x
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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?

  Réponse avec citation
 
Page generated in 0,04411 seconds with 9 queries