What line has the actual error? Is it happening on the same machine that the
XML is being created?
Yes, it happens in the same machine. You see, since I always use private
data session forms, when I pass a cursor from one to the other I use
XMLAdapter. It is the perfect way to do it, since there is no need to
save the cursor in the disk from the calling form and then lifting it in
the called form. The xml variable is passed directly from the first form
to the second and the latter transforms the xml received into the
original cursor.
I can pass a cursor back and forth in this manner and never have any issues.
But this network is giving me trouble from the start. The first problem
I had was with the sql driver (SQL Server Native Client 10.0) which I
downloaded from the MS site and installed it in the Home Basic machines,
othewise the ODBC connection gave me saving errors.
Now I get this error again, even though the Native client 10.0 is installed.
I even installed the full version of VFP9 with SP2 in them, thinking
that perhaps is some installation issue, but no.
I can try to have the machines use the exe version from the server. I
usually do not do that, placing the exe in each machine, so as to use
their own resources. That makes the network real fast. But this is a
very small LAN (only 3 machines) so I do not think that would be an issue.
What do you think? Also, what do you mean by:
the Regional settings may be different
across the machines.
Rafael
El 04/03/2015 a las 18:50, Tracy Pearson escibió:
Rafael Copquin wrote on 2015-03-04:
Scenario:
Windows 7 Professional with SQL Server 2008 Express R2. Houses a VFP9
app using SQL Server as back end. The machine is _not_ a dedicated
server.
Two Windows 7 home basic, connecting to the SQL Server via ODBC.
The app works perfectly from the W7 Prof machine. However, when trying
to _save_ from any of the Home Basic boxes I get this error:
Error number: 2110
Error message: XML analysis error: the value,type or number of arguments
is not valid for the function.
"original" XML node = <original>-1.005,00</original>
Error line: _________________________________________________________
create cursor curapagar from array
_XMLFieldsArray_EDA1D57E_139B_4889_8432_EEBFCBBCA07A_
The actual lines of code are:
** called form init event
lparameters tcXML
Local oXML
oXML=CreateObject('XmlAdapter')
oXML.LoadXML(tcXML)
oXML.Tables.Item(1).ToCursor() && contains curApagar cursor
I guess this has to do with the fact that I am passing a cursor from a
calling form to a called form as XML
** calling form XML creation method
local oXML,cXML oXML = CreateObject("XMLAdapter")
oXML.addtableschema('curApagar') oXML.ToXML("cXML")
do form form2 with cXML
Shoud I install something special in the Home Basic machines?
A MDAC version perhaps?
BTW, the app exe resides in each PC and is absolutely the same in all of
them.
Rafael Copquin
Rafael,
The only suspect I see right off is the Regional settings may be different
across the machines.
What line has the actual error? Is it happening on the same machine that the
XML is being created?
Tracy Pearson
PowerChurch Software
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
