How to retrive date field with vb6 code and SQL server 2000

From: Joooooooooooo (friends_soft@xxxxxxxxxxx)
Date: Sat, 08 Oct 2005 12:51:12 -0700

when i go to make a query of table ( sql server 2000 " like
"select * from emp where e_date =....
or
""select * from emp where e_date between.... and ....

an error ecured
but the same code is excuted with database of Access

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
.

Prev by Date: Re: Converting Command->Execute to Recordset->Open
Next by Date: Bugged by an easy problem for someone
Previous by thread: ADOX modify column Nullable
Next by thread: Bugged by an easy problem for someone
Index(es):
- Date
- Thread

Relevant Pages

DataList in Table
... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ... Prev by Date: ...
(microsoft.public.dotnet.framework.aspnet)
visual effects on a web-page
... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ... Prev by Date: ...
(microsoft.public.dotnet.framework.aspnet)
rename worksheet in excel
... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ... Prev by Date: ...
(microsoft.public.scripting.vbscript)
Re: Intellisense
... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ... Prev by Date: ...
(microsoft.public.dotnet.framework.adonet)
Re: Attached database / invalid owner / Database diagrams
... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ... Prev by Date: ...
(microsoft.public.sqlserver.setup)