Recent content by MikePP

Hi What type of server do you use for your VPN? How do you configure it manually? Will your programme be running on the VPN Server? Regards Mike Mike Watson Providing Systems and Software for you - Software for Banking - Systems for the Power Industry

James Interesting question, and I don't know the answer. What I find most interesting is your execution of a string within a stored procedure (@sql). Is this something you do regularly? What problems do you get? Yours very interested Mike Mike Watson Providing Systems and Software for you...

Rusty It could be your VPN configuration. Terminal Services uses specific TCP/IP ports for communication. The communication is via the RDP Protocol. I think the port used is 3389. If your VPN blocks this, Terminal Services will not work. Regards Mike Mike Watson Providing Systems and...

Hi It may be because your script is writing lots of messages to the window in SQL Server Query Analyzer. If this is the reason, you can reduce the number of messages by select Query|Current Connection ... and ticking the No Count box. Regards Sadcow

Hi To make this work you need to achieve two things. 1 - Get your machine to connect and be accepted by the server (using TCP/IP). 2 - Establish a Terminal Services session. Test if you are achieving (1) by establishing a dial-up session and mapping a drive from your workstation to the...

Hi The DLookup Command is used to find a single database value. To get a range of values, you need to use an alternative technique. (e.g. an ADO recordset) Regards Sadcow

Hi SetComplete command is normally used for state management. It should have little to do with retrieving data. This leads me to think you will still need it. Regards Sadcow

Hi It can be done Lookup System_User in Books online Sample Stored procedure follows: /* Returns the user's current record */ CREATE PROCEDURE spUser AS DECLARE @NTUser varchar(50) SET @NTUser = RTrim(SubString(System_User,Patindex('%\%',System_User)+1,50)) SELECT Top 1 * from tbUsers...

Hi I think you are correct in your assumptions about the changes in file sizes. To confirm this you could: Check the number of tables/Stored Procedures etc. match in the two databases. Check the number of records match in a number of sample tables. If you are happy with the checks, I think...

Hi Consider doing the following: 1 - Create a dial-up networking connection to do the dial-up and log-in 2 - Set your dial up connection to time out after a period of inactivity (say 2 minutes) 3 - Have your VB program call a shell command to activate the dial-up networking connection 4 -...

Hi Try using Return CAST(@@error as int) sadcow

Hi Your code appears OK to me Try IF @@ERROR <> 0 RETURN @@ERROR and see if you still get the error Regards sadcow

Hi The following may help In vb.net use the following: dim obj as object obj = server.createobject(&quot;Myobject&quot;) Regards sadcow

Hi Do you require the sort property used to depend on the column which is double-clicked. If so, could you set the sort property, from the double_click event, based on the currently selected column? Regards sadcow

Hi Drop-downs near the bottom of a form often cause problems (not just custom ones). Solutions to consider are: Reposition the control Limit the number of items that can appear in the list Use a standard list, rather than a drop-down one Use a smaller font Probably not what you wanted...