Setting up a Windows 2008 IT architecture
There are a few things you need to consider: VPN – are you setting up an internal VPN using MPLS or are you setting up a tunneling VPN through your DSL connection? Domain – It is better if you setup a single domain once you’ve decided on your VPN. You should have at least 2 [...]
View Answer
| May 10, 2013 10:08 PM
Datacenter management, DNS server, Domain Controller, IT architecture, Windows Server 2008, Windows Server 2008 Architecture
There are a few things you need to consider: VPN – are you setting up an internal VPN using MPLS or are you setting up a tunneling VPN through your DSL connection? Domain – It is better if you setup a single domain once you’ve decided on your VPN. You should have at least 2 [...]
View Answer
| May 10, 2013 10:08 PM
Datacenter management, DNS server, Domain Controller, IT architecture, Windows Server 2008, Windows Server 2008 Architecture
SQL server native webservices and PHP
It’ll be a lot easier to just log into the database and run the procedure manually. SOAP endpoints are being removed from SQL Server in the future.
View Answer
| May 10, 2013 3:34 AM
Apache, PHP, SQL Server, SQL Server 2008, WebServices
It’ll be a lot easier to just log into the database and run the procedure manually. SOAP endpoints are being removed from SQL Server in the future.
View Answer
| May 10, 2013 3:34 AM
Apache, PHP, SQL Server, SQL Server 2008, WebServices
Trouble creating SQL statement from MS Access Form
I found this bit of code: Dim escapedString as String escapedString = Replace(nonescapedString, "'", "''") Basically you need to replace the text field’s single-quote to double single-quotes (similar to how in MySQL you need to do ‘ for single quotes.
View Answer
| May 10, 2013 12:56 AM
Access 2007, Microsoft Access, SQL, VBA, Windows Vista
I found this bit of code: Dim escapedString as String escapedString = Replace(nonescapedString, "'", "''") Basically you need to replace the text field’s single-quote to double single-quotes (similar to how in MySQL you need to do ‘ for single quotes.
View Answer
| May 10, 2013 12:56 AM
Access 2007, Microsoft Access, SQL, VBA, Windows Vista
How to connect Visual Basic 6 to Oracle 11g
You could do it this way: First, you need to install Oracle Client software and make sure you are able to connect to the database (test the connection from SQL*Plus) Then the VB code is pretty simple. This is an example using ADO: Dim C As New ADODB.Connection Dim Rec As New ADODB.Recordset Dim SQL [...]
View Answer
| May 10, 2013 12:18 PM
Database programming, Oracle 11g, Oracle connectivity, VB 6, Visual Basic, Visual Basic 6
You could do it this way: First, you need to install Oracle Client software and make sure you are able to connect to the database (test the connection from SQL*Plus) Then the VB code is pretty simple. This is an example using ADO: Dim C As New ADODB.Connection Dim Rec As New ADODB.Recordset Dim SQL [...]
View Answer
| May 10, 2013 12:18 PM
Database programming, Oracle 11g, Oracle connectivity, VB 6, Visual Basic, Visual Basic 6
Tempory Zip Creation with Archive::Zip or other PERL Module
<a href=”http://search.cpan.org/~pmqs/Compress-Zlib-1.42/Zlib.pm”>This</a> will let you zip a file in memory.
View Answer
| May 10, 2013 3:01 AM
Apache, CGI, Linux servers, Perl, Zip
<a href=”http://search.cpan.org/~pmqs/Compress-Zlib-1.42/Zlib.pm”>This</a> will let you zip a file in memory.
View Answer
| May 10, 2013 3:01 AM
Apache, CGI, Linux servers, Perl, Zip
Create task sheduler event from command line
I believe you must run it with elevated privileges.
View Answer
| May 10, 2013 8:51 PM
AS/400 batch jobs, Command line, Scheduled batch jobs, Scheduled Tasks
I believe you must run it with elevated privileges.
View Answer
| May 10, 2013 8:51 PM
AS/400 batch jobs, Command line, Scheduled batch jobs, Scheduled Tasks
Active Directory in the Cloud
Check out this tutorial as it may help you figure out how to proceed with a seamless Active Directory experience leveraging Active Directory Federated Services (ADFS) and AppFab ACS – http://www.developerfusion.com/article/121561/integrating-active-directory-into-azure. I hope this link will surely help you out. Check it out: http://social.msdn.microsoft.com/Forums/en-HK/windowsazuresecurity/thread/28e40c3e-0243-418f-90c4-9d7bdb2b0b61 Update the community if you have any issue unresolved, we are [...]
View Answer
| May 10, 2013 10:05 AM
Active Directory
Check out this tutorial as it may help you figure out how to proceed with a seamless Active Directory experience leveraging Active Directory Federated Services (ADFS) and AppFab ACS – http://www.developerfusion.com/article/121561/integrating-active-directory-into-azure. I hope this link will surely help you out. Check it out: http://social.msdn.microsoft.com/Forums/en-HK/windowsazuresecurity/thread/28e40c3e-0243-418f-90c4-9d7bdb2b0b61 Update the community if you have any issue unresolved, we are [...]
View Answer
| May 10, 2013 10:05 AM
Active Directory
Automate SSRS report
You might be able to pass the values for all of the contractid’s at the same time, then split them in the report so that it runs for all of them at the same time. Then you can set up the reports to automatically send and you won’t have to do anything manually…I love technology! [...]
View Answer
| May 10, 2013 9:20 PM
SSRS reports, Visual Studio
You might be able to pass the values for all of the contractid’s at the same time, then split them in the report so that it runs for all of them at the same time. Then you can set up the reports to automatically send and you won’t have to do anything manually…I love technology! [...]
View Answer
| May 10, 2013 9:20 PM
SSRS reports, Visual Studio
Can somebody provide me SQL questions based on various situation?
A little research into T/SQL on <a href=”http://itke.techtarget.com/sql-server/”>my blog</a>, or on <a href=”http://SearchSQLServer.com”>SearchSQLServer.com</a>, or on <a href=”http://SQLServerPedia.com”>SQLServerPedia.com</a> –msi77– You can find a lot of questions on <a href=”http://www.sql-ex.ru/”>SQL Exercises</a>.
View Answer
| May 10, 2013 5:13 PM
SQL, SQL Database, SQL queries
A little research into T/SQL on <a href=”http://itke.techtarget.com/sql-server/”>my blog</a>, or on <a href=”http://SearchSQLServer.com”>SearchSQLServer.com</a>, or on <a href=”http://SQLServerPedia.com”>SQLServerPedia.com</a> –msi77– You can find a lot of questions on <a href=”http://www.sql-ex.ru/”>SQL Exercises</a>.
View Answer
| May 10, 2013 5:13 PM
SQL, SQL Database, SQL queries
Spy attacks my PC’s performance, IE & Desktop
If it is for home use, I suggest I use two I am reasonably happy with: Trend Micro PC-cillin 2005 (http://www.trendmicro.com/en/home/us/personal.htm) and lavasoft Ad-Aware (make sure you configure it well). If it is for corporate use, Trend micro had client server SMB software as well. Very usefull, centralized management, and so on. Test it first [...]
View Answer
| May 9, 2013 3:00 PM
DataCenter, Development, Hardware, Networking
If it is for home use, I suggest I use two I am reasonably happy with: Trend Micro PC-cillin 2005 (http://www.trendmicro.com/en/home/us/personal.htm) and lavasoft Ad-Aware (make sure you configure it well). If it is for corporate use, Trend micro had client server SMB software as well. Very usefull, centralized management, and so on. Test it first [...]
View Answer
| May 9, 2013 3:00 PM
DataCenter, Development, Hardware, Networking
How to add several registry values via VBs using GPO
<ul> Part One – Excel 2007 Trusted Folders</ul> I think you need to call the [HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0ExcelSecurityTrusted LocationsLocation6] portion explicitly before each value. Part Two – Excel 2003 Registry values HKEY_CURRENT_USERSOFTWAREMicrosoftOffice11.0ExcelSecurity or HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice11.0ExcelSecurity See here: http://support.microsoft.com/kb/910817
View Answer
| May 9, 2013 8:38 PM
GPO, Group Policy, Group Policy Objects, RegEdit, VBS, Windows Server 2003 Domain, Windows Server 2003 GPO
<ul> Part One – Excel 2007 Trusted Folders</ul> I think you need to call the [HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0ExcelSecurityTrusted LocationsLocation6] portion explicitly before each value. Part Two – Excel 2003 Registry values HKEY_CURRENT_USERSOFTWAREMicrosoftOffice11.0ExcelSecurity or HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice11.0ExcelSecurity See here: http://support.microsoft.com/kb/910817
View Answer
| May 9, 2013 8:38 PM
GPO, Group Policy, Group Policy Objects, RegEdit, VBS, Windows Server 2003 Domain, Windows Server 2003 GPO
Drive letter issue in 2003 terminal server application
Hi, I’m assuming that you have contacted the application vendor to confirm the inability to map drive C:. Since this is the standard drive letter for a system partition, it seems a little silly to force it to be mapped to a network share. Any chance of knowing the applciation that is causing you the [...]
View Answer
| May 9, 2013 3:02 PM
Active Directory, Application integration, DataCenter, Datacenter Server, DHCP, DNS, Implementation, Installing/upgrading operating systems, Integration/Connectivity, IT architecture, Microsoft Windows, Network requirements, Networking services, Partitioning, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Tech support, Windows, Windows 2000 Server, Windows on Intel, Windows Server 2003, Windows tools/WSRM
Hi, I’m assuming that you have contacted the application vendor to confirm the inability to map drive C:. Since this is the standard drive letter for a system partition, it seems a little silly to force it to be mapped to a network share. Any chance of knowing the applciation that is causing you the [...]
View Answer
| May 9, 2013 3:02 PM
Active Directory, Application integration, DataCenter, Datacenter Server, DHCP, DNS, Implementation, Installing/upgrading operating systems, Integration/Connectivity, IT architecture, Microsoft Windows, Network requirements, Networking services, Partitioning, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Tech support, Windows, Windows 2000 Server, Windows on Intel, Windows Server 2003, Windows tools/WSRM
Help with deleteing headers in Outlook 2k3
Try creating a bogus PST, drop those dups in it, and then delete the PST itself… see how it goes –Saurabh
View Answer
| May 9, 2013 1:54 PM
Exchange, Exchange 2000, Outlook
Try creating a bogus PST, drop those dups in it, and then delete the PST itself… see how it goes –Saurabh
View Answer
| May 9, 2013 1:54 PM
Exchange, Exchange 2000, Outlook
Question
What is it you are trying to do? There is not a way to get a handle on a lotus doc through javascript, not any way I know.
View Answer
| May 9, 2013 11:48 AM
JavaScript, Lotus Notes
What is it you are trying to do? There is not a way to get a handle on a lotus doc through javascript, not any way I know.
View Answer
| May 9, 2013 11:48 AM
JavaScript, Lotus Notes
Slow Logon Performance
We ran into some similar troubles with our AV Vendor and the firewall product. Might be worth verifying those settings
View Answer
| May 9, 2013 6:24 PM
Exchange, Microsoft Windows, Networking
We ran into some similar troubles with our AV Vendor and the firewall product. Might be worth verifying those settings
View Answer
| May 9, 2013 6:24 PM
Exchange, Microsoft Windows, Networking
shdocpv.dll – virus – hijack problem
Download HijackThis 1.99.1 (http://www.merijn.org/files/hijackthis.zip) Unzip the hijackthis.exe file to a folder you create named C:Program FilesHJT Do NOT run Hijack This from the Desktop, a temp folder, or a sub-folder of C:Documents and Settings, or choose to run it directly from the ZIP file as your backups will not be safely stored. Before running HijackThis: [...]
View Answer
| May 9, 2013 12:55 PM
backdoors, Current threats, Hacking, human factors, Intrusion management, Servers, Spyware, Trojans, Viruses, Windows 2000 Server, worms
Download HijackThis 1.99.1 (http://www.merijn.org/files/hijackthis.zip) Unzip the hijackthis.exe file to a folder you create named C:Program FilesHJT Do NOT run Hijack This from the Desktop, a temp folder, or a sub-folder of C:Documents and Settings, or choose to run it directly from the ZIP file as your backups will not be safely stored. Before running HijackThis: [...]
View Answer
| May 9, 2013 12:55 PM
backdoors, Current threats, Hacking, human factors, Intrusion management, Servers, Spyware, Trojans, Viruses, Windows 2000 Server, worms
Transferring a Domain
I just completed this project here. The best way I found to do this is to bring up a “Pivot server”, something that is big enough to handle your domain for a week or so. Bring that server up as a BDC in NT4 fully updated. Let it sit for a few day to make [...]
View Answer
| May 9, 2013 10:12 AM
Active Directory, Bind, DataCenter, Desktops, DHCP, DNS, Ethernet, IPv4, IPv6, Management, Microsoft Windows, NetBIOS, Networking, Networking services, OS, Security, Servers, SQL Server, TCP
I just completed this project here. The best way I found to do this is to bring up a “Pivot server”, something that is big enough to handle your domain for a week or so. Bring that server up as a BDC in NT4 fully updated. Let it sit for a few day to make [...]
View Answer
| May 9, 2013 10:12 AM
Active Directory, Bind, DataCenter, Desktops, DHCP, DNS, Ethernet, IPv4, IPv6, Management, Microsoft Windows, NetBIOS, Networking, Networking services, OS, Security, Servers, SQL Server, TCP
How can we ask private questions?
That would be directly vie email. Assume that anything you post on the Internet is visible to everyone. <b>Moderator Note:</b> You may submit a question for us to post for you by emailing Moderator@ITKnowledgeExchange.com. But we would still need to post the question for all to see to solicit an answer from your peers. Unless [...]
View Answer
| May 9, 2013 12:10 PM
ITKE
That would be directly vie email. Assume that anything you post on the Internet is visible to everyone. <b>Moderator Note:</b> You may submit a question for us to post for you by emailing Moderator@ITKnowledgeExchange.com. But we would still need to post the question for all to see to solicit an answer from your peers. Unless [...]
View Answer
| May 9, 2013 12:10 PM
ITKE
VB6 and Crystal Reports – Error 20599 SQL not found
From what I found, the problem seems to be related to password protected tables in your database. Here’s a possible solution. Microsoft Visual Basic: “Runtime error 20599 – Can’t Open SQL Server” This issue occurs on all Active Data reports which have been created using the Active Data driver, P2smon.dll version 60046 or higher and [...]
View Answer
| May 9, 2013 3:29 PM
Crystal Reports, Error 20599, VB 6, Visual Basic, Visual Basic 6
From what I found, the problem seems to be related to password protected tables in your database. Here’s a possible solution. Microsoft Visual Basic: “Runtime error 20599 – Can’t Open SQL Server” This issue occurs on all Active Data reports which have been created using the Active Data driver, P2smon.dll version 60046 or higher and [...]
View Answer
| May 9, 2013 3:29 PM
Crystal Reports, Error 20599, VB 6, Visual Basic, Visual Basic 6
if -else condition in xml publisher
XML Publisher supports the common programming construct “if-then-else”. This is extremely useful when you need to test a condition and conditionally show a result. For example: <pre> IF X=0 THEN Y=2 ELSE Y=3 END IF</pre> You can also nest these statements as follows: <pre>IF X=0 THEN Y=2 ELSE IF X=1 THEN Y=10 ELSE Y=100 END [...]
View Answer
| May 9, 2013 1:50 PM
Oracle, XML, XML and XML schema
XML Publisher supports the common programming construct “if-then-else”. This is extremely useful when you need to test a condition and conditionally show a result. For example: <pre> IF X=0 THEN Y=2 ELSE Y=3 END IF</pre> You can also nest these statements as follows: <pre>IF X=0 THEN Y=2 ELSE IF X=1 THEN Y=10 ELSE Y=100 END [...]
View Answer
| May 9, 2013 1:50 PM
Oracle, XML, XML and XML schema
