I just ran in to this issue as well but then was able to find the solution. You just need the newer version of SSMSE which is now 2008! Here's the MS download page: http://www.microsoft.com/en-us/download/details.aspx?id=7593

Probably sa account is disabled in your case. Try to login to sql server with (windows auth) login which you was using for installation and enable sa login Another thing - check if SQL Server authentication mode is SQL Server and Windows.

This is an example of a join to an aggregated table (I think that is the best way to understand it): SELECT ii.ItemNum, ii.ItemName, ii.OzOnHand, ii.OzOnHand - coalesce(il.cnt, 0) FROM dbo.InventoryItems ii LEFT JOIN (select il.InvItemNum, sum(OzRemoved) as cnt from dbo.InventoryLog il group by il.InvItemNum ) il ON ii.ItemNum = il.InvItemNum WHERE ii.active = 1; The subquery groups everything in the log and counts the number of entries. If each entry could affect more than one item, then you would use something like sum(cnt) as cnt instead of count(*). Then, the query uses a left outer join. This type of join ensures that all inventory items remain, even those with nothing in the log. Finally, the count is subtracted from what is available in set up. The

My aim was to do software ready installation with SQL available for everyone standard Users. Finally, I used MS Database Publishing Wizard 1.1 and not Server Management Studio Express 2005 or 2012 to make scripts for databases with data and schema for repository data. Solution for deploying at different platforms was by adding the following lines at the beginning of scripts: CREATE USER [Users] FOR LOGIN [BUILTINUsers] GO exec sp_addrolemember db_datareader, Users go exec sp_addrolemember db_datawriter, Users go

Have you configured your these files on your Linux server? (These are taken from an Ubuntu 12.04 server) /etc/odbc.ini # Define a connection to the MSSQL server. # The Description can be whatever we want it to be. # The Driver value must match what we have defined in /etc/odbcinst.ini # The Database name must be the name of the database this connection will connect to. # The ServerName is the name we defined in /etc/freetds/freetds.conf # The TDS_Version should match what we defined in /etc/freetds/freetds.conf [mssql] Description = MSSQL Server Driver = freetds Database = MyDatabase ServerName = mssql TDS_Version = 8.0 /etc/odbcinst.ini # Define where to find the driver for the Free TDS connections. [freetds] Descr

Sorry, i cannot add a comment and sorry for my english. Is your 'dbhostname' the name of your odbc connection (might be different from the sql server instance name)? Proof if your conf.php and your php file you use to display the grid are in utf8 without BOM encoding.

Seems there is a problem with .NET 4.5. I think you have to remove non-IFS LSP installed Winsock Catalog Provider. Kindly follow the instructions given on http://support.microsoft.com/kb/2568167.

If i remember correctly SQL Server disables remote connections by default. Please check whether remote connections are enabled and enable them if not: RMB on Server in Management Studio Object Explorer -> Properties -> Connections -> Allow remote connections...

Whilst this may be 30 days late.. I've actually been assigned the same project.. x) But took me a while to tinker around with it.. <?php /** * Submit XML to the TNT * server via a Stream instead * of cURL. * * @Returns String (XML) **/ function sendToTNTServer( $Xml ) { $postdata = http_build_query( array( //For Future reference //the xml_in= ( the = ) is appended //Automatically by PHP 'xml_in' => $Xml ) ); $opts = array('http' => array( 'method' => 'POST', 'header' => 'Content-type: application/x-www-form-urlen

You need to use a BroadcastReceiver that will be triggered when the connectivity status for Wi-Fi has changed. Set following things before registering BroadcastReceiver: private class ConnectionChangeReceiver extends BroadcastReceiver { public void onReceive( Context context, Intent intent ) { Log.d(tag, "Inside Broadcast Reciever"); CheckWifiStatus(); } } private void RegisterWifiWatcher() { if(wifiWatcher == null) wifiWatcher = new ConnectionChangeReceiver(); final IntentFilter intentFilter= new IntentFilter(); intentFilter.addAction("android.net.wifi.WIFI_STATE_CHANGED"); intentFilter.addAction("android.net.wifi.STATE_CHANGE"); registerReceiver(wifiWatcher, intentFilter); } WIFI_STATE_CHANGED : Broadcast intent action indicating that Wi-Fi has been enabled,

I used the ODBC - SQL Native Client driver and this works $db = new PDO("odbc:Driver={SQL Native Client};Server=ip,port;Database=db;Uid=user;Pwd=pass;");

You need to actually successfully get mongod running and listening for connections. Just type mongod with no options, hit ENTER, and let it run. Then in a separate terminal start your express app. Note that mongod is the mongodb server daemon whereas mongo is the command line client where you can run an interactive REPL and issue database commands.

You're getting that error because the (localDB)v11.0 is already a user instance of SQL Server. When you were using the SQLEXPRESS SQL Server instance, well, it's not. So, just get rid of the User Instance=true on the connection string.

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/ i think this will help you...

I have found the solution. It was, in fact, a r/w rights error. I have added following users to my profile folder: IUSR Local Service Network IIS_IUSRS Service I know I went overkill here but I wanted to be sure without giving everyone access rights. I will disable them one by one and find the right one(s) needed to properly run SQL Server Express 2012.

As documented, upgrade is supported from SQL Server 2008 R2 SP1 Express to SQL Server 2012 Express. Install the 2008 R2 SP1, and run installation of 2012 Express normally. It should pick up and offer an upgrade. Your operating system is also supported.

WITH in SQL Server 2000 allows only FillFactor to be set. See the documentation: http://msdn.microsoft.com/en-us/library/aa258255%28v=sql.80%29.aspx Remove other options from the WITH clause.

I haven't done it on Windows, but if I were you, I'd try to do this with Quicklisp: (ql:quickload "clhs") and follow the printed directions. I'd also get SLIME from Quicklisp via (ql:quickload "quicklisp-slime-helper"), but if your slime works ok, no real need.

I have faced the same issue in a perticular scenario. It was like, Page_Load event of 1st page contains code to redirect response to 2nd page and Page_Load event of 2nd page contains code to redirect response back to 1st page. So due to this browser response fell into infinite loop and it shows message: "Internet Explorer cannot display the webpage". So I'll suggest you to check the response redirection logic which may be causing problem.

why not ask the author? You should not rely on help on cloonix, communication on the product has been small and not many know about it. To reach the internet from a virtual machine, the host must be connected to the internet and the file /etc/resolv.conf of the host must be valid. If the above is ok, then connect an interface of the vm to the cloonix_slirp_admin_vlan and do dhclient on this interface from within the guest. Then your vm should be connected to the internet (check your /etc/apt/sources.list to have apt-get).

First of all - you should use the appropriate type for your dates - that is DATETIME - do not cast dates into strings and back if you can avoid it! (and you can definitely avoid it here) Secondly: the DATETIME in SQL Server as well as the DateTime in .NET both have dates and time information, e.g. 2013-06-23 14:57:34 so if you're doing an equality comparison in your JOIN condition, only those rows that exactly match your date and time will be selected. So you need strip off the time portion, if you want to use just dates for comparison. So try this code here: ALTER PROCEDURE dbo.YourProcedureNameHere (@currentdate DATETIME) SELECT DISTINCT table1.name, table2.class, table3.stream FROM dbo.table1 INNER JOIN dbo.table2 ON table1.id = table2.id INNER JOIN

Before calling connect(), use bind() on the socket and specify the local IP of the desired interface. It's fine to call bind() on a client socket -- just don't call listen().

First, you should make sure that the ssh daemon is installed properly on your RP. You can install it with sudo apt-get update && apt-get install ssh Next, you should try to connect to your SSH server locally, that means, open up a terminal directly on your RP and try to connect to your locally running SSH server: ssh root@localhost Or even better, use the current IP address of the RP instead of localhost. If you can connect, everything works on this side. Now you can try to connect to your RP from another box inside your local network. It should also work. If it does not, you most probably have a firewall blocking outgoing SSH connections on this box, or your RP itself is blocking incoming connections. Usually, it should not block it, unless you configured something like that

Not that I am aware of. Here is a method that detected WIFI and Data separately. Perhaps you can alter this and put a prompt in there forcing user to turn off data and turn on WIFI. public static boolean isNetworkConnected(Context context) { boolean isConnectedWifi = false; boolean isConnectedMobile = false; ConnectivityManager cm = (ConnectivityManager) context.getSystemService(Context.CONNECTIVITY_SERVICE); NetworkInfo[] netInfo = cm.getAllNetworkInfo(); for (NetworkInfo ni : netInfo) { if (ni.getTypeName().equalsIgnoreCase("WIFI")) if (ni.isConnected()) isConnectedWifi = true; if (ni.getTypeName().equalsIgnoreCase("MOBILE")) if (ni.isConnected()) isConnectedMobile = true; } return isC

http://msdn.microsoft.com/en-us/library/aa289160(v=vs.71).aspx scan on Configuring the Emulator to Connect to the Internet

Unfortunately the "official" drivers are Windows only. If you need a cross platform SQL Driver, checkout tedious. There is some work going on to make edge cross platform which would allow you to bridge .NET (or Mono) and Node.JS which would allow you to get much more performant SQL access, but it is not ready yet.

PrimitiveType 'Time' Are you sure it's not trying to create a datatype of time? 2005 does not have this type. I'm not sure if this is what you're using, but it looks like there is a difference between time and datetime. http://msdn.microsoft.com/en-us/library/ee382832.aspx

Query 2 displays the '090' data beneath the '90' data because that's what you're telling it to do in the ORDER BY aspect. Remember, your SOURCE column is a VARCHAR. It's a string, despite being numbers, and as such will sort according to the rules of strings. Thus, it's looks at the first character for order, rather than to the numerical value. If you want it to sort according to the numerical value which the string represents, then you'll need to cast the SOURCE column to an integer in the ORDER BY statement. And as for why it returns all data, that's because you're comparing the numerical representation of a number to a number. SQL performs an implicit conversion within the where clause to deal with the boolean operator. Now, your reported results for Query 1 are not what I'd expec

I have a feeling you're exceeding the size of data SSMS is allowing to be displayed. Try adjusting the size in SSMS here: Tools -> Options -> Query Results -> SQL Srver -> Results to Grid -> XML data Change 2MB to something larger

Based on the information you've given, I don't think it's possible to provide a solution to the question you're asking. You've stated that your code works when the two computers are on the same local network, so clearly the code (which, yes, has issues) works at least well enough to connect from client to server. If (as is established,) the code works, then it shouldn't matter whether the client and server are on the same network or separate networks, so long as there's a route, a path, a connection between the two networks. Therefore, if the client can't connect to the server, the conclusion is that this path is missing. The path being missing, however, is not a problem we can troubleshoot for you: It might be "my 'Windows Firewall' is blocking this app", it might be "my ISP (or the othe

I think that Active Directory Federation Services might be what you're looking for. Specifically the "Web Single Sign On" functionality. Since you've tagged with question with "insecure-connection" I feel I must add that you should not, under any circumstances let user account data flow in to or out from your company's firewall un-encrypted.

try this function: private final boolean isInternetOncheck() { ConnectivityManager connec = (ConnectivityManager) getSystemService(CONNECTIVITY_SERVICE); if (!(connec.getActiveNetworkInfo() != null && connec.getActiveNetworkInfo().isAvailable() && connec.getActiveNetworkInfo().isConnected())) { Log.d(TAG+"Internet not aviable"); ErrorDialog.dispDialog(MainList.this, getString(R.string.internet_is_not_available), getString(R.string.eliteerp)); return false; } else { Log.d(TAG+"Internet available"); return true; } } with permission <uses-permission android:name="android.permission.INTERNET" /> <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />

First you have to know the IP address of your server (ifconfig on posix and ipconfig on windows). Lets say the IP address is 10.10.10.10. Then you can start the kernel on your server with: ipython kernel --ip=* --IPKernelApp.connection_file=/tmp/kernel.json When the kernel is started, get the content of the /tmp/kernel.json $ cat /tmp/kernel.json { "stdin_port": 59836, "ip": "*", "hb_port": 50806, "key": "11c2f53e-ad38-4d1d-b038-2f4bd04c4d49", "shell_port": 49904, "iopub_port": 55081 } On your client create a /path/to/your/kernel.json file that has the same content, except that the ip address is the real ip address, and not the *: { "stdin_port": 59836, "ip": "10.10.10.10", "hb_port": 50806, "key": "11c2f53e-ad38-4d1d-b038-2f4bd04c4d49", "shell_port": 49904,

I looked into the code for the PowerShell Cmdlet on Github (https://github.com/WindowsAzure/azure-sdk-tools) and found that to check Internet connectivity, the code makes use of InternetGetConnectedState function in WinInet.dll (Source code here: https://github.com/WindowsAzure/azure-sdk-tools/blob/master/WindowsAzurePowershell/src/Management.Utilities/Common/Validate.cs). Then I searched for why InternetGetConnectedState function would return false even though the computer is connected to the Internet, I landed on the following page: http://support.microsoft.com/kb/315035. Can you check if this is not causing the problem you're facing? Hope this helps!

Try SELECT o.CarID, o.CustomerName, o.Date 'Date Replied', o.StatusID, o.Offer FROM ( SELECT CarID, CustomerName, MAX(Date) Date FROM viewCarOffers GROUP BY CarID, CustomerName ) q JOIN viewCarOffers o ON o.CarID = q.CarID AND o.CustomerName = q.CustomerName AND q.Date = o.Date ORDER BY CarID, CustomerName Output: | CARID | CUSTOMERNAME | DATE REPLIED | STATUSID | OFFER | ------------------------------------------------------------------------ | 1 | Karl | May, 04 2013 00:00:00+0000 | 2 | $1000 | | 1 | Kathy | May, 03 2013 00:00:00+0000 | 1 | $1500 | | 2 | Karl | May, 04 2013 00:00:00+0000 | 1 | $2000 | Here is SQLFiddle demo

You may use the DateAdd function to do this, e.g.Dateadd(hour,2, @yourTime). To display the result, you can use the convert function. The convert function has many format options, so pick the one that suits your needs (I guess '0' would be ok). Example: select convert(varchar, dateadd(hour,2,myTimeColumn),0) as PlusTwoHours from myTable. Hint: Avoid formatting in SQL. I would suggest removing the convert part and do the formatting in your application (report engine, excel or whatever).

select ImageID from SearchBrain where Primarykeyword in ('Man','Jumping','Beach') group by ImageID having count(distinct Primarykeyword) = 3 (where 3 is the number of keywords)

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.

I assume you're using BULK INSERT to insert data in to temporary table or you could import it using Import Wizard in SQL Server. After that you could use below queries. Even though you've if(exist) it will update only rows that exists in both the table. So remove if else and write queries directly as shown below: update test1 set col = (#dummy.col).. from test1 inner join #dummy on (test1.companycode =#dummy.companycode and test1.folio = #dummy.companycode) For inserting records that doesn't exits in test1, you could use left join as shown below: Insert into test1 select column names from #dummy left join test1 on test1.companycode =#dummy.companycode and test1.folio = #dummy.companycode where test1.companycode is null and test1.folio is null

Use nodes operator XQuery: SELECT reportDate, T.t.value('(m/s)[1]', 'int'), T.t.value('(m/ist)[1]', 'varchar(50)'), T.t.value('(m/ino)[1]', 'int') FROM dailyReports D CROSS APPLY D.xmldata.nodes('t') T(t)