Find Jobs
Hire Freelancers

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

$8-15 USD / hour

Cerrado
Publicado hace más de 8 años

$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.
ID del proyecto: 8962280

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
7 freelancers están ofertando un promedio de $15 USD /hora por este trabajo
Avatar del usuario
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting.
$15 USD en 2 días
4,8 (55 comentarios)
7,1
7,1
Avatar del usuario
I'm experienced in odbc and mysql, I can find the reason and fix it.
$27 USD en 5 días
5,0 (20 comentarios)
6,6
6,6
Avatar del usuario
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 en 40 días
5,0 (46 comentarios)
6,5
6,5
Avatar del usuario
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 en 2 días
5,0 (70 comentarios)
6,4
6,4
Avatar del usuario
Aucune proposition n'a encore été fournie.
$13 USD en 15 días
4,7 (17 comentarios)
4,2
4,2
Avatar del usuario
A proposal has not yet been provided
$13 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SPAIN
Sant Joan Despi, Spain
4,9
40
Forma de pago verificada
Miembro desde nov 8, 2010

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.