Selecting data from MySql in MSSQL — Seek Weng


Setup Link Server right click to add new linked server. Fill in all the appropriate details accordingly. Follow the database name in mysql to be use as data source over here. Provider string: DRIVER={MySQL ODBC 5.3 ANSI Driver};SERVER=ip address;PORT=port number;DATABASE=mt4_demo;USER=username;PASSWORD=password;Option=3 test connection and save it. after setup To query the data from the table […]

via Selecting data from MySql in MSSQL — Seek Weng

Advertisements