我正在尝试创建到MySQL数据库的链接服务器,但是我一直收到错误7303:找不到数据源名称,并且未指定默认驱动程序。数据库位于我必须使用登录名和密码远程连接到的服务器上我使用远程桌面连接来连接到服务器
我创建了在测试时可以成功连接的64位和32位系统DSN
这里是我正在使用的字符串:
-对于64位:EXEC master.dbo.sp_addlinkedserver @server = N'ECWIMA64',@ srvproduct = N'MySQL',@ provider = N'MSDASQL',@ datasrc = N'ECWIMA',@ provstr = N'Driver = {MySQL ODBC 8.0 ANSI驱动程序};数据库= mobiledoc; OPTION = 134217728; PWD =密码; UID = SQLUser; SERVER = ip地址;端口=端口'EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname =N'ECWIMA64',@locallogin = NULL,@useself = N'False',@rmtuser =N'* \ Administrator',@ rmtpassword = N'password'
-对于32位:EXEC master.dbo.sp_addlinkedserver@服务器= N'ECWIMA32',@ srvproduct = N'MySQL',@ provider = N'MSDASQL',@ datasrc = N'ECWIMA32',@ provstr = N'Driver = {MySQL ODBC 5.1 Driver}; DATABASE = mobiledoc; OPTION = 134217728; PWD = password; UID = SQLUser; SERVER = ip地址;端口=端口'EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'ECWIMA32',@locallogin = NULL,@useself = N'False',@rmtuser =N'* \ Administrator',@ rmtpassword = N'password'
而且,我不是IT人员,所以请为我哑巴。
这里是下一个尝试:EXEC master.dbo.sp_addlinkedserver
@server = N'ECWIMA64'
,@srvproduct=N'MySQL'
,@provider=N'MSDASQL'
,@datasrc=N'ECWIMA'
,@catalog=N'mobiledoc'
,@provstr=N'Driver={MySQL ODBC 8.0 ANSI Driver};DATABASE=mobiledoc;OPTION=134217728;PWD=password;UID=SQLUser;SERVER=ipaddress;Port=4928;ODBC:DSN=ECWIMA'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'ECWIMA64', @locallogin = NULL , @useself = N'False', @rmtuser = N'*\Administrator', @rmtpassword = N'password'