Odbc iseries signon1 jobs

...with the other dataset info in the visualizations by a categorical variable. Phase 2: 1. Investigate why I am unable to put certain variables into visualizations such as the scatter plot which were able to before. 2. Why do I get Error message when refreshing: “The Column [Column Name] of the table wasn’t found” when the column is there I verified it? 3. Why do I get an Error message: “OLE DB or ODBC Error” when refreshing. It seems to occur due to tables being related to each other. 4. How to fix circular dependencies errors. 5. Provide all documentation for codes and data prep. Description of the datasets: They are exported straight from my MLS system into a CSV file. Records amount to 300 to 900 new records per day. Provide at least 90 days o...

The excel workbook has vba macros. Currently uses ODBC for windows to connect to mysql db from excel workbook. But it doesnt work with excel for MacOS. Need someone who understands both excel and mac.

I need help resolving an SQL updates statement to write an OLE object type to an ODBC Firebird database.

Set up docker script to build and launch Apache Kylin 4.0.1 with Spark 3.1.1+, Hadoop 3.2.0+, Hive 2.3.9+ and use YARN cluster manager. Also, set up file to run this Kylin docker image. The script needs to be built on Ubuntu 20.04 and it should...Also, set up file to run this Kylin docker image. The script needs to be built on Ubuntu 20.04 and it should be demonstrated that Kylin works well with example data. Before this project ends a test needs to be run on my server to make sure it works as expected. As part of the project an Excel pivot table needs to be set up to allow browsing the cube live. A combination of the ODBC driver and Mondrian XMLA needs to be used to achieve this. See the following link for more details.

...database work in tables, for example I have a “users” table in MySQL but in SQL the table is “”, is not problem for me to change it in the users model and works correct, but I can´t do it in the “authManager” process, I mean the access, roles, login processes, that use some tables like “x_auth_assignment” and others that don´t have a model to manage this, the I obtain result like “[ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'x_auth_assignment'” My requirement is if I can change them with minor changes What I already did: - database migration to SQL server - database connection with SQL server with a correct driver - possibility to use my own tables with the sql server schema Wha...

We Need A Sage50 Query Created That Will Report On Ship Status Of Sales Order Lines (Qty Ordered, Qty Shipped, Remaining Qty To Ship) As Well As The Respective PO Details For Those Sales Orders Showing Qty Ordered, Qty Received and Remaining Qty Received. The PO Records In the Sage 50 JrnlRow Table Have A Link To The Sales Order Number To Link The Two Together. The report should show all ...JrnlRow Table Have A Link To The Sales Order Number To Link The Two Together. The report should show all sales order lines whether they have been partially shipped, fully shipped or not shipped at all. The PO details should show similarly lines that have been partially received, fully received or not received at all. This SQL (actually a Pervasive database) Query Will Be Used To Run A Report Via ...

Hello, I would like to connect an aveva data base with postresql i can connect the data base of aveva with that one of postresql with odbc actually, but the data and the tables are not created automatically. I was working with MySQL the data is generated automatically by my scada but it is not displayed on postgresql . Thank for your help.

I have an existing Azure MySQL database I would like to connect to Microsoft Access as a front end preferably. If not possible or fairly simple, looking for a way to connect to either Excel or Google Sheets. Please include in your proposal how often you have performed similar tasks/projects and preferably so...database I would like to connect to Microsoft Access as a front end preferably. If not possible or fairly simple, looking for a way to connect to either Excel or Google Sheets. Please include in your proposal how often you have performed similar tasks/projects and preferably some evidence of that experience with either suggestions of how you approach this. I tried using a ODBC connection string in VBA but Azure doesn't provide ODBC connection strings for MySQL...

We use NetSuite ERP and would like to do advanced reporting through PowerBI. We have a few projects to develop informational dashboards in Power BI for the business. Looking for an expert whom has Power BI and NetSuite knowledge to help us achieve the goals.

Need a secure login for Access front end to link to tables with ODBC MYSQL backend in cloud. If not succesful login, user should not be able to see any tables, or open forms to see data.

...danych i pobierać dane wskazane w konfiguracji za pomocą odpowiednich selectów. Pobrane dane powinna wstawić w odpowiedni szablon pliku i wygenerować cały plik według szablonu uzupełniony tymi danymi. Nazwa pliku powinna być określana w konfiguracji i składać się z odpowiednich sekscji. W konfiguracji powinny być do zdefiniowania : - typ bazy i połączenie do niej według wybranego sterownika bazy lub odbc - sekcje nazwy pliku (np. data+kod towaru) - typ pliku (tekst/QR) - pozycja X - pozycja Y - wielkość czcionki - pole tekstu, które umożliwia wklejenie odpowiedniego SQL pobierającego odpowiednie pole z bazy - ścieżka do generowania gotowych plików - opcja kasuj stare pliki/oznacz jako archiwalne W przypadku zwrotu kilku wyników dla każdego powinien być...

1- create a 128 bit AES symmetric key Base64 2- Use the key (1) to encode a password and a timestamp, using AES, Model ECB, PKCS5Padding, Base64. 3- Encode the symmetric key (1) using a RSA public key (pem), output Base64.

DEVELOPMENT TIMELINE : SIX(6) WEEKS FUNCTIONAL SPECIFICATION 1. Upload Sales Data Transfer sales data from odbc compliant datamart to the LMS platform via web api. 2. Integrate loan disbursement requests Create background service to monitor both databases. Service must identify when a new loan agreement record is generated on the LMS platform. Use agreement information to create a loan payment in Sage 300 ERP via API. Once the disbursement payment is posted in Sage 300 ERP, create a notification on LMS platform as confirmation that the disbursement has been completed successfully. 3. Integrate loan Invoice & repayment After the notification is sent, pull the loan repayment info from the LMS and create an AR invoice in Sage 300 ERP via API. Each week the loan ...

...1st option (tag cost included in your bid). Use built-in camera as a sensor wherever possible. The writing of printable codes will be done via wi-fi connected print devices. NFC, Mifare, Beacons and RFID will use their respective tags. The read/write data will be presented to user on cell display and option to stream out (allow separation of fields, if needed) via XML, Json, Websockets, , ODBC or other modern ways etc. also. Provide a clean, hook for future external apps or any extensions to this app to interact with this app as API, library etc. so it can be embedded into another Windows, mobile or web apps. A Windows app is needed to allow us to use as a virtual simulator to help determine the readers/tags layout for actual system Please submit some related job details of work...

...databases etc on DigitalOcean (DO) virtual machines (i.e. droplets). At certain points I need help from an Ubuntu expert. My current problem is as follows. I have an PostgreSQL database and another virtual machine on DO. To access SQL from the virtual machine I need to install ODBC driver using the following codes: sudo apt-get install unixodbc unixodbc-dev sudo apt-get install odbc-postgresql sudo odbcinst -i -d -f /usr/share/psqlodbc/ sudo odbcinst -i -s -l -n adyoung-pg -f /usr/share/doc/odbc-postgresql/examples/ sudo nano /etc/ The codes worked perfectly for a previous installation but not working now. I can see the folder for the ini file from the console but I need help to successfully run the codes it on Ubuntu. I am looking for an expert

Need an expert that knows really well VBA Excel Macros to create one for copying a sheet to MySQL through ODBC connection. The macro will be assigned to a button on the sheet. I will provide the sheet and the MySQL table schema. The sheet contains about 9 columns. Prior to inserting the data on MySQL the VBA script will need to query the MySQL database for additional information for the transaction (insert). Need this done in 1-2 days.

ODBC - Mac, Linux and Windows.

I need to offer my clients, ODBC access from Mac, Linux and Windows - to my Middleware Server. The API to the Middleware server, is over TCP/IP, on registered port 2874. The bare minimum API consists of 6 calls, AUTH, select DATABASE name (or show DATABASES), EXECSQL w/o Resultset, QUERY SQL with Resultset. To develop, you will need to present me with your public ip (see: to get it, so I can open firewalls to give you access). You can also go to to download a local copy of the server and my test client - Windows 32bit binaries of each. I will need all of the pieces (source) so I can compile and supply to my customers.

We have a script that processes 250,000 transactions every 15 minutes, it's been running correctly for over 2 years, but now it has stopped working. Currently script runs till a certain function logs a ODBC time out error and proceed to get stuck in a loop. The script is written in visual basic and uses windows scheduler to run. You will be required to work remotely on a Windows server and investigate why the script logs ODBC time out error logs the error and then get stuck in a loop. The script basically takes data from MSSQL, does some checks then uploads it to MYSQL. Only experts need apply for this role, must be able to work immediately. Webserver admin and windows server admin is beneficial but not 100% required. Job Spec, we would like to achieve 1, Find ou...

We have a MSSQL database that contains some store procedures inside. we are developing a site with a third party tool that connects to that database through an ODBC connection and datasource. we have no problem querying the data with direct SQL sentences using the tool and the ODBC connection, but we need as expert SQL programmer to write some queries that will return the result of those store procedures into the tool we are using with normal SQL queries. The work need to be done immediately and will be done through AnyDesk or any other collaboration tool. the programmer will take over our machine write and test the query on the environment as well and will get paid immediately. for an SQL expert this will be a matter of minutes

We are looking for a simple way to access a Opentext Gupta SQLBase with Python. Unfortunately, access with ODBC is not possible for us, so we need a Python implementation for access via the SQLBase C API. The implementation should be compatible with the Python DB-API2 standard, but is currently only required for Windows. () As far as I know, the SQLite implementation is usually used as a template () Attached you will find the: - SQLBase C-Api documentation - SQLBase C header file - Two test files with my first successful attempts to access the SQLBase A demo version der SQLBase can be downloaded from Opentext (

Hi all, I am a freelancer who requires a Tally Expert for one of our projects. We need a technical discussion for a solution. Sound knowledge on sales and Inventory on Tally ERP and Tally Prime Need to have experience in tally ODBC Drivers

This project contains 4 milestones: Milestone 1 Setup fully working Asterisk 18 as Docker container with ODBC MySQL remote connection: Dockerfile Asterisk config files Milestone 2 Migrate existing Asterisk application (dialplans, extensions, trunks, bash scripts containing Asterisk commands etc) from Asterisk 11.7.0 to Asterisk 18 container from Milestone 1 with MySQL connection to a remote MySQL server/container. Milestone 3 Review existing design/architecture of PHP applications - Asterisk interaction and provide feedback, improvements and best practices. Milestone 4 Install and configure a new SIP connection with a remote 4 SIM cards GSM gateway and configure the dialplan to add this SIP connection into the existing dialplan and application: set priorities between existing ...

Here is the situation: Web and database (Microsoft SQL Server) servers are on Amazon. Code is written in php5 The code to DB connection is through odbc The problem is that it only allows 1 active record, so you can't run second query unless first query is closed. We need to find a solution to this, as it is working fine on production server. Note: We don't have access to production server This is not a programming job, it is server setup job.

We are looking for an MS Access and Excel Guru with an expert level of experience in VBscript and Macros. We have an MS Access database with data extracted from MYOB using ODBC and from WMS (Warehouse management system) using SQL. We need someone to fix queries and errors and increase performance and automate to archive old data.

Install ODBC and PDO drivers on an Inmotion VPS server.

I have a very simple and small Visual Basic app which is used to run a query on a Sybase SQL Anywhere database via an ODBC Data Source (32 bit ). This app is not working on Windows 10 64 bit. I need someone to update the source code which I will provide so that it will work. I can also provide an installer for the SQL Anywhere Database and a sample DB

Current system accesses few DB2 queries using ODBC connection. The requirement is to provide GET API instead. Also, RPG XML suite must be used

We require a savvy, expert web developer who is fast, efficient and cost effective. This project is for an E-com...thereafter. Database – The developer needs to have expertise and robust skills in database design and management. We need a modern user-friendly Admin Panel to manage our product inventory as well as our Customers and Orders on the website database. BOTS – The developer needs to develop BOTS to automate exchange of data between our website, online markets and our telesales in-house order databases via ODBC API. Graphic Designer – The developer needs expertise in graphics design to create the Home Page, Product Pages and Item Finder pages. This is also an ongoing opportunity to continue IT development projects with our business for the right expert ...

We have a currently working ODBC from SQL to Access. Looking to automate the data from SQL to Access instead of using a manual macro.

Need a expert asterisk developer to work consistat on numerous projects must have he must have experience of 5 years minimum work experience on asterisk dial-plans Work experience in asterisk odbc connection Work experience on SIP protocol Chanspy and other areas

Looking for a seasoned RPG developer who is an expert in iSeries commands and utilities to write a subfile application with a Header and Detail file to store and maintain copy information to copy a single or multiple files from one iSeries system to another using DDMF. This utility would have a function key that would bring up the list of files in a library from which a user can chose one or multiple files to be copied. That configuration gets saved in the Header and Detail file to be used again in the future. This is a very small project but is urgent. Please provide your best quote (fixed amount only).

We are using a custom connector (Devart) for SSIS which help us fetch the data from Magento 2.0. For some reason, we can not view the data in sales order table and some of the table (support ticket table) is not visible to us. We asked the expert and they said the connector is fine but there is something wrong with t...(support ticket table) is not visible to us. We asked the expert and they said the connector is fine but there is something wrong with the API/connection method. We need someone who understands the Magento and helps us connect the database get fetch the data from the sales order table. Goal: fetch the data from the Sales order table and "helpdesk" table. Any other co Option 2: help us configure ODBC for mysql on our windows server to connect Magento underl...

We are a small non-profit art gallery, and we have a gallery shop in Shopify. We...people update their details in their shopify account. We also have membership dates stored in MS Access: join date, renew date, and expiry date (can be 1, 2, or 3 years from renewal/join date). People can buy a membership in Shopify, and we would like to update the MS access contacts with their new dates. We have been able to get the shopify tables into MS Access via linked table manager using ODBC. (We use a driver from CData, you can get a free trial to assist with development). Experience with the shopify tables would be preferred but not necessary. The main work is writing the SQL Update Query. The info required seems to be across 4 tables in Shopify: Customers, Customer Addresses, Orders, Ord...

I need a person who can transfer data from ODBC server to cloud server.

I am looking for a generic Java solution to connect with ODBC sources. I have multiple remote ODBC data sources that I would like to connect via to only read data. Requirements- The connection has to be made remotely. The solution has to be implemented using pure Java (and maven) Solution has to work on Java 11 and above Deliveries - Working solution concept Working code Working demo

-Powershell - C# .Net - Mulesoft Data migration - Salseforce - ODBC - Webservice - Cloud deployment

We are a Tree Nursery based in South Africa We manage quite a big stock list with 65 species in 6 different sizes in 1700 possible locations. We currently report on our stock using excel spreadsheet (ODBC connection from SQL) and pivot tables Database/Spreadsheet is now too big (1.4m rows x 20 columns) and pivot table is extremely slow to report/refresh We need someone to develop a "live" Stock Report using the data. This report will help us manage our current stock as well as be accessible to our customers to check on our availability .

I have a strong idea of what the front end interface of the tool should look like and have identified a few open source projects that tied together would make a comprehensive solution for small business owners. I nee...business owners. I need the following: The data structure mapped and performant for querying and use in live data visualizations (Postgres or TimelineDB) Assistance using the client server API for matrix to edit and connect a front end interface with the back end Data visualization in chartJS, D3 or other data visualizer software integrations with other databases for pulling in information - using ODBC Deliverables These may be separate projects or sub projects but here goes: about 15 screens from a pre-built web design package we bought hooked up to our back en...

Create a odbc table where the salesman name is one of its column. I have a collection code need to edit the code and make it workable based on requirement.

I can not get my PC to connect to an SQL server database using ODBC. I have tried other computers running Windows and they get connected without problems. However, my PC seems to have a setting activated that makes the ODBC drivers to behave wrong. So far, I have tried many ways to solve the issue: 1. Remove ODBC drivers and reinstall them 2. Using all sort of variations of the connection strings (changing ports, tcp on, tcp off, default database, etc) None of them work. All the other computers work just fine and I do not want to reinstall Windows on my PC as I believe it should be a matter of just one simple change to my PC (maybe on the registry) made from someone with deep understanding of ODBC, Windows, SQL connections.

I Requred A Window Based Software in Python will get data from a tally software ODBC. Request will send to tally ODBC And Responce should be save in My SQL (Sagricated Data) You Hav eKnowlidge About Accounting Software so you will get easly on software signup with software. login user have diffrent data 6.i requered DATA in Form Of Ladger, mobile number address software not requered very much coding but good knowlidge can made it easy. share if you have any Work Experiance Should Have knowlidge of Python XML SQL little bit knowlidge about Tally XML Request And Responce Tally Info easly available on tally website. i need it urgent basis. 10. All software look like a Branded Product. software sync pc to my sql time to time or

I am having difficulty downloading the latest ODBC Driver 13 for SQL server. I have had a freelancer do some work for me that involves this driver and whilst the the program works on his computer it does not work on mine. We have narrowed it down to this driver as he has a 2017 version and I have a 2015 version. When I download the latest driver from Microsoft my version does not change. I need someone who can help me get the right driver onto my computer. This process needs to be replicated for a bunch of other computers that will be using the program.

...product. The second HMI will receive weight through RS232. The third HMI will be designated (for the plant) as the main controller and will provid the most information, including grade, location, and drop. The final HMI will be primarily display, showing grade of product via color selection. All HMI's will be programmed with Win 10 as OS. Contractor will be providing customer with reporting via ODBC/JDBC interface. This is not part of scope, but may become a Phase 1.2 based upon customer need. Phase 2, upon completion will include an outgoing scale. more details will be provided. Potential Phase 3 will include RFID tracking. Phase 3 has only been discussd and not a given, so system must be enabled to track product through counting of photo sensor triggers....

I have a SQL query that returns data properly in Data Management Studio. Target Server is SQL 2016. I need a way to run the same query and have it target a ODBC/server and produce the results in a CSV file with a specific naming convention plus the current date in the name. The query I wrote that works and only calls the columns I need with the altered naming conventions. In the end I need a PowerShell or script to run via Task Scheduler everyday on a desktop and save the data (csv) file to a specified location.

I need to pull all data from a table in a Faircom DB, but the query errors with "21029 CTDB - InvalidDate" I need a query that will skip errors and continue with "SELECT * FROM table" You will not be provided access to this database as it contains confidential information. You will need to simply write an SQL statement that skips errors in Faircom.

Hello Vladan, are you interesting in writing an odbc code for generating an sql schema on any sql dbs? Br. Mohamed

Hello I know how to connect with mysql (appache) but i need connect to my server with sql server. Need connect with ODBC or SQLSERVER. Please help me

To setup ODBC in Quickbooks Enterprise

SAS tool upgrade : • SAS Platform / Base SAS 9.4 M5 • SAS Enterprise Guide 7.1 • SAS Enterprise Miner 14.3 • SAS Analytics Pro • SAS/GRAPH • SAS/STAT • SAS Metadata Server • SAS/ACCESS Interface to Microsoft SQL Server • SAS/ACCESS Interface to ODBC • SAS/ACCESS Interface to Oracle