I think I know where my problem originates.
I have the Oracle virtual box set up in my W7 Ultimate PC with an XP
Prof and a W2003 server. Both machines mimic the behaviour of a LAN,
which I use to test my apps.
In my XP machine I have SQL Server Express 200 R2 installed. In the
W2003 pc I have SQL Server Express 2005
The invoicing routine works flawlessly in my actual W7 Ultimate and in
the virtual XP machines. But in the W2003 virtual machine it bombs.
What I did was replace an "insert into statement" in the W2003 machine
with a series of replace commands.
It bombs in the "replace invdate with thisform.dDate" command.
Now, in the database, the invdate field is of type date, which exists
since SQL Server 2008. But in SQL Server 2005 there is no date type, but
datetime.
So if I try to save a date variable into a date field, there is no
problem in the W7 or the XP machines, which have SQL Server Express 2008
installed. Not so in the W2003 machine.
So I assume that the problem is with the SQL Server driver. In the W7
and XP machines I can use the SQL Server Native Client 10.00 driver
which SQL Server Express 2008 R2 installs automatically. In the W2003
machine I only have the SQL Server driver that is installed by default
in that version of Windows. There is no SQL Server Native Client 10.0 there.
So my question is:
How do I install the SQL Server Native Client 10.00 driver in the
machine that causes the problem, without having to install a version of
SQL Server Express 2008 R2 in it?
This is a question for the "SQL gurus" in this forum.
Please, help me
Rafael Copquin
_______________________________________________
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.
