Advanced Search

Return to Snippet

Revision: 66026
at February 28, 2014 06:52 by kidmizere
Initial Code 
EXEC MASTER .dbo.sp_addlinkedserver 
	@SERVER = 'MYSQL',
	@srvproduct = 'MySQL',
	@provider = 'MSDASQL',
	@provstr = 'DRIVER={MySQL ODBC 5.2 Ansi Driver};SERVER=ServerName;Port=3306;USER=USERNAME;PASSWORD=PASSWORD;OPTION=3;DATABASE=DATABASE';
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Adding a linked server to MSSQL account - particularly a MYSQL server

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Adding Linked Server to MSSQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, server

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL