Search found 9 matches

by spin
26.04.2023, 17:34
Forum: ADO
Topic: MsSql 2008 nvarchar(max) problem
Replies: 12
Views: 1340

Re: MsSql 2008 nvarchar(max) problem

Hello Jan,

It works fine now. Thanks for the help.

With best regards,

Spin
by spin
21.04.2023, 22:26
Forum: ADO
Topic: MsSql 2008 nvarchar(max) problem
Replies: 12
Views: 1340

Re: MsSql 2008 nvarchar(max) problem

Hello Jan,

I have attached the requested files.

With best regards,
Spin
by spin
18.04.2023, 09:57
Forum: ADO
Topic: MsSql 2008 nvarchar(max) problem
Replies: 12
Views: 1340

Re: MsSql 2008 nvarchar(max) problem

Now I have another problem using OLEDB and I am asking for help. If there is no "öüóőúáűé" character in the first query, it works fine, in the next query there can already be "öüóőúáűé" characters. After restarting the application, if there is "öüóőúáűé" character in th...
by spin
23.03.2023, 18:48
Forum: ADO
Topic: MsSql 2008 nvarchar(max) problem
Replies: 12
Views: 1340

Re: MsSql 2008 nvarchar(max) problem

:D

Hello Jan,

Everything works fine.
This is a good connection string:
Provider=MSOLEDBSQL;DataTypeCompatibility=80;Server=myServerAddress;Database=myDataBase;UID=myUsername;PWD=myPassword;

Both OLEDB and ADO work fine.
Thank you all for your help!

With best regards,

Spin
by spin
22.03.2023, 20:10
Forum: ADO
Topic: MsSql 2008 nvarchar(max) problem
Replies: 12
Views: 1340

Re: MsSql 2008 nvarchar(max) problem

Hello Jan, MsSql server: Microsoft SQL Server Express Edition with Advanced Services version: 10.50.4000.0 It gave the following error with the OLEDB protocol: Error Message: SQL Error: OLEDB Error SQLState: IM002 Native error: 0 Error message: [Microsoft][ODBC Driver Manager] Data source name not f...
by spin
21.03.2023, 19:48
Forum: ADO
Topic: MsSql 2008 nvarchar(max) problem
Replies: 12
Views: 1340

Re: MsSql 2008 nvarchar(max) problem

Hello Jan,

I'll try it tomorrow, I hope I'll have time for it, I won't get another job.
I hope this is the latest: zeoslib-code-0-r7974-branches-8.0-patches.zip

With best regards,
Spin
by spin
20.03.2023, 19:23
Forum: ADO
Topic: MsSql 2008 nvarchar(max) problem
Replies: 12
Views: 1340

Re: MsSql 2008 nvarchar(max) problem

Thank you for your quick response. In response to the questions: I tried in CodeTyphon Studio, there is Zeos 8.0, but it was not good here either. This was an old MySql database, it was converted to MsSql at the request of the administrator. (I used MSSQLConnection). Now you have to return to MySql,...
by spin
28.02.2023, 23:36
Forum: ADO
Topic: MsSql 2008 nvarchar(max) problem
Replies: 1
Views: 311

MsSql 2008 nvarchar(max) problem

MsSql 2008 nvarchar(max) problem I am asking for help with the following problem: Zeos version: 7.2.14-release Lazarus version: 2.2.4 FPC: 3.2.2 Operating system: win10 ZConnection properties: AutoEncodeStrings=ON codepage=CP_UTF8 controls_cp=CP_UTF16 ZConnection protocol: ado After connecting, I c...
by spin
28.02.2023, 10:50
Forum: ADO
Topic: MsSql 2008 nvarchar(max) problem
Replies: 12
Views: 1340

MsSql 2008 nvarchar(max) problem

MsSql 2008 nvarchar(max) problem : I am asking for help with the following problem: Zeos version: 7.2.14-release Lazarus version: 2.2.4 FPC: 3.2.2 Operating system: win10 ZConnection properties: AutoEncodeStrings=ON codepage=CP_UTF8 controls_cp=CP_UTF16 ZConnection protocol: ado After connecting, I...