Comments
Sort by recent activity
Hmm... I'm afraid not. It's not even the CLSID of the ANTS Profiler Core, which would've been what I'd assumed.
I guess you could try granting it that permission, but it'd be a bit of a stab in the dark on my part, and it's feeling like we're twiddling too many bits of configuration at this point...
Taking a step backwards, I assume that using SQL Server authentication rather than integrated windows authentication isn't an option for your web application?
Robert / comments
Hmm... I'm afraid not. It's not even the CLSID of the ANTS Profiler Core, which would've been what I'd assumed.
I guess you could try granting it that permission, but it'd be a bit of a stab in the...
Morning,
You've hit a slight limitation with the way we profile IIS. If you're profiling IIS6 in native mode, we'll either be running the application pool as the user you're running ANTS as (v3.0), or as LOCAL SYSTEM (v3.1). If you're running in IIS5 mode, it'll try and impersonate the user that IIS was configured to use.
The problem with not being able to log on as the specified user in IIS5 mode is probably caused by that user not having the "log on as a batch job" right. Granting that right should help.
In IIS 6 native mode, something you could try if you have v3.1 is changing the account the ANTS Profiler Service runs under, to the account you want the application pool to run under. You'll almost certainly have to give that account administrative rights temporarily, and I make no promises that it'll work, but it might be worth a shot.
Hope that helps,
Robert / comments
Morning,
You've hit a slight limitation with the way we profile IIS. If you're profiling IIS6 in native mode, we'll either be running the application pool as the user you're running ANTS as (v3.0),...
OK, that worked less well than I'd hoped :-( (it's not something I'd tried before - and by the looks of things not something I'll be trying again either!)
I'd give the "log on as a batch job" idea a go with IIS 5 mode, and see if that's any more successful.
Thanks,
Robert / comments
OK, that worked less well than I'd hoped :-( (it's not something I'd tried before - and by the looks of things not something I'll be trying again either!)
I'd give the "log on as a batch job" idea ...
Hi,
If you've got the Professional edition of Data Compare, you have access to the command line interface - SQLDataCompare.exe. This can take a project file (.sdc, as you say) as a parameter and run the comparison and synchronization.
I believe that the project files are stored in "%Documents and Settings%\Local Settings\Application Data\Red Gate\SQL Data Compare 5", so you should find all your .sdc files there.
If you open them in a text editor, you'll also find that they're XML - so you should be able to tweak the odd parameter (though this isn't officially supported, I think [image] ).
For more information on the command line, have a look at the command line interface in the web help.
Hope that helps,
Robert / comments
Hi,
If you've got the Professional edition of Data Compare, you have access to the command line interface - SQLDataCompare.exe. This can take a project file (.sdc, as you say) as a parameter and ru...
Hi,
The /argfile switch is for a slightly different XML argument file - essentially an XML version of the command line arguments. In order to use a project file from the GUI, you need the /project switch:
sqldatacompare /project:"C:\wrbfm03
rts.RTS_UnPublished v ROBINS.RTS 14-06-2006.08-12-05.6386.sdc"
Hope that helps,
Robert / comments
Hi,
The /argfile switch is for a slightly different XML argument file - essentially an XML version of the command line arguments. In order to use a project file from the GUI, you need the /project ...
Hi,
Whilst you can't directly profile just the DLL, you can choose to include or exclude namespaces, which normally does the trick. So, for instance, if you're profiling something in nunit, then you could exclude the namespace "NUnit".
If you're profiling a debug build of your DLL, then it's even easier - just choose to profile "only .NET methods with source code", and it should automatically only profile your library.
Hope that helps,
Robert / comments
Hi,
Whilst you can't directly profile just the DLL, you can choose to include or exclude namespaces, which normally does the trick. So, for instance, if you're profiling something in nunit, then yo...
Hi,
Yes, you can. If you profile the application that uses the DLL, then any .NET DLLs it uses will also be profiled. Make sure that you've also got the .PDB file associated with your class library in the same location if you want to see the source code.
Hope that helps,
Robert / comments
Hi,
Yes, you can. If you profile the application that uses the DLL, then any .NET DLLs it uses will also be profiled. Make sure that you've also got the .PDB file associated with your class library...
It's a little trickier since you're working with a web application, but if you delete the .PDB file, that should also do the trick. I think setting "Debug = false" in your web.config should do this.
You'll also have to select "Profile all .NET methods" rather than just those with source code in order to actually get any results.
Rob / comments
It's a little trickier since you're working with a web application, but if you delete the .PDB file, that should also do the trick. I think setting "Debug = false" in your web.config should do this...
Hi,
I wonder if you could try profiling in "Fast Mode" rather than "Detailed Mode" and see if you still get the error?
(The difference being that in fast mode, we don't instrument your code, so it's a good way of narrowing down the problem.)
Thanks,
Robert / comments
Hi,
I wonder if you could try profiling in "Fast Mode" rather than "Detailed Mode" and see if you still get the error?
(The difference being that in fast mode, we don't instrument your code, so it'...
Hi,
You certainly should be able to - I wonder if you could give some more details of the error you're seeing, and what (minor) version of Data Compare you're running?
Thanks,
Robert / comments
Hi,
You certainly should be able to - I wonder if you could give some more details of the error you're seeing, and what (minor) version of Data Compare you're running?
Thanks,
Robert