Find Jobs
Hire Freelancers

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

$8-15 USD / hour

已关闭
已发布超过 8 年前

$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: 8962280

关于此项目

7提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
7威客以平均价$15 USD/小时来参与此工作竞价
用户头像
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting.
$15 USD 在2天之内
4.8 (55条评论)
7.1
7.1
用户头像
I'm experienced in odbc and mysql, I can find the reason and fix it.
$27 USD 在5天之内
5.0 (20条评论)
6.6
6.6
用户头像
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 在40天之内
5.0 (46条评论)
6.5
6.5
用户头像
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 在2天之内
5.0 (70条评论)
6.4
6.4
用户头像
Aucune proposition n'a encore été fournie.
$13 USD 在15天之内
4.7 (17条评论)
4.2
4.2
用户头像
A proposal has not yet been provided
$13 USD 在2天之内
0.0 (0条评论)
0.0
0.0

关于客户

SPAIN的国旗
Sant Joan Despi, Spain
4.9
40
付款方式已验证
会员自11月 8, 2010起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。