Dear guest !

Welcome to Team Developer Community Forum. A place created by the community, for the community !

This is a resource for Q & A and discussion about everything related to OpenText Gupta Team Developer, SqlBase, TD Mobile and Report Builder.
It is the alternative for the OpenText customer forums which can only be accessed with an active support contract.

Please register your account now. It will make you part of the active community.
Also, this guest message will not be displayed for registered users.

As a bonus, registered users have access to the 'Newsgroups' subforum, holding 10 years worth of posts from the good old Gupta newsgroups.

Having an account gives you the opportunity to ask questions and get help from others.
We hope this free gathering will help you and the community getting forward!

Best regards,
The forum site admins.

Using 'Linked Servers' for SQLServer <--> SQLBase

General discussion forum about all things SqlBase.
Post Reply
Steve Leighton
Site Admin
New Zealand
Posts: 19
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand
Contact:

Using 'Linked Servers' for SQLServer <--> SQLBase

Post by Steve Leighton » 13 Mar 2017, 22:09

Using the Gupta OLE provider SQLBASEOLEDB is a good way to extract and /or update data from SQLBase into SqlServer or vice versa .
You can specify a SQL.ini file to use for some of the settings - and easily access data from either sources across remote servers.
Tips and Tricks:
[*]Once you have created a Linked Server in SqlServer , be sure to 'Allow Inprocesses' ( Right click properties of SQLBASEOLEDB under 'Providers' in SSMS)
[*]The SELECT and the UPDATE/INSERT/DELETE from within SqlServer actually have different syntax:

Code: Select all

--Select:
SELECT * FROM OPENQUERY( LINKServerName, 'Select * from TableOwner.TableName where ColumnName = Something') 

--Update ( Change the PK to the appropriate value ):
UPDATE [LINKServerName]..[TableOwner].[TableName ]
   SET [ColumnName] = [Something]
WHERE ColumnName = Something
GO

--Insert :
INSERT INTO [LINKServerName]..[TableOwner].[TableName ]
         ([ColumnName]
		   ,[ColumnName]
		   ,[ColumnName]
		   ,[ColumnName]
		   ,[ColumnName]
		   ,[ColumnName]
		   ,[ColumnName])     VALUES (Something,Something,'Something',Something,Something,Something,Something)
GO

--Delete :
DELETE FROM [LINKServerName]..[TableOwner].[TableName ]
      WHERE [ColumnName ] = Something

GO
Best wishes
Steve
Bankside Systems Ltd. ( New Zealand )
www.banksidesystems.co.uk

Post Reply

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest