I have developed s/w in visual basic 6 and database in MS SQL 7.0.
My problem is the program is running without any error on my machine and and some other client machines also.
But it is giving error on one client machine.
In my s/w package first I'm asking for userid and password from the user when they first run the program.
when the user is entering userid and password and click on OK button. the code will execute the query "select * from tablename"
So on executing this The program is giving following error:
"Class does not support automation or does not support expected interface select * from Table name"
anybody can give idea about how to solve this error.