Trying to setup a linked server to a SQLite database in a SQL 2012 cluster (active/passive) environment.
I'm able to get the linked server setup and have had SOME success querying, but it is very inconsistent.
For example, when I first setup this linked server, I was able to run the query from...
Preferably I would like to have a routine in MySQL that I can pass variables to which then creates the event based on the variables passed to it.
Simplified Example:
User defines they want a certain event to occur every 6 hrs starting at 1am. Pass the time parameters, the property they were...
Anyone know how to create events dynamically. I have a couple of applications I am developing where I would like to be able to setup events dynamically based on user interactions and setups. Is this possible through the MySQL routines or triggers? Can it be accomplished through coding on the...
I need to change the drive letter associated with a physical disk resource in Microsoft Cluster Services. There are some drives on the server that conflict with mapped drives that get associated at logon. The installer did not take into account drive mappings when originally setting these up...
Here is the scenario. I run a network with about 150 users on it, about 1/3 of which would likely not be happy if I permanently change their "Home Page" (unfortunately that is the upper 1/3 of the company). I would like, however, to enforce our company's Intranet site as the startup page when...
I am having problems with posting multiple files to our customer using a ssl URL with a certificate. I seem to be able to send one file to them at a time (with some unknown interval of time between them), but I am unable to send files in succession when sending multiple files. I have spoken...
New development:
I can now use the function to send 1 file at a time with a sigificant interval between attempts. This immediately started working once I installed VS2K5 SP1 and the Vista updates for SP1. I assume that may have had some impact on the function.
I have also contacted our...
Sorry, I should have clarified that a little better. No, the automated script is not running as a service. It is setup in such a way that I can run it either by a timer I have on the form or by clicking a button that initiates the code. In the background the button causes a script on the form...
I have a very strange occurrence in an application I am writing to transmit an XML file to a customer's https server. I am using the httpwebrequest with x509Certificates to authenticate to their system and post these files to them. Here's where it gets strange.
(Stage 1 - Manual Submittal of...
OK, so it looks like I solved this issue. It seems that if I do not close my StreamReader and StreamWriter objects before attempting to create the response object, I get this infinite wait. By moving the
myWrtr.Close()
myRdr.Close()
statements above the...
I have an application that is sending XML files up to a customer's site using the httpwebrequest and httpwegresponse objects. It has worked, hit and miss, but most recently I have run into a situation where assigning the httpwebrequest.getresponse to the httpwebresponse object seemingly just...
We have a Windows 2003 Small Business Server setup with Sharepoint Services. We can upload most files without trouble, however, if we attempt to upload an encapsulated postscript (.eps) file, no matter the size, the local computer attempting to upload the file freezes and hangs, eventually...
Clare1975,
Thank you for the reply, but the weird thing about this is that the recipients are external email addresses, not AD reliant. It is as if something is causing my users request to send externally the first time to fail, and when they resend from a failed attempt, the system realizes...
I have a 2003 SBS implementation where I have only a couple of users using the email system right now. Problem is, when they attempt to forward or reply to email messages, they receive the following error back the first time they try to send the message. This doesn't happen all the time, but...
Update:
I have fixed the problem, which seemed to be a combination of issues. How/when/why they changed or started affecting us is still unknown.
1) The <SID>ALRT.LOG file had grown to over 200MB in size, which I believe was causing issues with the database opening properly. I renamed this...
During a recent power outage we lost power to everything on our network. After restoring power and rebooting servers, our Novell Netware 4.11 server running Oracle 8.0.3 (without any issues for the last 6 years) failed to load the database. I am stuck. The TNS Listener seems to be fine...
TonyJollans,
Thanks for the input, but I need to reference the entire path of the menu if I don't use the find object, I am dynamically creating submenus, so I use the find to capture the command object, if there is an easier way to do this or reference the entire object rather then just the...
Found this myself....
*Note, you must add a tag definition to each menu item as you generate it, so you can do a find against it in the following code....
Dim ctlCurrentControl As CommandBarControl
Dim strControlName As String
Set ctlCurrentControl =...
I am creating a custom addin that generates a custom menu in the workbook based upon values returned from a database. I would like to be able to create a single macro that each item references in the onAction method and somehow pass the menu item's id or caption or full object path to the...
Need a secondary/backup route to the Internet in Windows SBS 2003. We have one DSL connection running through a Watchguard X15w, but it is not 100% reliable. We have dial-up access to the provider as well and would like to setup an automatic route change to demand dial-up account if external...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.