Find Jobs
Hire Freelancers

Connection to MySQL via ODBC / ADODB failing after using different server than current cPanel

$8-15 USD / hour

Closed
Posted over 8 years ago

$8-15 USD / hour

We have a client that is a developer and host its databases with us. He has one mysql DB where a client's application uses ODBD and ADODB to connect to this database. In this server, we have MySQL version 5.5.46. We moved this DB to a new Plesk 12.5 VPS. All worked perfectly in cpanel and now in plesk this doesn't work anymore. Exact client's steps to recreate the issue: With ODBC, creates next connectiuon: [login to view URL] Then he goes to Microsoft Access and vinculates tables via ODBC. Working fine. Problem comes when client tries to connect via ADO using Visual Basic: sConexion="Driver={MySQL ODBC 5.3 ANSI Driver};Server=[login to view URL];Database=client_db;User=user;Password=PROTECTED;Option=3" Dim miConexion As [login to view URL] Set miConexion = New [login to view URL] [login to view URL] = sConexion [login to view URL] Connection works fine, but when user goes to open a table with this order: Dim rsCB As [login to view URL] Set rsCB = New [login to view URL] [login to view URL] "select * from Codigos_Barras", miConexion Then user gets next error: [login to view URL] This means that tables doesn't exist ! The client's code is good and user has been working long time with it, also we've been mana¡ging this in our managed server server2.magennta.es. Also, my client is is an experienced application consultant and is using this technology in lots of places, and he never had any issue until now. Relevant data: - Connection string with ODBC driver os Driver={MySQL ODBC 5.3 ANSI Driver}, that's the last driver available. - miConexion object is the [login to view URL], once oppened has the next config: Provider=MSDASQL.1;Password=PROTECTED;Extended Properties="DRIVER={MySQL ODBC 5.3 ANSI Driver};PWD=PROTECTED;Server=[login to view URL];Database=client_db;User=user;Option=3; - I've seen a spanish letter (ñ) in two tables. Maybe this could affect, but very hard to tell developer to change this.
Project ID: 8962280

About the project

7 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average $15 USD/hour for this job
User Avatar
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting.
$15 USD in 2 days
4.8 (55 reviews)
7.1
7.1
User Avatar
I'm experienced in odbc and mysql, I can find the reason and fix it.
$27 USD in 5 days
5.0 (20 reviews)
6.6
6.6
User Avatar
Sr. Software Developer with 6.1+ yrs experience. Sr. Software Developer with 6.1+ yrs experience. Sr. Software Developer with 6.1+ yrs experience. ktanpatel31 is my skpid for Further communication.
$13 USD in 40 days
5.0 (46 reviews)
6.5
6.5
User Avatar
Hi, I had the same issue with other client. Please let me try to fix your trouble. You dont have to pay anything if I can´t. ABOUT THE ñ LETTERS, IT IS NOT THE PROBLEM, but it is easy to fix. Probably it looks like some strange characters when displayed. But if I fix it in less than 1 hour, you will pay 2 hours instead. Deal? I only need to have the connection parameters and I can test it with my own code. Right? When all done, I tell you the solution , you test it , then you release the 30 usd.
$15 USD in 2 days
5.0 (70 reviews)
6.4
6.4
User Avatar
Aucune proposition n'a encore été fournie.
$13 USD in 15 days
4.7 (17 reviews)
4.2
4.2
User Avatar
A proposal has not yet been provided
$13 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SPAIN
Sant Joan Despi, Spain
4.9
40
Payment method verified
Member since Nov 8, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.