“Library not registered” – QuickBooks Point of Sale 9.0

June 28th, 2010  / Author: Greg Pinero (Primary Searcher)

I started getting this error a few days after upgrading to QBPOS v9.0 when trying to print a sales receipt.

It seemed to fix the issue to backup Point of Sale, uninstall it with add/remove programs, and reinstall POS.

Resources:
http://community.intuit.com/posts/library-not-registered-3
http://community.intuit.com/posts/library-not-registered-error-when-using-pos-90
http://community.intuit.com/posts/library-not-registered-2

Mini Searches with Answers

June 26th, 2010  / Author: Greg Pinero (Primary Searcher)

These are links associated with recent searches I’ve done. They’re not difficult enough to warrant to their own posts but still super useful.

Reporting Services – table sum problem : reporting, services, sum
How to add a grand total to a SSRS report to a column that has duplicate values. Write a custom code function to do it. See comments by PFrog. (sorry it's experts exchange)

PyWin32 Documentation
Actual documentation for the PyWin32 package

Do Vultures Eat Vultures?
Do vultures eat dead vultures? The internet doesn't seem to know, but these folks say no.

‘xp_cmdshell’ does not exist??
In order to configure xp_cmdshell, first need to enable the advanced options and then only all the advanced configuration options works out.

It can be done as follows:

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

EXEC sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO

Refer http://msdn.microsoft.com/en-us/library/ms189631.aspx for more options.

“Access is denied” error message when you run a batch job on a Windows Server 2003-based computer
How to make SSIS call a batch file. I used method 1: Grant the Cmd.exe program Read and Execute permissions for the user account that the batch job runs under.

Method 2 didn't seem to help.

Tags: , , , , , , , , , , ,

SSIS – How to Export a Flat File with New Lines

June 21st, 2010  / Author: Greg Pinero (Primary Searcher)

I tried making a flat file in SQL Server Integration Services but SSIS decided to put all of the output on one line. I couldn’t figure out a way to get it to make one line per record using a fixed width file type.

Finally what I ended up doing was creating a ragged right file, and making a dummy field with 0 width as the last field. You see, ragged right format works perfectly for exporting fixed width flat files with one record per line except that it trims the trailing spaces after that last field.

So making a dummy 0 width field lets you keep all of the trailing spaces in the last field you care about but still lets SSIS do its thing to add carriage returns/line breaks.

Source

Fixing SSRS Error: ‘/’ is an unexpected token. The expected token is ‘=’. Line 9, position 33.

June 21st, 2010  / Author: Greg Pinero (Primary Searcher)

So I got this error when running a report in SQL Server Reporting Services that takes several minutes to run:

'/' is an unexpected token. The expected token is '='. Line 9, position 33.

It turns out you just have to go to the web config file in C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer and change the timeout value to something high enough.

(Be sure to back up your web config file before editing it.)

Source

Hiking and Getting to the Middle Patuxent Environmental Area

June 5th, 2010  / Author: Greg Pinero (Primary Searcher)

This is nice park in Howard county with hiking trails.

The address for parking for the Southwind Trail Interpretive Nature Walk mentioned on the link above should be around the 6500 block of South Wind Circle, Columbia, MD. At least that’s where the virtual tour indicates.

There are directions to the general park here. Maybe that’s the main entrance? I think it’s indicating somewhere around 5800 Trotter Road, Clarksville, MD but on the left side?