Saturday, November 19, 2005

Linux ethernet bonding

I asserted that you could potentially bond like 5 network cards in a single system. On Linux with the default kernel drivers this is not possible, however, you can bond two cards. Very similar to the compaq servers that I used to work with back in the day that supported "teaming" .

More information can be found in the bonding.txt readme in the kernel distribution or at This web site. The offical proejct web site On Sourceforge.net.

How to determine MDAC version

I had an instance recently where I needed to detemrine the version of MDAC on a computer without needing to download additional software.

I found Microsoft KB 301202


The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer

Thursday, November 10, 2005

Setting up MSDE 2000a

Sunday, November 06, 2005

Information on doing KDE in cygwin

Information on doing kde on cygwin can be found at:

http://cygnome.sourceforge.net/
http://webdev.cegit.de/snapshots/kde-cygwin/kde/kde3.4/

302 errors with perl-lwp

With perl LWP you are trying to write a thing that will allow you to scape a site that
makes use of post and then puts throws a 302 at you in an effort to stop scapers?

my $ua = LWP::UserAgent->new();

push @{ $ua->requests_redirectable }, 'POST';

would do the trick

connecting to oracle from the command line

how do I connect to oracle from the command line?
sqlplus /nolog
connect [user]/[table] as [user]

Oracle: Lost the system password

I lost the system password, however, I stil had the sys password how do I go back and change it
authenticate to the system as user sys

alter user IDENTIFIED BY
for more info see orafaq.com

Oracle ORA-12154

I found that tnsnames.ora is a lot like the DSN configuration in windows and some software that I was installing didn't update the tnsnames.ora and as a result the it couldn't connect to the database.

A html to ascii conversion utility

Recently I was hurting as I needed a program that could transform HTML to ascii text. My web search ended with html2text This porgram works on Linux. Its good stuff and its interesting how HTML tables become ascii tables.

Whats old becomes new again SMP becomes Dual Core

The media has been making a lot of fuss over dual core as of late. When I stopped to think about it for a minute I recounted a remark made by a friend when two of my collegues were discussing USB keyfobs and with all that capacity someone could walk away with large amounts of proprietary data. To which he said "This is the same discussion that we had over floppies 10 years ago." As I was reading http://reviews.zdnet.co.uk/hardware/processorsmemory/0,39024015,39233885,00.htm which I pulled off Slashdot I started to think about the reviews and comments that were made about dual CPU machines 10 years ago and how the arguments that were made then are some of the same that are made today.

Pros regarding
Performance
Productivity etc...


Cons regarding
Heat
That only a small number of applications were optimized to take advantage of such processing power.

I have to admit to not giving a whole lot of attention to the whole dual core movement but other than the fore mentioned pros and cons and the potential ability to make Columbia a 20,480 processor system (better processor clustering) is there some significant benefit that I'm missing here?

How do you a password of a user in MSDE

So I forgot the SA password and so I need to login to SQL server as to change the password for the SA account how do I go about doing that?

Answer:
That actually is pretty easy. On the system that has the SQL server login using osql -E.

Then make use of the following stored procedure:
1> sp_password @old = null, @new = 'complexpwd', @loginame ='sa'
2>go;

How do you determine MSDE authentication type

I had a question about a setup of MSDE as to what kind of authentication type an MSDE install had. I trolled through a bunch of Microsoft Support Knowledge base articles until I found This one regarding MSDE security.

Its interesting that the configuration is in the registry rather than in SQL server itself. Take a look at HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode and if you installed MSDE as a named instance then it would be HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name \MSSQLServer\LoginMode.

The values possible for this key are 1 for Windows Authentication only, 2 for mixed mode and prob 0 for SQL server auth only.

Windows LDD

I had been looking for this for a while. I was trying to move a binary in this case osql between two systems and I wanted to identify if there were any .dll files that I needed to copy with the binary. A search yeilded dependency walker freeware that can obtained from Dependency Walker.
It builds a hierarchical tree and it works only like every version of windows that Microsoft has produced.