Pass Through Query Problem

[gumby]

SELECT DISTINCT
CREATED,
INS_PRODUCT,
FROM dbo.S_SRV_REQ
WHERE (INS_PRODUCT = 'Data Compromise') AND (CREATED >
CONVERT(DATETIME, '2006-08-07 00:00:00', 102))


I am trying to query a database on a SQL server. I am unable to link it
because the tables has to many indexes.

I have also tried

SELECT CREATED, INS_PRODUCT
FROM dbo.S_SRV_REQ
WHERE (INS_PRODUCT = 'Data Compromise') AND (CREATED >
CONVERT(DATETIME, '2006-08-07 00:00:00', 102))


In the properties for the Pass through query I have this Connect Str.

ODBC;DSN=SQL SERVER
NAME;Description=OSCAR;UID=UserName;PWD=Password;DATABASE=Pubs


I am getting a error ODBC Call failure.Inccorect snytax near the key
word FROM.

Please help, thanks -

 

[gumby]

I got this to work, but I would like to only return a couple of fields.


SELECT *
FROM S_SRV_REQ
WHERE (INS_PRODUCT = 'Data Compromise') AND (CREATED >
CONVERT(DATETIME, '2006-08-07 00:00:00', 102))

David