2147467259 Oracle Error
Primary Software Version: 1.0.1 Primary Software Fixed Version: N/A Secondary Software: N/A Problem: I have an application that requires me to error 2147467259 sql connect to an Oracle Database. When I try and update a error 2147467259 odbc table in Oracle, I get Error -2147467259 from the DB Tools Insert Data VI. I have the latest version of the Oracle ODBC driver. What does this error mean, and how can I send data to Oracle from LabVIEW? Solution: The DB Tools Insert Data VI expects a cluster of data to be connected to the data input. You must have each variable in the cluster defined to be the appropriate data type. If you have all entries in the cluster defined as strings and the Oracle table is expecting numerics, you will receive the error message:Error: -2147467259 expecting a number but receiving a binaryAlso, be sure to use the DB Tools Format Datetime String VI from the Utilities sub-palette to correctly format any date or time entries that you need to send to the Oracle database. Related Links: KnowledgeBase 2R58GT44: Database Connectivity Toolset Error - Couldn't Find Installable ISAM KnowledgeBase 2QL8JLZO: When using the Motion ActiveX control in LabVIEW why do I get "error -2147467259 occurred at Unspecified error in Add Board ID.vi"? KnowledgeBase 1JT9E9TL: I Get "OleInitialize Failed Error" if I Try to Connect to Microsoft Access Database KnowledgeBase 2KLCMFEV: Workaround for Error -2147467259 (x4005) - Passing an Automation Refnum From a VI to a Call Library Node Attachments: Report Date: 11/17/2003 Last Updated: 07/09/2009 Document ID: 33GB4H59 Your Feedback! Poor|Excellent Yes No Document Quality? Answered Your Question? 1 2 3 4 5 Document needs work? Please tell us why. Please Contact NI for all product and support inquiries. My Profile | RSS | Privacy | Legal | Contact NI © 2014 National Instruments Corporation. All rights reserved. |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in ODBC All PlacesDatabaseDatabase Application DevelopmentWindows and .NETODBC This discussion is archived 3 Replies Latest reply on May 6, 2004 9:32 PM by 420772 Error message -2147467259 272086 Apr http://digital.ni.com/public.nsf/allkb/1F401CE96BCD2A1D86256DE1006386A0 30, 2004 12:03 AM A perfectly running application using VB6/Oracle/Crystal Report installed on multiple PC suddenly stopped working. To make it even worse, I don't know which installed application caused my app to stop working. During development I used, MDAC 2.5, Oracle ODBC 8.1.7. Created system DSN. Everything was running OK. Now I am getting https://community.oracle.com/thread/243922?start=0 error message Microsoft ODBC, specified DSN could not be found. I checked, TNSNames.ora, I checked Registry permission, all are well. Some culprit app is messing up my humble application. Can someone think of a possible cause that change ODBC not to work. It simply does not connect to Oracle DB. Stressed!!!!!! 1762Views Tags: none (add) This content has been marked as final. Show 3 replies 1. Re: Error message -2147467259 82532 Apr 30, 2004 1:40 PM (in response to 272086) I assume that on the same machine/user you can test and use the DSN from outside your application? Like Show 0 Likes(0) Actions 2. Re: Error message -2147467259 272086 May 4, 2004 3:35 AM (in response to 82532) I finally managed to pcAnywhere to the client PC where they are having problem. Using the same DSN, I manage to use Oracle ODBC test to connect to DB. It works fine. looks like it the problem is in ADO. I used MDA
[Microsoft][ODBC driver for Oracle][Oracle] [message #101578] Fri, 17 December 2004 18:32 Rachana Patrikar Messages: 2Registered: December 2004 Junior Member Dear Sir, I am using VB 6.0 to connect to Oracle and myconnection string is str = "Provider=MSDASQL.1;Persist Security Info=False;User http://www.orafaq.com/forum/t/38472/ ID=time;pwd=time;Data Source=hours" Earlier it was working properly but then, PC on which this application was running got formatted and i am getting this error -2147467259 error [[Microsoft]][[ODBC driver for Oracle]][[Oracle]] Can you please help me, its very urgent..............Please!!! I would be very thankful if i get solution as early as possible. Thanks and regards Rachana Patrikar Report message to a moderator Re: -2147467259 error [Microsoft][ODBC error 2147467259 driver for Oracle][Oracle] [message #101589 is a reply to message #101578] Fri, 24 December 2004 01:16 Frank Naude Messages: 4502Registered: April 1998 Senior Member Hi, This may help: Connectivity Issue with MDAC and Oracle8i - http://support.microsoft.com/support/kb/articles/Q264/0/12.asp If not, try to reinstall the latest version of MDAC. Best regards. Frank Report message to a moderator Re: -2147467259 error [Microsoft][ODBC driver for Oracle][Oracle] [message #101593 is a reply 2147467259 oracle error to message #101589] Mon, 27 December 2004 20:18 Rachana Patrikar Messages: 2Registered: December 2004 Junior Member Hi, Thanks for your kind cooperation. here i would like to extend my problem-- This program was running fine on a PC but then PC got formatted and we need to reinstall everything. now after reinstallation we are having 2-3 oracle homes in that PC like oracle 8i, oracle 9i......Now this program is accessing oracle 7.3 database which is on server. I am using str = "Provider=MSDASQL.1;Persist Security Info=False;User ID=timeoff;pwd=timeoff;Data Source=SAPHR" this connection string......to connect to oracle database. Also latest MDAC is installed there. now tell me can you please help me? thanks and regards. Rachana. Report message to a moderator Re: -2147467259 error [Microsoft][ODBC driver for Oracle][Oracle] [message #101605 is a reply to message #101578] Wed, 05 January 2005 00:00 Michael Hartley Messages: 110Registered: December 2004 Location: West Yorkshire, United Ki... Senior Member Hi, Have you confirmed the Oracle homes are correctly installed? eg. Can you sqlplus from each of the oracle homes to your target database? Have you confirmed the Oracle com interfaces and MDAC has been correctly installed. Have you created the "Data Source=SAPHR" entry with the MDAC data sources contr