I am starting a project to modify a legacy application to use cloud data. The application is a VB5 (not sure why not VB6) application using either Access database or file based SQL Server (.mdb) Since the person that developed the VB application is not willing (or able) to fully refactor the application, I was asked to look into how this could be done. A full re-write of the application may be in the cards but definitely not at this time. My plan is to start with a proof of concept to allow a single function in the VB application to use cloud data store. I plan to create a SQL Azure database containing the required table(s) and data as well as a Web API to access this data (C#/.net) I haven't used VB5 or 6 since late 90's but I am very familiar with it. However I am not sure the best method to use for connecting the VB application to the API to be able to work with the cloud data store. Here's what I know: I could use XMLHTTP to call the web services by way of http calls. That would get XML or Json back from the server which I assume I would need to deserialize/parse. I am wondering if the Soap Toolkit is still a viable option or something else that would allow calling the web service and work with the returned data as objects-no parsing required. I remember using Soap/ROPE in the late 90's which was cool because it allowed you to point to a dll containing methods/functions and automatically convert them to soap functions. Or I could create a com component to do this myself which would be a lot of work. Are there any better ways of getting VB5 to talk to REST based service?
Connecting VB6 application to SQL Azure Data store
273 Views Asked by billymac At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in REST
- Query parameter works fine with fastapi application when tested locally but not working when the FastAPI application is deployed on AWS lambda
- Add an http GET/POST entry point to a Django with channels websocket
- Difficulty creating a data pipeline with Fabric Datafactory using REST
- Flutter connection to a local api
- Accessing REST API Status Codes using Azure Data Factory Copy Activity (or similar)?
- Mass Resource deletion in REST
- why when I check endpoint /tasks, an error always appears "error : invalid token" even though I have entered the appropriate token that I got
- How to prevent users from creating custom client apps?
- How to create a REST API with .NET Framework?
- Efficiently Handling Large Number of API Calls with Delphi 10.4 and OmniThreadLibrary
- Put Request throwing 401 [no body] Unauthorized
- Converting img src data to octet-stream
- Implementing Email Verification and Notification System in a Full-Stack Application with React Frontend and Node Backend
- Micronaut - Add Controller from external library
- Moving Template or OVA to Datastore using vCenter API
Related Questions in SOAP
- How can I read the header of request to webserver
- Apache CXF is unable to handle duplicate localnames
- Using SOAP with WSDL in python with the suds-py3 library: Why doesn't it show me anything when I use the following code?
- How can I call a SOAP webserver method in Vue.js?
- Avoid soap fault response (org.apache.cxf)
- Python Zeep XML - 0 float value changes type shape
- Migrate ASMX web method to WCF which accepts string array
- In XSD do you have to import the standard schema in order to use it?
- Problem: Authentication. Project: C++ Onvif manager Deltaco camera
- java.net.ConnectException: Connection timed out: no further information Java to SOAP
- Looking for an API or approach for range based parameter flight pricing using SabreCommandLLSRS
- After upgrading to JDK 11 my SOAP response is different
- Correct way to make a non-blocking delay in Spring WS (SOAP)
- android.os.NetworkOnMainThreadException even using an Aysnc task
- How to send multipart/mime SOAP request
Related Questions in VB6
- ORACLE: Tabs used for indentation converted to spaces in stored procedure when executing through DSN connection
- How to enable a menu that I added to external program on VB6
- microsoft from 2.0 controler textbox to retrieve the hindi content in vba
- VB6 compiled DLL giving CLASS_E_CLASSNOTAVAILABLE issue
- VB6 Project restore from Icon tray
- Can 64-bit Excel VBA use VB6 ActiveX?
- Separate batch of xml using vb6
- Translating decryption function from VB6 to C#
- No value given for one or more required parameters. in Vb6.0
- Read Text File Content from HTTPS Web using VB6
- Setting Working Directory for compiled VB6 application
- becubed oletool missing function call servertime.refresh
- VB6, Win10 x64, MS Office 2016, the Office (Excel) 16 reference is not available, VB, how to add?
- How to set a data comparing with row and column of msflexgrid in vb6
- What is the proper way to create a win32 toolbar on vb6 using win32 api?
Related Questions in VB5
- Error on Upgrading VB5 code to Vb.net in Visual Studio 2008
- Do i need to change my SQL-Statements in my VB5/VB.net-Application, if i change the used database from Access 97 to Access 365?
- I need Newtonsoft.Json 4.5.0.0 or a way to get Version 13.0.0.0 to work with RestSharp.Net2 for VB
- We are trying to migrate a VB5 program (50k Lines) to VB6 encountering multiple errors
- Getting system time milliseconds
- Connecting VB6 application to SQL Azure Data store
- Using MSXML2.ServerXMLHTTP instead of XMLHTTP for POST requests from VB5 application for handling HTTPS
- Migrating an ancient VB5 program to something newer?
- Error in using winsock in VS2010 : The variable 'Winsock2' is either undeclared or was never assigned
- Convert an unknown database file from a windows software into a MySqli Database
- Which files of VB 5.0 project can I ignore with git?
- Convert a call to old DLL from vb5 to c# - System.BadImageFormatException
- What does the error "wrong version of run-time dll" mean? (VB5 / VB6)
- vb3: change to locale date format
- VB5 and Oracle 11G: Init parameter NLS_NUMERIC_CHARACTERS ignored
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 # Hahtags
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?
Given how cumbersome the VB6 IDE can be to modify and debug code, of am ADO connection is unavailable I would keep things dimple. I would go with an XMLHTTP wrapper class and a formatter class.
The formatter class could stuff a Collection by iterating through nodes or with specific XPath queries.
Often, to simplify the legacy code, I will replace the XMLNS namespace with an empty string before loading the DOM so that I don't have to keep bloating the code with it.