Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts

Saturday, February 25, 2012

Data Warehousing

HAI
i have read about few pages in Microsoft dataware housing toolkit by ralph
kimball.i find it little difficult and vague to understand the concepts.so i
kindly request anybody who have worked with dataware housing to recommened
me a book to get a clear picture to start with and then to concentrate on
design part.
thank youmaybe try this book:
Microsoft SQL Server 2005 Analysis Services Step by Step
but I don't know what is its content.
"vidhya" <vidhya@.chellasoft.com> wrote in message
news:u4MZEqxrGHA.4512@.TK2MSFTNGP02.phx.gbl...
> HAI
> i have read about few pages in Microsoft dataware housing toolkit by ralph
> kimball.i find it little difficult and vague to understand the concepts.so
> i kindly request anybody who have worked with dataware housing to
> recommened me a book to get a clear picture to start with and then to
> concentrate on design part.
> thank you
>|||hi, i'm thangesh
i'want datawarehousing in informatica project and design pls give
datails and how to prefer resume and interview technical questions.
*** Sent via Developersdex http://www.codecomments.com ***

Sunday, February 19, 2012

Data type mismatch in criteria expresioin

Hi again, I'm having problems with an insert record page to insert records into a msaccess database via sql and dreamweaver mx.asp pages.

There are four date fields that can be entered (all not required), but it keep getting the

ERROR;Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

from my documentation there seems to be a known problem with msaccess and update/insert server behaviours....

Has anyone managed to overcome this issue, and if so, how ??

thanks for your help...That may be because of the Date format on the access database.
Try to insert the date in this format:
aaaa-mm-dd

______________
Paulo Gonalves|||thanks heaps...I actually got it sorted about 20 minutes before I read your reply...and you were right...I had the msaccess date formats set to an input mask that I don't think dreamweaver took a liking to...

cheers.