How to through ole db or other way to be able to connect to a remote Mysql server-CodePudding

See online have said through ole db to be able to connect to a remote server, but not in detail, especially for mysql, I demand is sina sae some application of cloud, sina is using mysql, don't know if pb can connect?

CodePudding user response:

With IP can ah

CodePudding user response:

reference 1st floor jlwei888 response:

have IP can

Through the ole db or odbc? In addition with the HTTP url (not IP)?
Do you have any specific example?

CodePudding user response:

refer to the second floor jiang396 response:

Quote: refer to 1st floor jlwei888 response:

With IP can ah

Through the ole db or odbc? In addition with the HTTP url (not IP)?
Do you have any specific example?

Consult the

A, use the Microsoft OLE DB Provider For ODBC MySQL link
Install MySQL ODBC driver MyODBC
1, build a system ODBC data source for MySQL, for example: select the database for the test, the data source name as
String 6
MyDSN
String 8
2, create links database
The EXEC sp_addlinkedserver @ server='MySQLTest, @ srvproduct=' MySQL ', string 8
@ the provider='MSDASQL, @ datasrc=' https://bbs.csdn.net/topics/myDSN '
GO
The EXEC sp_addlinkedsrvlogin string 8
@ rmtsrvname='MySqlTest, @ useself=' false ', @ locallogin='sa', @ rmtuser='mys string 7
Ql username ', @ rmtpassword='mysql password'
String 8

CodePudding user response:

reference lzp_lrp reply: 3/f

Quote: refer to the second floor jiang396 response:

Quote: refer to 1st floor jlwei888 response:

With IP can ah

Through the ole db or odbc? In addition with the HTTP url (not IP)?
Do you have any specific example?

Consult the

A, use the Microsoft OLE DB Provider For ODBC MySQL link
Install MySQL ODBC driver MyODBC
1, build a system ODBC data source for MySQL, for example: select the database for the test, the data source name as
String 6
MyDSN
String 8
2, create links database
The EXEC sp_addlinkedserver @ server='MySQLTest, @ srvproduct=' MySQL ', string 8
@ the provider='MSDASQL, @ datasrc=' https://bbs.csdn.net/topics/myDSN '
GO
The EXEC sp_addlinkedsrvlogin string 8
@ rmtsrvname='MySqlTest, @ useself=' false ', @ locallogin='sa', @ rmtuser='mys string 7
Ql username ', @ rmtpassword='mysql password'
String 8

The webmaster, you have the code under the pb?