<div>
You mean I have to replace code like X$=myRecordSet(&quot;MyMemoFiel<wbr />d&quot;) with getchunk calls? Care to elaborate (too lazy to go into that code today)?<br />

</div>


You mean I have to replace code like X$=myRecordSet("MyMemoField") with getchunk calls? Care to elaborate (too lazy to go into that code today)?


<div>
<div class="content wysiwyg-content">
I try to convert a VB program to use dbUseODBC workspaces. I get the following error when reading a field which is defined as text on MS SQL Server (which would be called memo in VB terms):<br />
<br />
Run-time error '0':<br />
<br />
S1109: [MS][SQL Server Driver]Invalid cursor position<br />
<br />
The type of the field in question is given correctly as dbMemo by DAO. Querying some other field properties, eg Size, produces the same error. While doing some trial and error debugging, I somehow managed to get a message like 'the requested action is not supported with the current version of the cursor library' - so I tried all combinations of OpenRecordset parameters that made sense to me, namely the locking options - to no avail.<br />
<br />
Anybody know what´s going on ? Tips?
</div>
</div>


I try to convert a VB program to use dbUseODBC workspaces. I get the following error when reading a field which is defined as text on MS SQL Server (which would be called memo in VB terms):

Run-time error '0':

S1109: [MS][SQL Server Driver]Invalid cursor position

The type of the field in question is given correctly as dbMemo by DAO. Querying some other field properties, eg Size, produces the same error. While doing some trial and error debugging, I somehow managed to get a message like 'the requested action is not supported with the current version of the cursor library' - so I tried all combinations of OpenRecordset parameters that made sense to me, namely the locking options - to no avail.

Anybody know what´s going on ? Tips?

DAO dbUseODBC w/ SQL Server text fields?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.