No,no,no
I use it with transactions since day one. They only disabled replication
and then, only as a publisher
Rafael
El 22/09/2014 19:00, Paul McNett escribió:
What are the limitations of SQL Server Express? I'd look that up, too.
Maybe they disabled transaction support...
Paul
On 9/22/14, 2:56 PM, Rafael Copquin wrote:
That is a good suggestion thank you. I will follow your advice
I wonder if the AV is causing the trouble. The server machine uses a
free version of AVG
Rafael
El 22/09/2014 18:45, Paul McNett escribió:
On 9/22/14, 2:42 PM, Rafael Copquin wrote:
I have an app that uses SQL SERVER EXPRESS 2008 R2 as external motor.
The SQL server resides in a Windows 7 Prof box, acting as a server
for 3
other Windows 7 Home boxes
I can connect from the HOME pc to the Prof server and my app can read
data from the SQL Server
I can save new records from the HOME pc to the SQL engine, using
cursor
adapters, provided they are a single table.
From the Server computer I can save a series of tables within a
transaction, also using cursor adapters, with no problem (ie: invoice,
consisting of a header, a child and several other tables, such as
stock,
accounts receivable, value added tax collected, etc)
However, using the same app from the Windows 7 Home boxes, I can't
save
the invoice. The error I get states that the data types do not match.
What's the exact error message and what's the line of code that it was
trying to execute that generated that error message?
I repeat, the same app run from the server works flawlessly, but run
from the other pc's gives that error.
How about coding up a single test program that:
1) creates a table
2) populates it with test data
3) changes/inserts data
4) saves
Run it from each machine. If it works, make it more complex in steps,
like adding relations. If it still works after you've added enough to
mimic the original app, then something's definitely wrong in the
original app. On the other hand, if it fails early with the same
error, you've proved that it isn't your app at all but something
environmental on these machines. Knowing this information without a
shadow of a doubt is valuable, and what I propose won't take long.
Paul
[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.
