Hi Jure,

our Server is MS SQL Server 2017

we used the ODBC Driver "SQL Server" and now "ODBC Driver 17 for SQL 
Server"
Both ar okay, but Security made us changing to "ODBC Driver 17 for SQL 
Server".

With normal fields (text, numbers, Integer) no problems.

BLOBS are special
Date and Time do not work, DateTime is okay using TimeStamp Fields On 
SQL Server.

SQL Server ==> Paradox is very fast

Paradox ==> SQL Server is slow.
Updating tables on SQL Server best via SQL-Statments.
Tcursor are in Trouble with DateTime-Fields.
Memo fields are best via TCursor - using 2 steps
1st all other data via SQL
2nd Memo -Fields via Tcursor

"merging" a local Table to SQL Server:
1st Create tmp table on SQL Server
2nd Update tmp table on SQL Server from Paradox
3rd use SQL Merge on SQL Server

reading not compatible data form SQL Server
use CAST

Thies






Am 23.03.2022 um 14:50 schrieb modridirkac:
> Hello everyone!
> 
> Now I need some help. (not directly linked to paradox)
> 
> Situation:
> I have some old app, written in Delphi, which uses DB tables.
> This app works OK, no need to rewrite it.
> 
> Then I have some WEB pages, hosted on IIS ina MsSQL.
> Those pages also work OK.
> 
> Problem:
> I need to read data from DB tables and use it on SQL.
> Now I do it with Intersolv drivers. And it works.
> BUT problem is, that those drivers work only on Win server 2013 (or older).
> So I have an old virtual machine just for that purpose.
> 
> What I would like:
> I would like to get rid of that old windows box and
> have MsSQL on new windows and connect to DB tables.
> 
> Can this be done and what drivers do I need?
> (links and/or short instructions would be very good)
> 
> Thx Jure