Vb as400 iseries odbc jobs

Problem: I am inserting records to SQL table as per demand using VB6.0 script. Sometimes the data is not inserting to SQL table due to multiple reasons. The problem is observed rare when data traffic loaded. Requirement: We don't want to miss any record due to script errors. Each and every record is important. Probable Solution: Plan is to insert the SQL table as well as Text file using my VB Script. Writing to text file has very less lines of code compare to inserting to SQL. So I belive, writing the text file VBScript is very simple and it will not generate any script error. Writing to text file will be consider as backup plan. So plan is to write a SQL stored procedure to read the text file and check if the same data is already available. If available then NO ACTION. If t...

I am in need of a proficient Excel expert with experience in VB, Macros, and Forms. The ideal candidate will be tasked with developing an automated inventory management sheet to streamline our inventory handling, specifically: - Recording incoming inventory - Tracking current inventory levels - Generating inventory-related reports - Recording outward inventory - Recording daily production inventory The aim of this project is not only to track and record but to utilize this data to: - Generate daily production reports - Calculate total inventory turnover - Monitor inventory usage This project calls for a great understanding of inventory management and proficient skills in Excel VB and macros. The desired completion time for this project is as soon as possible. Please ensur...

...advanced skills in visual basic, as this project requires a considerable amount of editing at the VB level. Knowledge and understanding of database relationships, including one-to-one, one-to-many, and many-to-many is essential as there are specific relationships and dependencies that need to be taken into consideration when modifying or building tables. Previous experience working with Microsoft Access databases specifically will be highly advantageous. Additionally, good problem-solving skills and attention to detail are needed to understand the relationships or dependencies among the current tables. This project does not require SQL understanding, hence if you are less SQL wise but stronger in VB, that is perfectly fine. I value your expertise and look forward to achi...

...an issue I'm experiencing with connecting a SQL view to my Access database using ODBC. Despite successfully linking tables, I'm unable to establish a connection to the view. The core of this project involves diagnosing and fixing why this connection isn't happening, ensuring that data can seamlessly flow into Access from the SQL view. **Key Requirements:** - **Diagnose Connection Issues:** Identify why the ODBC connection to the SQL view isn't established. Investigate if it's related to the view itself, the ODBC setup, or another underlying issue. - **ODBC Expertise:** Deep understanding of ODBC (Open Database Connectivity), including setup, troubleshooting, and configuration. Familiarity with the latest ODBC driver...

I urgently need help with automating data extraction from SAP reports. The key focus is on financial reports and Plant Maintenance. Deliverables: - A reliable solution to extract, as a minimum, general data from reports in SAP. Ideal Candidate: - Familiar with SAP reports, particularly Financial and Plant Maintenance. - Proficient with VB and RFC for data extraction. - Able to deliver quickly as I need this implemented ASAP.

...maintain technical documentation, including system design documents, program specifications, user manuals, and release notes. • Working closely with all stakeholders to resolve issues and implement improvements. JOB REQUIREMENTS: • Proficiency in COBOL programming language, with a minimum of 4 years of experience in application development. • Experience with mainframe technologies, such as IBM iSeries, LIFE/400, SMART/400, and DB2. • Experience with software development methodologies, such as Agile or Waterfall. • Experience working with SQL. • Excellent analytical and problem-solving skills in a technical environment. • Good level of English language – both written and spoken. • Excellent communication skills. • Ability to wor...

I’m looking for a talented programmer to develop a Windows application in Visual Basic. This application must do the following: I need a Windows based application to solve two formulas (see highlighted formulas in attached document). The use would input the variables as listed, input a pressure and the program would select the correct formula to use based on pressure and provide the calculated diameter. I would like this to be programed in visual basic. Deliverables would be the executable file and source code. **Ideal Skills and Experience:** - Proficiency in Visual Basic programming - Experience in creating Windows applications - Understanding of mathematical computations within software - Ability to create user-friendly interfaces **Project Requirements:** - Develop a Windo...

Part 1 of the project suggest creation SQL data base that will collect online streaming data from our app for FORTEX market. Steps of the project: 1) Install and configure Database 2) Set up connection to ODBC 3) Connecting QUIK via ODBC to Database 4) Save historical data in the SQL including division data based on the instruments 5) At the end of each data create txt file located on folder FORTEX for each instrument in following format (data is aggregated for all historical data points) For tikers: <TICKER>,<PER>,<DATE>,<TIME>,<LAST>,<VOL> Si_T_1,0,20231226,085944,92351.000000000,2 Si_T_1,0,20231226,085944,92351.000000000,5 Si_T_1,0,20231226,085944,92351.000000000,1 ticker, 0, YYYYMMDD, HHMMSS, price, contract volume For time frame: ...

Please Sign Up or Login to see details.

Please Sign Up or Login to see details.

Please Sign Up or Login to see details.

Hi, this is a small project for $15 USD. I will send you an excel and the details in chat. maybe VB is neededbe avoided We need show values from different cells, based on a cell value.

I am currently managing athlete information in Excel 2016 and need assistance with creating multiple dyn...The primary objective for this project is to filter various sets of data. Ideal Skills and Experience: - Advanced expertise in Excel 2016 - Proven experience managing and filtering information - Proficient in creating dynamic arrays in Excel Main Task: - Implement multiple dynamic arrays to effectively filter the student information as described in the attachment. Solution cannot be written in VB - macros are not permitted. The successful freelancer will demonstrate a clear understanding and practical knowledge of managing dynamic arrays in Excel 2016. If you can help me transform my spreadsheets into a more streamlined, efficient data filtering mechanism, I'd love to...

I'm currently experiencing some challenges with my PHP website. Here are the issues: - Errors being displayed throughout the site - Dysfunctionality of several pages and features - Total inaccess...entirely offline Website is very simple appointment display and book. It was working on a host But they upgrade the platform and as the page queries an external MS SQL database for a list of available appointments, this no longer works. It used PDO (PDO_dblib) to connect but its not work. Tried a test connection and it doesnt work. Changed to PDO_sqlsrv but its not supported as it needs ODBC on server and 123reg will not allow. I have set up a VPS which they say will work but I do not understand. Looking for someone to fix, and then add a bit more functionality but that is lat...

I am in need of a well-versed back-end developer for my ASP.NET VB project. Here are the key aspects of this project: We have aspx web application running on Microsoft IIS 8. This was written in vb.net We need a small extra functionality for this application Create a standalone aspx page written in vb.net that Will show (preview) pdf files stored in a specific folder on that web server. Only PDF files may be shown. Other files should be ignored in case there would be any. We should be able to browse through the pdf files with next – previous buttons We also need a button “approve”. When pressed it will Insert a record in a SQL table named “ApprovedInvoices” and containing only 2 field (id and filename) Move file to a subfolder “Approved&rdquo...

I require a skilled developer to create an Android client app to talk to a software service running on a current Android-based hardware platform. The command set to be included in the app has already been developed separately in C# as a Windows client, and this project is mostly porting from existing C# code (as a VB project file) to Android. The Android client will be simpler (involving less functions overall than the Windows client). I need someone in the USA. Since I may need to ship them a tablet. The project's critical components will involve: - Crafting an intuitive GUI. - Taking existing functions in C# and porting them into Android app wrapper (compatible with Android 10 Go, and Android 13). - Functions include establishing secure connection to service alread...

- Support languages: c++, c#, Java, Delphi, VB etc - Project ready to GO! - Job scope ready - Require to integrate hardware device with ready SDK instruction - Require admin panel, Ui design, android, ios, landing page -------------------------------------------------------------------------- Please read before accept this job. Thank you -------------------------------------------------------------------------- 01. If you are looking for a work life balance and work based on your sweet time. pls DO NOT accept this job. 02. Work life balance not for young man. Work hard when we still young 03. we only deal with business owner, if you are agency, sales manager or project manager pls do NOT accept 04. we dont mind if u are just a small team. as long as responsibility, work hard, fast...

Hello how are you. I have a project in Java (I don't have the source code, I had to decompile it with online tools) and I am recreating a similar tool in .NET (Visual Basic). When my file is saved (both in Java and VB) the program takes the last 3 digits of the employee ID and converts them into a password, but in the result of my they are encrypted. What I need to do with the program is for my visual basic to encrypt my password and generate the signature (last parameter of the ) in the same way that java does, that is, if I generate a with The .Net , my password and signature parameter, must be the same as the one generated by Java (if not, it does not work for me in another tool that uses ) Here I attach the tool in Java and I attach

I have a Windows application connected to a Microsoft SQL Server where the server and database names in the VB.NET connection string need to be altered. Currently, application connects to SQL Server using SQL Server Native Client 11.0 that cannot be installed on Windows 11 due to compatibility issues. So I need to replace it either with : - Microsoft OLE DB Driver for SQL Server OR - Microsoft ODBC Driver for SQL Server I am not sure which way would be better. I need to replace connection string. Code can be reused and I would not change except where is needed. I have form where I choose to connect to database. This connection string is saved to XML file. This part I would not change except whats needed. Their task would involve: - Changing both the server and database names wi...

I'm on the lookout for skilled freelancer who possesses significant expertise in creating machine control interfaces for an XY Axis CNC Drill Machine. Your role will require creating an interface to create various holes patterns. Key features this interface must include are: - User-friendly Interface to create customizable Drill Patterns: Ability to select from common geo...lines, circular, matrix) and add new ones. - Interactive Picture Box: Status of each hole (done, ongoing, pending) shown -- Scalable picture box representing the part dimensions. List of points should be displayed in a data grid. - Mouse-Click Coordinates: The interface should also record and display the coordinates of where the operator clicks on the Picture Box. Task only requires you to work on VB an...

I am looking for a developer who can fix errors or bugs in desktop software that was built using Microsoft Studio VB . I have the source code for the software. -Mainly the issue is in the activation process. By Mistake, I deleted the online database where the software was accessed and checked whether the activation code existed or not and also if the code was used before or not. -I need to modify the activation code and create a new online database. -You can PM me to send you the link to the software. Requirements: - Experience with Microsoft Studio VB - Strong debugging and problem-solving skills - Familiarity with desktop software development and common issues - Attention to detail and ability to thoroughly test and identify bugs - Ability to work independently and ef...

I'm in need of a highly proficient HP UFT trainer to deliver advanced online training. The sessions should ideally cover the below areas: - Scripting fundamentals - Object Identification - Test results analysis - Proficient in VB Script - preferably from South India and Hyderabad is added advantage. Given the advanced level of training required, the trainer should possess an expansive knowledge of HP UFT and be adept at communicating complex concepts in an approachable and understandable way. Experience in delivering online training is desired, as well as the ability to tailor sessions to accommodate the learner's pace. Providing resources for additional self-study will be a significant advantage.

I am looking for a freelancer who can fetch data values from an app in real-time and send them as a webhook URL. Data Values: - The data values t...webhook URL. Data Values: - The data values that need to be fetched include text, numbers, and dates. Source: - There is a specific app from where the data values need to be fetched. Frequency: - The required frequency for fetching data values is in real-time. Skills and Experience: - Experience in web scraping and data extraction. - Proficiency in programming languages such as Python ,JavaScript,VB or C#. - Familiarity with API integration and webhook implementation. - Attention to detail and ability to handle real-time data updates. - Strong problem-solving skills to troubleshoot any issues that may arise during the data fetchin...

I am seeking a seasoned VB developer to incorporate a new feature into an existing VB project. Specifically, I am looking to add button functionality. Here's what I am looking for: -Experience in Visual Basic (VB) programming and software development. -Demonstrable expertise in integrating new functions into existing applications. -A high level of accuracy and attention to detail. If you are adept at code improvement and have a background in successfully implementing new features in VB projects, then this could be the job for you. I look forward to reviewing your applications!

I am looking for a .NET developer, particularly with VB experience, to embark on a comprehensive project featuring sales data processing and analytics capability. Part 1: Building a Sales Analytics Database - Database should be capable of processing and storing sales data that has been agregated. - The database should be designed around the analysis of sales data specifically. Part 2: Automating Data Feed - The developed system should facilitate weekly data feeds into the analytics database. - The data for analysis will include cumulative sales and sales trends over time. - Products that are selling with other products etc. Part 3: Sales over time specific graph - Create a console application which gets yearly trend data for specific products, per month for the last 12-18 months,...

I am searching for a proficient VB developer to adjust the volume of pre-recorded WAV files. Key Responsibilities: - Amend volume of existing pre-recorded WAV files to a prescribed level - Develop clean, efficient code in VB Ideal Candidate: - Excellent mastery of VB - Experience in handling audio files, particularly WAV format - Familiarity with manipulation of audio file properties like volume in a pre-recorded format - Timely delivery of tasks since I am running on a tight schedule - Proactive communication and problem-solving skills. Your task will solely focus on volume adjustment, no additional sound engineering skills are needed.

...(cubecart, oscommerce) database. I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the link I will provide and use this data for the export-import. Paradox DB files are in database folder. 2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it 3) review the mapping of the data fields between source

...(cubecart, oscommerce) database. I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the link I will provide and use this data for the export-import. Paradox DB files are in database folder. 2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it 3) review the mapping of the data fields between source

I am looking for a freelancer who can help me copy and replace a DLL file from one PC to another using Visual Basic 2008 Professional Edition over the network. The ideal candidate should have experience with VB 2008 and network file transfer. Requirements: - Proficiency in Visual Basic 2008 Professional Edition - Knowledge of network file transfer protocols and techniques - Ability to copy and replace DLL files from one PC to another Skills and Experience: - Experience with Visual Basic 2008 Professional Edition - Familiarity with network file transfer protocols (e.g., FTP, SMB) - Understanding of DLL files and their usage in Windows systems Timeline: - The project needs to be completed ASAP.

I am looking for a skilled Excel VB developer to create an application that integrates SAP data with other systems. The application should call the Master Data API in SAP S/4HANA using Excel 2016. Specific requirements for the project include: - Developing an Excel VB application to call the Master Data API in SAP BTP - Ensuring compatibility with Excel 2016 and SAP BTP - Integrating SAP data with other systems - Providing automation for data entry and generating reports Ideal skills and experience for this job: - Proficiency in Excel VB programming - Experience working with SAP APIs, particularly the Master Data API - Knowledge of SAP S/4HANA and its integration capabilities - Familiarity with data entry automation and report generation in Excel If you have the ne...

I am looking for a freelancer who can help me connect my MySQL database to my Excel spreadsheet on my MacBook Air. Operating System: Mac ODBC Driver: MySQL Connector/ODBC Excel Version: 16.8 Skills and Experience: - Strong knowledge of MySQL and Excel - Experience with ODBC connectors and drivers - Familiarity with Mac operating system - Ability to troubleshoot and resolve any connectivity issues between MySQL and Excel on a Mac - Attention to detail to ensure accurate data transfer between the database and spreadsheet

I'm looking for a freelancer to create a new form (no application) ASP.NET WebForms VB ONLY within a timeline of 2/3 days (test included). Informations are sufficient to provide an estimate (times and costs). No C#, no third party controls, no compiled objects. Write simple, straightforward code, without using complicated classes or data types Using free objects/sources freely available on the internet is really appreciated (and reduces testing and development time). ----- General info ----- We have 3 buildings. During our activities, some BU (offices) need to require something from a building to another. After use, they must send back what they used. The new form must must contains all fields that we need to fill. Usually: - who requires - who receive - what - price - w...

I am looking for a skilled developer to integrate my asp.net web form website with myFatoorah payment gateway. Here are the project details: Website Platform: - The website is built on asp.net (vb) web forms. API Documentation: - I can provide access to the documentation. Skills and Experience: - Strong knowledge and experience in asp.net(vb & c#) web forms development. - Familiarity with integrating payment gateways, specifically myFatoorah. - Ability to work independently and efficiently to complete the integration. If you have the required skills and experience, and can work with the provided API documentation, I would love to discuss further details and get started on this integration project.

I am looking for a skilled mobile app developer to create a Steel Bars Trading Inventory app for Android. The app should have the following features: Need a webapp/mobile app which can record daily inward and outward of steel bars in four locations by four users and give stock report and summary (Item/Date/Party Wise) Legacy Windows App (VB - Access - Oracle ) already available for idea amd functionality New App should also have function to record steel processing work done on raw material and related reports

I am in need of assistance with an error that is occurring when running a macro on VB. The error message states that a class is not registered. Skills and Experience: - Proficiency in VB programming, specifically in the version used by the client (VB A) - Experience with troubleshooting and resolving macro errors - Knowledge of class registration processes in VB - Ability to analyze error messages and identify potential causes for the error

...recommendations based on the analysis to inform pricing and product feature decisions Skills and experience required: - Strong proficiency in data analysis and statistical analysis techniques - Experience in collecting and analyzing customer reviews - Knowledge of e-commerce industry and competitor analysis - Attention to detail and ability to identify key insights from large datasets - I need python or Vb code to run myself. In future I will increase number of competiors and data frequency. -It would be good result gives different plots,Different KPIs and suggestion of best selling products based on my data. Sample csv data file is attached here. I have this type of data for particular interval. If you have the skills and experience necessary for this project, please submit...

Provide the VBA code in an Excel sheet to control an excel graph: => Manual inputs to the VB code in an Excel form: -Range of rows to graph: ex if I enter 250-1240 only row from 250 to 1240 will appear on the graph with horizontal axis showing values from 250 to 1240. -Graph all columns checked: list with checkboxes of all columns within the table. The columns being checked are graphed on the Y-axis. Check all/ none button available. The X-axis column is always the "Index" column. -Additionally to those being checked, graph all columns whose header in row 1 contains a given string. Ex: if "2251" is manually entered in the form, graph columns in the table whose header contains "2251" (4 columns). Multiple strings can be entered (separated with com...

I am looking for a Oracle VB developer to assist me with quick POC to prove some key functionalities achieved thru VB. Key requirements for this project include: - Experience in Oracle VB development - Proficiency in Service Connections and Business Objects - Strong understanding of UI components and custom business logic If you have the necessary skills and experience, please reach out to me with your portfolio and a brief overview of your relevant experience.

Scenario : I have a requirement to produce a spreadsheet which will have sheets for SUBSCRIBERS CURRENTLY ON THE NEWSLETTER, NEW ORDERS DETAILS, UNSUBSCRIBERS UNSUBSCRIBERS needs to be removed from the NEW ORDERS DETAILS sheet and produce...from the NEW ORDERS DETAILS sheet and produce a new sheet created ADD TO LIST SUBSCRIBERS CURRENTLY ON THE THE NEWSLETTER need to be removed from the ADD TO LIST sheet to leave unique users who have not previously unsubscribed. I will be using this spreadsheet weekly so it needs to be easy for me to update with NEW ORDERS DETAILS and then process. This will be achievable with Excel and macro's/VB I believe. I can supply sample data to suitably qualified freelancers to produce a demo. Any suggestions to make this easier will be certainl...

Installing ODBC on Windows for a beginner Skills and experience needed: - Proficient in installing programs on Windows - Knowledge of ODBC installation process - Familiarity with troubleshooting installation issues Project details: - The client is seeking assistance with installing ODBC on their Windows operating system. - The client has a beginner level of experience with installing programs. - They already have the necessary installation files and documentation. - The freelancer will be responsible for guiding the client through the installation process and troubleshooting any issues that may arise.

I need make some excel vb in a file I need to add some VBA script in a excel files Thanks

...scripting, PSADT Experience in Application Packaging – Windows and MAC Be responsible for the evaluation, validation, and execution of application packaging. Experience in MSI technology and standard operating environments and tools Expert Skills in common installation and packaging technologies (Silent Installations/Deinstallation Non-MSI, InstallShield Setups - Good command PowerShell Scripting, VB/Batch scripting. Troubleshooting experience on Windows OS platforms - Installer issues. - Knowledge of SCCM deployment. Good to have experience in Driver packaging. Qualifications and Work Experience Degree in Electronics/Computer/IT Engineering. 5+ years of experience in Windows and MAC Packaging Must have (essential) InstallShield PowerShell Microsoft MSIX Microsoft ...

I am trying to insert date for a new entry and to show a date for any updates in another cell. I have a VBA code but it will not run in the spreadsheet. New entries shall place the entry date in column L (DateEntered) and Column M (DateUpdated). Any future updates shall put Updated Date in the DateUpdated cell. Private Sub Worksheet_Change(ByVal Target As Range) ' Code to put the date of the latest update following a change Dim myTableRange As Range Dim myDateTimeRange As Range Dim myUpdatedRange As Range Set myTableRange = Range("A2:K20") If Intersect(Target, myTableRange) Is Nothing Then Exit Sub Set myDateTimeRange = Range("L" & ) Set myUpdatedRange = Range("M" & ) If = "" Then = Now End If = Now ...

Small excel task / vb script to create batch 'Names' and 'Refers To' in the Name Manager section from a table I have provided. Excel Sheet (name manager xls) is attached and provides in table showing each of these and have also added the Excel sheet (Final Call Forward) that these entries need to go into. I have also provided an image with example of where it is and how they are entered. As this is a small task I will offer $35 AUD to complete this.

Small excel task / vb script to create batch 'Names' and 'Refers To' in the Name Manager section from a table I have provided. Excel Sheet (name manager xls) is attached and provides in table showing each of these and have also added the Excel sheet (Final Call Forward) that these entries need to go into. I have also provided an image with example of where it is and how they are entered. As this is a small task I will offer $35 AUD to complete this.

I can provide you satisfied result with my high skills and extensive knowledge and full experiences very similar work with your project. Hello! ⚡️ I am a skillfull expert in Software Developing ⚡️ I have full experience(+7 years) and good skills in software developing. ✅C/C++/C#/Java/VB/MFC/STL✅full experience of Software Development. My proficient knowledge and full experiences assure high quality work. *** I am always online so that contact at any time. *** I will do my best to provide the results you are looking for. We can discuss about the project more. This assures my work. I will do my best for you

Below is my current code (ASYNC FUNCTION) that does not work ! Response always false ! Public Async Function UploadImageAsync(imagePath As String, altText As String) As Task Using client As New HttpClient() Dim usec As String = Para(Val(TermNumber), 483) 'for testing hard code para 483 usec = "|ck_key |cs_key" If DatabaseUSE = 2 Then usec = Para(Val(TermNumber), 535) End If If DatabaseUSE = 3 Then usec = Para(Val(TermNumber), 601) 'shopify info End If If InStr(usec, "|") = 0 Then Exit Function End If Dim keysN() As String = Split(usec, "|") keysN(0) = LCase(keysN(0)) Dim myString As String = keys...

hi , i have VB dot net project done for gold loan desktop application. The software is 90% complete. The application is saas model. Checkout all the bugs and get the project completed. Start your reply with "redo" to consider your offer. Developers with expertise and experience will only be considered.

1. Remove 'Summary' Tab / remove coding relating to it, without effecting any existing code. 2. 'DropDown' tab - When you change the number circled in image attached , it does not bring up the suppliers (corresponding to that cc# in the 'Template' tab. I need instructions on how I can edit the numbers in the VB script so that it allows me to select the number from the drop change the numbers at the top and for it still to be working the same way. 3. 'Template' tab. I need script written to allow Tasks to be searched in the B column without having to scroll. The condition will be that any code is written is not to effect any functionality of the worksheet. Search is search for text on whole page and act similar to the native Ctrl + F sea...

This is a SUPER SIMPLE fix for an experienced VB developer. I have a VP app that downloads photos from a website. It recently stopped working. A few lines of code changes should fix it. To be considered please answer these questions in detail: 1) What is your experience with VB and VB.net? 2) Can you fix this now? 3) How is your written English from 1 to 10 (with 10 being fluent)? 4) How is your spoken English from 1 to 10 (with 10 being fluent)? *** You will only get a reply if you have answered the above questions ***