＆QUOT;数据源名称未发现和未指定默认驱动程序＆QUOT; MySQL的连接 [英] "Data source name not found and no default driver specified" connecting mysql

问题描述

由于一些技术上的原因，我不得不从SQL Server更改我的数据库到MySQL。
但我收到以下错误，我无法连接到数据库..！

  

Microsoft OLE DB提供的ODBC驱动程序错误80004005

  
  

[微软] [ODBC驱动程序管理器]数据源名称未发现和未
  指定默认驱动程序

 设置ObjConn =的CreateObject（ADODB.Connection）
ObjConn.Open（DRIVER = {MySQL的ODBC驱动程序5.0.96}; SERVER = 68.128.172.38; DATABASE = XXX; UID = XXX; PWD = XXX）
 

解决方案

在这里你去同一个连接字符串示例

  SERVER_NAME =localhost的连接到本地remort在数据库服务器databseName =DB'数据库名
mySQLUser =根'用户名
mysqlPassword =admin的数据库用户passwrd构造=驱动程序= {MySQL的ODBC 5.1驱动}; SERVER =＆放大器; SERVER_NAME＆安培; DATABASE =＆放大器; databseName＆安培; ; UID =＆放大器; mySQLUser＆安培; ; PWD =＆放大器; mysqlPassword＆安培; PORT = 3306; OPTION = 67108864; 连接字符串
 

如果还是不行，请尝试安装培训相关连接器为MySQL 选择并下载连接

Due to some technical reasons, I had to change my database from sql server to MySQL. But I am getting the following error, I cannot connect to the database..!

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Set ObjConn = CreateObject("ADODB.Connection")
ObjConn.Open ("DRIVER={MySQL ODBC 5.0.96 Driver};SERVER=68.128.172.38;DATABASE=xxx;UID=xxx;PWD=xxx")

解决方案

here you go with a sample connection string

Server_Name = "localhost" 'connect to the local  remort database server

databseName = "db" 'database name
mySQLUser = "root" 'user name
mysqlPassword = "admin" 'passwrd of the db user

ConStr= "Driver={MySQL ODBC 5.1 Driver};SERVER=" & Server_Name  & ";DATABASE=" & databseName & ";UID=" & mySQLUser & ";PWD=" & mysqlPassword & ";PORT=3306;OPTION=67108864;" ' Connection string

if that doesn't work, try installing the relevent connector for mysql Select and download the connector

这篇关于＆QUOT;数据源名称未发现和未指定默认驱动程序＆QUOT; MySQL的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！