Yes. I was wondering why it doesn't allow me to instantiate a remoting object, when I'm running on an impersonated account. SDE

Thanks. :) SDE

Perspx wrote: In the left pane click on Reliability and Performance. Could not see this. :( I am using windows XP perfmon. Is this the same process that is mentioned above? Thanks. SDE

alex1205 wrote: Thanks for the response. I've tried that and it doesn't work. Oh, sorry about that. I take it the Connection State is showing the connection is still active? alex1205 wrote: it raises an error when you execute something even if the connection has been restored. In the original post you mention the next time you execute a query it throws an error. What is the error message it throws when this happens? DEBUGGING : Removing the needles from the haystack.

Hi, Thanks for the information. How bout Shamsi dates? I have been looking information about it. I wanted an introduction to it on how it would affect my app... Do you have any article you could recommend? Thanks. SDE

A quick Google for "VB6 convert string byte array" comes up with: ' Convert string into a byte array: Dim b() As Byte b = "This is the String" ' Add null termination: Redim Preserve b(0 To Ubound(b) + 2) As Byte RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

that can be done by data grid control... the sql server helps to create stored procedures to develop your database. by saravanaprabu.R

Thanks guys. These have been a great help. I've been thinking about this for quite some time now.

OK. Thanks. SDE

The return value is zero because there was a failure. Use GetLastError to get the error number, then look that up here[^]. This is the System Error Codes list on MSDN. You might want to check the value returned by RegisterEventSource first. It looks like your not getting a good EventLog handle returned here. Your passing in an empty string instead of a 0 (which means NULL). This is where I think your problem is. If you change the call to this, it might work: hEventLog = RegisterEventSource("." & chr$(0), sSource) Again, if you get back a zero for either RegisterEventSource or ReportEvent, then use GetLastError to find out what the error was. RageInTheMachine9532

ok. got it. thanks. SDE

Yes. You can define a user defined structure (a Type) in VB which corresponds to your C++ structure. That way, you can pass the structure back and forth. Look in the MSDN on how to do this: Passing User-Defined Types to a DLL Procedure. Of course, your Type declaration in VB must be equivalent to the C++ version. Ian Mariano - http://www.ian-space.com/ "We are all wave equations in the information matrix of the universe" - me

Thanks. I have seen a solution to it. In order for output parameters to be retrieved properly, the ActiveConnection's Cursor type should be set to adUseClient before calling the execute method. Thank you for the reply. :> SDE