BomberMan2K
Programmer
Hi,
I have this weird problem that i would be grateful if any one could help.
I've moved from an Access DB to SQL Server using SQL Server Migration tool. All is fine, but a certain field field just doesn't send back when I try to get it using ASP code.
That's a nvarchar(MAX) field.
It seems that if I use ODBC to access the server, I can't get this field, and if I use JET.OleDb.4 I get this field.
The catch is that even if I get back to Access and use ODBC on it, i still can't get this field.
The catch might that the DB has Hebrew language fields as well. Even if I write only English chars in the field, it still doesn't return me anything.
If I check the field returned for null or emptiness - I almost always get an empty field, but sometimes it doesn't recognize it as empty or null - but still prints nothing.
Would appreciate some help,
Good day,
Roman.
I have this weird problem that i would be grateful if any one could help.
I've moved from an Access DB to SQL Server using SQL Server Migration tool. All is fine, but a certain field field just doesn't send back when I try to get it using ASP code.
That's a nvarchar(MAX) field.
It seems that if I use ODBC to access the server, I can't get this field, and if I use JET.OleDb.4 I get this field.
The catch is that even if I get back to Access and use ODBC on it, i still can't get this field.
The catch might that the DB has Hebrew language fields as well. Even if I write only English chars in the field, it still doesn't return me anything.
If I check the field returned for null or emptiness - I almost always get an empty field, but sometimes it doesn't recognize it as empty or null - but still prints nothing.
Would appreciate some help,
Good day,
Roman.