Searching a real time converter to sql server

F

fpsoft

My vb6 and vb.net application needs to be used with a jet database (already
does) and sql server 2005. In the software, i have written all queries using
access syntax (iif, format) not supported by sql server.

I was searching for a "real time query translator" to which (at run time) i
pass the query (in access format) and it gives back the query in sql server
format.

Anybody can help?

Thanks.
 
Top