PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
HFSQL as Microsoft SQL Linked Server - Memo column issue
HFSQL as Microsoft SQL Linked Server - Memo column issue
Started by TobiasDC, Jan., 27 2024 8:21 AM - No answer
Connect yourself…
TobiasDC
#1
Registered member
1 message
Posted on January, 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!
Message modified, January, 27 2024 - 8:25 AM
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text