Search found 3 matches

by isabelle2378
Thu May 12, 2005 5:22 pm
Forum: Configuration, Maintenance, Troubleshooting
Topic: Setting up ODBC Query
Replies: 5
Views: 29579

ODBC errors

Hi, I uninstalled Oracle 9i and reinstalled it with the user that has permissions to the application. Now when I try and do a test, it comes back with: Error 4294967295 Specified driver could not be loaded due to system error 127 (Oracle in Oracle 9i). When I look up this error, it states: Setup the...
by isabelle2378
Wed May 11, 2005 5:26 pm
Forum: Configuration, Maintenance, Troubleshooting
Topic: Setting up ODBC Query
Replies: 5
Views: 29579

Still getting an error

Hi, I installed the ODBC drivers from Oracle 9i Rel2, setup a new dsn and tested it and it was able to connect successfully. I went back into Hostmon and changed it to use the new dsn and now I'm getting this error: Error 4294967295:[Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on SQL_HAND...
by isabelle2378
Wed May 11, 2005 3:41 pm
Forum: Configuration, Maintenance, Troubleshooting
Topic: Setting up ODBC Query
Replies: 5
Views: 29579

Setting up ODBC Query

Hi, I am trying to setup an ODBC Query to run a sql statement and if it returns anything other than 0, send an alert. The query is: select count(*) from ord_mast where status='SHIP'and upld='N' and trunc(status_dt)<trunc(sysdate). When I try and test it, I get the error: Error 4294967295[Microsoft][...