Psychology Technology

This came about because of some hard-coded row limits on a SQL database.

Luckily, all of the code was encapsulated in SQL a view before hitting the VB application.  This meant that we were able to limit the issue by truncating down to the first x rows.  Once this was done on the view (which the vb app called), the application then no longer had the Runtime Error 9 message.

while creating a test environment, I found that Project Server 2007 was giving me a difficult time, with errors that were not altogether very helpful, at least for my limited experience of Analysis Services and Cube Building.

Such things as:

Error: Cannot connect to the repository.

No process is on the other end of the pipe.

Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid.

Frustratingly, none of the above links helped solve my problem (though they are informational).  What seemed to me to just need to create the Repository database after setting up the DSO information, was more than that.  I needed to created the olapobjects table with the correct schema.  That’s where this MS article comes to the rescue.  after creating the necessary table structure here for my SQL 2005 Repository db, my cubes now successfully build.

I missed that fantastic push on the euro at 4pm.  Hohum that’s what happens when you don’t watch your charts!  I’m still cautious on any movement being pre-emptive to the long-term trend and FOMC minutes.  There was an easy 30-50 pips on the 15 minute charts to be had, hopefully you were one of ‘em.

Accessibility Options
 access.cpl

Add/Remove Programs
 appwiz.cpl

Add Hardware Wizard
 hdwwiz.cpl

Automatic Updates
 wuaucpl.cpl
 
Bluetooth Properties
 bthprops.cpl
 
Display Properties
 desk.cpl
 
Firewall Properties
 firewall.cpl
 
Game Controllers
 joy.cpl
 
Internet Options
 inetcpl.cpl

iSCSI Initiator
 iscsicpl.cpl
 
Java Control Panel
 jpicpl32.cpl
  
Licensing Mode
 liccpa.cpl
 
Mouse Properties
 main.cpl
 
Network Connections
 ncpa.cpl

Network Setup Wizard
 netsetup.cpl
 
ODBC Properties
 odbccp32.cpl
 
Power Options
 powercfg.cpl
 
Regional and Language Options
 intl.cpl
 
Sound and Audio Devices
 mmsys.cpl

Stored Passwords
 keymgr.cpl

System Properties
 sysdm.cpl
 
Telephone and Modem Properties
 telephon.cpl

Time and Date Settings
 timedate.cpl
 
User Accounts nusrmgr.cpl
 
Windows Security Center
 wscui.cpl

Wireless Link
 irprops.cpl