Hie !Please, how to manage (attach,connect to) MySql database located on host server http://www.avanti.si from my home PC with Microsoft SQL Server Management Studio Express This "http://www.avanti.si:8080\MySqlDatabaseName,3306" fail !
Thenks!
Attach MySql database via internet
Hot Topic
- No indication of the SQL Server edition in the About window
- Cube deployment issue SSAS 2005
- shrinking a file
- Create Store Procedure Fails "Incorrect syntax near the keyword 'ON'."
- Error when changing the length on DataReader Source
- Understanding Collation Selection With Multi-Lingual Requirements
- Unable to browse the dimension '<Dimension Name>'
- Remote connection not working using MSSMSE
- Opening package stored in MSDB
- Problem with named calculation
SQL Server
- Merge Replication not replicating updates
- How to export SQL data to Excel SpreadSheet using SQL Query?
- Incremental Dimension update in 2000
- Using ssis task to call a web service
- Reporting Services Instance could not be found
- Command line/utilities to clear cache
- TNS Alias name changed
- "VS_ISBROKEN" error
- Can I link the data mining Results to any front end or CRM system
- Error: The component has inconsistent metadata
Attach MySql database via internet
Proceed
Actually, you can't connect directly to MySQL database, Management Studio is designed for use with SQL Server. You can create a linked server to any database that offers an OLEDB provider, which I believe MySQL has. The linked server will allow you to query your data from MySQL, but not manage the database.
Regards,
Mike
haihtomy
hi,
you should ask you provider about connection info..
assuming the "server" is named and available as "www.avanti.si" and 3306 is the port you have to use to connect to, you should provide that info in the SQL Server MAnagement Studio Express connection dialog as
www.avanti.si,3306
in the server property, and provide your SQL Server standard login and pwd.. in the "options" tab you can, but is not mandatory as the <default> value will be resolved as tcp/ip, set the network protocol as tcp/ip and specify the "connect to database" property to "MySqlDatabase", but this one should be resolved as well without your intervention becouse you should be usually only grated db access to your db, MySqlDatabase...
you have to verify the www.avanti.si is the actual SQL Server instance name as well, and I doubt about it..
regards
LibertySt
ooppss...
did not notice/intended MySqlDatabase as a "MySql.. database"
thank you Mike