kumaresan c wrote:
Thanks. You are right. As per that code there is no need to create DSN. But I can't access even by creating DSN under wine and modify the connection code as follows
Db.open "DSN=ForLinux; User Id=sa; Password=kumaresan" Ok, How to check whether the provider(oledb) works? or else What should I do to install oledb provider?
--Kumaresan
I'm not sure it will work through DSNs cause it requires some system support beside providers. You should install mdac as you did, and possibly override all oledb related modules, please use Wine user support forum http://forum.winehq.org/ for such questions, wine-devel isn't used for support.