Xbase/VFP - Problems with Memo fields , Shared Files
Posted: Wed 09 Oct 2019 14:49
2 issues with most recent Driver Release and need help trying to resolve and not getting adequate help from support. Has Anyone else run into the same issues and if so, how was it resolved
I am using SQL server SSMS and have created an ODBC connection called "Test" and then created a 'Linked Server' using this connection and querying using Openquery()
1- Unable to included Memo Fields.
I created a simple test table with a couple of fields include 1 memo field. In my query I am simply doing a 'Select *' and get the following error. There are only 10 row
If any of the memo fields are empty/blank I get the error- which cannot be right as it possible to have memo fields without any data.
Msg 7342, Level 16, State 1, Line 10
An unexpected NULL value was returned for column "[MSDASQL].MEMO1" from OLE DB provider "MSDASQL" for linked server "TEST". This column cannot be NULL.
I make sure that each memo field had data and still get an error.
OLE DB provider "MSDASQL" for linked server "TEST" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Msg 7341, Level 16, State 2, Line 10
Cannot get the current row value of column "[MSDASQL].MEMO1" from OLE DB provider "MSDASQL" for linked server "TEST". The provider cannot allocate memory or open another storage object on this column.
-- So Unable to include ANY memo field in a query - with or without data.
2- The other issue I am having is that I am unable to query ANY table in the Path that is setup in the connection if anyone else as ANY table in the same path open- Whether involved in the openquery or not. So basically I can only use this when absolutely no one else using any of the files
I tried to query a table called 'TestTable' A very simple query and with VFP opened a table called 'Country'
select * from openquery(TEST,'Select * from [Testtable]')
OLE DB provider "MSDASQL" for linked server "TEST" returned message "[Devart][ODBC][xBase]Cannot open file "j:\rna\Country.DBF". The process cannot access the file because it is being used by another process".
Msg 7350, Level 16, State 2, Line 10
I was told by support that I need to change the connection mode to 'Unsafe' but still get the same results.
If anyone can provide assistance it would be greatly appreciated.
I am using SQL server SSMS and have created an ODBC connection called "Test" and then created a 'Linked Server' using this connection and querying using Openquery()
1- Unable to included Memo Fields.
I created a simple test table with a couple of fields include 1 memo field. In my query I am simply doing a 'Select *' and get the following error. There are only 10 row
If any of the memo fields are empty/blank I get the error- which cannot be right as it possible to have memo fields without any data.
Msg 7342, Level 16, State 1, Line 10
An unexpected NULL value was returned for column "[MSDASQL].MEMO1" from OLE DB provider "MSDASQL" for linked server "TEST". This column cannot be NULL.
I make sure that each memo field had data and still get an error.
OLE DB provider "MSDASQL" for linked server "TEST" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Msg 7341, Level 16, State 2, Line 10
Cannot get the current row value of column "[MSDASQL].MEMO1" from OLE DB provider "MSDASQL" for linked server "TEST". The provider cannot allocate memory or open another storage object on this column.
-- So Unable to include ANY memo field in a query - with or without data.
2- The other issue I am having is that I am unable to query ANY table in the Path that is setup in the connection if anyone else as ANY table in the same path open- Whether involved in the openquery or not. So basically I can only use this when absolutely no one else using any of the files
I tried to query a table called 'TestTable' A very simple query and with VFP opened a table called 'Country'
select * from openquery(TEST,'Select * from [Testtable]')
OLE DB provider "MSDASQL" for linked server "TEST" returned message "[Devart][ODBC][xBase]Cannot open file "j:\rna\Country.DBF". The process cannot access the file because it is being used by another process".
Msg 7350, Level 16, State 2, Line 10
I was told by support that I need to change the connection mode to 'Unsafe' but still get the same results.
If anyone can provide assistance it would be greatly appreciated.