Qtp Unspecified Error Oracle
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community unspecified error in alm Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers unspecified error in qtp Samples Retired content We’re sorry. The content you requested has been removed. You’ll be auto redirected unspecified error uft in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Unspecified Error - when retrieving data from recordset Data Platform Development > ADO.NET Managed Providers Question 0 Sign in to vote I am writing a simple query in VB .NET using Visual Studio 2005. I trying to connect to Oracle 9i. using "Microsoft ODBC for Oracle" (2575.1117.00) MSORCL32.DLL 28/04/2004. The connection to dataserver is succesfull. Even I can runthe following query succesfully: myCommand.CommandText = "select * from NLS_SESSION_PARAMETERS" myRecordset = myCommand.Execute But when I try to run the following simple query, all I get is "unspecified error" myCommand.CommandText ="select * from my_user_db.my_table" myRecordset = myCommand.Execute Does anyone knows what is happening here ?? Thanks Fede Sunday, July 09, 2006 3:19 PM Reply | Quote Answers 1 Sign in to vote OK, regarding the problematic field (TIMESTAMP(3)) I just do this in my query: select field1, to_char(timestamp_field) from my_table And its works fine. Problem solved. Since the Error.Source retrieved is from the provider (Microsoft ODBC), Interesting is why I 'm recieving "Unspecified Error" and not something more useful to debug. Thank you all for answering my post. Fede Monday, July 10, 2006 7:52 AM Reply | Quote All replies 0 Sign in to vote You've omitted too much information, so I've to assume the following: - You're using OdbcCommand class to connect to database. - You're calling OdbcCommand.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, https://social.msdn.microsoft.com/Forums/en-US/025ef331-4669-489b-9209-332ad9077788/unspecified-error-when-retrieving-data-from-recordset?forum=adodotnetdataproviders helping each other. Join them; it only takes a minute: Sign up VB Script - DB connectivity issue up vote 1 down vote favorite Getting 'unspecified error' while executing the code below: DBConn.Open "Driver={Microsoft ODBC for Oracle}; " & _ "CONNECTSTRING= (DESCRIPTION=" & _ "(ADDRESS=(PROTOCOL=TCP)" & _ "(HOST="&strHost &")(PORT="& strPort &"))" & _ "(CONNECT_DATA=(SERVICE_NAME="& strServiceName &"))); uid="& strUID http://stackoverflow.com/questions/25931346/vb-script-db-connectivity-issue &";pwd="& strPwd &";" If DBConn.State = "1" Then msgbox "connected" Else msgbox "not connected" End If SQL = "select * from abc_tbl where abc_i in ('" & strValue & "')" DBRecordSet.Open SQL,DBConn 'GETTING ERROR ON THIS LINE This snippet is working when I try for many other tables, but for one table alone it's not working and throwing 'Unspecified Error'. Please point me where I'm going wrong in this. Thanks! qtp adodb share|improve this question asked Sep 19 '14 at 10:04 zeal 110214 1 Try simplifying your code and remove everything that is not relevant to your question. You're using 6 variables (strHost, strPort, strServiceName, strUID, strPwd, strValue) and that means we can't be certain what you're doing. Eliminate all of that and re-post your most code. Show the full connection string and full SQL query and it will be much cleaner and easier for others to help you. –HgCoder Sep 20 '14 at 21:00 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote
unspecified error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to http://www.vbforums.com/showthread.php?483196-rs-Open-quot-Select-*-from-blah-quot-gives-unspecified-error visit from the selection below. Results 1 to 9 of 9 Thread: rs.Open "Select * from http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/unspecified-error-opening-adodbrecordset-35565 blah" gives unspecified error Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Aug 9th, 2007,10:44 AM #1 DssTrainer View Profile View Forum Posts Thread Starter Addicted Member Join Date Aug 2006 Posts 211 rs.Open "Select * from blah" gives unspecified error I have a simple database lookup program Using ADODB with Oracle 9i, unspecified error I have my connection string: Code: Conn = "Driver={Microsoft ODBC for Oracle};Server=myserver;Uid=myname;Pwd=mypass;" which works fine. I can query on all the schemas in my database fine I can see which tables are in the schemas When I try: Code: Set rs = New ADODB.Recordset rs.Open "Select count(*) from USER_TABLE where USER_ID='123'", db, , , adCmdText it pulls back the count in my datagrid just fine. When I try: Code: Set rs = New ADODB.Recordset rs.Open "Select ID from USER_TABLE where USER_ID='123'", db, unspecified error in , , adCmdText It pulls back all the matching ID rows just fine. But when I try: Code: Set rs = New ADODB.Recordset rs.Open "Select * from USER_TABLE where USER_ID='123'", db, , , adCmdText I get ERROR: Unspecified Error from my Error Handler trap. Is there some setting I need for oracle when using select *? Reply With Quote Aug 9th, 2007,10:52 AM #2 szlamany View Profile View Forum Posts MS SQL Powerposter Join Date Mar 2004 Location CT Posts 17,185 Re: rs.Open "Select * from blah" gives unspecified error Maybe try: USER_ID=123 without the quotes - I'm guessing USER_ID is a numeric datatype - right? *** Read the sticky in the DB forum about how to get your question answered quickly!! *** Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post". Some Informative Links: [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ] [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ] MS MVP 2006, 2007, 2008 Reply With Quote Aug 9th, 2007,11:23 AM #3 DssTrainer View Profile View Forum Posts Thread Starter Addicted Member Join Date Aug 2006 Posts 211 Re: rs.Open "Select * from blah" gives
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP Inside-CRM MacProTX VoIP_News I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Adrian_Grigoriu Iqbalyk numbersguyPA RichardChan COMPANIES Compuware ZOHO Corporation Cisco HighJump Software View All Topics View All Members View All Companies Toolbox for IT Topics Visual Basic Groups Ask a New Question Visual Basic – General Discussions The VB - General Discussions group is a forum where peers share technical expertise, solve problems, and discuss issues related to the use of the Visual Basic programming language. Home | Invite Peers | More Visual Basic Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Unspecified Error opening ADODB.Recordset Unknown User asked Oct 23, 2001 | Replies (3) Hello All - I am having trouble opening a ADO recordset when the executable is run. My application runs fine in design mode. I am connecting to an AS/400 using the Client Access ODBC Driver installed on my machine. I created a File DSN and extracted the necessary values for my connection string. I have verified that the connection does open. Trapping the error results in: Error: -2147467259 Description: Unspecified Error Source: Provider I cannot seem to find any relevant information on the web. Resolutions include removing spaces in the connection string, checking user security, & recordset is read only (which is how I am connecting). The error that is raised is a generic error number. I have tried both MDAC 2.5 & 2.6. Again, the application runs fine in design mode. Any help would be greatly appreciated. Dim dbConn As New ADODB.Connection Dim dbRS A