Hello Jan,
It works fine now. Thanks for the help.
With best regards,
Spin
Search found 9 matches
- 26.04.2023, 17:34
- Forum: ADO
- Topic: MsSql 2008 nvarchar(max) problem
- Replies: 12
- Views: 1408
- 21.04.2023, 22:26
- Forum: ADO
- Topic: MsSql 2008 nvarchar(max) problem
- Replies: 12
- Views: 1408
Re: MsSql 2008 nvarchar(max) problem
Hello Jan,
I have attached the requested files.
With best regards,
Spin
I have attached the requested files.
With best regards,
Spin
- 18.04.2023, 09:57
- Forum: ADO
- Topic: MsSql 2008 nvarchar(max) problem
- Replies: 12
- Views: 1408
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...
- 23.03.2023, 18:48
- Forum: ADO
- Topic: MsSql 2008 nvarchar(max) problem
- Replies: 12
- Views: 1408
Re: MsSql 2008 nvarchar(max) problem
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
- 22.03.2023, 20:10
- Forum: ADO
- Topic: MsSql 2008 nvarchar(max) problem
- Replies: 12
- Views: 1408
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...
- 21.03.2023, 19:48
- Forum: ADO
- Topic: MsSql 2008 nvarchar(max) problem
- Replies: 12
- Views: 1408
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
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
- 20.03.2023, 19:23
- Forum: ADO
- Topic: MsSql 2008 nvarchar(max) problem
- Replies: 12
- Views: 1408
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,...
- 28.02.2023, 23:36
- Forum: ADO
- Topic: MsSql 2008 nvarchar(max) problem
- Replies: 1
- Views: 332
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...
- 28.02.2023, 10:50
- Forum: ADO
- Topic: MsSql 2008 nvarchar(max) problem
- Replies: 12
- Views: 1408
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...