Search results for query: *

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...

Hi To run a script you can open it in SQL Server Query Analyzer and run it by clicking the green arrow. To run it bit by bit: 1 - Select the lines you want to run 2 - Click the green arrow Only the selected lines will run Important ========= The script will run against the database...

I am configuring a Windows 2000 Server with Arcserve 2000. It has a Quantum DLT 8000 Tape Drive. Yesterday I formatted a single tape from ArcServe and gave it a name. Today ArcServe does not seem to recognize that the tape drive exists. The tape drive seems to operate correctly - ie it...

Hi Some of what I say below may seem obvious to you. Apologies. The Server Load depends on the nature of the queries and how they are written, and the volumes of data involved. If you do suffer performance problems it can be as much down to poor indexing or badly written stored procedures, as...

Hi The above appears correct, but there is a far easier way. Open SQL Server Enterprise Manager Find your database in the treeview on the left Click on the tables node below your database In the right hand pane Right-Click and Select Add Table This will give you a grid which allows you to...

Hi I can't think of a quick and easy way of doing this. What you could do is use a timer control, set to fire at a high frequency, and resize and reposition the form slightly each time the timer fires. This would give a movement effect. Regards Sadcow