Script work in Devl but not in Prod Vmware machine

mfauzim · Post by **mfauzim** » Wed Oct 18, 2006 9:58 am

I have a script which is able to pull data from oracle in insert in mssql. it works in the . When I move the compile app to prod machine which is using vmware, the system give the following error code:

adodb.connection : 3704
operation is not allowed when object is closed.

any help pls.

Post by **Marcus Tettmar** » Wed Oct 18, 2006 11:08 am

Maybe it's not able to connect to the server? Can you post the code?

pgriffin · Post by **pgriffin** » Wed Oct 18, 2006 7:28 pm

Do you have a .open line in your code? There can be user permission issues from machine to machine which can effect whether or not a connection can be made. Are you able to test on that machine as user (say, yourself maybe) which has access to that database?

mfauzim · Post by **mfauzim** » Sat Oct 21, 2006 12:58 am

Sorry guy for late reply, i managed to solved it by using pracle odbc. Previously I used microsoft odbc for oracle, I keep getting error on vmware, but after change odbc to oracle odbc driver, everything works without any code change

Script work in Devl but not in Prod Vmware machine

Script work in Devl but not in Prod Vmware machine

Code is correct only error with MDAC