Linking Oracle Servers

Has anyone successfully linked to a Linux Oracle server running 9i? We are unable to get the link working.....have installed various drivers and still get connection refused. Any thoughts?

Try to install oracle client on your machine,and it should work

Best Regards

|||

We have installed the client on the MS SQL server, installed Oracle OLE DB, etc. Still receive the error that we cannot initialize the MSDAORA. Not sure why. Using MS Access we are able to connect to the data via an ODBC connection (on the same box). However, we cannot use the ODBC to connect directly to the Oracle server (Oracle 9i on a Linux platform). Any other thoughts are appreciated.

|||Try to use Oracle ODBC driver instead of Microsoft ODBC for oracle (His name should be Oracle in <oraclehome>)

servers to Lotus Notes

Hello,

I have successfully linked a Lotus Notes server to our SQL Server
database using an ODBC connection.
This works fine when wanting to select records
eg openquery(LOTUSNOTES2, 'select * from Person' )

The problem I have is when I try to update the record I get an error
eg
update openquery(LOTUSNOTES, 'select * from Person where
MailAddress=''nick.bloor@.sandh-ltd.com''' )
set JobTitle='Test'

Produces the following error
==========
OLE DB provider 'MSDASQL' reported an error. The provider did not give
any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows
returned 0x80004005: The provider did not give any information about
the error.].
===========

I have tested the ODBC connection using an Access database. The link
tables facilities enable me to select what I think should be the
primary key. If I select a primary key then I can use Access to update
the lotus notes database, however if I don'k select a primary key, the
table is not updateable.

I believe that if I can somehow create an index on the linked table
within SQL Server, I should be able to update the Lotus Notes database
from SQL Server, but I cannot find a way of doing so.

As the Lotus Notes software is third party, I cannot actually change
anything on that server.

Thanks for any help.

Regards

Nick BloorNickBlooruk (nickblooruk@.yahoo.com) writes:
> The problem I have is when I try to update the record I get an error
> eg
> update openquery(LOTUSNOTES, 'select * from Person where
> MailAddress=''nick.bloor@.sandh-ltd.com''' )
> set JobTitle='Test'

I don't know Lotus Notes, nor do I have much experience of updating
through OPENQUERY. But what happens if you move the WHERE to the
SQL Server side of things?

> I have tested the ODBC connection using an Access database. The link
> tables facilities enable me to select what I think should be the
> primary key. If I select a primary key then I can use Access to update
> the lotus notes database, however if I don'k select a primary key, the
> table is not updateable.

Is Person.MailAddress the primary key? If it's not it seems like a
difficult case.

> I believe that if I can somehow create an index on the linked table
> within SQL Server, I should be able to update the Lotus Notes database
> from SQL Server, but I cannot find a way of doing so.

You cannot create indexes on linked tables.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi Erland,
Thanks for your response.

Strictly speaking Lotus Notes is not a relational database. The Person
table therefore does not have a primary key.
There are a few records will null values in the MailAddress within
Lotus notes.
However the data I am interested in is unique within Lotus notes.

Access 2000 allows me to say that the MailAddress field is unique (even
though it isn't strictly). This allows me to update the Lotus Notes
table using Access' Query.

I cannot find a way of doing the same with MS SQL SERVER 2000, so the
table is currently not updateable.

I have tried using the WHERE on the SQL SERVER side
eg:
update openquery(LOTUSNOTES2, 'select * from Person ' )
set [JobTitle]='Test'
FROM
openquery(LOTUSNOTES2, 'select * from Person ' ) a
where a.MailAddress='NickBlooruk@.yahoo.com'

but the error is still the same.

Thanks for your advise.

Nick

Erland Sommarskog wrote:
> NickBlooruk (nickblooruk@.yahoo.com) writes:
> > The problem I have is when I try to update the record I get an
error
> > eg
> > update openquery(LOTUSNOTES, 'select * from Person where
> > MailAddress=''nick.bloor@.sandh-ltd.com''' )
> > set JobTitle='Test'
> I don't know Lotus Notes, nor do I have much experience of updating
> through OPENQUERY. But what happens if you move the WHERE to the
> SQL Server side of things?
> > I have tested the ODBC connection using an Access database. The
link
> > tables facilities enable me to select what I think should be the
> > primary key. If I select a primary key then I can use Access to
update
> > the lotus notes database, however if I don'k select a primary key,
the
> > table is not updateable.
> Is Person.MailAddress the primary key? If it's not it seems like a
> difficult case.
> > I believe that if I can somehow create an index on the linked table
> > within SQL Server, I should be able to update the Lotus Notes
database
> > from SQL Server, but I cannot find a way of doing so.
> You cannot create indexes on linked tables.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||(nickblooruk@.yahoo.com) writes:
> Strictly speaking Lotus Notes is not a relational database. The Person
> table therefore does not have a primary key.

I kind of suspected that.

> Access 2000 allows me to say that the MailAddress field is unique (even
> though it isn't strictly). This allows me to update the Lotus Notes
> table using Access' Query.
> I cannot find a way of doing the same with MS SQL SERVER 2000, so the
> table is currently not updateable.

Access and SQL Server are not really the same sort of animals. Access
is a GUI and DBMS in once. SQL Server is only a DBMS.

Yet one more thing to try is something like:

UPDATE LOTUSNOTES2...Person
SET JobTitle = 'Test'
WHERE MailAdress = '...'

You would need to find out what to place between the dots in the four-
part notation, which is not always that easy.

> I have tried using the WHERE on the SQL SERVER side
> eg:
> update openquery(LOTUSNOTES2, 'select * from Person ' )
> set [JobTitle]='Test'
> FROM
> openquery(LOTUSNOTES2, 'select * from Person ' ) a
> where a.MailAddress='NickBlooruk@.yahoo.com'

I was more thinking of

update openquery(LOTUSNOTES2, 'select * from Person ' )
set [JobTitle]='Test'
FROM where MailAddress='NickBlooruk@.yahoo.com'

But I would guess you've already tried that.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks Erland for your help.

I have discovered that there is a unique reference number in Lotus
Notes called NoteID. This has all the characteristics of a primary
key, however as it is not a primary key in the strict sense of the
work as there is no built in integrity checks, I cannot update using
the openquery statement.

I think I will post a note on the lotus notes forum and also try to
find a different solution.

Thank you very much though

Regards

Nick Bloor.|||NickBlooruk (nickblooruk@.yahoo.com) writes:
> I have discovered that there is a unique reference number in Lotus
> Notes called NoteID. This has all the characteristics of a primary
> key, however as it is not a primary key in the strict sense of the
> work as there is no built in integrity checks, I cannot update using
> the openquery statement.
> I think I will post a note on the lotus notes forum and also try to
> find a different solution.

Good luck! :-)

I can only say that I'm glad that I don't have fight that battle.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

servers

I am testing linking an unsecured Access database to my SQL 2000 server. I
have been successfully been able to link the server and map a login to view
the data.
I am trying to figure out how to create an update statement in TSQL. I am
using the Cutomer table in the linked NWind database. Can someone help with
the syntax of translating the following syntax:
UPDATE Cutsomers
SET CustomerName = 'Anders'
WHERE CustomerID = 'ALFKI'
into a linked query.
Thank you,
JLFleming
Have you tried using a 4 part name, as in the following?
UPDATE LinkedServer...Customers
SET CustomerName = 'Anders'
WHERE CustomerID = 'ALFKI'
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
news:7E155BC0-BF89-485F-99E7-A116002CFACC@.microsoft.com...
I am testing linking an unsecured Access database to my SQL 2000 server. I
have been successfully been able to link the server and map a login to view
the data.
I am trying to figure out how to create an update statement in TSQL. I am
using the Cutomer table in the linked NWind database. Can someone help with
the syntax of translating the following syntax:
UPDATE Cutsomers
SET CustomerName = 'Anders'
WHERE CustomerID = 'ALFKI'
into a linked query.
Thank you,
JLFleming
|||UPDATE [linkedServername]..Customers
SET Companyname = 'Anders'
WHERE CustomerID = 'ALFKI'
"JLFleming" wrote:

> I am testing linking an unsecured Access database to my SQL 2000 server. I
> have been successfully been able to link the server and map a login to view
> the data.
> I am trying to figure out how to create an update statement in TSQL. I am
> using the Cutomer table in the linked NWind database. Can someone help with
> the syntax of translating the following syntax:
> UPDATE Cutsomers
> SET CustomerName = 'Anders'
> WHERE CustomerID = 'ALFKI'
> into a linked query.
> Thank you,
> JLFleming
|||Thank you. I thought I might need to use the OPENQUERY command.
"Narayana Vyas Kondreddi" wrote:

> Have you tried using a 4 part name, as in the following?
> UPDATE LinkedServer...Customers
> SET CustomerName = 'Anders'
> WHERE CustomerID = 'ALFKI'
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
> news:7E155BC0-BF89-485F-99E7-A116002CFACC@.microsoft.com...
> I am testing linking an unsecured Access database to my SQL 2000 server. I
> have been successfully been able to link the server and map a login to view
> the data.
> I am trying to figure out how to create an update statement in TSQL. I am
> using the Cutomer table in the linked NWind database. Can someone help with
> the syntax of translating the following syntax:
> UPDATE Cutsomers
> SET CustomerName = 'Anders'
> WHERE CustomerID = 'ALFKI'
> into a linked query.
> Thank you,
> JLFleming
>
>
|||Sorry fogot a poitn in that:
UPDATE [linkedServername]...Customers
[linkedservername].[database].[owner].[objectname]
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> UPDATE [linkedServername]..Customers
> SET Companyname = 'Anders'
> WHERE CustomerID = 'ALFKI'
>
> "JLFleming" wrote:

servers

I am testing linking an unsecured Access database to my SQL 2000 server. I
have been successfully been able to link the server and map a login to view
the data.
I am trying to figure out how to create an update statement in TSQL. I am
using the Cutomer table in the linked NWind database. Can someone help with
the syntax of translating the following syntax:
UPDATE Cutsomers
SET CustomerName = 'Anders'
WHERE CustomerID = 'ALFKI'
into a linked query.
Thank you,
JLFlemingHave you tried using a 4 part name, as in the following?
UPDATE LinkedServer...Customers
SET CustomerName = 'Anders'
WHERE CustomerID = 'ALFKI'
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
news:7E155BC0-BF89-485F-99E7-A116002CFACC@.microsoft.com...
I am testing linking an unsecured Access database to my SQL 2000 server. I
have been successfully been able to link the server and map a login to view
the data.
I am trying to figure out how to create an update statement in TSQL. I am
using the Cutomer table in the linked NWind database. Can someone help with
the syntax of translating the following syntax:
UPDATE Cutsomers
SET CustomerName = 'Anders'
WHERE CustomerID = 'ALFKI'
into a linked query.
Thank you,
JLFleming|||UPDATE [linkedServername]..Customers
SET Companyname = 'Anders'
WHERE CustomerID = 'ALFKI'
"JLFleming" wrote:
> I am testing linking an unsecured Access database to my SQL 2000 server. I
> have been successfully been able to link the server and map a login to view
> the data.
> I am trying to figure out how to create an update statement in TSQL. I am
> using the Cutomer table in the linked NWind database. Can someone help with
> the syntax of translating the following syntax:
> UPDATE Cutsomers
> SET CustomerName = 'Anders'
> WHERE CustomerID = 'ALFKI'
> into a linked query.
> Thank you,
> JLFleming|||Thank you. I thought I might need to use the OPENQUERY command.
"Narayana Vyas Kondreddi" wrote:
> Have you tried using a 4 part name, as in the following?
> UPDATE LinkedServer...Customers
> SET CustomerName = 'Anders'
> WHERE CustomerID = 'ALFKI'
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
> news:7E155BC0-BF89-485F-99E7-A116002CFACC@.microsoft.com...
> I am testing linking an unsecured Access database to my SQL 2000 server. I
> have been successfully been able to link the server and map a login to view
> the data.
> I am trying to figure out how to create an update statement in TSQL. I am
> using the Cutomer table in the linked NWind database. Can someone help with
> the syntax of translating the following syntax:
> UPDATE Cutsomers
> SET CustomerName = 'Anders'
> WHERE CustomerID = 'ALFKI'
> into a linked query.
> Thank you,
> JLFleming
>
>|||Sorry fogot a poitn in that:
UPDATE [linkedServername]...Customers
[linkedservername].[database].[owner].[objectname]
"Jens Sü�meyer" wrote:
> UPDATE [linkedServername]..Customers
> SET Companyname = 'Anders'
> WHERE CustomerID = 'ALFKI'
>
> "JLFleming" wrote:
> >
> > I am testing linking an unsecured Access database to my SQL 2000 server. I
> > have been successfully been able to link the server and map a login to view
> > the data.
> >
> > I am trying to figure out how to create an update statement in TSQL. I am
> > using the Cutomer table in the linked NWind database. Can someone help with
> > the syntax of translating the following syntax:
> > UPDATE Cutsomers
> > SET CustomerName = 'Anders'
> > WHERE CustomerID = 'ALFKI'
> >
> > into a linked query.
> >
> > Thank you,
> > JLFleming

servers

I am testing linking an unsecured Access database to my SQL 2000 server. I
have been successfully been able to link the server and map a login to view
the data.
I am trying to figure out how to create an update statement in TSQL. I am
using the Cutomer table in the linked NWind database. Can someone help with
the syntax of translating the following syntax:
UPDATE Cutsomers
SET CustomerName = 'Anders'
WHERE CustomerID = 'ALFKI'
into a linked query.
Thank you,
JLFlemingHave you tried using a 4 part name, as in the following?
UPDATE LinkedServer...Customers
SET CustomerName = 'Anders'
WHERE CustomerID = 'ALFKI'
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
news:7E155BC0-BF89-485F-99E7-A116002CFACC@.microsoft.com...
I am testing linking an unsecured Access database to my SQL 2000 server. I
have been successfully been able to link the server and map a login to view
the data.
I am trying to figure out how to create an update statement in TSQL. I am
using the Cutomer table in the linked NWind database. Can someone help with
the syntax of translating the following syntax:
UPDATE Cutsomers
SET CustomerName = 'Anders'
WHERE CustomerID = 'ALFKI'
into a linked query.
Thank you,
JLFleming|||UPDATE [linkedServername]..Customers
SET Companyname = 'Anders'
WHERE CustomerID = 'ALFKI'
"JLFleming" wrote:

> I am testing linking an unsecured Access database to my SQL 2000 server.
I
> have been successfully been able to link the server and map a login to vie
w
> the data.
> I am trying to figure out how to create an update statement in TSQL. I am
> using the Cutomer table in the linked NWind database. Can someone help wi
th
> the syntax of translating the following syntax:
> UPDATE Cutsomers
> SET CustomerName = 'Anders'
> WHERE CustomerID = 'ALFKI'
> into a linked query.
> Thank you,
> JLFleming|||Thank you. I thought I might need to use the OPENQUERY command.
"Narayana Vyas Kondreddi" wrote:

> Have you tried using a 4 part name, as in the following?
> UPDATE LinkedServer...Customers
> SET CustomerName = 'Anders'
> WHERE CustomerID = 'ALFKI'
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "JLFleming" <JLFleming@.discussions.microsoft.com> wrote in message
> news:7E155BC0-BF89-485F-99E7-A116002CFACC@.microsoft.com...
> I am testing linking an unsecured Access database to my SQL 2000 server.
I
> have been successfully been able to link the server and map a login to vie
w
> the data.
> I am trying to figure out how to create an update statement in TSQL. I am
> using the Cutomer table in the linked NWind database. Can someone help wi
th
> the syntax of translating the following syntax:
> UPDATE Cutsomers
> SET CustomerName = 'Anders'
> WHERE CustomerID = 'ALFKI'
> into a linked query.
> Thank you,
> JLFleming
>
>|||Sorry fogot a poitn in that:
UPDATE [linkedServername]...Customers
[linkedservername].[database].[owner].[objectname]
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> UPDATE [linkedServername]..Customers
> SET Companyname = 'Anders'
> WHERE CustomerID = 'ALFKI'
>
> "JLFleming" wrote:
>

server using NT authentication

Hi,
I have successfully set up linked servers using SQL authentication. However,
I can't figure out how to configure a linked server using NT authentication.
I would appreciate it if anyone could help with this matter.
Sincerely,
Shan
Think you just want the users crrent security context on the security tab.
"Shan" wrote:

> Hi,
> I have successfully set up linked servers using SQL authentication. However,
> I can't figure out how to configure a linked server using NT authentication.
> I would appreciate it if anyone could help with this matter.
> Sincerely,
> Shan
>

server to MYSQL using OLEDB Provider for MYSQL cherry

Good Morning

Has anyone successfully used cherry's oledb provider for MYSQL to create a linked server from MS SQLserver 2005 to a Linux red hat platform running MYSQL.

I can not get it to work.

I've created a UDL which tests fine. it looks like this

[oledb]

; Everything after this line is an OLE DB initstring

Provider=OleMySql.MySqlSource.1;Persist Security Info=False;User ID=testuser;

Data Source=databridge;Location="";Mode=Read;Trace="""""""""""""""""""""""""""""";

Initial Catalog=riverford_rhdx_20060822

Can any on help me convert this to corrrect syntax for sql stored procedure

sp_addlinkedserver

I've tried this below but it does not work I just get an error saying it can not create an instance of OleMySql.MySqlSource.

I used SQL server management studio to create the linked server then just scripted this out below.

I seem to be missing the user ID, but don't know where to put it in.

EXEC master.dbo.sp_addlinkedserver @.server = N'DATABRIDGE_OLEDB', @.srvproduct=N'mysql', @.provider=N'OleMySql.MySqlSource', @.datasrc=N'databridge', @.catalog=N'riverford_rhdx_20060822'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'collation compatible', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'data access', @.optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'dist', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'pub', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'rpc', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'rpc out', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'sub', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'connect timeout', @.optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'collation name', @.optvalue=null

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'lazy schema validation', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'query timeout', @.optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'use remote collation', @.optvalue=N'false'

Many Thanks

David Hills

Have you tried to include password to initstring?|||No I have not, as there is no password set for testuser in the mysql database.|||

---

Have you tried to include user id like this @.UID='<my id>'? It shall work with MySQL OLE DB Provider|||

I got a reply from the software provider "cherry" they told me it won't work with

sqlserver 2005 as a linked server.

It should be quite straight forward to write a .net vb applet that uses the .net provider for mysql to

get the data out of mysql server, then use ado.net to write it into sqlserver 2005.

But what I wanted to do is to contain the code within sqlserver management studio so I don't

have external code.

Anyone know if I can write a VB.net or C## .net applet from with sqlserver 2005. It seems it's

the sort of intergrated solution that would be convient to be able to do?

|||I've setup a MySQL linked server in SQL 2005 using the ODBC driver for MySQL, and then using the OLEDB Provider for ODBC. Would you be apposed to doing it that way?

server to MYSQL using OLEDB Provider for MYSQL cherry

Good Morning

Has anyone successfully used cherry's oledb provider for MYSQL to create a linked server from MS SQLserver 2005 to a Linux red hat platform running MYSQL.

I can not get it to work.

I've created a UDL which tests fine. it looks like this

[oledb]

; Everything after this line is an OLE DB initstring

Provider=OleMySql.MySqlSource.1;Persist Security Info=False;User ID=testuser;

Data Source=databridge;Location="";Mode=Read;Trace="""""""""""""""""""""""""""""";

Initial Catalog=riverford_rhdx_20060822

Can any on help me convert this to corrrect syntax for sql stored procedure

sp_addlinkedserver

I've tried this below but it does not work I just get an error saying it can not create an instance of OleMySql.MySqlSource.

I used SQL server management studio to create the linked server then just scripted this out below.

I seem to be missing the user ID, but don't know where to put it in.

EXEC master.dbo.sp_addlinkedserver @.server = N'DATABRIDGE_OLEDB', @.srvproduct=N'mysql', @.provider=N'OleMySql.MySqlSource', @.datasrc=N'databridge', @.catalog=N'riverford_rhdx_20060822'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'collation compatible', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'data access', @.optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'dist', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'pub', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'rpc', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'rpc out', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'sub', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'connect timeout', @.optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'collation name', @.optvalue=null

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'lazy schema validation', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'query timeout', @.optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @.server=N'DATABRIDGE_OLEDB', @.optname=N'use remote collation', @.optvalue=N'false'

Many Thanks

David Hills

Have you tried to include password to initstring?|||No I have not, as there is no password set for testuser in the mysql database.|||

---

Have you tried to include user id like this @.UID='<my id>'? It shall work with MySQL OLE DB Provider|||

I got a reply from the software provider "cherry" they told me it won't work with

sqlserver 2005 as a linked server.

It should be quite straight forward to write a .net vb applet that uses the .net provider for mysql to

get the data out of mysql server, then use ado.net to write it into sqlserver 2005.

But what I wanted to do is to contain the code within sqlserver management studio so I don't

have external code.

Anyone know if I can write a VB.net or C## .net applet from with sqlserver 2005. It seems it's

the sort of intergrated solution that would be convient to be able to do?

|||I've setup a MySQL linked server in SQL 2005 using the ODBC driver for MySQL, and then using the OLEDB Provider for ODBC. Would you be apposed to doing it that way?