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.
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!
The forum site admins.
General discussion forum about all things SqlBase.
- Site Admin
- Posts: 20
- Joined: 05 Mar 2017, 20:57
- Location: Tauranga, New Zealand
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 * 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
INSERT INTO [LINKServerName]..[TableOwner].[TableName ]
,[ColumnName]) VALUES (Something,Something,'Something',Something,Something,Something,Something)
DELETE FROM [LINKServerName]..[TableOwner].[TableName ]
WHERE [ColumnName ] = Something
Who is online
Users browsing this forum: No registered users and 1 guest