Search results for query: *

I have a stored procedure containing the following statement. exec sp_configure 'Ole Automation Procedures', 1; RECONFIGURE; When the above statement runs, SQL server responds with the following regular message, which is not an SQL server error. "Configuration option 'Ole Automation...

One of my cluster SQL 2008 R2 cluster server failed over. Many Access databases that were connected to the server through ODBC (by the server name, not the IP address) worked fine after the fail-over. However, another application (ProCenter) lost its connection to SQL Server after the...

I am trying to set up a linked server to a 32-bit SQL2000 server on a 64-bit SQL 2008R2 server. On that 2008 Server, a linked server to another 32-bit SQL2000 server has been set up by someone else and it works fine. I used the following script to create the linked server. EXEC...

I am currently using shared hosting for a asp.net/sql server 2005 web application. The backend sql server database is fairly small (left than 300M). I want to move to VPS hosting for more predictable performance. I wonder what the common choice for the database solution is. I checked out GoDaddy...

Where can I find a list of "official" provider names used in the Provider Attribute in the ADO connection string? I usually used the connection strings provided by connectionstrings.com. But I want to know more about what these provider names stand for. The only place I can find for those...

I got two different usb wireless adapters, both claiming to support 802.11n with speed over 100M. I am using a router Netgear N750, whose 2.4G band provides the speed up to 300 mbps. But the connection I got from my workstation is still 54mbps. How do I configure my network to get the speed over...

I am moving my existing asp.net web site and sql server to a hosting environment. I am trying a couple hosting companies. Please advise whether I am on the right track. The hosting service provider should 1. Allow the database access through connection string (asp.net), this is basic; 2. Allow...

I ran into this problem when I upgraded from Win XP Pro to Win 7 Pro. I created System DSNs using admin permission. Those DSNs are supposed to be visible to all users. However they were not visible when I tried to created linked tables in Access for a non-admin user. On the Access screen to...

I've been using Outlook 2003. Every email was assigned to one or more categories. How I replied an email, that replied email was automatically assigned the same categories as the original one. I just upgraded to Outlook 2010 and that auto-assigning does not work any more. Did Microsoft disable...

I need to run a FTP synchronization software (using Windows Task Scheduler) to regularly sync my server and the web server. Could anyone recommend a software for it? I used to use WSFTP pro, but it only worked for 32 bit software. Thanks.

4 Windows 7 workstations were in a workgroup with a Windows server. All workstations remembered their mapped drives. Now I moved them into a Windows 2008 domain and they could no longer remember mapped drives. Is this normal behavior of a workstation? Do I have to set up something (like logon...

Could anyone give me recommendations on security software (anti-virus, anti-spyware) running on SBS 2008, for both paid software and free ones? Thanks.

MS Small business server premium 2008 includes SQL Server 2008. I ordered a server with SBS premium 2008 and it came without the SQL Server preinstalled. When I called the tech support I was told that SBS 2008 premium is supposed to be a two-server system. The SQL Server cannot be installed in a...

I am thinking about upgrading my SQL2k5 server to a new SQL2K8 server. Before investing on a new server, I wonder whether I should host the server on the cloud. This is a small office with less than 20 users. The SQL server is used both by the office and infrequent online users. The office...

As far as I know, Server 2008 R2 only supports 64 bit. My laptop is Windows 7 pro 32 bit. I want to learn Server 2008 R2. Can I run Server 2008 R2 on my laptop using Virtual PC? If not, can I run a Server 2008r2 on a 64bit Windows 7 pro?

My office network contains about 10 workstations, 1 file server and 1 SQL Server. The network is behind a LinkSys router, which also serves as the firewall. Now I plan to add a web server and expect small traffic (less than 200 visits a day). The web application on the web serer is not...

For some technical problems my web server has only https (443) port open. Any request to http (80) port got a "Page cannot display" error. My question is: Can I just leave the server like that? Or I have to fix the problem so a visitor can visit the server thorough both http and https ports...

My Access database system is connected to the remote SQL Server 2005 Standard (in the same LAN) through ODBC DSN. The LAN is peer-to-peer. Most of client machines using Win XP and the DSN connection is fast. However, one Vista machine always had slow connection. When I clicked the button "Test...

I am trying to use OLE automation to get the last modified date of a file located in a mapped drive on the SQL Server computer. The network is peer-to-peer. I logged on the SQL server as the administrator. The SQL Server and the workstation sharing its folder have the same password for the...

I routinely put the following code at the end of an asp page. cnn is the connection object <% on error resume next cnn.close set cnn=nothing %> But today I got this strange error in a new page. Microsoft VBScript compilation error '800a0401' Expected end of statement...