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

Thanks for the reply, which I totally agree. I told the ProCentor admin to restart the application first thing if the sql server fails over again.

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 figured it out. I needed to set up an system dsn on the SQL2008 server.

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 got the same error but maybe a different situation. One workstation was power off for a long time. Then I found out this error in the System Event Log. It generated over 10,000 error entries in a month. How do I stop DCOM from retrying the connection?

Thanks. Although SQL Server Express is free, I still need to register at Microsoft after I install it in order to use it legally for free. Is this true?

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

You need to manipulate the subform recordset to set the focus on the record that a user just entered. The code is like: ' after a invoice detailed record is inserted and the RowID for ' that record is obtained. dim frm as Form set frm=me!SubformDetails frm.form.requery frm.recordset.findfirst...

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

Thanks Denny, I think eventually I will move to a dedicated server. Right now the only thing I can do is to frequently change the database password.

If I use shared hosting, I cannot control the firewall. Is there any other "safer" way that a hosting company can provide?

Denny, Thanks for the reply. Regarding the second bullet, what is the safe way to access a hosted sql db? I tried MS Azure SQL. It allows ODBC connection but has firewall rules limiting the IP addresses that have access to the db. Is that a safer way?

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

Possible two reasons: 1. the form name or the control name is wrong. 2. EventType might be a reserved word. Try rename it as txtEventType.

In the form design mode, right click the checkbox and select "Position - Bring it Front". You may find "Bring it Front" at the "Format" menu too, depending on which version of Access you are using. If this does not work, then the problem is probably caused by the activeX control. I would try...

try [Forms]![frmCreateRFS].form![frmRFSHardwareSubform].[Form] ![EventType]

PHV is right. Sorry for my typo.

Try using the code: lngrcds = Me.Recordset.Count