This is a VB6 question as I am currently working on a feature that calls a MSSQL stored procedure which return 7 tables. I store it in a ADODB recordset but when I use the NextRecordSet function I can't access past my 6th table, is this a limitation with the ADODB in VB6, the same stored procedure was used in VB.Net in an ASP.NET website and worked fine.
VB6 DODB Recordset can't access more than 5 tables
111 Views Asked by Daniel Oliveira At
0
There are 0 best solutions below
Related Questions in ASP.NET
- Create an IIS web request activity light
- Writing/Overwriting to specific XML file from ASP.NET code behind
- What is the point of definnig Asp.net Intrinsic Objects In different places and what is the different betwen them?
- Deleting Orphans with Fluent NHibernate
- IOrderedEnumerable to vb.net IOrderedEnumerable Conversion
- Entity Framework Code First with Fluent API Concurrency `DbUpdateConcurrencyException` Not Raising
- Getting deeply embedded XML element values
- What is best way to check if any of the property of object is null or empty?
- NuGet - Given a type name or a DLL, how can I find the NuGet package?
- ASP-MVC Code-first migrations checkbox not active
- How do i add onclient click to my jquery button
- Jquery: Change contents of <select> tag dynamically
- Retrieving data from Oracle database
- ASP.NET: Fill Textbox field upon dropdownlist selection by user
- Why web API return 404 when deploy to IIS
Related Questions in SQL-SERVER
- SQL server not returning all rows
- Big data with spatial queries/indexing
- Conditional null constraint on Null
- SQL Query - Order by String (which contains number and chars)
- Optimising a slow running SQL Server Stored procedure ordered by calculated fields to return a closest match
- Dynamics CRM Publishing Customizations - Multi Developers
- Is there anyway to set the relationship of many tables from Model?
- Implementation of Rank and Dense Rank in MySQL
- ORM Code First versa Database First in Production
- MVC : Insert data to two tables
- Data streams in case of Merge
- table with multiple IDs but seperate notes need sorting (Tried SQL code to make a union query)
- SQL table Partitioning by Year with ColumnStore index implemented on the table
- Defining which network to use for SQL Server 2012 Management Studio
- Fill a week days in a table with preceding Sundays value
Related Questions in VB6
- How to export VB6 TextBox data(Arabic) to MS Excel
- Need code for removing all unicode characters in vb6
- Team Foundation 2012 not recognising changes in vb6 app
- How can we add custom logic while installing exe created by installshield
- Convert VB6 to VB2010 code
- Why is VB6 FlexGrid throwing a run-time error 381 'Subscript out of range'?
- Enum values from VB6 DLL do not appear in C#
- Using dll of .Net by VB6 app in Windows 8
- Change parameters On error in vb6
- Is it possible to use VB6 enums which have values with spaces in C#?
- Converting VERY large number to a hex string
- Controls randomly not showing in my VB6 software
- GetWindowsDirectory() API returns wrong (vba\vb6)
- Can create Scripting.FileSystemObject 64-bit but not 32-bit
- Which function is there in Python equivalent to Val() in VB6?
Related Questions in ADODB
- Upload data to SQLServer
- Cast and Convert functions are not supported on converting the column to date time format (in vbscript - Excel adodb)
- ADODB Connection is empty, Unable to read CSV file
- Open Connection and Recordset objects to use SQL for sheet to sheet data movement
- Trying to get some record. No matter what query I do, I am always getting `!NC!`
- Slow performance when using classic ASP with ADODB on Window 2012 and IIS, Oracle Database
- Fast update of Access data with Excel data using Excel VBA
- ADODB.Recordset keeping rows after close.. Classic ASP
- How to resume/retry a broken TADOConnection across the application?
- UDF function in Excel running ACE SQL query, JOIN two tables does not work
- How to select dynamic sheet names with an Excel VBA macro that moves data with ADODB?
- Adding SQL statements to ADODB connections
- "Not enough storage is available to complete this operation" when base64-encoding a zip file
- VBA - ADODB.Connection - Using parameters and retrieving records affected count
- Invalid Use of Default Parameter Error While Performing an Insert
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?