Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. seaport

    SQL Regular message is taken as an error

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

    ODBC Connection during the Cluster Fail Over

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

    ODBC Connection during the Cluster Fail Over

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

    Set up a linked server to a SQL2000

    I figured it out. I needed to set up an system dsn on the SQL2008 server.
  5. seaport

    Set up a linked server to a SQL2000

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

    DCOM event id 10009

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

    The database for Virtual Private Server (VPS) hosting

    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?
  8. seaport

    The database for Virtual Private Server (VPS) hosting

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

    auto add item in table when a code is entered

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

    Provider Attribute in the ADO connection string

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

    Wireless connection over 54 mbps

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

    SQL Server Hosting Requirements

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

    SQL Server Hosting Requirements

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

    SQL Server Hosting Requirements

    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?
  15. seaport

    SQL Server Hosting Requirements

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

    Reference subform control from query problem

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

    Front Back issue

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

    Reference subform control from query problem

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

    Counting filtered Records on a form using VBA

    PHV is right. Sorry for my typo.
  20. seaport

    Counting filtered Records on a form using VBA

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

Part and Inventory Search

Back
Top