Search results for query: *

Hi all, After I installed Terminal Server on my Win2003 server I had problem to connect to SQL server. I thought the problems where connected to the terminal server so I uninstalled Terminal server and restarted the server. Users connects to SQL Server via ODBC sometimes get the following...

Hi all, I want to install terminal licensing on a Win 2003 Enterprise edition server. The server has sp2 installed. The wizard from the control panel needs to know the path where sp2 is installed. How can I figure out where it is? Kent J.

Hi all, In the Terminal Configuration Manager I can set the number of maximum connections for the Network adapter. I can increase the number to 200 but when I close the consol I'll get: 'Configuration changes has been made to the registry...user sessions now active on RDP-Tcp will not be...

Hi all, I have a Java application and I want the users access this via RemoteDektop and Internet Explorer. After the userlogin Id like to have Internet Explorer started and directed to a specific http-address. How can I do this? I've seen the consol 'Terminal Services Profile' in computer...

Hi all, I would like to create a new table every day with todays date after the tablename. like: MyDatabase..MyTable_yymmdd How can I do this? Kent J.

Hi all, I have a wireless network. I get the message: "Could not clear the ARP-cash"? It's solved by arp -d But I guess it's only a symtom of something else. Someone who knows? Kent J.

Hi all, What is the best way/software to remote control a Win2003EnterpriseServer sp2? Kent J.

Hi all, I have a wireless network with a ADSL modem/router with DHCP and a wireless DLink 'Range Extender' - DWL-G710. I get: 'Windows - System Error. There is an IP-adress in conflict with another system on the network'. Everything looks right except that 'MYCOMPUTER' and 'Range Extender...

Hi all, I'm trying to restore a SQL-server 2000 Master database from a backup. I need to restore the security. I understand that I have to be a single user on the server to do this. To do this I have sqlserver.exe -m -c as a startup parameter. But after startup I'm not allowed to access the...

Hi all, I have an old Win2003 server which I intend to replace with a new one. The new server had Win2003 server sp2 installed I thought that would be easy. The filebackup included a file- and system backup. On the new server I ran a restore on the filebackup. My plan was reuse all the old...

Hi all, I have rented a server with Win2003 Standard Edition. Then server has 2 Intel Quad CPU = 8 processors and 16 GB ram. I now understand that Win2003 only supports 4 GB and 4 CPU. So what should I install instead? Win2008? My intention is to run SQL-server2000 and Cognos PowerPlay on...

Hi all, How can I update a Pivotable on a form with a command? I've seen the update button "!" when I'm running the form. What's the eqvivalent command for "!"? Kent J.

Hi, I have diagram on a subform and the subform is placed on a TabControl. I want the diagram to be updated when I change page on the TabControl. * TabControl is called tabOrders * FrmDiagram is the name of the subform control * FrmDiagram is the name of the form inside the subform If I run...

Hi, I have a dynamic SQL stored procedure that looks like: ========================================== ALTER PROCEDURE sp_Analys @Parameter1 as nvarchar (4000), @Parameter2 as nvarchar (50) AS DECLARE @sql nvarchar(4000) SET @sql =' select Field1,Field2,Field3 from Table1 where Field1 in...

Hi all, I have a query that works fine with: select * from Table1 where Field1 in ('47740','47993') But if I replace '47740','47993' with a parameter in a stored procedure: select * from Table1 where Field1 in (@Parameter1) ... I get "too many arguments specified." How can I tell the...

Hi all, How can I retrive records from a SQL stored procedure in a Access form? I have this code: ========================= 'Sets values Set cnSQL = New ADODB.Connection Set cmd = New ADODB.Command 'Opens a connection to the SQL server cnSQL.Open _ "Provider=...

Hi all, I have a liked SQL-server 2000 table in an Access database. This table have worked fine for 6 months. But now it start to say: 'In use by another user..' when I try to edit a record. The table has a primary key defined. The table looks like this: =====================================...

Hi all, How can I store a value from a Subform? Something like: ============================= Dim strString as string strString= Forms![FrmGrund]![Subform].Forms![TxtCtrl] ============================= Kent J.

Hi all, I have a mainform with a listbox. The listbox is supposed to query the subform from a 'after_update' event: ============================= Dim sfrm As Form Set sfrm = Forms![FrmSubForm].Form With sfrm .RecordSource = "select * from Qry1 where [SalesPerson]='" & Listbox1 & "' ORDER BY...

Hi all, I have a partition a a Win2003 system with disk array consisting of 4 harddrives. Do I have to run the defragmentation tool on the array (raid5)? Is it advisable? Kent J.