Connecting to Microsoft Access with Perl using Win32::ODBC

Just a short example.

require 5.004;

use POSIX qw(locale_h);
setlocale(LC_ALL, "russian");

use Win32::ODBC;

$ODBCUserDSN = 'AccessODBCTest';

$db = new Win32::ODBC($ODBCUserDSN)
  || die "Error opening ODBC \"$ODBCUserDSN\"\n";

$stmt = "SELECT table2.field1, table2.field2, table1.field3
  FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1;";

$rc = $db->Sql($stmt);
die qq(SQL failed "$stmt": ), $db->Error(), qq(\n) if $rc;

while ($db->FetchRow())
{
  ($A1, $A2, $A3) = $db->Data();#("field1", "field2", "field3");
  print "$A1, $A2, $A3\n";
} # while

$db->Close();

exit;

iPhone 3G RMAA test report.

iPhone 3G RMAA audio test.

iPhone 3G

Testing chain: iPhone 3G (16-bit, 44.1 kHz AIFF file playback) -> SBLive!24 line-in (24-bit, 48 kHz).
Frequency response (from 40 Hz to 15 kHz), dB : +0.02, -0.15
Noise level, dB (A) : -92.4
Dynamic range, dB (A) : 92.3
THD, % : 0.0024
THD + Noise, dB (A) : -81.3
IMD + Noise, % : 0.012
Stereo crosstalk, dB : -88.1
IMD at 10 kHz, % : 0.011

Testing chain: iPhone 3G with 16 Ohm load (16-bit, 44.1 kHz AIFF file playback) -> SBLive!24 line-in (24-bit, 48 kHz).
Frequency response (from 40 Hz to 15 kHz), dB : +0.15, -2.09
Noise level, dB (A) : -93.0
Dynamic range, dB (A) : 92.9
THD, % : 0.027
THD + Noise, dB (A) : -69.9
IMD + Noise, % : 0.047
Stereo crosstalk, dB : -67.6
IMD at 10 kHz, % : 0.074

Frequency response

Noise level

Dynamic range

THD + Noise (at -3 dB FS)

Intermodulation distortion

Stereo crosstalk

IMD (swept tones)

MP3 player Explay X1 (ATJ3310) RMAA test report.

RMAA - RightMark Audio Analyzer.
ATJ3310 - Actions Semiconductor multimedia IC

Explay X1

Explay X1 audio tests below...

Testing chain: Explay X1 (16-bit, 44.1 kHz WAV file playback) -> SBLive!24 line-in (24-bit, 48 kHz).
Frequency response (from 40 Hz to 15 kHz), dB : +0.05, -0.28
Noise level, dB (A) : -91.2
Dynamic range, dB (A) : 91.2
THD, % : 0.0027
THD + Noise, dB (A) : -82.0
IMD + Noise, % : 0.010
Stereo crosstalk, dB : -89.1
IMD at 10 kHz, % : 0.0096

Testing chain: Explay X1 with 16 Ohm load (16-bit, 44.1 kHz WAV file playback) -> SBLive!24 line-in (24-bit, 48 kHz).
Frequency response (from 40 Hz to 15 kHz), dB : +0.05, -0.29
Noise level, dB (A) : -91.8
Dynamic range, dB (A) : 91.7
THD, % : 0.0045
THD + Noise, dB (A) : -80.0
IMD + Noise, % : 0.013
Stereo crosstalk, dB : -66.5
IMD at 10 kHz, % : 0.023

Frequency response

Noise level

Dynamic range

THD + Noise (at -3 dB FS)

Intermodulation distortion

IMD (swept tones)

MEIER-AUDIO CORDA ARIETTA headphone amplifier RMAA test report.

MEIER-AUDIO CORDA ARIETTA headamp audio test by RightMark Audio Analyzer (RMAA).

CORDA ARIETTA

See more recent tests here.

Testing chain: SBLive!24 line-out (24-bit, 48 kHz) -> ARIETTA -> SBLive!24 line-in (24-bit, 48 kHz).
Frequency response (from 40 Hz to 15 kHz), dB : +0.01, -0.07
Noise level, dB (A) : -94.9
Dynamic range, dB (A) : 94.9
THD, % : 0.0016
THD + Noise, dB (A) : -87.3
IMD + Noise, % : 0.0055
Stereo crosstalk, dB : -89.6
IMD at 10 kHz, % : 0.0056

Testing chain: SBLive!24 line-out (24-bit, 48 kHz) -> ARIETTA (with 16 Ohm load) -> SBLive!24 line-in (24-bit, 48 kHz).
Frequency response (from 40 Hz to 15 kHz), dB : +0.01, -0.09
Noise level, dB (A) : -94.9
Dynamic range, dB (A) : 95.1
THD, % : 0.0066
THD + Noise, dB (A) : -82.0
IMD + Noise, % : 0.010
Stereo crosstalk, dB : -54.7
IMD at 10 kHz, % : 0.015

Frequency response

Noise level

Dynamic range

THD + Noise (at -3 dB FS)

Intermodulation distortion

Stereo crosstalk

IMD (swept tones)

Creative Sound Blaster Live! 24-bit RMAA test report.

Creative Sound Blaster Live! 24-bit audio test by RightMark Audio Analyzer (RMAA).

iXBT.com review

Testing chain: line output (24-bit, 48 kHz) -> line input (24-bit, 48 kHz).
Frequency response (from 40 Hz to 15 kHz), dB : +0.01, -0.05
Noise level, dB (A) : -100.8
Dynamic range, dB (A) : 100.9
THD, % : 0.0012
THD + Noise, dB (A) : -92.3
IMD + Noise, % : 0.0029
Stereo crosstalk, dB : -98.8
IMD at 10 kHz, % : 0.0039

Frequency response

Noise level

Dynamic range

THD + Noise (at -3 dB FS)

Intermodulation distortion

Stereo crosstalk

IMD (swept tones)

CentOS 5.6 tuning.

# yum update
# yum list installed
# yum remove GConf2.x86_64
# yum remove kernel-2.6.18-238.el5
# yum remove NetworkManager NetworkManager NetworkManager-glib NetworkManager-glib
# yum remove ...

# yum install ntp.x86_64
# vi /etc/ntp.conf
(edit)> server <X.X.X.X>
# vi /etc/sysconfig/ntpd
(edit)> SYNC_HWCLOCK=yes

# chkconfig --level 3 ntpd on
# service ntpd start

# adduser -c "<User Name>" -m -u 1001 -g users -G wheel <login>
# passwd <login>

# cd /home/<User Name>
# vi .bash_profile
(edit)> PATH=$PATH:/sbin:/usr/sbin:$HOME/bin

# vi /etc/aliases
(add)> root: <login>
(add)> <login>: <user@domain>
# newaliases

# vi /etc/sysconfig/iptables
(add)> -A RH-Firewall-1-INPUT -m state --state NEW -s <X.X.X.X>/<X> -m tcp -p tcp --dport 22 -j ACCEPT
# service iptables restart
# service ntpd restart

# vi /etc/sysconfig/network
(add)> FORWARD_IPV4=no
(del)> GATEWAY=<X.X.X.X>
# vi /etc/sysconfig/network-scripts/ifcfg-eth0
(add)> GATEWAY=<X.X.X.X>
# service network restart

# vi /etc/pam.d/su
(uncoment)> auth            required        pam_wheel.so use_uid

# vi /etc/sudoers
(uncoment)> %wheel        ALL=(ALL)       ALL

# vi /etc/ssh/sshd_config
(edit)> PermitRootLogin no
(edit)> AllowTcpForwarding no
(edit)> X11Forwarding no
# kill -HUP `cat /var/run/sshd.pid`

...