I have the following line in my ASP script:

SELECT * FROM Name WHERE Name like 'an*';

Which runs fine in RAW access Query mode both in 98 and 2000 versions.  But 

does not work thru ASP using CreatObject ADODB object and also thru VB 

(with ref to ADO 2.5 Lib).



Have I missed a ref to somet else?

You should read the following:



http://www.adOpenStatic.com/FAQ/likequeries.asp



and



http://www.adOpenStatic.com/FAQ/selectstarisbad.asp



Cheers

Ken



----- Original Message -----

From: "Idris Mansoor" 

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, July 14, 2000 10:29 AM

Subject: [asp_databases] SQL in Access 98/2000





> I have the following line in my ASP script:

> SELECT * FROM Name WHERE Name like 'an*';

> Which runs fine in RAW access Query mode both in 98 and 2000 versions.

But

> does not work thru ASP using CreatObject ADODB object and also thru VB

> (with ref to ADO 2.5 Lib).

>

> Have I missed a ref to somet else?