PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV 2024 → HFSQL as Microsoft SQL Linked Server - Memo column issue
HFSQL as Microsoft SQL Linked Server - Memo column issue
Iniciado por TobiasDC, jan., 27 2024 8:21 AM - Sem resposta
#1
Membro registado
1 mensagem
Publicado em janeiro, 27 2024 - 8:21 AM
Hello,

We added an HFSQL server as a linked server to a Microsoft SQL Server. We've created a System DSN in Windows using the HFSQL ODBC driver. And we're calling this DSN from the Micsorosft SQL server using MSDASQL (Microsoft OLE DB provider for ODBC drivers)
I'm able to connect to the server, view all tables in the database and select data from the tables using a query where we specify columns with 'normal' datatypes:
--- SELECT varchar_column from [LINKED_SERVER]...[DB_Table]

But when we do a SELECT statement where memo columns (in mmo files) are used, we get below error:
--- SELECT mmo_memo_column from [LINKED_SERVER]...[DB_Table]
--- SELECT * FROM OPENQUERY ([LINKED_SERVER], 'SELECT mmo_memo_column FROM DB_Name.DB_Table')

OLE DB provider "MSDASQL" for linked server "***" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
OLE DB provider "MSDASQL" for linked server "***" returned message "[Microsoft][ODBC Driver Manager] Driver does not support this function".
Msg 7341, Level 16, State 4, Line 6
Cannot get the current row value of column "[MSDASQL].mmo_memo_column" from OLE DB provider "MSDASQL" for linked server "LINKED_SERVER". [COLUMN_NAME= mmo_memo_column STATUS=Unknown DBBINDSTATUS]

Has anyone encountered this? I tried casting the mmo column to less then 8000 chars, even less then 100 chars. I tried SUBSTR as well.
Does one need to use specific parameters in the ODBC connection string to be able to select data from mmo columns?

Thanks!
Mensagem modificada, janeiro, 27 2024 - 8:25 AM
→ Voltar para WINDEV 2024