2. ASPRunnerPro General questions
  3. Error number -2147467259
This topic is locked

Error number -2147467259

 		4/7/2005 3:28:37 PM
ASPRunnerPro General questions
M
 mohindru author

Hey all...
I am using ASP Runner with Orcale 9i and am seeing the following error on the index page. Can anyone help. please. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1305&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1305&image=2&table=forumtopics' class='bbc_emoticon' alt=':)' />

Manbir

****
Error number -2147467259
Error description [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

URL /RTDORDER_VW_list.asp
SQL query select CLIENT, ORDERID, OOID, TYPE, CURRENTJOURNALID, SECBRORDID, USERID, SETTDATE, ENTRYMET, RECPROCDAT, RECPROCINF, CANCANCEL, TIF, TIMEZONE, INSTOID, CLISUBID, PRICE, EXTEXPDATE, BRSUBID, USEHUB, BRORDID, LIMPRICNT, OPENCLOSE, ACCTNO, HANDLIN, ORBRORDID, INHIBITMS, EXPUTCTIM, ZEROEXECID, COMMENTS, ORITDCOID, REQPROC, ORCURORDID, SETDATE, HELDFRMMKT, RITDSTATUS, SELLSIDEHB, LOCALCODE, CLICOMPID, EXCONOID, EXTEXPTIME, EXPUTCDAT, CPINSTIDFR, CURRENCY, BRCOMPID, SETTCURR, SECTYPE, CANCREAS, TRADINST, SPECINST, BUYSIDEHUB, OUTMESS, CANCELORDER, ORDERTIME, CLINSTIDFR, MKTCPTY, CASHORQTY, STPPRICNT, ITDCOID, EXECINST, PEGDIFF, CUSTFIRM, EARLYEXP, MINQTY, LIMITPRICE, CURORDID, RITDAMID, CONMULT, REJSOURCE, INMESS, EXCON, CANCDATE, FIXHUB, EXPIREDON, RECPROCTIM, COVUNCOV, AMHELDMKT, WEBSTATUS, ACCREQ, HELDFRMCLI, ORDERDATE, STOPPRICE From MPN_REP_REPORTING.RTDORDER_VW
Sergey Kornilov admin 4/8/2005

Hi,
please try to use ODBC driver from Oracle to connect to Oracle 9i database in ASPRunner.
S
 		sl_54ab 6/19/2005

Hi,
But I have tried to used MS ODBC for oracle already. Still got the same error as "Error description [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed "
I'm using oracle 9i and ASPRunner.

What's the problem? if the odbc driver has problem or anything else?
SL
500238 6/20/2005

Hi there,
I have the same problem also. Here we use oracle driver with asprunnpro. the same problem exists. Is there anything we missed?
thanks..
Kanthony
Sergey Kornilov admin 6/20/2005

Hi,
make sure you use the latest version of ASPRunner.

You can download it here.
If you have problems with ODBC driver from Oracle try ti use ODBC driverfrom MS and vise versa.
D
 		dallen03 1/13/2006

I really like this product when it work right, which I have been struggling since I have purchase it. I installed the upgrade 4.0 and now I can't get any access database connection to work. I built a simple database to be used and populated by a asp form once submitted. I have placed the db\database in the root of my website: and I also place the same database and asp files in the httpdocs\ path -
I still get this dam error:

This should be fairly simple but its a pain - ERROR
ASP error happened
Technical information

Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x111c Thread 0x13f0 DBC 0x316a0564 Jet'.

URL /SafetyMatters/SAFETYMATTERS_list.asp
More info on this error
Please provide a resolution for invoice users as myself - this is why I purchased the software to make it simple
Sergey Kornilov admin 1/13/2006

Last year I have answered this question 14 times. I do not mind to do this one more time.
This error message means ASP engine cannot locate your database file. Since you using non-default database location you have to adjust connection string manually.
Better yet - if you use FTP upload feature builtin into ASPRunnerPro you can point ASPRunnerPro to folder where database file should be located. In this case connection string will be adjuected automatically.
If this doesn't help post here the following:

  • conenction string that can be found in include/dbconnection.ap file
  • path to ASP files on the Web server
  • path to database file on the Web server
    Also make sure you placing database file to folder where write permissions are set. In other case you won't be able to edit or delete records.