Link access to sql server työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). -------...

Access-tietokanta, joka sisältää tiedon syöttämistä, raportteja ja mahdollisuutta muokata tietoja.

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

server optimisation

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Project Background: We envision an innovative platform designed to transform how organizations, including startups, nonprofits, researchers, and small businesses, search for and apply for grants and funding. By leveraging advanced AI technologies and a user-friendly interface, it aims to simplify and enhance the funding acquisition process. Objective: The primary objective of this project is to develop the Minimum Viable Product (MVP) using the Bubble platform, incorporating the capabilities of the Perfect AI Software Template. This MVP will validate the concept by offering essential functionalities such as AI-driven funding opportunity matching, interactive user profiling through an intelligent quiz, and efficient application assistance. Scope of Work: The project e...

...his team PROBLEM STATEMENT Due to missing connection to database, the website on clients local machine is generating errors thus preventing development. SOLUTION: Create a replica of RDS production server (to be called "dev") on AWS, that can be used for development on local environment and for staging testing later on. CONTRACTORS ANTICIPATED TASKS (high level) 1. Take backup of production database on AWS 2. Create new RDS instance (server) using the backup and restore the backup. 3. Configure and verify the network settings to make connections over internet. 4. Test connection of new dev database with web application on local environment. DELIVERABLES 1. Demo showing the website on local environment working with new "dev&qu...

...three core user roles - Admin, Doctor, and Subadmin. The Admin will have the highest level of access and control, managing user roles, form submissions, and payment links. The Doctor will primarily be responsible for filling out forms and creating payment links. The Subadmin will receive completed forms and process payments. - Admin Capabilities: The Admin user should be empowered to manage user roles and permissions, view and edit all forms and payment links, and generate reports. This will be crucial for maintaining the system and monitoring its performance. - Doctor Responsibilities: Doctors will be primarily engaged in filling out forms and creating payment links. They should also have the ability to view responses provided by Subadmins. This project requires...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This process will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion ca...

I'm currently experien...website. Key Requirements: - Fix database connection errors causing website load problems - Ensure the website is running smoothly and all features are fully functional - Full access to the website's hosting account and database for troubleshooting - Clear and timely communication using instant messaging for updates and feedback Ideal Skills and Experience: - Proven experience in resolving database connection errors on Wordpress websites - Strong understanding of database management and troubleshooting in Wordpress - Excellent problem-solving skills and ability to work efficiently - Previous experience in instant messaging for client communication is a plus Had issues like this before. It was fixed in 1 hour by the right freelan...

I need a straightforward solution that allows users on both Windows 10 and 11 to download documents via either email or browser links. Project description: Set up Win10/11 so that the download starts comfortably when you click on an FTP URL link on a website (various browsers) or in mail clients (e.g. Thunderbird). After setting it up once, it should no longer be necessary to enter the FTP access data again. The FTP server expects Explicit SSL/TLS (port 21). The link/URL typically has the following structure: ftp://ftp_username[at] Either the user should be asked where he wants to save the download file, or it is permanently saved in the settings. Ideally, well-known applications are used for file transfer, such as WinSCP, FileZilla or MS...

I'm in need of an expert in VB.Net webforms to create an HR job portal for me. The portal should incorporate the following features: - I also want learn this - A job search and filtering module, allowing job seekers to find suitable positions. - An option for resume submission, where job seekers can upload their CVs for potential employers to view. - A company profile section to provide a brief about various potential employers. Within the platform, we'll have two distinct roles: job seekers and an admin role. The admin should have extended access and capabilities to manage all activities on the portal. The layout and design should resonate with a professional and corporate feel reflecting our business nature. We favor a design that i...

I have migrated my website to Amazon AWS EC2 Site has been migrated using duplicator plugin for wordpress successfully The migrated site can be opened by setting IP on your computer with hostname (if you do not set the IP in hosts file you will go to the live site that is not giving any problem) Once you go to (after setting the virtual host IP on your computer) you can see that only homepage opens other links are returning a 404 error. That is the problem that needs a solution I can give you SSH access to the linux on AWS I have tried all solutions from google but nothing is working .So only an expert should bid payment only of issue is solved

I am seeking native Portuguese speakers from Portugal with a partner to aid in a dual channel natural conversational audio recording project designed for speech recognition training. In this project, you will: - Engage in natural dialogs about 6 topics are provided (36 options) - Each topic must be 15 minutes of natural conversation - Record these conversations in two methods, which applications and also Skype. It needs two phones during the recording and need to be together on the same room with the parnert. Ideal candidates are native Portugal Portuguese speaker if aren't native but have the accent can also participate , with good conversation skills, and have access to recording equipment. A partner with the same skills is also needed. We...

I'm looking for a UI designer to develop a clean and minimalist interface for a stock taking application. This UI will be used primarily by our Warehouse staff. Key components of the project include: - UI Design: The primary focus of this project is the design of the user interface. It should be user-friendly, intuitive, and minimalist in style. - Backend Development: The system will be powered by Microsoft Access. The backend should support: - Inventory Tracking: The system should be able to record and update our inventory. - Cost Analysis: The backend should be able to calculate the cost of our stock. - Report Generation: The system should be able to generate detailed reports based on the data entered. The ideal freelancer for this project...

Server Admin for and Node.js

...understanding of the Google Play Console. Key Requirements: - Uploading an existing Android app to Google Play Console: The developer must be able to guide through the process, ensuring that the app is uploaded correctly and isn't rejected. - Managing app releases: The selected freelancer should be able to handle the release process on Google Play Console, including managing updates and implementing best practices to ensure a smooth release. Specific Permissions: - The app requires access to: - Location Services - Camera - Storage The ideal candidate should have a strong background in Android app development, and should possess the following skills and experiences: - Proven experience in uploading apps to Google Play Conso...

I'm seeking participants f...Learning. Your recordings will be utilized in a series of ways to improve AI's capabilities with language. I'm looking for more than 300 pairs of participants to contribute to the project. Your conversations will not only be beneficial for the AI but also offer you a chance to engage in a creative, spontaneous exchange. Ideal applicants for this project should have: - Proficiency in English (born in USA) - Access to a stable internet connection and a quiet environment - Enthusiasm for participating in a conversational project - Willingness to work with a partner and engage in unscripted conversations on various topics. Your contribution will be integral to the development of language l...

...Discord user to create detailed tutorials on getting started with the platform and managing servers. 1. Your tutorials should include the 10 topics i mentioned on the attached file. it's important all the tutorials are screen recorded and done by you i don't want get in trouble of copyright so all the work should be done by you. 2. all 10 videos should be up to 5 minutes and should cover the topic clearly - videos should not be rushed - quality of the videos should be high - Each tutorial should be a step-by-step walkthrough, including screenshots to help illustrate each point. - - Extensive experience with Discord and great communication skills are must-haves for this project. I look forward to seeing your proposals. 3. For the voi...

...capabilities; comprised of industry veterans, Confirmis's business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to...

...capabilities; comprised of industry veterans, Confirmis's business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to...

...capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to...

I need a freelancer to copy and paste video links from YouTube, and organize them by upload date. Ideal Skills and Experience: - Proficient in navigating YouTube - Basic understanding of video content - The project involves copying and pasting video links from YouTube - The links need to be organized according to their upload date - The freelancer will need to work with a large volume of links, so attention to detail is critical - Previous experience with data entry or content organization would be beneficial Please go through the document Links that need to be attached and apply only if you can do the job completely. Thanks

...capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to...

I'm in need of a seaso...professional who can set up a Windows-based VPN server for my company. The primary purpose of this server is to allow our employees to access the company's resources securely from remote locations, which is currently a pressing need for us. Key Requirements: - Configuration of a VPN server on Windows OS - Setting up a secure connection for remote employees - Allowing simultaneous connection for a small user base (1-10 users) Ideal Skills and Experience: - Proficiency in Windows OS - Hands-on experience with VPN server configuration - Knowledge of network security best practices - Prior experience with remote access solutions Your expertise will play a crucial role in enhancing the security and ef...

I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.

...Unauthorized Access: My account has been compromised and I need assistance in reclaiming control over it. This involves identifying the source of the breach and securing the account. - Setting up a New Ad Account: Due to security concerns, I'm looking to establish a fresh ad account on Facebook. This would require seamless migration of existing campaigns and ensuring they continue to perform optimally. - Enhanced Security & Integration: It's imperative that the new ad account and my FB page are equipped with heightened security measures. Additionally, I would like the transition to be smooth and integrated with existing tools and platforms. Ideal Skills: - Proficient in Facebook Page and Ad Account Management - Experienced in Handling Ac...

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of da...

...skilled freelancer who can help me set up a system to remotely control a headless Windows virtual machine using graphical applications. The virtual machine will specifically be running WhatsApp Desktop. Key project components: - Setting up a Windows virtual machine - Configuring it to run WhatsApp Desktop - Implementing a system for remote control Ideal Skills: - Proficiency in Windows OS - Experience with virtual machines, particularly setting up headless ones - Knowledge of remote access software - Previous experience setting up and using WhatsApp Desktop This project has a tight deadline, and I need someone who can start immediately and complete the task ASAP. The successful freelancer will have excellent communication skills and be able to provide tim...

I'm looking for an intermediate SAP administrator to assist with the basic administration of our SAP system. Key Tasks: - Basic user management, including creating and deleting users, assigning roles, and setting up authorizations - Monitoring system performance and taking necessary actions to ensure it runs smoothly - Troubleshooting and resolving basic configuration and authorization issues - Assisting with system backups and ensuring data integrity - Providing general support to the team on SAP-related queries It's important that you're comfortable working with the SAP system and have a good understanding of its basic functions and administration. A background in SAP Administration or similar roles is preferred. I will provide access to...

...penetration testing, and web application security testing is required. Tasks I need help with: 1. Vulnerability Assessment: Conduct a systematic evaluation of my system's vulnerabilities. 2. Network Penetration Testing: Simulate a possible attack on my network to assess its security. 3. Web Application Security Testing: Ensure the security of my web applications against potential threats. Further, I have been compromised on some of my email and social media accounts. I need your support with: - Password Recovery: Restore access to my accounts by recovering or resetting lost passwords. - Account Verification: Confirm my identity and reinstate my control over my accounts. - Two-Factor Authentication Setup: Increase my accounts' security through the impl...

...and government agencies in Brazil. It allows users to access multiple government platforms and services with a single set of credentials. When a user attempts to log in to a participating website or application, they are redirected to a common login page hosted at "". Here, users can enter their credentials, typically consisting of a username (usually their CPF - Cadastro de Pessoas Físicas, the Brazilian individual taxpayer registry identification) and a password. Description: I am reaching out to inquire about a service you may provide regarding the automation of login within a Docker environment. I have encountered difficulties automating the login process on , particularly when attempting to execute the script w...

...specialist to assist me in configuring my existing Unifi Gateway, CloudKey, and Access Points for enhanced security. Key Requirements: - Configuration of Unifi Gateway, CloudKey, and Access Points: The primary goal is to enhance the security of the network. Therefore, the specialist will need to ensure that the configuration aligns with this objective. Ideal Skills and Experience: - Proficiency with Unifi network devices: The specialist should have hands-on experience with Unifi Gateway and Access Points. Experience with CloudKey would be a plus. - Network Security Expertise: A strong understanding of network security principles and best practices is essential. Additional Information: - Although the Unifi Switch is part of my current setup, I...

Our existing CGI ...script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and...

I need assistance with submitting ...Support Service (TSS) system. - Familiarize with TSS System: Understanding of the TSS system is necessary as the project requires comprehensive usage of it. I have access to the system but I need someone who can efficiently navigate it and complete the task accurately. - Document Preparation: Although the document needs to be prepared on the TSS system, any other necessary paperwork to supplement the TSS filing will be required. So, proficiency in documentation is important. - Experience: Having prior experience in customs declarations and familiarity with Northern Ireland's regulations would be ideal. Your responsibility will be to ensure the TSS filing for customs declarations transitions smoothly and is com...

I need a custom bill of lading that reflects our company branding and can be accessed as a Word document. The document...document shouldn't be editable by the recipient and doesn't require any security features. Key Requirements: - The bill of lading should be in Word format for easy access and editing on our end. - It should include our company information and logo, serving as a representation of our brand. - The recipient should not be able to edit the document, ensuring the information remains intact. Ideal Skills: - Proficiency in creating professional Word documents. - Experience with custom branding and design elements in documents. - Understanding of document security and the ability to make a file read-only. - Good communication skills to cla...

I have an urgent need for a tool that can monitor my supplier's sto...status in real-time. The service should mimic the functionality of Uptimerobot, but with the ability to track stock levels instead of website uptime. Key Features: - Real-time updates: Constant monitoring of supplier's stock status - User login: Access to the tool via username and password - Email Notifications: Instant alerts for changes in stock levels Key Skills & Experience: - Proficiency in web development and API integration - Prior experience in creating monitoring tools or systems - Strong background in notification systems (email preferred in this case) The ideal candidate should be able to deliver a robust and user-friendly service that meets my specific requirements...

Looking for a skilled developer to build a comprehensive contact management app for both iOS and Android platforms. This app should embody a minimalist and clean design, making it user-friendly and appealing to the eye. Key features that must be included are: - The ability to upload, categorize, and share there important contacts easily; users should not have to struggle to extend their connections. - Contact grouping feature; to keep things tidy and accessible, we require the functionality of grouping contacts Based on categories we choose. - The users should be able to access their family network contacts for categorize life events for ease of use. Ideal applicants will have experience in app development for both platforms and an...

I've encountered an internal server error on my website when accessing a specific page. This issue is particularly critical as some of my visitors are unable to access my site due to this error. While some visitors can browse the website, others are completely blocked. Key Project Details: - The error is triggered when accessing a specific page. The rest of the website is accessible. - The issue is causing a split in visitor access, with some able to view the site consistently and others unable to access at all. - The problem is particularly urgent as it is directly impacting my site's usability. Skills and Experience Needed: - Proficient in troubleshooting common internal server error causes. - Experience in addres...

I encountered an internal server error while trying to access a specific webpage on my website. The error is isolated as it only occurs on certain pages. Some visitors can access the site and some cannot. For example: I can access with WiFi but not with my mobile connecction. The ideal freelancer for this project should have: - Proficient understanding of server-side technologies and the workings of web servers. - Strong problem-solving skills and the ability to troubleshoot technical issues effectively. (Wordpress) and (godaddy) - Experience in handling internal server errors, ideally on specific pages. - Good communication skills to effectively inform me of the error's cause and resolution. Please contact me if you hav...

...individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between CPTs & Building Complex Queries: You will need to ensure th...

...learning to curate content based on user preferences. The dashboard will feature an AI-driven recommendation system that not only presents news articles but also provides analytical insights into trending topics and sentiment analysis of news content. Objectives: Main Goal: Develop a web application that personalizes news content for users based on their reading habits and preferences. Secondary Goals: Implement data visualization features to display trends and sentiment analysis of news articles. Minimum Requirements: Content Aggregator: Develop a system that pulls news data from various APIs or web scraping. User Profile Management: Create functionality for users to register, login, and specify their interests and preferences. Recommendation Engine: Implement a ...

...I want the site to have certain features Key Features: - Course Information and Syllabus: I expect to have a section where I can upload all the necessary information regarding the courses I'm taking. - Student Login and Registration: There should be a secure login system for students to access the personalized information. - Grades, Student Education History, Fee Details: The website should allow me to keep track of my academic performance, educational history, and fee details. - Time Table: A feature that allows me to maintain my schedule and plan my time effectively. - Downloadable Documents: Users should be able to download important documents, such as course materials or assignment briefs. The primary purpose of this website is...