Windows was unable to connect to this network
Solution 1
Sorry for my stupidity. It was just a wrong security key - windows didn't report that it was incorrect but silently failed the connection. When I tried the same on Mac OS, it has reported the error correctly.
In details that is how it worked for me:
- Right click on the network icon in the tray and select
Open Network and Sharing Center
- Select
Manage wireless networks
on the left - Click
Add
in the toolbar - Select
Manually create a network profile
- Type SSID (name) of your network
- Select security and encryption type (if the combination you selected won't work - you can change it later)
- Type into your security key (make sure it's correct).
- Click
Next
andClose
Now click once on the tray icon and see if the connection is shown with red cross next to it. Typically that means that you have selected the wrong security/encryption type at step 6. Just right click the connection and select Properties
. There at Security
tab you can change security and encryption types. Try different combinations until you'll get rid of the red cross. Then just click on the connection and select Connect
. It should work now.
Good luck!
P.S. If there is a demand to show this in pictures - please write in comments and I'll create screenshots.
Solution 2
Is there an open unsecured wireless network within range that windows might latch onto? I've had systems grab my neighbor's unsecured (stock!) netgear unit which is just barely in range... it thinks 'free wireless!!', but it can't talk to the router to negotiate the connection.
Sounds stupid, but this is one of those 'phase of the moon' type things... try rebooting the router. Just unplug it, count to ten in Swahili, then plug it back in.... Mine does this occasionally where it doesn't want to talk to anyone new. Yes, your Mac side of Bootcamp can connect, but Windows has a different 'flavor' to the router. (hopefully, that made sense)
Just point to a corner of the apartment... yell loudly "Look! It's Elvis/Stalin/E.T./StayPuft Man!!!" And while they're gawking, reboot the router...
Honest... it works. (the reboot, AND the Look! thing...)
Related videos on Youtube
coderwill
Updated on September 18, 2022Comments
-
coderwill over 1 year
Hello i am trying the getting result in xml format in the sql server but i don't get propare xml format many data it's repeat in xml format. i have write this query in the sql server but not a getting propare data. any one know where is my mistake then please let me know how can do that.
Here i have write this query :
select * from ( SELECT SSCF.SubSubCategoryId AS InterestId,c.FeedId,c.Description,u.UserId,u.Email,u.UserName,u.ProfileImage,u.Name, ISNULL(SSCL.SubSubCategory,SSC.SubSubCategory) AS Interest, 1 AS [Type] FROM SubSubCategoryFollowers SSCF LEFT JOIN SubSubCategories SSC ON SSCF.SubSubCategoryId = SSC.SubSubCategoryId INNER JOIN Feed c on c.FeedId = SSC.FeedId inner join Users u on u.UserId = SSCF.UserId WHERE u.Email is not null UNION ALL SELECT SCF.SubCategoryId AS InterestId,c.FeedId,c.Description,u.UserId,u.Email,u.UserName,u.ProfileImage,u.Name, ISNULL(SCL.SubCategory,SC.SubCategory) AS Interest, 2 AS [Type] FROM SubCategoryFollowers SCF LEFT JOIN SubCategories SC ON SCF.SubCategoryId = SC.SubCategoryId INNER JOIN Feed c on c.FeedId = SC.FeedId inner join Users u on u.UserId = SCF.UserId WHERE u.Email is not null )as res group by res.UserId,res.InterestId,res.FeedId,res.Description,res.Email,res.Interest,res.Type,res.UserName,res.ProfileImage,res.Name order by res.FeedId OFFSET 1 ROWS FETCH NEXT 50000 ROWS ONLY FOR XML PATH('User'), ROOT ('Users')
this is my current op =>
<Users> <User> <UserId>1660</UserId> <Email>xyz.com</Email> <UserName>xyz</UserName> <ProfileImage>20160717035320958.jpeg</ProfileImage> <InterestId>15</InterestId> <FeedId>4689</FeedId> <Description>Test</Description> <Interest>Event</Interest> <Type>2</Type> </User> <User> <UserId>1660</UserId> <Email>xyz.com</Email> <UserName>xyz</UserName> <ProfileImage>20160717035320958.jpeg</ProfileImage> <InterestId>16</InterestId> <FeedId>4689</FeedId> <Description>Test</Description> <Interest>Party</Interest> <Type>2</Type> </User> <User> <UserId>1660</UserId> <Email>xyz.com</Email> <UserName>xyz</UserName> <ProfileImage>20160717035320958.jpeg</ProfileImage> <InterestId>21</InterestId> <FeedId>4689</FeedId> <Description>Test</Description> <Interest>Club</Interest> <Type>2</Type> </User> <User> <UserId>1661</UserId> <Email>abc.com</Email> <UserName>abc</UserName> <ProfileImage>20160717035320959.jpeg</ProfileImage> <InterestId>15</InterestId> <FeedId>4690</FeedId> <Description>Test1</Description> <Interest>Cricket</Interest> <Type>1</Type>
My expected o/p =>
<Users> <User> <UserId>1660</UserId> <Email>xyz.com</Email> <UserName>xyz</UserName> <ProfileImage>20160717035320958.jpeg</ProfileImage> <InterestId>15</InterestId> <FeedId>4689</FeedId> <Description>Test</Description> <Interest>Event</Interest> <Type>2</Type> <InterestId>16</InterestId> <FeedId>4689</FeedId> <Description>Test</Description> <Interest>Party</Interest> <Type>2</Type> <InterestId>21</InterestId> <FeedId>4689</FeedId> <Description>Test</Description> <Interest>Club</Interest> <Type>2</Type> </User> <User> <UserId>1661</UserId> <Email>abc.com</Email> <UserName>abc</UserName> <ProfileImage>20160717035320959.jpeg</ProfileImage> <InterestId>15</InterestId> <FeedId>4690</FeedId> <Description>Test1</Description> <Interest>Cricket</Interest> <Type>1</Type>
i want like this data in xml format any one know please let me know.
-
Logman almost 12 yearsdoes the network connection between Win7 and your Mac work fine? Can ping each other? Share? etc... and will it work "wired"?
-
user1222303 almost 12 yearsBoth Win7 and Mac are installed on the same computer, so there can't be any connection between them as they can't be booted at the same time. I couldn't try it wired since I didn't have a cable, but I have found a solution to the problem (see below).
-
iamdave almost 7 yearsWhat is the result of your query as is and how is it different to your desired output?
-
coderwill almost 7 yearsright now in i have repeat this data as well like UserId is repeat all the data is repeat so i need the stop this repeat data
-
coderwill almost 7 years@iamdave can i post my current op so you can easy to understand?
-
iamdave almost 7 yearsYes, please add your current output to your question.
-
coderwill almost 7 years@iamdave i have edit my question you can check this and please help me on that.
-
iamdave almost 7 yearsAs far as I am aware that is how XML works? Is your current output giving you any actual problems with wherever you are using the generated XML?
-
coderwill almost 7 years@iamdave so can you please let me know where is my mistake in the query?
-
iamdave almost 7 yearsWhy do you think there is a mistake? Is your XML file not working when uploaded/processed in another application?
-
Jayvee almost 7 yearstry SSCF.SubSubCategoryId AS InterestId AS "User/InterestId"
-
coderwill almost 7 years@Jayvee can you please give me the new post as a answer so i can easy to understand
-
Jayvee almost 7 years@coderwill will do in a few minutes.
-
coderwill almost 7 yearsguys any one know how can do that this task
-
-
user1222303 almost 12 yearsNice approach to rebooting a router (Look! thing) :)
-
alpha almost 12 yearsYeah, Windows is weird that way... mistype the key... it SAYS it's connected, but it LIES!!! LIES!!! Mac, Linux, Android, they all say "Bad Key, Try again"... But Windows LIES! I'm glad you figured it out. Of course, admitting that you fat-fingered the key is a good thing. Good for your soul, or karma, or such. We'll laugh, but it's a sympathetic laugh, because we've ALL done it. Of course, no one mentioned the possibility of mistyping the key... because would be like calling you stupid in public. Wouldn't want to do that, that's mean. Glad you got it working.
-
bwDraco over 11 yearsI don't see how this would plausibly be the cause of the problem.
-
coderwill almost 7 yearsTriv with my query how can do that in query i can used union also so
-
coderwill almost 7 yearscan you please give me with my query your answer so it's very use full for me this solution it's also 100% good but i can't modify with my query so please can you more one help
-
TriV almost 7 yearsYou should try yourself. I think it's not so hard to map my answer with your code.... :)
-
coderwill almost 7 yearsi am getting this error The FOR XML clause is invalid in views, inline functions, derived tables, and subqueries when they contain a set operator. To work around, wrap the SELECT containing a set operator using derived table syntax and apply FOR XML on top of it.
-
coderwill almost 7 yearsHello triv i am trying to add your solution with my query and i am get result also but pagination is not working so any idea?