Re: Problem in connect to Oracle from ADO

Set up a DSN(ODBC) to your Oracle database, them connect to the DSN (ODBC). Doing your insert, are you using the ADOX objects, or are you executing scripts (insert into). If you are using ADOX, take a note of advice - oracle and ADOX are not friends ...

On the other hand, connecting via DSN (ODBC) will not allow ADOX inserts into tables (provider does not support blah blah blah).

Here is an example connection string for DSN (ODBC) "DSN=POLite;UID=SYSTEM;PWD="

POLite = Name you gave your DSN connection.

Good luck.

So, my advice - use odbc to connect to the orable, then use scripts to insert. If you do get the ADOX inserts to work, please let me know ...

--
Posted via dBforums
http://dbforums.com