Hello,
I have a problem. I've linked MySql server to MsSql, in MySql I have a
table with Latvian data(character set is ucs2, ucs2_general_ci) and
the problem is that when I use openquery to read data from MySQL
server, some characters are not translated correctly! I receive
question symbols instead of Latvian special characters.
Maybe someone had this kind of problem with collation?
When executing a query which joins against a large resultset from a linked server, SQL Server reports the following error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "foo" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "foo".
This is using SQL Server 2005 with SP2, and MyODBC version 3.51.16 (although previous versions also seem to have the same behavior).
Once the error occurs any subsequent query against the linked server (even something as simple as select top 3 * From foo...users) fails with the same error message. Queries using the OpenQuery syntax also fail with this error.
I've tried to determine if there are some error logs that might give me more insight into what's going on, but the above events don't seem to log to the ODBC trace logs. And I can't seem to figure out a way to trace the MSDASQL (i.e., oledb) events.
I initially thought there might be a problem with the MySQL myODBC driver, but the ODBC layer itself does not seem to have a problem. But the following steps indicate otherwise:
1. Create a new Linked Server to MySQL. Same error as above
2. Execute a query against the ODBC DSN directly, using a shell program. This works fine
I'm trying to clearly identify if the problem is with the MySQL driver or with the MSDASQL provider. It would appear that the latter is at fault, given the error message, and the lack of any ODBC logging.
Would anyone have any insights about what might be going on here, and if there is any possible resolution?
I am in the middle of a major migraton project, moving from x86 SQL 2000 to IA64 SQL 2005. I have a business need to link to several legacy servers. I have a number of problems I am trying to solve.
1) Linking a Kerberos server to a non-Kerberos server.
2) Linking x64 or IA64 servers to x86 servers.
3) Linking SQL 2005 to SQL 2000.
Two of the errors I am encountering are:
------------------------------
TCP Provider: An existing connection was forcibly closed by the remote host.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
OLE DB provider "SQLNCLI" for linked server "SCDC250DB" returned message "Communication link failure".
(Microsoft SQL Server, Error: 10054)
------------------------------
And
------------------------------
The OLE DB provider "SQLNCLI" for the linked server "SCDC250DB" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SCDC250DB".
OLE DB provider "SQLCLI" for linked server "SCDC250DB" returned message "Invalid authorization specification".
(Microsoft SQL Server, Error: 7399)
If someone has worked through these problems before, I would appreciate it if you could direct me to the relevant documentation to resolve these issues.
Thanks!
Brandon Forest
Database Administrator
Data & Web Services Team
Sutter Connect Information Technologyforesb@sutterhealth.org
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
Hi all, hoping someone can help.
I have created an ODBC connection to a remote MySQL database.
I can then go into DTS wizard and specify this ODBC connection, it all goes through fine and I can see the tables on the remote server and import data.
The problem arises when I try and create a linked server using the same ODBC connection. I get the following error, when I try to view the tables.
I am so stuck. Any help would be very much appreciated.
I am currently trying to complete part of my A-level coursework but am stuck.
i am creating a website for a restaurant on which customers can submit information to do with four areas:
---------------------
Bookings
Comments
Job Applications
Pre-order
----------------------
i have used access alot in the past and had no problems creating a running model of my final database.
i have built my website and created the four tables in the alloted MySQL area that came with my website package.
BIG QUESTION:
how do i create the interface for people to submit data and for it to be sent to my database?
i am a complete beginner to MySQL using it for the first time this week so im not sure what i need to do in the slightest to solve this issue
-------------
any help or advice would be VERY VERY gratefull
I need to have database access via an
application to both sql server 6.5 & 7
the 6.5 uses mixed mode security,
the 7.0 uses trusted. Using
sp_addlinkedsrvlogin I can get from a client to
the 7.0 server, but not to the 6.5.
Is this even possible?
Two SQL Servers1) "Test"Payroll DBTransaction Tablepr_SubmitTransaction in Payroll DB********************************************2) "Production"Payroll DBTransaction TablePr_SubmitTransaction in Payroll DBAccounts DBPr_VerifyAccounts (@AcctNumber)********************************************I want to use same pr_VeriftAccounts in both test and productionPr_SubmitTransaction stored procedure.The pr_SubmitTransaction in production works fine when I sayExec Payroll.dbo.pr_VerifyAccounts as it is on same server. (WORKSFINE)Exec [PRODUCTION].Payroll.dbo.pr_VerifyAccounts (DOES NOT WORK)Should I use sp_addlinkedServer ?? to do this ?. Please provide me somefeedback.I know I can acheive this by front end, but I was do it in one storedprocedure.
View 7 Replies View Related
We have reporting services on 1 server, while the data comes off of another which does not have rs and on sql server 2000. I was able to build the reports and deploy it. But the report wont render. The error message is shown below.
My question is will linking servers work and if anyone has done this could you pl provide an example?
Thanks in advance
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'sds1'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
I'm using SQl 7.0. After setting up a linked server. I recieve this
error when attempting to connect to the linked server: 'Error 7302 -
could not create an instance of OLEDB provider 'SQLOLEDB'. Any ideas??
I do not recieve this error when linking from another server.
Thanks,
Steve Bajada
Hi.I have two sql servers and have ran exec sp_addlinkedserver 'ACSPSM', N'SQLServer' to link one to the other and also vise versa.Each server has two users permissioned.My problem is when ever I try to do something that does a remote write I getthe follow error messageMicrosoft OLE DB Provider for SQL Server error '80040e14'[OLE/DB provider returned message: Cannot start more transactions on thissession.]Alsowhen I try and manually run a stored procedure, I get:Remote tables are not updatable. Updatable keyset-driven cursors on remotetables require a transaction with the REPEATABLE_READ or SERIALIZABLEisolation level spanning the cursor.(1 row(s) affected)(1 row(s) affected)(50 row(s) affected)Server: Msg 7395, Level 16, State 2, Procedure ams_Move_Stock_To_PSM, Line65Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. Anested transaction was required because the XACT_ABORT option was set toOFF.[OLE/DB provider returned message: Cannot start more transactions on thissession.]Can anyone suggest how I resolve this.FYIDatabase Creation Script: (both database are the same scripts but db namesare changed)CREATE DATABASE [msmprim] ON (NAME = N'msmprim_Data', FILENAME =N'D:ACS_DBdatamsmprim_Data.MDF' , SIZE = 2000, FILEGROWTH = 10%) LOG ON(NAME = N'msmprim_Log', FILENAME = N'D:ACS_DBlogsmsmprim_Log.LDF' , SIZE= 2000, FILEGROWTH = 10%)COLLATE Latin1_General_CI_ASGOexec sp_dboption N'msmprim', N'autoclose', N'false'GOexec sp_dboption N'msmprim', N'bulkcopy', N'false'GOexec sp_dboption N'msmprim', N'trunc. log', N'false'GOexec sp_dboption N'msmprim', N'torn page detection', N'true'GOexec sp_dboption N'msmprim', N'read only', N'false'GOexec sp_dboption N'msmprim', N'dbo use', N'false'GOexec sp_dboption N'msmprim', N'single', N'false'GOexec sp_dboption N'msmprim', N'autoshrink', N'false'GOexec sp_dboption N'msmprim', N'ANSI null default', N'false'GOexec sp_dboption N'msmprim', N'recursive triggers', N'false'GOexec sp_dboption N'msmprim', N'ANSI nulls', N'false'GOexec sp_dboption N'msmprim', N'concat null yields null', N'false'GOexec sp_dboption N'msmprim', N'cursor close on commit', N'false'GOexec sp_dboption N'msmprim', N'default to local cursor', N'false'GOexec sp_dboption N'msmprim', N'quoted identifier', N'false'GOexec sp_dboption N'msmprim', N'ANSI warnings', N'false'GOexec sp_dboption N'msmprim', N'auto create statistics', N'true'GOexec sp_dboption N'msmprim', N'auto update statistics', N'true'GOUser Creation Script:/****** Object: Login MSM Script Date: 31/10/2002 10:41:26 ******/use [msmprim]GOdeclare @sqlLoginName nvarchar(32) select @sqlLoginName = N'msm'declare @UserPassword nvarchar(32) select @UserPassword = N'wibble'declare @logindb nvarchar(132) select @logindb = N'msmprim'declare @loginlang nvarchar(132) select @loginlang = N'British English'if not exists (select * from master.dbo.syslogins where loginname =@sqlLoginName)BEGINif @logindb is null or not exists (select * from master.dbo.sysdatabaseswhere name = @logindb)select @logindb = N'master'if @loginlang is null or (not exists (select * from master.dbo.syslanguageswhere name = @loginlang) and @loginlang <> N'British English')select @loginlang = @@languageexec sp_addlogin @sqlLoginName, @UserPassword, @logindb, @loginlangEND/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/if not exists (select * from dbo.sysusers where name = @sqlLoginName and uid< 16382)EXEC sp_grantdbaccess @sqlLoginName, @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_datareader', @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_datawriter', @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_owner', @sqlLoginNameGOuse [msmprim]GOdeclare @sqlLoginName nvarchar(32) select @sqlLoginName = N'psm'declare @UserPassword nvarchar(32) select @UserPassword = N'wibble'declare @logindb nvarchar(132) select @logindb = N'msmprim'declare @loginlang nvarchar(132) select @loginlang = N'British English'if not exists (select * from master.dbo.syslogins where loginname =@sqlLoginName)BEGINif @logindb is null or not exists (select * from master.dbo.sysdatabaseswhere name = @logindb)select @logindb = N'master'if @loginlang is null or (not exists (select * from master.dbo.syslanguageswhere name = @loginlang) and @loginlang <> N'British English')select @loginlang = @@languageexec sp_addlogin @sqlLoginName, @UserPassword, @logindb, @loginlangEND/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/if not exists (select * from dbo.sysusers where name = @sqlLoginName and uid< 16382)EXEC sp_grantdbaccess @sqlLoginName, @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_datareader', @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_datawriter', @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_owner', @sqlLoginNameGO
View 1 Replies View RelatedI have two production servers with two different databases and I was thinking about using Linked Servers, but never did this before.Found this stored procedure
sp_addlinkedserver('servername').Would you just execute this and then run your query after the SP?
Hello all!
How do I go about linking two SQL Server Express servers? I can't seem to find information on this.
Also, I need to import data from MSDE. Is there anyway to do this?
Regards,
Andrew Cappella-Pakos
Hello,
I was wondering whether it is possible to query linked servers in SQL Server Management Studio Express 2005 if those servers linked to are SQL Server 2000 machines?
I have added some linked servers to express and queried them, however the login timeout is expiring. I thought it might be because of an incompatability.
Cheers,
Damien.
I know this is an easy one for most of you but this is new territory for me.
I am trying to link a production application database to an existing SMS database.
Both of these databases are SQL 2000. I have sa access to both of them.
I have an accreditation application that deals with internal processes within our active directory network. We are using SMS database collections to provide the discovery for reporting of this application database and I want to compare the collection to the existing data between the 2 databases.
For simplicity I will define them both.
Application Database we will call €śA-Database€?
SMS Database we will call €śB-Database€?
I have gone into the A-Database and gone to linked Servers under the security node in enterprise manager. I created a new linked database and selected the SQL Server option in the general Tab.
In the Security Tab I selected the €śBe made using the security context€? and used €śsa€? for the Remote login and the CORRECT sa password for the With password option.
The server options tab remain the same with €?RPC, RPC Out, & Use Remote Collation€? selected.
It appears to connect but there is not any Table or Views showing up. What am I doing wrong here and what do I need to do to link these 2 database engines so I can move forward?
Thanks,
Gene Godsey
Is it possible to connect to different databases on different serversso i can merge them as one.I heard there is a tool that does this but still to come accross itany help appreciated.
View 1 Replies View RelatedI am using vb.net and the myoledb provider.I've run into a problem where what I need to do is open a databaseconnection to a mysql server, easy. The problem arrises in that I wantto, if the server cannot be found, open from a locally storedencrypted XML file.Works fine when the sever is present, but when I go to open theconnection and the database cannot be found, a dialog box pops up as tofill in the connection string information. I do not want this, is thereany way I can intercept this dialog or skip past it so my try/catchhandles it?Thanks.--Posted via http://dbforums.com
View 2 Replies View RelatedHi all,
I have a query that I need to run where I join two tables that both
reside on different servers. I use an INNER JOIN statement to attempt
to join these tables, but for some reason I am getting the following
error message...
"
Cannot resolve collation conflict for equal to operation."
The query is as follows...
SELECT TABLE_NAME, LEFT(TABLE_NAME, CHARINDEX('_', TABLE_NAME + '_') - 1) AS Abbreviation
FROM mrcsmis.INFORMATION_SCHEMA.TABLES
INNER JOIN DEVELCAD1.Portal.dbo.dnl_db_names_log AS imp ON (imp.dnl_table_name = TABLE_NAME)
WHERE (TABLE_TYPE = 'BASE TABLE')
Thanks
Tryst
Hi Guys
I am trying to create a Linked server on Sql Server 2000 with Collation
Latin1_General_CI_AS with an Sql 2005 Server having collation SQL_Latin1_General_CP1_CI_AS
When i created the Linked server using the MSDASQL Provider and try to expand the Linked server node It throws the following error
Cannot Resolve collation Conflict for equal to Operation
How do i resolve this problem?
Vic
I have created a linked server to a MySQL database using a DSN. Does anyone know how to run a select statement against a table in the MySQL database? The usual 4 part naming convention does not work.
I can run SELECT *
FROM OPENQUERY(Top50, 'SELECT * FROM orders') which does return records successfully. (Top50 being the name of the linked server)
My objective is to be able to insert records into the MySQL database and I am not sure how do to that using OPENQUERY. Any thoughts on that would be appreciated as well.
Thanks in advance.
Anyone know how to go about getting data from MySql to MS SQL server? Im a little confussed as to what ODBC driver is needed and all that. Is it possible to this all through enterprise manager? Thanks a lot.
View 1 Replies View Related:confused: Hallo! I'm trying to link a MySql 's DB in SQLServer with ODBC: the operation was susseful but I'm not able to read and write/update the data.
HELP ME PLEASE!!!
silvia, Italy
We are trying to do a linked server to MySQL from MS SQL2k. We downloaded MyODBC drivers, setup the system dsn successfully but then SQL errors out using both the GUI and the stored proc to add the linked server to mysql. Does anyone have a good site to reference or any words of advice. An hr or so of google didn't really give up any helpfully information.
Thanks,
DMW
Hi,
I have a problem , I created a linked server to mysql with following parameters:
New linked server: ServerName
Server Type: Other data Source: Microsoft OLE DB Provider for ODBC Drivers.
In the Provider String:Driver={mySQL ODBC 3.51 driver};Server="ip";Port=3306;Option=17923;Stmt=;Database="database";Uid=root;Pwd="pwd"
And I created a ODBC with mysql, and connection worked sucessfully!
The connection worked corretly until I' ve running a transact query in sql query analyzer, thats connects to MySQL and...
when I try to connect in SQL Server 2000 standard Ed. in linked Server, the following message appears to me now, and before this I was able to connect!
Server: Msg 7399, Level 16, State 1, Line 11
OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure.
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 169 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x8000ffff: The provider reported an unexpected catastrophic failure.
The query just make a select in MySQL, but I think that broke something...
What I have to do?
reply to my email: daniel.sarnes@antilhas.com.br
Thanks a lot!
We have SQL Server 2000 on a Windows 2000 server and a mySQL database running on a Windows 2000 server.
We have used MyOLEDB driver(OLEDB) to link the mysql database.
How can I access the data stored in a Linked server?
Any help would be appreciated.
Thanks!!
this is our codeˇG
exec sp_addlinkedserver @server='OLEDB_test',
@srvproduct=N'',
@provider=N'MySQLProv',
@datasrc=N'203.xx.xx.xx',
@catalog = N'Store'
exec sp_addlinkedsrvlogin 'OLEDB_test','false',null,'root',''
select * from OLEDB_test.Store.root.Books
or
select * from OLEDB_test.Store..Books
error message:
Can't create OLE DB Provider 'MySQLProv' instanceˇC
OLE DB error trace [Non-interface error: CoCreate of DSO for MySQLProv returned 0x80040154]ˇC
by the wayˇG
1.We Create an ODBC System DSN that points to our MYSql server
2.We use OLEDB for ODBC to create a linked server to mySQL
3.We have got the query to work with openquery
but we can't updateˇBdeleteˇBmodify the data stored in a Linked server
Hi,
I've installed MyODBC-3.51.06 and succsesfully created 2 odbc sources to the MySQL database with the ODBC data source administrator. One is a User DSN, the other a system DSN (Q1: what's the difference?) The test in that applet perfoms positively.
Running a dataimport of the tables using the import data option in enterprise manager does work as well.
Now for the part that gives me trouble. I would like to create a linked server using enterprise manager of SQL server 2000 (SQL 8.00.194) but I'm totaly stuck there. So Q2: how to get this set up?
Hi,
I have setup a MYSQL server as a linked server in SQL SERVER 2000. I am able to select from a table using OPENQUERY as I understand that you can't use the 4 part qualifier to access an object from MYSQL as the ODBC driver does not expose the proper interface for this. The problem is that I cannot update,delete or insert into the OPENQUERY() table
eg.
UPDATE OPENQUERY(MySQL_LinkedServer,'select id from msqlTableTest') SET id = 0
INSERT INTO OPENQUERY(MySQL_LinkedServer,'select id from msqlTableTest') VALUES(0)
DELETE FROM OPENQUERY(MySQL_LinkedServer,'select id from msqlTableTest') WHERE id = 0
This is the OLEDB PROVIDER FOR ODBC error I am getting...
The requested operation could not be performed because the OLE DB provider 'MSDASQL' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::QueryInterface returned 0x80004002].
I know there are brilliant Professionals on this forum. Please tell me that this is just an MDAC upgrade or something that is not configured correctly...
Good Morning
the available oledb providers for mysql don't seem to work with sqlserver 2005.
So whats the best way these days of exposing data from within sql server from a mysql data base.
What I wanted to do was create a linked server connection to the mysql server using either oledb or odbc, but neither seem to work.
There is a .net provider for mysql, but that won't work to create a linked server connection.
any ideas appreciated.
What I want to do is write some scheduled proceedual sql from within sql server to query some tables in mysql and update some sqlserver tables.
thanks
David Hills
I can create a linked server to another MsSQL from MsSQL,but encounter error when create a linked server to MySQL:
Error 7399:OLE DB provider 'MSDASQL' reported an error.
Data source name not found and no default driver specified.
......
Anyone can help me?
Thanks!
I'm trying to use linked server to import big amount of data(around 9 million rows) from mysql to a sql 2005 table.
I plan to create a stored procedure and use job agent to run it at off-peak time everyday. The SP is like:
.....
Truncate table sqltblA;
Insert Into sqltblA(col1, col2, col3)
Select col1, col2, col3
From OpenQuery('mysql', 'Select col1, col2, col3 From mytblB')
.....
But when I tried to CREATE the above SP from management studio, seems the sql server was trying to get all data from table mytblB and ended up with failure after several minutes hang. The error message is sth. like "running out memeory". BTW, during that several minutes hang, I can't query mytblB using mysql's tool as well. it seems to me that table got locked.
However if i try to change the returned result to 100,000 rows by changing script to
Insert Into sqltblA(col1, col2, col3)
Select col1, col2, col3
From OpenQuery('mysql', 'Select col1, col2, col3 From mytblB Limit 100000')
The SP could be created without any problem and running the SP could get the data in table sqltblA.
But that's not what I want, I need all rows instead of a certain amount of rows.
Does anyone know what's going on there when I try to CREATE that SP and any solution to it?
Plus I tried to use SSIS as well. When I'm configuring the DataReader source, which uses ADO.NET's ODBC option to connect to mysql, if its sqlcommand is "select * from mytblB" without the Limit key word, then the configuration page will hang there as well and table mytblB is not accessible by using mysql tool. I'm just sick of wasting time on that and that's why I chose to use SP istead of SSIS. But same result. :-(
Is it possible to link to an SQL 2005 server db from a SQL 2000 server? Is there a driver for this?
View 1 Replies View Relatedcan anybody tell me about Linked Servers and their uses and how to add a linked server to my Sql Server 2005.
any help on this would be highly appreciated.
Hello All,
I have been trying to Link two sql servers on two different machines over the Internet without any luck. Can someone point me to information about doing this with good examples?
Thanks