|Connect to mysql on Amazon EC2 from a remote server - ERROR 2003|
i have in the iptables this line
REJECT all -- anywhere anywhere reject-with
and this line only append the rule to the end of the list so the reject
catch it first
sudo iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT
to solve it i needed to put the rule higher in the chain, i.e. use -I
switch like this:
sudo iptables -I INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT
|using ELMAH with visual studio 2003|
I have found all the answers for elmah at the following location:
Elmah Help for .NET 1.1 applications
|VB.net Visual Studio 2003 Reading Data from Excel Table|
You may need to put additional quotes around the Extended Properties=Excel
5.0; part of your connection string (see connectionstrings.com for more
|Most Efficient Way To Export Access 2003 Listbox RowSource (query) To Excel 2003|
Try generating a XML file. Here an example:
P.S. About first method.
To avoid users clicks you can hide Excel.
Also you can speed up Excel (see functions below). Use Prepare() before
putting data and Ended() after it or in case of error.
Public Sub Prepare()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
ActiveSheet.DisplayPageBreaks = False
Application.DisplayStatusBar = False
Application.DisplayAlerts = False
Public Sub Ended()
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
Application.EnableEvents = True
ActiveSheet.DisplayPageBreaks = True
|Unable to make remote connection to Ms Sql Server 2008 R2 in windows 2003 server|
MSSQL 2008 has a utility called a "Surface Area Configuration Manager" that
actually blocks the TCP port to external network interfaces, by default.
Check that out, and I'm betting it will solve your problem.
|NetBeans Remote Development with additional configuration|
It turned out that setsee is more or less an internal tool. Yet “the core
question” remains: how to have an arbitrary script executed on behalf of
an SSH session created by IDE, before IDE actually uses that script.
Answer to the “How can I set environment variables for a remote rsync
process?” question on Super User says it all.
To summarize it shortly: in ~/.ssh/authorized_keys one has to modify an
entry corresponding to the key with which the IDE will log in. There one
has to add a command parameter that is a script to be executed after
logging in but before “returning control”.
There is also another thing associated with that solution. If the script to
be executed within the command option outputs anything the it will break
many tools (possibly the IDE as well). Such too
|GIT: Managing repos between two remote development teams|
This isn't a simple problem.
When you have two repositories that simultaneously update each one of them
you can get conflicts when sync-ing them.
Conflicts may need human interaction to be solved the correct way. One way
to solve this is to always sync, while pushing to B, A is locked down and
then B is pushing to A and A is unlocked again, and the other way around.
This is probably not a good solution for you. I suppose that you have
bandwidth limitations, otherwise all devs would work directly with A.
So, let's do some magic. You have a timezone difference. Let's move the
master repository twice every day.
Make B read only and let all devs push to A. Let B do a pull. Make A read
only and let all devs push to B. Let A do a pull and so on.
You would always have fast-forward updates (i
|Xbox Application Development using C# and Visual Studio|
Visual Studios seems to be what most developers would use for xbox.
As for languages if your looking to develop apps for xbox and not games,
you could use C# or WPF.
Hope this was a bit helpful.
|Run Two Projects on Same Visual Studio Development Server|
I finally found a way:
Use IIS Express and change the managed pipeline mode to classic
(instructions: http://stackoverflow.com/a/5918197/2503659) so that HTTP
modules will be loaded.
|query data in business intelligence development studio (BI)|
If you do want to display in the form of report , you can use SQL Server
This allows us to display the query data in various formats. It may be
Tabular , drill down,
Hiearchial , Pie Charts , graphs etc.
After creating the reports , deploy them and call from website . There is
a control called
ReportViewer which helps in displaying your reports and also export them in
Use the below link to Kick start your reporting with SSRS.. Hope this
|What is Security Development Lifecycle Checks option in Visual Studio?|
The Microsoft Security Development Lifecycle is a software development
process used and proposed by Microsoft to reduce software maintenance costs
and increase reliability of software concerning software security related
These may helpful:
|How to setup typescript development workflow in visual studio 2013?|
1.) How to let visual studio compile all typescript files into only one
You need to add the section
<TypeScriptOutFile>Some.js</TypeScriptOutFile> to your project
TypeScript compiler cannot do this. Use uglify.js OR google closure OR
do this for you.
3.) Could we have google closure "exportsymbol" feature in the
typescript? If I want to all symbols in my_public_api.ts is kept as
they are and all other symbol names should be obfuscated.
TypeScript compiler does not do any minification / obfuscation.
|Unable to connect to ASP.NET development server error visual studio 2010|
Even I faced this problem. while installing the visual studio 2010 we need
to install IIS component.Follow the steps for installing "IIS 6 management
1.goto control panel>>Turned windows features on or OFF>>
2.Internet information services >> web management tools>> check out
checkbox (IIS management console)
|Create web services for Data Mining using Business Intelligence Development Studio (BIDS)|
I assume here that you know how to write a web service.
You should use the adomd.net to fetch your cube data.
Refer: ADOMD.NET Client Programming
Example: Displaying a grid using ADOMD.NET and MDX
AdomdConnection conn = new AdomdConnection(strConn);
AdomdCommand cmd = new AdomdCommand(MDX_QUERY, conn);
CellSet cst = cmd.ExecuteCellSet();
|visual studio development server automatically redirects to default port with machine ip|
I have faced this issue and resolved by following steps:->
Go to Internet Option ->Connections
Click on Lan Settings
Uncheck Automatic detect settings check box.
Clear all browser cache/history
Try and browse the site now. You should be able to view your site
Since Chrome uses IE settings, this solution should work for Chrome too.
|What's the industry standard way to organize Visual Studio projects and code for .NET Cross-platform development|
This is a well known programming problem, if solution exists they usually
require some work and even more when a project is not designed from scratch
to be portable. As you correctly pointed out, pre processed statement will
quickly become an overhead and a real pain to maintain and expand over
Yet it is not easy to answer this question directly since the solution you
are seeking might be highly dependent of your implementation. Generally
speaking I would advise you to make extensive use of well known design
pattern such as Abstract Factory, Bridge, Facade, etc.
As an exmaple, start by identifying every single piece of code which is
platform dependent, define API interfaces responsible to handle these
specificities in your core project and implement them into dedicated
projects - u
|Script working fine on development server but not remote server|
If its timing out on the server it's more than likely because a link to a
resource in your script is not pointing to the correct location.
Leading to a function call not working or other resource not being found.
|Collecting a list/table of version specific information for RAD Studio/Delphi/C++ Builder related development environments|
Part of the information comes from these sources:
How do I determine the Delphi version which created a Delphi project
http://sourceforge.net/projects/radstudiodemos/ (note these are often
incorrect: updates in various older branches have been done with newer
RAD Studio XE5
Platform targets supported
Win32, Win64, OS X x86, iOS Arm, Android Arm
DllSuffix Package Version (file suffixes of BPL and DCP files)
HKCU base registry key
HKLM base registry key
Default base installation directories (on x86 and x64 systems
|Remote Debuggging in Visual Studio 2012|
Consider the following situation:
We have deployed a web application on a client machine and the client
reports a bug. Then we try to replicate the problem in our local
environment (where the code exists), but could not succeed. Now there are
two ways to debug the client installation – either through log files or
through visual studio debug mode. If our logging is not detailed, we will
have nightmares in troubleshooting. The other option is installing visual
studio in a server machine (which is not a great idea).
To solve this remote debug problem, we can use a tiny tool called Remote
Debugging Monitor (MSVSMON.EXE). It lets you run, debug, and test an
application that is running on one device (client machine) from another
computer (local development environment) that is running Visua
|How to import remote library in Android Studio using gradle?|
You can use:
or if you have the library copied to your project libs directory, you can
compile files ('libs/ nineoldandroids-2.4.0.jar')
however, you can check out my post on getting started with swipelistview:
|Visual Studio 2010 Remote Debug across domains|
First, i've read @KyleMit's answer on the same question and done all steps.
But, for across domain debugging also need to edit
C:WindowsSystem32driversetchosts file on local computer.
Just add remote computer's ip address like this:
126.96.36.199 - ip address of your remote server
SRV-TEST-ADRESS - Server's name from Visual Studio Remote Debugger
Monitor on remote computer
You can know your server's ip address by ipconfig in cmd
After that, i could attach to proccess on remote computer across domain.
|Cannot use Visual Studio 2012 remote debugger from inside VM|
As long as the visual studio debugger can see the surface's IP that should
be good enough. They don't need to be on the same subnet (although it makes
it a ton easier, they cannot be NAT'd as far as I am aware but that's a
better question for Microsoft directly). The best that I can recommend
would be to switch from shared to bridge for your networking, that should
put your Win 8 VM on an actual IP on the same subnet. Otherwise you might
be able to try IPv6... but I don't know how well that will work with
|Remote SQL Servers unavailable after installing Visual Studio 2012|
I think you'll need to look in your SQL server configuration manager and
make sure TCP/IP is enabled for the database instances your interested in.
It isn't by default if I remember rightly.
If you're ok locally, have you read this post?
An error occured during the pre-login handshake
|How to debug an Asp.Net Mvc Application in Visual Studio 2012 from a remote computer|
If your remote machine is also the IIS server:
If you share your Remote Debugger Folder out so it can be accessed on the
remote machine. Folder for 2012 should be
C:Program Files (x86)Microsoft Visual Studio 11.0Common7IDERemote
On the remote machine access the folder and run the msvsmon.exe
It will give you a server name once launched. Then on your local machine,
in VS2012, in the debug menu, select attach to process.
Enter the server name provided by the remote debugger into the Qualifier
field and attach to the w3wp.exe process
if your IIS server is the localhost and your remote machine connects to it:
You dont need remote debugger, just attach to process from the debug menu
and select the w3wp.exe process.
For good measure, here is the MSDN
|Not able to connect any remote database server after installing Visual studio 2012|
Have a luck via running following command (netsh Winsock reset) from
command prompt mentioned in
|How does SQL Server Mgmt Studio access remote file system using SQL credentials?|
During the installation of SQL Server on the remote machine, it is
Commonly it is set to the NT AUTHORITYNETWORKSERVICE Account or NT
It can be configured after-the-fact using Sql Server Configuration Manager.
It is described as the Log On As: Property.
|What does Production Phase ,Development Phase and deployment means in Visual studio 2010|
We use SVN at our site (TortoiseSVN as client).
Each project has its own repository with three types, a Trunk, a Releases
branch, and Branches. Trunk is a work in progress, Releases are snapshots
of the source for major releases, and a new Branch gets created for a
particular task. Upon completion a branch will get merged back into Trunk,
and eventually a release gets created from Trunk.
Development phase and Production phase seem confusing, but I'm guessing
development means code in the process of being developed, and production
means code that has been released into the production environment. You
generally don't want to do development in the production environment, you
should start in development phase and once the functionality is thoroughly
tested, promote it to production.
|Visual Studio 2008 C++ - Remote Debugging - "Could not load symbols" only for main project|
I figured out that I missed a setting for the main project that was done
for all other projects. I had to set "Project -> Properties -> C/C++ ->
General -> Debug Information Format" to "Program Database (/Zi)".
|Visual Studio 2012: Remote and local debugging of a Windows Store app at the same time|
This is how you can do this:
Build your Windows Store App in Visual Studio.
Select Local Machine on debugger toolbar. Right click on your Windows Store
App Project in Solution Explorer -> Click Deploy. This will deploy latest
App on Local Machine.
Select Remote Machine on debugger toolbar. Right click on your Windows
Store App Project in Solution Explorer -> Click Deploy. This will deploy
latest App on Remote Machine.
In Visual Studio click on Debug menu -> Debug Installed App Package. Choose
Machine (by default) -> find your application and click Debug.
Launch Remote Debugger on Remote Machine.
The same step as 4 above, but for Remote machine. In Visual Studio click on
Debug menu -> Debug Installed App Package. Choose Remote Machine -> find
your application and click Debug.
|Visual Studio remote debugger "invalid access to memory location" feature|
The hotfix 2588507 ended up resolving the issue after all. I am running
several instances of visual studio 2012 for several days, and debugging
remote processes constantly, and have not seen yet a single "invalid access
to memory location"
|Analyse performance of android app using Android Development Studio|
From Android Studio Tips and Tricks, on developer.android.com:
When you build and run your app with Android Studio, you can view adb
and device log messages (logcat) in the DDMS pane by clicking Android
at the bottom of the window.
If you want to debug your app with the Android Debug Monitor, you can
launch it by clicking Monitor in the toolbar. The Debug Monitor is
where you can find the complete set of DDMS tools for profiling your
app, controlling device behaviors, and more. It also includes the
Hierarchy Viewer tools to help optimize your layouts.
So, have you tried clicking on the monitor button? It looks like a little
green android. From there you can use all the regular tools.
As for the downvote, I can only assume it was for one of two reasons
|Installing Android Studio for Android development|
Try setting JAVA_HOME to your JDK folder, not your JRE folder. If you
don't have an installed JDK, go download it
|Do any standards and practices exist for applying acceptance test driven development to non-development tasks?|
Take a look at this post in StackExchange: Agile methodologies such as
Scrum in non-software development projects
Also there is a nice article called "Scrum is not just for software"
written by the Agile Alliance (note that this is a PDF download)
|Error Queuing Visual Studio Load Test on Remote Test Controller|
Visual Studio Online Cloud Load Test provides a solution to perform Cloud
based load test runs where in you don't need to go through this pain of
setting up the controllers and agents by yourselves in a cloud provider.
Please go through this link and try out the solution -
|ODP.NET 32 bit on Win 7 64 bit and Win Server 2003 64 bit|
IMO There are a few options:
Compile for x86 and install the 32 bit Oracle Client on your 64bit server
(could run side by side if you change the ORACLE_HOME, TNS_ADMIN, ...
Compile for x86 and pack all DLL's for a 32 bit Oracle Instant Client
together with your binaries (make sure the TNS_ADMIN system variable is set
otherwise you won't be able to use LDAP or tnsnames);
Compile your application for Any CPU but create a different set of dll's
for x64 and x86 bit (Oracle.DataAcess.dll is compiled for a specific
architecture, there is a version for x64 and one for x86);
Oracle is working on a managed Oracle driver, no Oracle client is required
anymore, most codebases can converted easily but be aware that it's not
feature complete yet and only supports Oracle 11+ database
|How to use InStr function in VBA 2003?|
Start index of InStr function is 1-based => 0 is invalid value.
See Exceptions section of
|What is the Best way to see a dataset contents in Vs 2003 IDE|
Grab the XML Visualizer 1.0 for Visual Studio 2003 from Google Drive while
it's still there.
Maybe someone else will also find this link useful in the future.
|IFERROR in Excel 2003|
The Excel 2003 equivalent of =IFERROR(A1,"") is =IF(ISERROR(A1),""). See
=IS. But neither version of that formula is very useful. A little more
useful would be something like =IF(ISERROR(A1),0) where an error in A1,
perhaps resulting from dividing by zero, is elsewhere (ie in the cell with
the formula) displayed as 0.
The trouble with the single comma is that if ISERROR() is false (ie A1 is
not an error) this returns FALSE - not particularly helpful but relatively
So these formulae are normally used with another formula instead of A1.
That is, one formula is wrapped around another. The later Excel version
might have =IFERROR(A1/B1,""). Thus, if A1 contained 1 and B1 2, the result
would be 0.5 whereas if A1 then were changed to become #REF! the result
would be blank (nothing
|Connect to Sharepoint 2003 in C# WPF|
There are 2 ways:
a. Using Sharepoint web services
Suppose your sharepoint server URL is as follows
Then replace default.aspx with /_vti_bin/lists.asmx to get list of web
services expose by sharepoint.
This will provide you with list of all operations exposed by service.
You can use GetList to get calendar list and check if you get desired
b. Uisng Sharepoint object model and Microsoft.Sharepoint.dll (WPF
application can run on same server where sharepoint is installed)
|Microsoft.ACE.OLEDB.12.0 for MS Access 2003|
I would store the available connection strings in a table, along with a
Yes/No field called "Active". Then, when the app is launched you can
determine which version of Office is installed, set the Active field for
that record to "Yes", and have your database pull the connection string out
of the table based on which record is active. Easily done with a DLookup
command. Bada-Bing! Going forward, you just need to distribute a new
version of the table with any additional connection strings you may need.
This way, you don't have to keep re-writing or re-editing the code. Making
everything table-driven has saved me WEEKS of coding time on projects I've