How to create link server between MYSQL and MS Sql server

preview_player
Показать описание
How to create link server between MYSQL and MS Sql server
Рекомендации по теме
Комментарии
Автор

It was perfect!!!! THANK YOU VERY MUCH FOR THIS VIDEO :) as we say in Romania: Multumesc Foarte Mult!!!

mateitalucian
Автор

Excelente video, muchas gracias por compartirlo.

DRIVER{MySQL ODCB 8.0 ANSI Driver}; server= MYSERVER ;user id=MYUSER ;password=MYPASS MYDB

juancarlosroa
Автор

Hi Good Day, It's a good tutorial, anyway how do i get the driver path? just like in your notepad that you copy and paste in "PROVIDER STRING" .. thank you :) please help me.

jancrisrramos
Автор

Sir need your help, i already made the server link and this query already returning values.select * from openquery([CSD-SALES-SRV], 'SELECT * FROM db_account_c99a392f.tbl_invoice_det'), how do i make an stored proc that has parameter say WHERE invoice_date = GETDATE() and put it in a JOB in my SQL server.  My objective is to pickup the daily sales in POS and put in staging table in our ERP system.

junlopez
Автор

Can you please Share the Provider string details

AnbuMani-mxrc
Автор

it will be more better if you add your

mamatakumari
Автор

i still can't use SQL server connect to MySQL, but i will keep try ;(

mollylin
Автор

Please attacht link fro the driver please

dicmuslim