Sql Server

General discussion forum about all databases other than SqlBase.
Giorgio Bravi
Italy
Posts: 4
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: 34
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
Site Admin
Netherlands
Posts: 6
Joined: 07 Mar 2017, 08:46
Location: Lelystad, The Netherlands

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: 4
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

gigit
Italy
Posts: 12
Joined: 14 Jun 2017, 15:04
Location: Italy

Re: Sql Server

Post by gigit » 06 Oct 2017, 08:59

Hi George,
I connect to all versions of SqlServer with all versions of TD with this in the ODBC session of sql.ini:

REMOTEDBNAME=AGEPROS,Driver=Sql Server;Server=GIGI01\SQL20012;Database=agepros;LastUser=sa;UseProcForPrepare=0;AnsiNPW=No;QuotedId=No;AutoTranslate=No;Language=English;

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

Re: Sql Server

Post by Giorgio Bravi » 09 Oct 2017, 14:28

I was using the same until TD5.2 then changed to OLEDB
Now it's time to go back (forward?) to ODBC in the process to migrate to TD7

Thank for the info.

Giorgio

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

Re: Sql Server

Post by FRBhote » 17 Oct 2017, 06:36

Just trying TD7. The same SQL.ini and the same SqlDatabse, SqlUser and SqlPassword which connects in TD 2.1 gives a 00401 DBA COD Cannot open database.

Is there any change - don't see anything in the documents.
[win32client]
clientname=FRB
setzerolengthstringstonull=on


[win32client.dll]
comdll=sqlora32
comdll=sqlodb32
comdll=sqlws32


[odbcrtr]
remotedbname=V,DSN=V

Return to “General Discussion”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests