Thanks SMUCKERS..:)..need a little more help

[Masaud]

Smuckers thanks for your help...

I downloaded WinSQL as you told me and it is working fine. It made it very easy to write quries.

But I am stuill not able to run functions. For example:

select last_name, TO_CHAR(hire_date, 'MM/YY')
from employees;

Error: Undefined function 'TO_CHAR' in expression. (State:37000, Native Code: FFFFF3E2)

Does this software support functions and I need to do something on my machine in order to get it work or I can not do this.

Thanks once again!!!

 

[cmmrfrds]

Are you trying to pass this select statement to another database engine.

select last_name, TO_CHAR(hire_date, 'MM/YY')
from employees;

How are you passing the SQL. Through a Pass-thru query or ADO?

 

[Masaud]

I think I am using ADO. I might be wrong here. Sorry but I am not expert and I might be wrong...I am a beginner Following is what I get when I make a connection..(start WinSQL)

DSN=MS Access Database;DBQ=C:\Documents and Settings\Masaud\Desktop\SQL quries\db1.mdb;DefaultDir=C:\Documents and Settings\Masaud\Desktop\SQL quries;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;

Thanks for youe help!!