Visual Basic with ADO connection to 9iLite
Hi there,
I am trying to get VB to connect with the string conn.Open "TEST2_price", "system", "test2" but I get the following error from VB "[POL-2200] Failed to create mapped file".
I know the ADO connection is working with the DSN because I can connect using JDBC from another program and retrieve results. However, I need to continue to use ADO with this application. Maybe I am using the wrong drivers? the wrong references in VB?? drivers not set up correctly???
Also, if I change the same connection to another DSN that isn't Oracle 9iLite but the real Oracle 8 the connection is successful. Please help, I've been at this for a week with no luck.
Thanks......