|
Try establishing a pattern for the crash.
Try checking the MDAC versions on the machines where it crashes and compare that to the MDAC versions on the machines where it doesn't.
|
|
|
|
|
indeed
one of them has office xp installed, so one would assume that a suitable version of mdac would have been installed
Bryce
---
Publitor, making Pubmed easy.
http://www.sohocode.com/publitor
|
|
|
|
|
is there a way to hook on system stored procedures or replace it, i want to hook or replace sp_who2, is there a way?, im using sql server 2000
|
|
|
|
|
This is NOT recommended since other users might rely on the system stored procedure for correct functionality.
However, you can replace them by going into the master database, dropping the procedure and then recreating it.
|
|
|
|
|
thanks let me try it
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
but i cant drop it i get an error
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
|
ok sorry.. forgot to tell you.. you need to perform the following steps first to enable changing of system stored procedures:
<br />
execute sp_configure 'allow updates',1<br />
go<br />
reconfigure with override<br />
go<br />
Once you are done, set allow updates to 0:
<br />
execute sp_configure 'allow updates',0<br />
go<br />
reconfigure with override<br />
go<br />
You do know that this is highly unsupported and not recommended..
|
|
|
|
|
still doesn`t work i dont know why, any other idea?, thanx for the help .
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
Please tell me what error you are getting.
|
|
|
|
|
i get a messagebox telling me that i cant erease system objects, im trying to delete sp_who from master database.
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
You need to perform the entire query with T-SQL as follows:
<br />
use master<br />
go<br />
execute sp_configure 'allow updates',1<br />
go<br />
reconfigure with override<br />
go<br />
drop procedure sp_who<br />
go<br />
execute sp_configure 'allow updates',0<br />
go<br />
reconfigure with override<br />
go<br />
|
|
|
|
|
thanks that worked , thanks for your help.
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
Is it possible to specify the port of a server in a DSN (when it not 1433, for instance)?
|
|
|
|
|
Yes it is:
connection.ConnectionString="driver={SQL Server};server=myserver;port=5000;uid=myuser;pwd=mypassword;database=mydatabase;"
|
|
|
|
|
Does anybody know of any SQL tools that allow me to formally verify that differently structured SQL statements would result in the same result set?
Thanks,
Ian
--
Ian Darling
|
|
|
|
|
I haven't ever come across any tools like this (so if anyone knows of any tool like this I'd be interested too.)
What you can do is execute the statements into two global temp tables and then compare the temp tables with one of the numerous table diff tools out there.
|
|
|
|
|
Ian Darling wrote:
Does anybody know of any SQL tools that allow me to formally verify that differently structured SQL statements would result in the same result set?
If you are using SQL Server you can use Query Analyzer and dump the results to a file (this is a menu option). Then use WinDiff against another dataset that you have dumped to compare.
-Nick Parker
|
|
|
|
|
That's a good way, but you could also write some SQL to do it:
SELECT * FROM query1name INNER JOIN query2name ON query1name.primarykey < > qurery2name.primarykey;
If you get anything back, you know that they return different results (at least in the current situation).
"Do unto others as you would have them do unto you." - Jesus
"An eye for an eye only makes the whole world blind." - Mahatma Gandhi
|
|
|
|
|
This would only verify that the same primary keys exist but does not necessarily verify that the other fields in the rows are the same.
|
|
|
|
|
But they are returning results from the same table, so if the primary key was the same, then the results would be the same, right?
Maybe I was taking it as a given that this was so - are you talking about comparing results from different tables?
"Do unto others as you would have them do unto you." - Jesus
"An eye for an eye only makes the whole world blind." - Mahatma Gandhi
|
|
|
|
|
The following two select statements return different results even though they return the same keys, so the results are different:
select prkey, name, address from mytable
select prkey, name, address, dob from mytable
So, effectively, the resultsets are different.
|
|
|
|
|
You're right.
"Do unto others as you would have them do unto you." - Jesus
"An eye for an eye only makes the whole world blind." - Mahatma Gandhi
|
|
|
|
|
what is the syntax for executing oracle queries directly
like what i want to do is , on the click of a button on a form in vb.net , i want to delete the rows in a table
ie the query should be (delete qset )
|
|
|
|
|
how convert a ado connection to a oledbconnection ?
how can i?
|
|
|
|