Scenario: I wanted to connect to an SQL server 2008 from a FreeBSD 8.2 machine using PHP5.3 and FreeTDS. We have a similar set up on another server running FreeBSD 7.2 with PHP 5.2 . This is still running in production and connecting to the same DB server successfully. The logical thing to do was Read More…
Category: Windows
Cannot telnet locally to MSSQL Port 1433 (2005 Standard Edition)
OS: Windows 2008 R2, SQL 2005 Standard Edition, vCenter 5.0 Scenario: I was upgrading from vCenter 5.0 to vCenter 5.1a. The SSO installation failed as it could not connect to the local SQL database. Caveat: I had upgraded from SQL2005 Express to standard on the same server as our vCenter inventory had grown too big Read More…
Creating a 32bit DSN for Windows 64bit
Scenario: I needed to re-create a 32 bit DSN as I was moving a VMware Update Manager database from SQL 2005 Express bundled to SQL 2008 R2 Standard on a standalone machine. To invoke the 32 bit DSN go to the following in Windows Explorer or Run box: %systemdrive%\Windows\SysWoW64\Odbcad32.exe
Enabling SNMP in Windows 2008
First of all you may need to add the “feature” from Server Manager Now go to Services (in Administrative Tools) Right click the SNMP Service and select properties . Go to the Security tab Edit the settings to your needs. In this case I have allowed the host 172.17.19.100 access to this host and kept the Community name as the default public Read More…
There isn’t enough disk space or memory when trying to update a table
OS: Windows 7 Software: MS Access 2003 When trying to change the column in MS Accees 2003 from Currency to Number we received the error : “There isn’t enough disk space or memory” Looking in the table there are 350, 000 records – which makes sense. To fix this we need to edit the registry. Go Read More…
MS Access displaying NULL values in currency column after upsizing to SQL 2008
Software: MS Access 2003 / MS SQL 2008 After upsizing a database, a currency column in a particular table was completely empty via the Access application. However, when viewing the table in SQL 2008, the values are present in “money” format. Suggested workarounds didn’t really fit for us (eg changing the workstations to English US Read More…
Connecting to a share on Linux via Windows 2003 (SP1) NFS Client
Scenario: We have an NFS share on a Centos 6.x server – which other Linux machines use for a data repository. A requirement arose in the network to use a Windows 2003 to server to connect to this share. I believe Windows 2003 SP2 and 2008+ all ship with the NFS Client (although you may Read More…
You must use the dbSeeChanges option with OpenRecordset when accessing a SQL server table that has an IDENTITY column
We just upgraded an internal MS Access 2003 DB to use MS SQL 2008 (in linked server table format) and immediately got the error listed in the title (and pictured below) The debug option gave the following line as the problem: Set rs = db.OpenRecordset(sql) I tried Set rs = db.OpenRecordset(sql, dbSeeChanges) but just Read More…
Searching using the command prompt in MS DOS
Useful command in DOS for searching within a directory : findstr /spin /d:\dir1\dir2\ “searchstring” Note: Flags: /s : Searches for matching files in the current directory and all subdirectories. /p : Skips files with non-printable characters /i : Specifies that the search is not to be case-sensitive. /n : Prints the line number before each line that matches.
BOOTMGR is Missing – Press CTRL+ALT+DEL to Restart
Yep. Your Windows 2008 R2 server wont boot. This is quite common if you mistakenly make your C: partition active when no bootmgr is on this volume. Steps to fix are: 1) Insert Windows 2008 disk and boot from DVD/CD drive. 2) Follow the Install guide -> Select the Repair option -> Click Next 3) Read More…
You must be logged in to post a comment.