Odbc Projects
Looking for freelance Odbc jobs and project work? PeoplePerHour has you covered.
Post an offer to educate them
Past "Odbc" Projects
Visual Basic software API development with Postgresql
Visual Basic software API development with Postgres and LIMS integration. We have a basic Visual Basic .NET API and documentation to connect to a Laboratory analyser We need someone familiar with Visual Basic .NET APIs and who also ideally knows Postgresql. If you know Postgresql you would read and write to a DB using an ODBC connection If you don`t know Postgres you could read and write files Partial documentation is extracted and attached - there is some more documentation available
PowerBI connection to Nesuite
Hello, I'm a business consultant looking for a specialist who has experience with setting up PowerBI to connect directly with Nesuite using an ODBC license. The setup at Netsuite end is complete however I am looking for support to complete and troubleshoot the connection so that existing dashboards (built off excel reports from Nesuite) can be migrated to live data from Netsuite direct. Look for someone ASAP to complete work.
Docker engineer required to bug fix a docker build error
I have a dockerfile that builds a Laravel App and has worked until recently when the build started failing. I need an engineer to bug fix the build fail. The Dockerfile: - Builds PHP Alpine Installs MS ODBC Driver for SQL Server Verify's signature Installs apk packages Installs extensions Installs my Laravel app The bug is somewhere in those steps in the Dockerfile. I can grant access to the repo through a Personal Access Token.
opportunity
SQL/Access/Word Template help
I have bought a piece of database software (Landlord and Letting Agent Manager by https://www.propertyportfoliosoftware.co.uk) and it creates invoices but the software does not let me amend the invoices to the look and feel I require. One of the database programmers was kind enough to give me the SQL query which will pull through the fields I require to create my own word template. Given enough time I'm sure I could create the invoice I require but I'm busy with my job and very rusty in SQL/Access. I need someone to create the word template and tell me what I need to do to run the query through ODBC ?
Excel Macro to automatically send emails
Hi Please see attached screenshots from the old template which needs fixing. The Macro simply needs to be updated so that does not link to the other tabs. Need this completed by Sunday evening UK time. PPH would not let up upload the file format so I can email upon request. Purpose of the report/workbook Send employees are adjustments to their pay before it is submitted. It is received as a PDF in an email attachment. Original Macro settings The blue tabs I believe are where the macro mainly works. The Template tab shows the fields that the employee sees The employee gets a PDF report attached to an email which they can review Had the option to send emails automatically or one by one so you can review them first. This setting needs to remain The create emails button on the main tab will generate the email and would work with outlook The task The report needs to work if all red tabs are deleted Template page needs to be amended to add all column headings in 'Additions Deductions' tab Month and other info to be moved to 'Additions Deductions' tab rather than Criteria tab If you have a better way of doing if please suggest The workbook originally worked on the data being linked to an HR system database called 'Simply Personnel' and the queries were added to the tabs running ODBC drivers. The system have not changed and the databases do not exist which is why the file does not work. The original Macro was designed to get data from those tabs and add to the 'Additions Deductions' tab. * Red Tabs - will need to be deleted but have not been deleted so you can understand how things worked before. Delete when return the workbook * Purple Tab - The macro needs to to work with this tab. This is the main tab. All headings in this sheet need to appear on the report to the employees * Blue tabs - Believe these are needed for the Macro * Orange tab - Leave in file
pre-funded
MSQL Server - Create Linked Table with 32bit ODBC Source
This project is specialised. The task is to create a 'Linked Tables' in Microsoft SQL Server from an ODBC Source. Sounds simple? The ODBC Data source is a 32 bit custom driver made by Elevate Software - DBISAM. The MSQL Server is of course a 64bit machine. The ODBC data source is accessible through many applications including Visual Studio so it must be possible to create a linked table in SQL Server. The reason for creating a linked table is to allow easier app development by apps connecting to the Microsoft SQL Server and running queries that are in turn run on the DBISAM database - thus removing the need to keep connecting to DBISAM directly. This task should be really easy for anyone who has done this before - should take less than an hour for someone with experience. Candidates must demonstrate experience in creating such a connection. Many thanks
pre-fundedurgent
VBA Bespoke Macro - inc Interaction with another Windows Program
Hi All I have another Project. This one requires advanced VBA Skills. We have a working Excel Macro which is great - we want to extend its functionality to interact with another Excel Sheet (that contains data from an ODBC Source) - AND is able to interact with another windows application - clicking and typing - so that that application can in turn create a CSV that set actions can be run on in excel. Easy? Get in touch! I prefer to work one on one using TeamViewer. Potential candidates must me lone freelancers - Informal Interview may be required. Pay is negotiable based on experience. Best of Luck!
pre-funded
VBA module required to create a scrolling dashboard
I have a dashboard built in Excel which shows a list of jobs with planned time and actual time worked on them. This is to be displayed on a large screen in our workshop for supervisors to refer to in order to track jobs. The workbook uses ODBC links to an underlying database which refresh every 15 minutes. I have written VBA modules to calculate one of the fields in the dashboard and to run refresh all every 15 minutes from the point the workbook is opened. The problem I have is that there are more fields in the dashboard than can be displayed on one screen. I therefore need to write a VBA module that scrolls the dashboard (like the departures board at an airport). I have written one but it creates an infinite loop which I am concerned will crash the workbook or prevent the "refresh all" code from running every 15 minutes. The key requirements are as follows: 1) I need the code to start automatically once the "refresh all" code has run; 2) I need it to stop every 13 minutes so that the "refresh all" code can run successfully, or at least to run in a way that does not interfere with the "refresh all" code; 3) I need the screen to always show data in every row (ie the last screen in the loop should not show two or three lines of data and then 50 blank rows); 4) I need to be able to alter the time that the loop takes between scrolls based on user feedback; 5) I need to be able to alter how many rows that the loop jumps in each scroll (as I do not yet have the screens set up, so don't know how many rows will fit on the screen at the desired resolution). 6) The dashboard is filtered to exclude jobs with 0 actual hours (ie jobs that haven't started) and to only show jobs for the relevant department - the scrolling needs to work with these filters still in place I've uploaded the workbook with the macros disabled and the ODBC links removed. If the existing VBA modules are not visible please let me know and I will upload them too.
Dev/Admin needed to install a PHP app on Windows
I've got a Windows machine with SQL Server 2019 and I need someone to: - - Download and install TeamViewer (www.teamviewer.com) to connect to this machine - Download, install and configure PHP 7.3. - Configure IIS to host the PHP app. - Configure an ODBC connection for the PHP app to use to connect to the pre installed SQL Server 2019. - Send a screenshot of the PHP app login screen on the machine to show it working. I’ve attached a screenshot of what login screen looks like for the PHP app and I’ve put the PHP code in C:\aj\ on the Windows machine.
Dev/Admin needed to install a PHP app on Azure Windows 2019 VM
I've provisioned a Windows 2019 VM with SQL Server 2019 in Azure and I need someone to: - - Download, install and configure PHP 7.3. - Download and install TeamViewer (www.teamviewer.com). - Configure IIS to host the PHP app. - Configure an ODBC connection for the PHP app to use to connect to the pre installed SQL Server 2019. - Send a screenshot of the PHP app login screen on the VM to show it working. I’ve attached a screenshot of what login screen looks like for the PHP app and I’ve put the PHP code in C:\aj\ on the Azure Windows VM.
Fix problem with ODBC connection from Access to Mysql
Since I moved to a new computer, the first 10 records in mysql tables all show as deleted, and when I longer pull up a single record using an Access query, the Msql table shows that record as deleted. This is true for all tables and all single records. That was never a problem before. I use Office 365 for Access and I reinstalled it on the new computer, so this problem could be something in an updated Access version or something in the new ODBC options available in Access. It could also be the ODBC version I use. There are several options, more than I recall in Access on my old computer.
Connect MS Access to SQL database as linked table
There is a client database in a Website portal as SQL. I need to connect to this database as ODBC or similar, providing a link to this database. Part of my team there is a developer with the ability to change the server settings. The issue i am having is when connecting with Access i am receiving this error. "Your login account does not have the permissions required to make this operation".
opportunity
I need help connecting a to a linux box using ODBC
I have a linux box hosting a MySQL 5.6 db which I connect to via SSH and terminal. I also have a windows 10 VM with MySQL ODBC driver and Excel. I need help with configuring the box / Windows VM such that I can access the Database directly from Excel. I can connect to another box that is left open (i.e. no SSH) hosting the same db. I can't when the box has security. **MUST BE WILLING TO COMMUNICATE VIA SCREEN/SHARE, TELEPHONE CALL**
I need help connecting a to a linux box using ODBC
I have a windows machine with MySQL 5.7 driver installed on it. We have a MySQL 5.7 database hosted on an Azure Linux Box. I can connect to the MySQL server directly from Heidi SQL using the SSH option and plink. I would like to configure the windows machine such that the ODBC driver is able to connect to the machine in order for Excel to be connected to the MySQL server on the linux box. I think it can be done by configuring the SLL options of the MySQL ODBC connector or by creating a SSH tunnel. I envisage a telephone call and screen-share will be enough to resolve this matter with someone who is an expert.
SAGE TO XERO MIGRATION
I am looking to move from SAGE to XERO. Lots that is good, but can't get my head around a few things. KEY is the whole issue of projects, and allocating costs and revenue to certain projects, which we initiate in ACT, though we can import these via an ODBC and then CSV. I am evaluating Zahara for purchase orders and expenses and I am very happy with the way that is going, and want to include this in our suite of software. The final issue is selecting a package for expense management for our engineers. To date I have failed to find a package that can handle this allocating an expense to a job, to a nominal and to a card / cash. The objective is to improve the workflows and visibility that these packages provide. Budget I am yet to fully decide, hence the hourly rate. A good implementation will be well worth it.
Remote odbc configuration for SQL server Express 2008 on AWS Windows 2008
Hello, i have a Windows 2008 server with an SQLserver Express database on it. I want to set up an odbc to access remotely to the database. I can give you the credentials to get a remote desktop. The delivery must be a documentation to show me what are the good parameters on the serrver, and how to set up the ODBC on my laptop.
Remote odbc configuration for SQL server Express 2008 on AWS Windows 2008 server
Hello, i have an Amazon Windows 2008 server with an SQLserver Express database on it. I want to set up an odbc to access remotely to the database from internet. I can give you the credentials to get a remote desktop. The delivery must be a documentation to show me what are the good parameters on MY server, and how to set up the ODBC on MY laptop. I do not want a generic method or youtube video. I want a good fee lancer on SQLserver settings and Windows network settings (port opening in the firewall). To check if the job is done, the free lancer must abble to send a sql query from his own laptop via ODBC reaching my server Amazon. Please be honest with yourself and do no try to lie. I guess that a specialist on the topic can do the settings in 30 minutes and the screen shot in 15 minutes. If you are not confident with this time evaluation, please do not reply to my offer.
Core Oracle Expert
Dear All , we need someone to look into the Oracle 8i database unicode issue . The issue is with the Arabic character are coming in the form of boxes [] and question marks (??) in the SQL developer and also in the excel (when we connect with the ODBC driver) . But same Arabic text looks fine in the oracle form application . All we need is to display correct arabic data in the sql developer , may be its an issue with the NLS_lang variable or something like that . You have to figure it out and fix it without disturbing anything .
Core Oracle Expert
Dear All , we need someone to look into the Oracle 8i database unicode issue . The issue is with the Arabic character are coming in the form of boxes [] and question marks (??) in the SQL developer and also in the excel (when we connect with the ODBC driver) . But same Arabic text looks fine in the oracle form application . All we need is to display correct arabic data in the sql developer , may be its an issue with the NLS_lang variable or something like that . You have to figure it out and fix it without disturbing anything .
Cannot install MySql driver
Cannot install the MySql driver 5.3 on my co-worker computer. It is probably an easy fix for many sql experts but it already consumed a working day to me, trying to find a solution. Anyhow the error is the number 126, returned when trying to set up a MySql / ODBC connection on a Win10 machine. The error states that the myodbc5w.dll is missing, but I can see it in the MySql directory, and no errors were raised during the driver installation. Thank you