Tuesday, November 4, 2014

How to connect from VS2013 to MS SQL Server 2012

1. Using the management studio to manage the databases






2. Connection from VS 2013









Connection String:

Provider=SQLNCLI11;Data Source=FMI-431-2\SQLEXPRESS;Password=sa;User ID=sa;Initial Catalog=Users


Access connection
            aConnection = 
                new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\fmi\\Source\\Repos\\fmiedd\\111121321321_StudentStoayn\\CRUDDummyAccessConsole2b\\CRUDDummyAccessConsole2b\\data\\Users.accdb");


Tuesday, September 9, 2014

Creating bootable Linux USB pen drive with Windows software.

http://www.pendrivelinux.com/

LinuxLive USB Creator
http://www.linuxliveusb.com/

UUI
http://www.pendrivelinux.com/universal-usb-installer-easy-as-1-2-3/

!!!!!!!!!!!!!!!!!!!!!!!!!!! I was using this one !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YUMI
http://www.pendrivelinux.com/yumi-multiboot-usb-creator/
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!




























I can not boot from USB3 port when I move it to USB3 gets recognised

1) http://forums.anandtech.com/showthread.php?t=2228240


2) http://forums.scotsnewsletter.com/index.php?showtopic=66933

Very few BIOS's support booting from a USB 3 drive because there is little room for a USB 3 driver in the BIOS.  This means, also, that there is no driver loaded when the Grub2 menu appears.  Not realizing this, I purchased a couple of 64gb USB 3 flash drives with the intent of loading distros on them and freeing up space on my SSD drive.

I think I can partially solve this in Linux by installing a "minimalist" distro on the SSD and then switching to the USB 3 drive after the kernel has loaded.  I know I can do it in Mint or Ubuntu by switching after the OS has fully loaded but I'm thinking that there must be a more elegant way of doing it earlier in the boot process.  Anybody have any suggestions?

#2 OFFLINE   amenditman

    Posting Prodigy
  • Forum MVP
  • 2,426 posts
Posted 10 December 2013 - 04:28 PM
I don't understand your problem.

I have been happily booting LiveUSB distros and fully installed distros from USB 3.0 sticks for a year and a half.
I have never found a computer that would boot from USB that would not boot from the USB 3 sticks.
Ditto for USB 3 external HDDs.
Obviously, if the board only supports USB 2 I am only booting them using that but they still boot.

More information is required, perhaps there is something else going on.
Posted 10 December 2013 - 05:27 PM
View Postamenditman, on 10 December 2013 - 04:28 PM, said:
I don't understand your problem.

I have been happily booting LiveUSB distros and fully installed distros from USB 3.0 sticks for a year and a half.
I have never found a computer that would boot from USB that would not boot from the USB 3 sticks.
Ditto for USB 3 external HDDs.
Obviously, if the board only supports USB 2 I am only booting them using that but they still boot.

More information is required, perhaps there is something else going on.
You can boot USB 3 sticks all day long.  Just not from all USB 3 ports.  They'll boot from USB 2 at USB 2 speeds.  This is not true in every case.  I imagine more expensive boards may have USB 3 drivers in their BIOS but Asrock's tech supports confirmed that my MB does not.  The OS must load drivers before the USB 3 ports on the MB are functional.

Thursday, September 4, 2014

USB 3 USB 2, FireWire 800, SATA III speed comparison. My HD SATA, USB tests HDTunePro

I)

http://superuser.com/questions/138845/speed-comparison-between-usb-2-0-usb-3-0-and-sata-and-firewire
1) Which is fast, faster, fastest? I would appreciate a slowest to fastest list including USB 2.0, USB 3.0, FireWire 400, FireWire 800 and eSata.



Easy:
  • USB 1.1 = 12 Mbit/s
  • Firefire 400 = 400 Mbit/s
  • USB 2.0 = 480 Mbit/s
  • FireWire 800 = 800 Mbit/s
  • USB 3.0 = 5 Gbit/s
  • eSATA = Up to 6 Gbit/s right now as it depend on the internal SATA chip.
For the speed/throughput/bandwidth of more devices have look at this article on wikipediahttp://en.wikipedia.org/wiki/List_of_device_bit_rates#Peripheral
There you go.
You should note that these speed are theorical speed, in fact, you will never experience these speed in everyday life.

http://en.wikipedia.org/wiki/List_of_device_bit_rates#Peripheral

1.1) List of device bit rates



Peripheral[edit]


TechnologyRate (bit/s)Rate (byte/s)Year
CBM Bus[46][47]2.7 kbit/s0.34 kB/s1981
Apple Desktop Bus10.0 kbit/s1.25 kB/s1986
Serial MIDI31.25 kbit/s3.9 kB/s1983
Serial EIA-232 max.230.4 kbit/s28.8 kB/s1962
Serial DMX512A250.0 kbit/s31.25 kB/s1998
Parallel (Centronics)1 Mbit/s125 kB/s1970 (Standardised 1994)
Serial 16550 UART max.1.5 Mbit/s187.5 kB/s
USB 1.1 ("Low-Bandwidth")1.536 Mbit/s192 kB/s1996
Serial UART max2.7648 Mbit/s345.6 kB/s
GPIB/HPIB (IEEE-488.1) IEEE-488 max.8 Mbit/s1 MB/slate 1960s (Standardised 1976)
Serial EIA-422 max.10 Mbit/s1.25 MB/s
USB 1.1 ("Full-Bandwidth")12 Mbit/s1.5 MB/s1996
Parallel (Centronics) EPP 2 MHz16 Mbit/s2 MB/s1992
Serial EIA-485 max.35 Mbit/s4.375 MB/s
GPIB/HPIB (IEEE-488.1-2003) IEEE-488 max.64 Mbit/s8 MB/s
FireWire (IEEE 1394) 10098.304 Mbit/s12.288 MB/s1995
FireWire (IEEE 1394) 200196.608 Mbit/s24.576 MB/s1995
FireWire (IEEE 1394) 400393.216 Mbit/s49.152 MB/s1995
USB 2.0 ("Hi-Speed")480 Mbit/s60 MB/s2000
FireWire (IEEE 1394b) 800[48]786.432 Mbit/s98.304 MB/s2002
Fibre Channel 1 Gb SCSI1,062.5 Mbit/s100 MB/s
FireWire (IEEE 1394b) 1600[48]1.573 Gbit/s196.6 MB/s2007
Fibre Channel 2 Gb SCSI2,125 Mbit/s200 MB/s
eSATA (SATA 300)3 Gbit/s375 MB/s2004
CoaXPress Base (up and down bidirectional link)3.125 Gbit/s + 20.833 Mbit/s390 MB/s2009
FireWire (IEEE 1394b) 3200[48]3,145.7 Mbit/s393.216 MB/s2007
External PCI Express 2.0 ×14 Gbit/s500 MB/s
Fibre Channel 4 Gb SCSI4.25 Gbit/s531.25 MB/s
USB 3.0 ("SuperSpeed")5 Gbit/s625 MB/s2010
eSATA (SATA 600)6 Gbit/s750 MB/s2011
CoaXPress full (up and down bidirectional link)6.25 Gbit/s + 20.833 Mbit/s781 MB/s2009
External PCI Express 2.0 ×28 Gbit/s1,000 MB/s
USB 3.1 ("SuperSpeed+")10 Gbit/s1,250 MB/s2013
Thunderbolt10 Gbit/s × 21,250 MB/s × 22011
External PCI Express 2.0 ×416 Gbit/s2,000 MB/s
Thunderbolt 220 Gbit/s2,500 MB/s2013
External PCI Express 2.0 ×832 Gbit/s4,000 MB/s
External PCI Express 2.0 ×1664 Gbit/s8,000 MB/s
http://en.wikipedia.org/wiki/Serial_ATA#Comparison_with_other_buses

1.2) Serial ATA compared to other






-------------------------------------------------------------



Intel Thunderbolt, as per the Wikipedia Sata link just above, is 10GB/s

Also, none of these answers so far give any practical/useful information. Theoretical maximum and real-world speeds can vary wildly, and only some significant actual testing will give meaningful answers.

So far, I haven't found many such tests. There's one at Crunchgear.com:


But even this leaves some question, as perhaps their specific USB 3.0 implementation is not optimal. (we need more variety to be sure, and even then, your system (or any given system) may not produce comparable benchmarks)

Another seems to suggest USB 3.0 "Turbo" (whatever that is?) has a bit over eSATA, at sansdigital.com:


But I have to question that, suggesting ~200 MB/s hard drive read/write speeds - unless hard drives have dramatically improved recently, I don't believe those speeds are physically possible, and suspect those speeds are just cached.

It's probably relatively safe to go with eSATA or USB 3.0 and get speeds that are close to optimal... as long as there's nothing choking your chain, so to speak. (poorly designed or cheap component, etc., causing a bottleneck) We really need more real world comparisons with various different hardware components.



http://techcrunch.com/2010/02/05/esata-is-faster-than-usb-3-0-at-least-right-now/

1.3) eSATA is faster than USB 3.0 — at least right now


Testing parameters: These numbers were gathered using HD Tune Pro 4.01. I also timed an 8.34 GB file transfer onto the drive for real world results. The two external drives were 7200 RPM models, while the internal was a 5400 RPM drive. I would have liked to show the Western Digital MyBook 3.0’s results as well, but the drive and HD Tune Pro didn’t get along. Check out the review for a comparison between the SeagatePS110 — it’s just slightly faster.






But if you’re looking for a reliable and fast external hard drive right now, forget USB 3.0 and instead look at eSATA drives.


-------------------------------------------------------------------------------------------------


sms.bg


My Tests on computer Ani 

















































































On the ns2




















Ina comp







ns2 with USB3 JetFlash Transcend but connected to USB2
OPEN CASE. The temp was very high before.
THE REASIN IS NOT WORKING FAN ON THE POWER SUPLY!!!!
When you touch it with hand you can feel it hot.












Connected to USB3 on ns2





 again test on ns2 with open case

ns2 open case Transcent Read Boost Enabled





Ani comp USB3 Transcend 32GB connected to USB2 front panel



Canada RAID

The very same USB2 JetFlash Transcend 32GB za 30BGN on the Ina computer


The very same USB 2 Flash Kingston 4GB password on the Ina comp

The very same USB2 JetFlash Transcend 32GB for 30BGN on ns2 comp

The speed of the computer is also very important. USB goes trough the CPU.
The very same USB3 JetFlash Transcend 32GB for 30BGN attached to USB2 port on Ina comp after adding 4 Live Linux distributions




The very same USB3 JetFlash Transcend 32GB for 30BGN attached to USB2 port on the fastest ns2 comp after adding 4 Live Linux distributions


The very same USB3 JetFlash Transcend 32GB for 30BGN attached to USB3 port on the fastest ns2 comp after adding 4 Live Linux distributions



The speed of the USB device depends on the computer also. The very same Corsar but with slower Ina computer. The speed is ~20MB/s now:





USB 1.1 = 12 Mbit/s
FireWire 400 = 400 Mbit/s
USB 2.0 = 480 Mbit/s
FireWire 800 = 800 Mbit/s
USB 3.0 = 5 Gbit/s
eSATA = Up to 6 Gbit/s right now as it depend on the internal SATA chip.

Ani comp 
SATA 2 old HDD - 76.1 MB/s  - 40C
SATA 3 1TB brind new - 167.1 - 36C
USB 2 Flash Kingston 4GB password - 14.9
USB 2 Flash Corsar 16GB - 28.3
USB 2 Maxell 4GB - 11.9
USB 2 Flash Kingston 8GB  - 20.0 - 41C
USB 2 Flash Kingston 32GB - 20.1
USB 2 1TB Seagate Free Agent external HDD - 29.4 - 26C
USB2 JetFlash Transcend 32GB za 30BGN - 29.7

ns2
SATA 3 1TB brind new - 158.6 - 49C
SATA 3 1TB old one for the Datacenter formatted partitioned - 98.3 - 50C
USB2 JetFlash Transcend 32GB za 30BGN read Boost disabled - 26.7
USB3 JetFlash Transcend 32GB za 30BGN Read Boost disabled - 80.7
USB3 JetFlash Transcend 32GB za 30BGN Read Boost enabled - 80.7

Ina
SATA 2 Ina 80GB - 49.8 - 44C
USB2 JetFlash Transcend 32GB za 30BGN read Boost disabled - 17.3
USB 2 Flash Kingston 4GB password - 11.3

Canada RAID
2 Seagate Baracuda 120Gb HDDs fake RAID - 44.6


USB 1.1 = 12 Mbit/s => 12*1024*1024/(8*1024*1024) = 12/8 = 1.5MB/s
or 12*1000*1000/(8*1024*1024) = 1.430511474609375 MB/s
FireWire 400 = 400 Mbit/s => 400/8 = 50MB/s
USB 2.0 = 480 Mbit/s => 480/8=60MB/s
FireWire 800 = 800 Mbit/s => 800/8=100MB/s
USB 3.0 = 5 Gbit/s => 5/8 = 0.625 GB/s

eSATA = Up to 6 Gbit/s right now as it depend on the internal SATA chip. => 6/8 = 0.75GB/s

Conclusion:
1) The ordinary USB2 flash drives have read speed of ~20MB/s
2) Special and more expensive USB2 flash drive models Corsar and USB2 external HDD. Also the Ordinary USB3 Flash drives connected to USB2 ports ~30MB/s
3) Internal SATA drives ~ 160 MB/s

The best is to buy a cheap USB3 Flash Drive. Even connected to USB2 port the performance still will be around 30MB/s

*Computers used for the tests:

Ina:

ns2
Motherboard: M4A88TD-M EVO/USB3