To Daniel and everyone
I was very impressed that I have so much of replies and help from many
people. To all of you, please accept my appreciation.
I was trying everything but not thing was worked for me. James was helping
running my code on his database. The only thing James fixing my code was
changing the line:
oRs.Open "DSN=OrclCoreTest;UID=coretest;PWD=coretest;"
to
oRs.Open "DSN=OrclCoreTest"
I don't know why it was making a different by setting UID and PWD in ODBC
instead of passing them at runtime.
Now I find another way to work around it. When I have time I am going to
looking into it later. Anybody have any quick idea why ?
Best Regards
Myle Pham