linked server to Mysql

I want to import some mysql data to SQL Server.
How can I go about the same as far as setting up linked server,etc.?
ThanksDear Hassan,
This link will help you.
http://www.microsoft.com/technet/pr...ploy/mysql.mspx
Regards,
Mohammad Daoud | Technical Development Manager | Mobile +962 79 999 65 85
Tel. +962 6 554 3721 | daoudm@.greatpbs.com
http://www.greatpbs.com| http://www.facebook.com/group.php?gid=18895609248/
"Hassan" wrote:

> I want to import some mysql data to SQL Server.
> How can I go about the same as far as setting up linked server,etc.?
> Thanks
>
>

linked server to Mysql

I want to import some MYSQL data to SQL Server.
How can I go about the same as far as setting up linked server,etc.?
Thanks
Dear Hassan,
This link will help you.
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx
Regards,
Mohammad Daoud | Technical Development Manager | Mobile +962 79 999 65 85
Tel. +962 6 554 3721 | daoudm@.greatpbs.com
http://www.greatpbs.com| http://www.facebook.com/group.php?gid=18895609248/
"Hassan" wrote:

> I want to import some MYSQL data to SQL Server.
> How can I go about the same as far as setting up linked server,etc.?
> Thanks
>
>

linked server to Mysql

I want to import some MYSQL data to SQL Server.
How can I go about the same as far as setting up linked server,etc.?
ThanksDear Hassan,
This link will help you.
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx
Regards,
Mohammad Daoud | Technical Development Manager | Mobile +962 79 999 65 85
Tel. +962 6 554 3721 | daoudm@.greatpbs.com
http://www.greatpbs.com|http://www.facebook.com/group.php?gid=18895609248/
"Hassan" wrote:
> I want to import some MYSQL data to SQL Server.
> How can I go about the same as far as setting up linked server,etc.?
> Thanks
>
>

Linked Server to DBC Data

Hi All,
I'm having trouble setting up a linked server OR using an OpenRowset operati
on from SQL Server against once of the DBC files from one of our vendors.
I can get connected through a DSN using Microsoft Access without trouble but
when trying to set up a linked server on the same DSN I get the following e
rror...
****************************************
**************************
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manag
er] Driver's SQLSetConnectAttr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manag
er] Driver's SQLSetConnectAttr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPr
o Driver]Cannot open file c:\data\MyDB.dbc.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: ].
****************************************
**************************
Can someone advise?
Thanks!
TravisSorry, for clarification, a DBC file is a FoxPro Data file.
"REM7600" <rem7600@.hotmail.com> wrote in message news:%23mkG6JLiGHA.4044@.TK2
MSFTNGP03.phx.gbl...
Hi All,
I'm having trouble setting up a linked server OR using an OpenRowset operati
on from SQL Server against once of the DBC files from one of our vendors.
I can get connected through a DSN using Microsoft Access without trouble but
when trying to set up a linked server on the same DSN I get the following e
rror...
****************************************
**************************
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manag
er] Driver's SQLSetConnectAttr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manag
er] Driver's SQLSetConnectAttr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPr
o Driver]Cannot open file c:\data\MyDB.dbc.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: ].
****************************************
**************************
Can someone advise?
Thanks!
Travis|||Hi Travis,
You haven't posted which version of SQL Server you are using or the code
you're using in the OpenRowset statement.
First, be sure you have the latest FoxPro and Visual FoxPro OLE DB data
provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates.
I've successfully set up linked servers with code like this:
EXEC master.dbo.sp_addlinkedserver
@.server = N'VFP_Northwind',
@.srvproduct=N'Microsoft Visual FoxPro OLE DB Data Provider',
@.provider=N'VFPOLEDB',
@.datasrc=N'C:\Program Files\Microsoft Visual FoxPro
9\Samples\Northwind\Northwind.dbc',
@.provstr=N'VFPOLEDB.1'
After that you can access data with the four-part naming convention:
Select * From VFP_Northwind...Customers
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@.cindywinegarden.com
"REM7600" <rem7600@.hotmail.com> wrote in message
news:%23mkG6JLiGHA.4044@.TK2MSFTNGP03.phx.gbl...
Hi All,
I'm having trouble setting up a linked server OR using an OpenRowset
operation from SQL Server against once of the DBC files from one of our
vendors.
I can get connected through a DSN using Microsoft Access without trouble but
when trying to set up a linked server on the same DSN I get the following
error...
****************************************
**************************
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manag
er] Driver's
SQLSetConnectAttr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manag
er] Driver's
SQLSetConnectAttr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPr
o
Driver]Cannot open file c:\data\MyDB.dbc.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: ].
****************************************
**************************|||Cindy,
Thanks for the reply... I've definitely seen your name a time or two around
the web in my search. As it turns out, I believe it to be related to
security. And how our network (Linux/Samba based shares) handles
authentication. I could be wrong but I've given up... Locally I can make
it work fine, on a share NO GO...
Regardless, I've taken a different direction on the solution and it looks
like I'm going to be able to come out with my "goaled for" end result.
Thanks for the reply.
TR

> you're using in the OpenRowset statement.
> First, be sure you have the latest FoxPro and Visual FoxPro OLE DB data
> provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates.
> I've successfully set up linked servers with code like this:
> EXEC master.dbo.sp_addlinkedserver
> @.server = N'VFP_Northwind',
> @.srvproduct=N'Microsoft Visual FoxPro OLE DB Data Provider',
> @.provider=N'VFPOLEDB',
> @.datasrc=N'C:\Program Files\Microsoft Visual FoxPro
> 9\Samples\Northwind\Northwind.dbc',
> @.provstr=N'VFPOLEDB.1'
>

Linked server to DB2

Does anybody have good documentation on setting up a linked server to a
DB2/AS400 database? I've been unable to set one up in Enterprise Manager or
through Query Analyszer. Thanks"sp_addlinkedserver"
http://msdn.microsoft.com/library/d... />
a_8gqa.asp
"Microsoft Host Integration Server 2000 Product Overview"
http://msdn.microsoft.com/library/d...
server2000.asp
"Host Integration Server 2000 Resource Kit Chapter 14 - Deploying Data
Access"
http://www.microsoft.com/resources/...
hisrkc14.mspx
Cristian Lefter, SQL Server MVP
"blue_nirvana" <bluenirvana@.discussions.microsoft.com> wrote in message
news:3A853550-643E-468F-B244-8010A5FDA916@.microsoft.com...
> Does anybody have good documentation on setting up a linked server to a
> DB2/AS400 database? I've been unable to set one up in Enterprise Manager
> or
> through Query Analyszer. Thanks

Linked server to DB2

Does anybody have good documentation on setting up a linked server to a
DB2/AS400 database? I've been unable to set one up in Enterprise Manager or
through Query Analyszer. Thanks
"sp_addlinkedserver"
http://msdn.microsoft.com/library/de..._adda_8gqa.asp
"Microsoft Host Integration Server 2000 Product Overview"
http://msdn.microsoft.com/library/de...server2000.asp
"Host Integration Server 2000 Resource Kit Chapter 14 - Deploying Data
Access"
http://www.microsoft.com/resources/d.../hisrkc14.mspx
Cristian Lefter, SQL Server MVP
"blue_nirvana" <bluenirvana@.discussions.microsoft.com> wrote in message
news:3A853550-643E-468F-B244-8010A5FDA916@.microsoft.com...
> Does anybody have good documentation on setting up a linked server to a
> DB2/AS400 database? I've been unable to set one up in Enterprise Manager
> or
> through Query Analyszer. Thanks

Linked server to DB2

Does anybody have good documentation on setting up a linked server to a
DB2/AS400 database? I've been unable to set one up in Enterprise Manager or
through Query Analyszer. Thanks"sp_addlinkedserver"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp
"Microsoft Host Integration Server 2000 Product Overview"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnhis/html/his_hiserver2000.asp
"Host Integration Server 2000 Resource Kit Chapter 14 - Deploying Data
Access"
http://www.microsoft.com/resources/documentation/host/2000/all/reskit/en-us/part3/hisrkc14.mspx
Cristian Lefter, SQL Server MVP
"blue_nirvana" <bluenirvana@.discussions.microsoft.com> wrote in message
news:3A853550-643E-468F-B244-8010A5FDA916@.microsoft.com...
> Does anybody have good documentation on setting up a linked server to a
> DB2/AS400 database? I've been unable to set one up in Enterprise Manager
> or
> through Query Analyszer. Thanks