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.

Sql Server

General discussion forum about all databases other than SqlBase.
Post Reply
Giorgio Bravi
Italy
Posts: 3
Joined: 09 Mar 2017, 18:08
Location: Bergamo, Italy

Sql Server

Post by Giorgio Bravi » 10 Mar 2017, 12:00

I'm planning a migration from 5.2 to 7 of a large application (ERP) with SQL Server
Until now I used OleDB but in recent news Microsoft says it will be deprecated.
So we must go back to ODBC?
Does anyone have tips on this?
Thank you.

Giorgio

FRBhote
India
Posts: 23
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Sql Server

Post by FRBhote » 11 Mar 2017, 11:43

If all your connects are done by a single function, then I wouldn't worry about it - when the time comes you can modify just that function.

Gideon Schulter
Site Admin
Netherlands
Posts: 6
Joined: 07 Mar 2017, 08:46
Location: Lelystad, The Netherlands
Contact:

Re: Sql Server

Post by Gideon Schulter » 14 Mar 2017, 08:39

Hi Giorgio,

Microsoft dropped OLEDB support in the SQLServer Native client already.

If you want to keep using OLEDB from TeamDeveloper to a SQLServer 2014 or 2016 instance, you will need to install the Microsoft SQL Server Native Client 2012.
Both SQL Server 2014 and 2016 are compatible to the SQLServer 2012 Native client.

See: https://msdn.microsoft.com/nl-nl/library/cc280510.aspx

If your source implements SqlCreateSession/SqlCreateStatement/SqlCommitSession, it would be wise to start changing your code to just using SqlConnect.
Best regards,

Gideon Schülter
Lelystad - The Netherlands

Image

Giorgio Bravi
Italy
Posts: 3
Joined: 09 Mar 2017, 18:08
Location: Bergamo, Italy

Re: Sql Server

Post by Giorgio Bravi » 14 Mar 2017, 11:47

Many tanks to all

After some test i can confirm that using new connettivity data access speed up to 50% better

Giorgio

Post Reply

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest