12-01-2000, 12:02 PM
I am writing an application that uses ADO to connect to an Oracle database. Also, there are links that I must update (Oracle-->DB2). I am having no problems updating the Oracle tables, but I have no clue when it comes to the links. I thought that since I manipulate the tables and links in the same way within, say, a SQL Plus window that they would behave the same way within my VB code. But, alas, they don't! I am getting errors -2147467259, ORA-02070 and ORA-02063. Any help would be incredibly appreciated!!!!!
12-03-2000, 02:40 PM
Are you connecting to oracle with the same username in VB as you use in SQL/PLUS? Some type of permission problem is the only thing I can think of. I didn't look up the ora error because I don't have the documentation installed at home.
Brian T. Wiehoff
12-05-2000, 06:59 AM
Yes, the username/password/instance are the same in SQL Plus and through my VB app. This is a really confusing problem for me, as I am not terribly familiar with the way that links behave vs. the way tables behave. A command cut and pasted from my app into SQL Plus works (in SQL Plus and not in my app, that is). I'm not really sure where to go from here! :-(