Linked Server Provider

Hi All
I am trying to create a linked server to mysql and it is not listed in the
Linked Server providers in SQL Server 2005. How do I go about adding a
provider that is not in the existing provider list?
Any ideas on how to either add the provider or create the linked server
would be appreciated.
Thanks
- DavidYou need to obtain the needed drivers or providers for MySQL
and install it on the SQL Server box. There are third party
drivers but you can download free drivers from:
http://dev.mysql.com/downloads/
-Sue
On Wed, 30 Aug 2006 06:11:02 -0700, David
<David@.discussions.microsoft.com> wrote:

>Hi All
>I am trying to create a linked server to mysql and it is not listed in the
>Linked Server providers in SQL Server 2005. How do I go about adding a
>provider that is not in the existing provider list?
>Any ideas on how to either add the provider or create the linked server
>would be appreciated.
>Thanks
>- David

Linked Server gives Internal SQL Server error

Hi All,

I am accessing a linked server (also a SQL Server) from a stored
procedure. There is an insert statement that I run on a table in the
linked server. This statement causes the Internal SQL Server error. But
if I run the insert statement separately from Query Analyzer, it works
fine! Also, I put the stored procedure directly into the database on
the linked SQL Server and it ran fine on it. Has anybody come across
something of this sort?

Thanks,
Sanjeevmahajan.sanjeev@.gmail.com napisa(a):
> Hi All,
> I am accessing a linked server (also a SQL Server) from a stored
> procedure. There is an insert statement that I run on a table in the
> linked server. This statement causes the Internal SQL Server error. But
> if I run the insert statement separately from Query Analyzer, it works
> fine! Also, I put the stored procedure directly into the database on
> the linked SQL Server and it ran fine on it. Has anybody come across
> something of this sort?
> Thanks,
> Sanjeev

When you start procedure from query analyzer you do it as some user
but when this procedure is started by sql agent as job it is another
user which doesn't have an access to the database linked by linked
server, and this is the problem.

You can try to run this procedure from vbs for example with ado
connection the same as in query analyzer

Linked Server Error Between SQL Server and Oracle

I have used Linked Servers to hook up to an Oracle 9i database in SQL
Server 2000. I can see all the Tables and Views when I look in the
linked server section. I can also run the following SQL statement :

Select *
from Orcldb..SYSTEM.CrossTabSaveSites

and get a return result. The problem I realize is that some of the
tables are going to be quite larger and I can't wait for SQL Server to
download all the data and parse it itself, so I tried to use a
passthrough query like so :

SELECT * FROM OPENQUERY(OrclDB, 'SELECT * FROM
SYSTEM.CrossTabSaveSites')

Unfortunately this gives me the error message :

Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'MSDAORA'.
[OLE/DB provider returned message: ORA-00942: table or view does not
exist
]

There is also the issue of speed. It takes about 15 seconds to come
back to me to tell me that the table/view doesn't exist, but sometimes
it comes back immediately. Is this something with the user
permissions in Oracle? (Don't really know much about Oracle) It just
seems like a very long time to wait just to let me know that the item
doesn't exist.

Any help would be greatly appreciated,

-Jevon Thurlow"Jevon" <jevonthurlow@.hotmail.com> wrote in message
news:34e7f100.0404080933.2e40e19e@.posting.google.c om...
> I have used Linked Servers to hook up to an Oracle 9i database in SQL
> Server 2000. I can see all the Tables and Views when I look in the
> linked server section. I can also run the following SQL statement :
> Select *
> from Orcldb..SYSTEM.CrossTabSaveSites
> and get a return result. The problem I realize is that some of the
> tables are going to be quite larger and I can't wait for SQL Server to
> download all the data and parse it itself, so I tried to use a
> passthrough query like so :
> SELECT * FROM OPENQUERY(OrclDB, 'SELECT * FROM
> SYSTEM.CrossTabSaveSites')
> Unfortunately this gives me the error message :
> Server: Msg 7321, Level 16, State 2, Line 1
> An error occurred while preparing a query for execution against OLE DB
> provider 'MSDAORA'.
> [OLE/DB provider returned message: ORA-00942: table or view does not
> exist
> ]
> There is also the issue of speed. It takes about 15 seconds to come
> back to me to tell me that the table/view doesn't exist, but sometimes
> it comes back immediately. Is this something with the user
> permissions in Oracle? (Don't really know much about Oracle) It just
> seems like a very long time to wait just to let me know that the item
> doesn't exist.
> Any help would be greatly appreciated,
> -Jevon Thurlow

I can't tell you anything about the performance issue, but the ORA-00942
error is probably because Oracle is case-sensitive, and object names are
usually in upper case:

http://support.microsoft.com/defaul...kb;EN-US;240340
http://support.microsoft.com/defaul...kb;EN-US;280106

Simon

Linked Server - Query

Hey all,
I have an Access app that need to be able to Query a Linked Server. The
Linked Server points to an Access Database. When I put the Access App on th
e
SQL Box where SQL 2000 and the Linked Database reside, I am able to Query th
e
Linked Server from the Access App with a SELECT or SP containing a statement
such as:
"SELECT * FROM PCCW...TRANS"
But when I try to run this same Query from the same Access App on any other
machine, I get the error:
"Cannot start your application. The Workgroup information file is missing or
opened exclusively by another user"
Any help is appreciated as always!
Thanks,
GerardHi Gerard
Have you checked out
http://msdn.microsoft.com/library/d...serr_2_6jzt.asp
John
"Gerard" wrote:

> Hey all,
> I have an Access app that need to be able to Query a Linked Server. T
he
> Linked Server points to an Access Database. When I put the Access App on
the
> SQL Box where SQL 2000 and the Linked Database reside, I am able to Query
the
> Linked Server from the Access App with a SELECT or SP containing a stateme
nt
> such as:
> "SELECT * FROM PCCW...TRANS"
> But when I try to run this same Query from the same Access App on any othe
r
> machine, I get the error:
> "Cannot start your application. The Workgroup information file is missing
or
> opened exclusively by another user"
> Any help is appreciated as always!
> Thanks,
> Gerard