Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

mysql linked server

 
   Database Help (Home) -> Connect RSS
Next:  Port 1434 Filtered  
Author Message
test25

External


Since: Nov 23, 2004
Posts: 1



(Msg. 1) Posted: Fri Feb 18, 2005 3:52 pm
Post subject: mysql linked server
Archived from groups: microsoft>public>sqlserver>connect (more info?)

MSSQL 2000 sp3a -- to a remote--> mysql 4.0.20-standard

The ports are open and a DSN has been created between the two using the
native mysql drivers, I've tried the following without success: (usually
when I click 'tables' under the linked server name, Ent. manager becomes
non-responsive:


sp_addlinkedserver 'mysqlDB1', 'MySQLDBNAME', 'MSDASQL', NULL, NULL,
'DSN_dev_mysql'sp_addlinkedserver 'mysqlDB3', 'MySQL', 'MSDASQL', Null,
Null, 'Driver={MySQL ODBC 3.51 Driver}'sp_addlinkedserver @server =
'192.168.2.100' , @srvproduct = 'MSDASQL' , @provider =
'MSDASQL' , @datasrc = 'dev_mysql' , @location =
'192.168.2.100' , @provstr = 'Driver={MySQL ODBC 3.51 Driver}' ,
@catalog = 'database_mssql'

 >> Stay informed about: mysql linked server 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Oracle linked Server - Hello, I have a SQL 2003 SP3a on Windows 2003 and am connecting to an Oracle 9i database. I've set up the linked server and necessary permissions and it has been working successfully for months. However occasionally after rebooting the machine I..

Linked Server Connection and CONCAT_NULL_YIELDS_NULL - Hello I have question to linked Server Connection from a SQL2k Server to another SQL2k Server. I set up the linked server Connection with the command: EXEC sp_addlinkedserver @server='NEST', @srvproduct='', @provider='SQLOLEDB', @datasrc='ISAG2' The...

Performanceproblem with subquery to Oracle Linked Server - Hello I hope anyone can help me here with a Problem between my Microsoft SQL Server 2000 SP 3 and an Oracle 8 Server. I have to copy records from a Oracle table (3.000.000 records by now) to a SQL Server table (8.000.000 records by now) daily..

IIS 6 and Windows Authentication to SQL Server 2000 - I am running a Windows Server 2003 machine as my web server. I would like to use Windows authentication for connections to my SQL Server 2000 instance on a Windows 2000 server. I've read where mirroring the ASPNET account and password on the web server...

Cannot connect to local sql server 2000 from VB.NET on pc .. - Hi I just installed SQL Server 2000 to run locally on a WinXP Pro SP2 PC. When I run the following VB.NET code: Protected Const SQL_CONNECTION_STRING As String = _ "Server=localhost;" & _ "DataBase=Northwind;" &...
   Database Help (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]