These web pages that connect directly to SQL, do you want to connect 
directly to .db tables from the web pages? How are you connecting the 
web pages to SQL Server?

On 24/03/2022 8:46 pm, Thies Grimm wrote:
> 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
>