w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Connecting existing asp.net application to azure sql server vm without SDK
You mentioned not knowing anything about Azure, so checking out the tutorials at www.windowsazure.com is a great place to start, especially if you're attempting to launch a production application into an environment you know little about. Having said that: If your SQL Server is running in a VM, and that VM is part of a different deployment from your asp.net app (e.g. you used something like a web role, or Azure Web Sites), than you can not use your SQL Server's internal IP address, since you'd have no access to that IP address (each deployment lives in its own private network). Your options would be: If you deployed your website to Azure Web Sites, you'd reach your SQL Server VM through its public endpoint (you'd need to create that endpoint, called an input endpoint, with port 1433 ope

Categories : Asp Net

Azure DNS server keep connecting to virtual machine endpoints
Late answer, but for the benefit of anyone arriving here from a search engine, see answer from Craig Landis at this link: http://social.msdn.microsoft.com/Forums/silverlight/en-US/04589d2d-4acb-4f86-a2d0-957dc2a73a4f/endpoints-not-working-dns-scans-them In summary, there was a change recently so that when you create an endpoint in the portal, it is automatically load balanced and regularly "probed" to check if the endpoint is alive. At the time of writing, the portal will still display the endpoint status as 'not load balanced'. You have to use the Azure CLI tool or PowerShell to recreate the endpoint without load balancing - it cannot be done from the portal. It is the load balancer that tries to probe the endpoint every 15 seconds, and can take the endpoint out of service if it doesn't

Categories : Dotnet

Very slow deploy on azure: 'Warning: Unable to connect to the remote server'
Run a repair on your Visual Studio 2012 installation by selecting the application name in Programs and Features and clicking on Change. If that doesn't work, you may also try to re-download your Azure subscription publishing profiles again (remove the current ones from VS first).

Categories : Azure

Azure blob download is incredibly slow using PowerShell (via Get-AzureStorageBlobContent), but fast via Azure Explorer, etc?
Check out Blob Transfer Utility. It uses the Azure api, and its a good bet that is what Azure Explorer is using as well. BTU is open source so it would be much easier to test if its the cmdlet that is the problem.

Categories : Powershell

Error connecting to SQL Azure Database
Step 1: Simplify your connection string. Ours looks like this: <add name="[CONTEXTNAME]" providerName="System.Data.SqlClient" connectionString=" Server=tcp:[SERVER].database.windows.net,1433; Database=[DATABASE]; User ID=[USER]@[SERVER]; Password=[PASSWORD]; Trusted_Connection=False; Encrypt=True; Connection Timeout=30;"/> So looking at your connection string, I would try something like: <add name="MyEntities" providerName="System.Data.SqlClient" connectionString=" metadata=res://*/Model.ModelMy.csdl|res://*/Model.ModelMy.ssdl|res://*/Model.ModelMy.msl; Server=myserver.database.windows.net; Database=MyDatabase; User id=myUser@myserver; Pa

Categories : SQL

Connecting to SQL Azure from a Java application
Have you allowed access to the database server from that particular IP address? If not, go to the management portal select the database on the bottom right, select the server go to the configure tab enter the ip address (or range of them)

Categories : Sql Server

Connecting to a remote database from Azure Websites
Are you using the default MySQL Database from Web Sites? If so, could you be hitting an issue with the maximum concurrent connections? The default database allows up to 4 concurrent connections. If you want to upgrade to a larger database you can do so from the provider ClearDB

Categories : Mysql

getting 404 error when connecting to azure storage account
The problem was the container was not created or had been deleted. I added container.CreateIfNotExist(); and it worked fine. I would have expect a different error not a 404. but that fixed it.

Categories : Dotnet

Windows Azure: FTP issue When Connecting to Website
The error message: Response: 550 The network connection was aborted by the local system Suggests that there is an error in your local network. This error is not within Windows Azure, but within your local network (and appears to only be triggered by FileZilla). Contact your system administrator or Internet Service Provider. Also, please try first solving the problem yourself using something like this.

Categories : Azure

Queries to connect Azure Websites with SQL server in Windows Azure Virtual Machine
1) You can simply backup your databases and restore them onto the VM's SQL Server 2) Yes. 3) Correct. 4) Telerik controls are client controls and should have no bearing on your server-side deployment platform 5) OS space on the VM is part of the price of the VM's hourly fee 6) What are you looking to do with virtual network?

Categories : Azure

sitecore azure module 3.0.0 slow
We are using Sitecore Azure module version 3.0.0. but with Sitecore 7. Deployment from my PC takes about an hour. On my internet connection uploading takes the most time. Currently we're looking for a workaround. If we find I will update this answer.

Categories : Azure

Azure Service Bus relay response slow
By default, the Azure Service Bus Relay typically uses an opt-in authentication via ACS (Access Control Services). In order to consume the relay endpoint - it must first authorize the WCF Channel using an ACS token. The extra calls you are seeing could be removed via configuration if you choose not to use ACS as you are providing your own relay access control. Disables ACS for Service Bus Relay (Opt-Out) <bindings> <netTcpRelayBinding> <binding name="default"> <security relayClientAuthenticationType="None" /> </binding> </netTcpRelayBinding> </bindings> For more details, see MSDN on securing Azure Service Bus Connections. As for the latency issue (5-10 seconds) - this all depends on the number of WCF Calls used, where you ar

Categories : Wcf

Services extremely slow when deployed on Azure
You'll obviously need to profile your app to find the real cause. Check out these two articles which should get you started: http://msdn.microsoft.com/en-us/library/windowsazure/hh369930.aspx http://www.windowsazure.com/en-us/develop/net/common-tasks/profiling-in-visual-studio/

Categories : Performance

Windows Azure WADLogs Query is very slow
Gaurav Mantri has a post explaining how to query WAD tables in a performant manner. The bottom line is that you need to query on PartitionKey and RowKey to avoid a performance-killing table scan. The PartitionKey for the WAD tables contains the TickCount in a slightly encoded form and an appropriately constructed value can be used for range queries.

Categories : Azure

"The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website
You likely don't have a CA signed certiticate installed in your SQL VM's trusted root store. If you have Encrypt=True in the connection string, either set that to off (not recommended), or add the following in the connection string: TrustServerCertificate=True SQL Server will create a self-signed certificate if you don't install one for it to use, but it won't be trusted by the caller since it's not CA-signed, unless you tell the connection string to trust any server cert by default. Long term, I'd recommend purchasing a CA signed certificate from a known trusted CA (fairly inexpensive), and install it on the VM. You can read more on this topic in SQL Server books online under the topic of "Encryption Hierarchy", and "Using Encryption Without Validation". HTH

Categories : Misc

Why is infrequently-accessed Azure blob storage slow?
Windows Azure Storage is not architected how you are describing (with an expanding number of cache VMs), so there would be no impact of some data being cached and other data not being cached on the Azure Storage server side. See Windows Azure Storage Architecture Overview for a good overview, or SOSP Paper - Windows Azure Storage: A Highly Available Cloud Storage Service with Strong Consistency for a more in depth look. To determine why your blob requests are slower, the first thing to do would be to determine if the slow performance is server side or client side. Fortunately Azure Storage makes this easy via the Storage Analytics (Windows Azure Storage Logging: Using Logs to Track Storage Requests) - just compare the End To End latency and the Server Latency. I suspect you will see on

Categories : Performance

sqlsrv error while connecting to mssql server 2008 on windows 2003 server
Two ways to try, first to check if the Native driver has the right version - is your server really a 32bit Version and not 84bit? The other thing is, to check if the extensions are actually loaded. To check that, create a file like "phpinfo.php" and put it in you folder for .htdocs. <?php // show phpinfo file phpinfo(); ?> The easy way is to search for it in the phpinfo-Page with Ctrl+F and "extension=php_sqlsrv_53_ts_vc9.dll"

Categories : PHP

Batch File Connecting to Server and execute program install on connected server
Here's a little code to help you connect to the SQL server and interrogate the SQL version. @ECHO OFF SQLCMD /? > nul 2> nul IF ERRORLEVEL 1 ECHO.SQLCMD not found on this machine & PAUSE & GOTO :eof SET SQLCmdLine=SQLCMD -b -w400 REM use something like the next line for NT authentication; second line for SQL authentication REM for NT SET SQLCmdLine=%SQLCmdLine% -E -S "YourServerName" REM for SA SET SQLCmdLine=%SQLCmdLine% -U "YourSQLUserName" -P "YourSQLPassword" -S "YourServerName" SET Database=YourDatabaseName REM I will use NT Authentication for this example SET SQLCmdLine=%SQLCmdLine% -E -S "(local)" SET TestSQLCmdLine=%SQLCmdLine% -h-1 -d "%Database%" REM this will get the SQL version %TestSQLCmdLine% -Q "SELECT @@VERSION" | FINDSTR /v "rows affected" REM this will

Categories : SQL

Painfully slow Azure table insert and delete batch operations
basic concept - use paralleism to speed this up. step 1 - give your threadpool enough threads to pull this off - ThreadPool.SetMinThreads(1024, 256); step 2 - use partitions. I use guids as Ids, i use the last to characters to split into 256 unique partitons (actually I group those into N subsets in my case 48 partitions) step 3 - insert using tasks, i use object pooling for table refs public List<T> InsertOrUpdate(List<T> items) { var subLists = SplitIntoPartitionedSublists(items); var tasks = new List<Task>(); foreach (var subList in subLists) { List<T> list = subList; var task = Task.Factory.StartNew(() => { var batchOp =

Categories : C#

Windows Azure virtual machine is slow to access network when scaling
The VM sizes each have their own bandwidth limitations. | VM Size | Bandwidth | | ------------- |:-------------:| | Extra Small | 5 (Mbps) | | Small | 100 (Mbps) | | Medium | 200 (Mbps) | | Large | 400 (Mbps) | | Extra Large | 800 (Mbps) | I suspect you always have one copy of your mounted VHD and have ~150 instances hitting it. Increasing the VM size of the VM hosting the VHD would be a good test but an expensive solution. Longer term put the files in blob storage. That means modifying your scripts to access RESTful endpoints. It might be easiest to create 2-3 drives on 2-3 different VMs and write a script that ensures they have the same files. Your scripts could randomly hit one of the 2-3 mounted VHDs to spread out the load. H

Categories : Windows

Windows Azure Active Directory slow authentication on mobile devices
David, Is it correct that your site is using wsfed and redirects to AAD where the client enters creds? Do you notice where the slowdown occurs, is it before the user enters cred (if they do) or after? Brent.

Categories : Azure

.Net Multi threaded application slow on a powerful server vis a vis regular server
Your question is a little vague especially since we have no code to work with or any idea of the framework. But I can think of some general things that might be causing your problem. First off just because you add more cores doesn't mean you will get better processing, in fact depending on how the code is written, you could get the exact opposite which is what you are seeing. My primary suspicion would be that you have some common object(s) that all your task are using which your tasks end up fighting over resulting in bottlenecks. So my first question would be do you have any shared resources among tasks? Basically are the tasks that you are spawning individual units of work (i.e. have no dependencies shared between tasks)? Another warning sign that you have a bottleneck is your CPU usag

Categories : C#

Connecting to a SQL Server DB
Well this seems to work ok, use DBI; # $dbh = DBI->connect( "dbi:mysql:DBNAME", "root", "password" ) or die "Connection Error $DBI::errstr "; N.B. Please Check you have the required modules installed.

Categories : Perl

issues in connecting to AD server over SSL?
If you can't get TLS to work, it is unlikely that SSL will work. Are you sure that you got the right certificate and configured the keystore correctly? Based on the SSLHandshakeException when trying to use TLS, it would seem that may not be set up correctly. Check out this SO answer for some tips on how to verify that your keystore is correctly set up: http://stackoverflow.com/a/9619478/1792088

Categories : Java

connecting to an SQL Server database
The problem your having with regards to connecting to the database on a server is because of SqlConnection dbConnection = new SqlConnection("Data Source=.\SQLEXPRESS;Integrated Security=true"); The best way to do this is to go to your Web.config file and find the block and add a connection to your database in there. eg <add name="ConnectionString" connectionString="Data Source=YOUR SERVER;Initial Catalog=YOUR DATABASE;User ID=YOUR USER ID;Password=YOUR PASSWORD" /> then you can just call the connection string accross your whole project whenever you need to use it. Also with regards to VS2012. There are very few companies using that IDE at the moment so your probably better off learning VS 2010 in the most part but i would agree that VS2008 is fairly out of date now

Categories : C#

Connecting to sql server 2008 using vb
In DBConnect, check the status of objConn to make sure it's really being opened. In DBConnect, you have exit function before response.write. In GetValue, check value of err.number.

Categories : Vb.Net

Connecting to SQL Server in Xcode
One route to take is to make a copy of that Database and put it on the phone as an SQLite Database and have a PHP script that gets the newest additions and adds them to the SQLite database. A second route you could take, is you could ask him to put it JSON format and you would have a dictionary on the phone that held all of the JSON, and then parse the JSON using apples built in parser, NSJSONSerialization or any of the other JSON parsers out there. Using the parsed JSON, you could then do as you please with the list of notifications Another method will be for that guy to write a PHP script for you to access all the notifications and you run that in a for loop and populate a table, or whatever, on the phone of the latest push notifications that way. This while take a few seconds longer t

Categories : Iphone

Client isn't connecting to server
Always create output output stream before your input stream for Object streams, otherwise you create a deadlock situation. output = new ObjectOutputStream(socket.getOutputStream()); // output.flush(); if the underlying stream is buffered input = new ObjectInputStream(socket.getInputStream()); The input reads the header written by the output, which won't be there unless the output is created first.

Categories : Java

Connecting to database server using php
This should be basically the mysqli version of what you wrote. <?php $username = "user"; $password = "pass"; $hostname = "creative.coventry.ac.uk"; $mysqli = new mysqli($hostname, $username, $password, "asantec"); $stmt = $mysqli->prepare("SELECT * FROM books;"); $stmt->execute(); $stmt->bind_result($id, $title, $author, $price); //Put all your expected variables here while ($stmt->fetch()) { echo $id.'<br />'; echo $title.'<br />'; echo $author.'<br />'; echo $price.'<br /><br />'; } $mysqli->close(); ?> Also, if you have any issues in the code you've posted, this will work. Check your DB credentials and the data you're querying.

Categories : PHP

Connecting to wamp server from different pc
you need to follow the below steps: 1.in httpd.conf DocumentRoot "C:/xampp/htdocs" //add your wwwroot folder path (this is Xampp example) <Directory /> Options FollowSymLinks AllowOverride None Order deny,allow Deny from all </Directory> 2.Open httpd-vhost.conf and add: ##</VirtualHost> <VirtualHost Name:80> DocumentRoot C:/xampp/htdocs/wwwroot/ <Directory "C:/xampp/htdocs/wwwroot/"> Options Indexes FollowSymLinks Includes execCGI AllowOverride All Order Allow,Deny Allow From All </Directory> ServerAdmin (any@email.com) ServerName (IP address or FQDN) </VirtualHost> 3.The most Important step is to add an exception for the used port(80 in this example) on windows firewall. Hope this helps :)

Categories : PHP

Connecting Sql Server though Node.js
I just did it following this walkthrough at http://tech.pro/tutorial/1848/getting-nodejs--sql-server--azure-to-work-together He's using the "msnodesql" package at https://www.npmjs.org/package/msnodesql, code at git-hub at https://github.com/WindowsAzure/node-sqlserver, and I've got it running in a node-console app with a simple select-statement: var mssql = require('msnodesql'); var conn_str = "Driver={SQL Server Native Client 10.0};Server=tcp:xxxxx;Database=yyyy;Uid=zzzz;Pwd=wwww;Connection Timeout=30;"; mssql.query(conn_str, "select * from testtable", function(err, recordset) { if(err){ console.log("Got error :-( " + err); return; } recordset.forEach(function(record) { console.log("name: " + record.Name + " (" + record.ID + ")"); }); });

Categories : Sql Server

Can you setup an azure server to sync with a outside NTP server?
here are the steps I used reg add HKLMSYSTEMCurrentControlSetServicesW32TimeTimeProvidersVMICTimeProvider /v Enabled /t reg_dword /d 0 w32tm /config /syncfromflags:manual /manualpeerlist:0.pool.ntp.org,1.pool.ntp.org,2.pool.ntp.org,3.pool.ntp.org net stop w32time & net start w32time w32tm /resync /force w32tm /query /source

Categories : Azure

Connecting to sql server 2008 database using C#
You connection string is wrong. It should be of this form if you use SQL Server Authentication: Server=myServerAddress;Database=myDataBase;User Id=myUsername; Password=myPassword; Where myServerAddress is the IP or host name of the computer running SQL Server. If it's your PC, localhost will probably work. myUsername and myPassword are the credentials of the user connecting to the server. If you use Trusted Connection,you connection string should be of this form: Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; You can check more examples here: http://www.connectionstrings.com/sql-server/

Categories : C#

Connecting by php to a python websocket server
I think your problem is in how you are packing the data. Without knowing which protocol you are trying to use, I can't tell you how to pack it! But, there is a working code snippet in one answer to this question.

Categories : PHP

Error connecting to server in a file
This line: inet_aton(h->h_addr_list[0],&indirizzo_server); is wrong. h_addr_list is not a list of strings in the format that inet_aton expects. It's not even a list of strings at all. It's a list of addresses ready to be copied directly into the appropriate field of the struct sockaddr_*. The char **h_addr_list in struct hostent should be treated as void **, which is what it would be if it hadn't been designed before ANSI C gave us void. A generic pointer is used because gethostby* supports (at least theoretically) arbitrary address families. In the case of h_addrtype==AF_INET, each h_addr_list[n] is a pointer to a struct in_addr, so you can just say indirizzo_server = *(struct in_addr *)h_addr_list[0]; and all will be well.

Categories : C

Not seeing database from localhost but seeing it when connecting to server
GRANT USAGE is not what you want. According to the mysql documentation: USAGE Synonym for “no privileges” It is used at the global level with GRANT to modify account attributes such as resource limits or SSL characteristics without affecting existing account privileges. http://dev.mysql.com/doc/refman/5.1/en/grant.html You need to grant actual privileges to your "someuser" user for the database the user needs to see. For example, if you grant select privileges on the mysql.*: GRANT SELECT ON mysql.* TO someuser@localhost IDENTIFIED BY "somepassword"; FLUSH PRIVILEGES; Now, someuser connected from localhost will be able to see the mysql database when executing SHOW DATABASES; However, you might want to reserve the access to the mysql database for root only.

Categories : Mysql

Connecting C socket server from PHP using PHP Extension
Debug your code properly, could you receive parameters in your C Client code passed from PHP function call, I hope you will not get the parameters which you are passed from PHP function call. Check your parameters receive section, there you have to check the type of values sending from PHP should match the type of declaration in your C Client socket connection scripts. I hope replace your receive parameters section with my following code, it will work. if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "ls|b", &i_iPortNumber, &i_pcIPAddress, &return_long) == FAILURE) { RETURN_NULL(); }

Categories : PHP

Need help! Connecting MS SQL Server 2005 to Eclipse
You have to download the jTDS JDBC driver and add it to your classpath. You are loading this driver here: Class.forName("net.sourceforge.jtds.jdbc.Driver"); but it seems not to be available at runtime.

Categories : Java

Connecting to smtp server windows C++
In the following line: sock = socket(AF_INET, SOCK_STREAM, 0); You do not specify a protocol. You should change it to sock = socket(AF_INET, SOCK_STREAM, IPPROTO_TCP); This is the kind of protocol you are going to want to establish with something such as a mailing service.

Categories : C++

JBoss web application not connecting to RMI server
The failure you are getting isn't with the 'RMI server' at all. It is with the RMI Registry. You are using Naming.lookup() where you should be using something JBoss-specific. As the exception suggests.

Categories : Java



© Copyright 2017 w3hello.com Publishing Limited. All rights reserved.