| Author |
 Topic  |
|
weeweeslap
Senior Member
USA
1077 Posts |
 Posted - 23 November 2010 : 23:22:14
|
hi ruirib,
I have sent you a detailed email. I provided contact info as well and if there is any missing info, please reply to it. 
Thank you,
Oscar |
coaster crazy |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 24 November 2010 : 20:46:13
|
| ruirib is awesome! He came in and fixed it all up. Thank you much Rui! |
coaster crazy |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 November 2010 : 10:10:57
|
Well there were two coding errors. First, for some unknown reason, the Snitz connection object was not being used, a new connection was created. To open this connection, instead of passing the connection string, the code was passing the snitz connection object! For some reason, this worked on Windows 2003! The weird thing is that not only the method call to open the connection was not generating any errors, but any subsequent uses of the connection to execute SQL weren't generating errors either! So the code was executing SQL over even non existing database tables without so much as a "complaint"!
Once that was fixed, the desired SQL started to execute. There was another logical error (trying to update a record without being sure it existed, which didn't update at all when the record did not exist), but the major issue was the one with the connection opening method call. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20611 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 November 2010 : 13:09:11
|
Ahh yes. I see what you're saying now. Just went and look back at the file weeweeslap posted:
quote:
Set objDB = Server.CreateObject("ADODB.Connection")
objDB.Open my_Conn
It was using it's own connection instead. I see I see. |
Support Snitz Forums
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 November 2010 : 04:38:25
|
Yeppers, that was it.
I guess this means that you can't even use the argument that a given set of code was working well before, when problems arise. You just need to question it all!! Not a reassuring thought!! |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 26 November 2010 : 14:17:18
|
Happy Thanksgiving, thank you for resolving this error  |
coaster crazy |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Code Works In Windows 2003 Not In Windows 2008
