The infamous net8 protocol error. This is _usually_ caused when the password for a schema is about to expire. SQL*Plus and other programs can handle that responses and prompt you with a message to change your password, or whatever.
However the drivers for CFMX don't know what to do with that response and throw this generic net8 protocol error. - Adam On 4/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I am having a weird problem trying to connect to an Oracle Database using CF > MX7. I have setup dozens of other Oracle Datasources on the CF MX7 server > already, but I am having trouble connecting to this one. The error I am > getting is this: > Connection verification failed for data source: ddts java.sql.SQLException: > [Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error. The root > cause was that: java.sql.SQLException: [Macromedia][Oracle JDBC Driver] > Internal error: Net8 protocol error. > I have been setting up these datasources from my TNSNAMES.ORA file. The only > difference between this database and the others is the addition of a > server=dedicated property, like so: > (CONNECT_DATA = (SID = DDTS) (server=dedicated) > Any help that anyone could give me on this would be great. Just point me > towards any documentation or an answer. Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203748 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
