Skip to main content


Showing posts from 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 everythi…

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 h…

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
convert.ToDateTime(MyVariableWithDate).ToString("yyyy-MM-dd") 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