Lost your password?

Blogs about: Linked Server

Featured Blog

Oracle Database Links & SQL Server Linked Servers

SQLWebLogger wrote 1 month ago:     Oracle SQLServer SQL to get a list DBLink /linked server Select * from ALL_DB_LINKS; E … more →

Tags: Oracle, SQL, SQLSERVER, Database Link, dblink, oracle db link, sql server linked server

MS SQL Server - Error - Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET.

danieladeniji wrote 1 month ago: Earlier today, a business user wanted to know why a 4 GB text file was not properly imported into a … more →

Tags: technical, OpenRowSet

Linked Server

7explications wrote 1 month ago: Linked Server Excel 2007 Linked Server Lets see How to create a linked server with Excel 2007. Well … more →

Tags: Linked Server Office 2007, Linked Server Excel, Link Server FoxPro, Link Server Access, Link Server other database

How to parametrize OPENQUERY in MSSQL

Raghunath Bhandari wrote 1 month ago: How to parametrize OPENQUERY in MSSQL: MSSQL has good feature of linked server between two different … more →

Tags: Parametrize OPENQUERY, How to parametrize OPENQUERY in MSSQL, Microsoft SQL Server, MSSQL tricks, OPENQUERY, parametrize query, Tips

Created a linked server to MySQL

sheezy wrote 6 months ago: Just a little background.  My company is currently running a MSSQL server for internal and external … more →

Tags: Work, mysql, SQL Server, headache, MSSQL, phpMyAdmin, DSN, Connector/ODBC

Current happenings

sheezy wrote 6 months ago: Right now for work, I am working on making a MySQL database that will lie externally and handle the … more →

Tags: Work, mysql, SQL Server, Joomla

Checking Permissions on Linked Servers

Kendra wrote 7 months ago: One reason I started this blog was just the idea of going through my catalog of scripts and reviewin … more →

Tags: Sample Code, Security, SQL Server 2005, Permissions

Using Data from Access in SharePoint via SQL

sharepointdiva wrote 8 months ago: This is a reoccurring issue I have; I don’t know C# beyond one program I wrote 3 years ago whe … more →

Tags: MOSS 2007, SharePoint, ShareVis, SQL, Access, CADworks, Database Connection, dataview, Sharepoint Designer

SQL Server 2005 Linked Server

Rob Bamforth wrote 1 year ago:   In this example SERVER 1 is the server bieng linked to. SERVER 2 is the server bieng linked from. … more →

Tags: SQL, SQL Server 2005, connect server

Connect to MySQL database from SQL server1 comment

Rob Bamforth wrote 1 year ago: First of all you need to download the MySQL connection / ODBC driver. The ODBC driver can be downloa … more →

Tags: SQL, mysql linked server, SQL Server, connect sql server to mysql server

Set MSSQL 2000 Linked Server ke MySQL

Moch. Firmansyah wrote 1 year ago: Beberapa hari ini saya dapet tugas mengeksplore aplikasi HRD tapi databasenya menggunakan mysql, … more →

Tags: MSSQL / SQL Server, MySQL to SQLServer, mysql, SQL Server, MSSQL

How to Connect Oracle from SQL Server

Admin wrote 1 year ago: Berikut adalah cara setting Connection SQL Server to Oracle : Install Oracle Client di SQL Server Ma … more →

Tags: SQL Server, Oracle

Linked Server : SQL Server 2005 x64 > SQL 2000 x32

dsarvan wrote 1 year ago: I had created a linked server from SQL Server 2005 x64 to export data to SQL 2000 server x32. In the … more →

Tags: SQL, SQL 2005, Linked Servers, SQL 2005 to SQL 2000

SQL SERVER - Executing Remote Stored Procedure - Calling Stored Procedure on Linked Server47 comments

pinaldave wrote 2 years ago: I was going through comments on various posts to see if I have missed to answer any comments. I real … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T-SQL

SQL Server Basics

Admin @ srt7 wrote 1 year ago: If you are a database developer you better know your basics on SQL Server. This article from Pinal D … more →

Tags: technology, SQL Server, RDBMS, Triggers, Stored Procedures


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS