Saturday, 16 August 2014

skype webcam fix workaround for vista and windows xp | How to use most of the older skype versions

UPDATE: after writing (spamming?) a few links about this solution skype have changed the informations on the back of the main windows on older version informing that they will be retired.

After that you've already updated, for sure, your O.S. and the drivers of your webcam install the latest version of skype .... probably you already have it installed since you are facing that problem.

Login  with your account and make sure to -check- to remember the password so that skype locally saves the credentials (Credentials3 in the latest version).

Downloard this zip and uncompress the file (skypeb.exe) it in the skype folder

create a link on the desktop and just start it when needed.

Check your preferences and the webcam should be there with the older version of skype that should not prompt to update (since we automatically login).
Disable the automatic updates.

I prefer this way so that even if it automatically updates everything should work as before.

I've found this solution after struggling for hours with registry keys and executable deobfuscation ... without a damn result.

Fix How to use most of the older skype versions:

Just follow the above procedures.
The credentials (the stored *password*) are located in %appdata%\skype\yourusername\config.xml. Save the config file
Uninstall the newly installed skype.
Install your preferred version.
Overwrite the config file with the saved one .... or leave it as is.

More info

TIPs for who is interested into doing a real fix ... maybe a way to show the webcam
Just for your information.... the last version that I've used checks this registry key (maybe for the webcam.

password hash encryption. I've tried to create a sort of pre login but I suppose that is time wasted since skype is gonna change things ... in worse.

Friday, 15 August 2014

Restore the default security settings on windows

 Windows XP
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb /verbose
Windows Vista, 7
secedit /configure /cfg %windir%\inf\defltbase.inf /db defltbase.sdb /verbose

I've not tested the commands on windows 8 and 8.1 but they should work.

USB 2.0 Webcam usb\vid_1e4e&pid_0102&rev_0002 drivers

This is an easy task but I've wasted a lot of time to find it out (ok, I'm not smart guy .... )

right-click on "My Computer" and select "Properties".
Select the "Device Manager" tab.
Click on Device Manager in the left pane.
Select your device (the "usb 2.0 webcam" with the question mark).
right-click and select "Update Driver".
This will launch an update Wizard.
Choose to install from the local computer (not from the path).
Select the "manual" installation.
Manually select  "composite usb device" that should be listed in the compatible drivers.

You can use most of the applications for webcams. The one that is working for sure with this device is "cyberlink youcam".
 If the webcam doesn't show up immediately you need to go in the options and select the device.

A very easy thing that have wasted the whole morning (I'm still trying to fix skype to work with HP integrated webcam and this webcam .... damn)

usb\vid_1e4e&pid_0102&rev_0002 drivers
usb\vid_1e4e&pid_0102&rev_001 drivers
usb\vid_1e4e&pid_0102 drivers

USB 2.0 WebcamWebcam cinese

driver windows vista webcam
driver windows 7 webcam
Composite webcam drivers windows 7

Sunday, 3 August 2014

Date error with MySQL and .NET

Date error with MySQL and .NET

Sample query to retrieve a date from mysql and use it directly with a dataset, datatable, datagridview.
Select DATE_FORMAT(mysqldatecolumn, '%Y-%m-%d' )  from mytable

To convert the date in .net
Datetime.Now().ToString("yyyy/MM/dd hh:mm:ss")

when we wan to retrieve and add the date in the db.

A workaround in mysql is to set those vars for the session. It's not suggested and sometimes the variables are read only.
SET SESSION date_format="%Y/%m/%d";
SET SESSION datetime_format="%Y/%m/%d %H:%i:%s";

Mysql Exception MySql.Data.Types.MySqlConversionException' in MySql.Data.dll

Note: Info are a bit messed up

Twitter Delicious Facebook Digg Stumbleupon Favorites More