Database Books

I had an application that I was working where the client insisted on using an Access database for the application. The application was running on a two node server farm so the Access database had to be located on a seperated machine and accessed over the network. When upgrading the server farm from 2000 to 2003 the client ran into an issue accessing the database.

After checking to make sure it wasn’t an error with the connection to the location where the database was held I attempted to put the database underneath the site and connect to it there. Well that connection worked fine and the data could be accessed.

Long story short after some research and some long hours on this I found that the issue was a combination of things. First under IIS 6 all applications are run under application pools. The application pools do not pass the identity along that they run under. This creates a problem when trying to access a remote drive. To solve this issue you can enable impersonation of the account that you had IIS to run as the anonymous user. To do this you need to open the web.config file of your application. Under the and then insert a line that is similar to this:

< IDENTITY impersonate=""true"/" >

This line should be used if you wish to impersonate the user as the account that the user is logged in as on their desktop.

or

< IDENTITY impersonate=""true"" userName=""< your" user name >” password=”< USER account password > “/>

This line should be used if you want to specify one specific account to impersonate.

After I turned on the impersonation in my project another issue appeared. I got the dreded /< YOUR name application > Application Error. This issue was addressed in Microsoft KB82719 Article.

When a .NET application executes it uses the TEMP folder of the ASPNET user, or whatever user you have specified to run your .NET applications, to run and store temporary files. When you run an Access database/application temporary files are opened but since you are impersonating a user that user does not have access to open these files under the ASPNET temp directory. The solution for this is simple, go into the file structure and grant the account access to the temp folder in C:Document settingsServerNameASPNETlocal settings folder. Only give the account access to the Temp folder so that a security risk is not created.

Jason Fortner is co-founder of Total Productivity Solutions, http://www.totalproductivitysolutions.com, a company that specilizes in SharePoint, Webpart and .NET development. More tips on web development visit Total Productivity Solutions.

Share This

Filed under: Database by admin
No Comments »

There are many types of computerized organizing products that claim to save us time. We can choose between information or contact management software such as Outlook, Act!, Goldmine, InfoSelect, Now Up-To-Date (for the MAC), and many more. Then there are the PDAs (personal digital assistants), which fall into 2 categories: those that run on the Palm operating system, and Microsoft’s Pocket PC. But when I observe how people use these products, I see that many are just scratching the surface. They’re getting only a fraction of the time-saving benefits because they don’t know how to choose and use these products.

Importance of Realistic Expectations

Stephen Covey observed that many people seek a “Magic Tool” which they hope will magically, effortlessly, get them organized. But in reality it’s not that simple: In addition to choosing the right tool and using it properly, we must manage paper and phone calls, set priorities, deal with crises, juggle multiple projects, and plan for the future. Many people have a To-Do list dozens of items long, including tasks that have been waiting for months. Is such a list more effective just because it’s “in the computer“? Obviously not!

Choose Carefully, Then Learn to Use It

Don’t get me wrong — I’m no Luddite. I love computers. I’m totally dependent on my contact management and scheduling software — it literally saves me hours each week. (In case you’re curious, I use Goldmine). Yet few people seem to get the full benefit of the technology they’re using. For some users, these products even waste as much time as they save — although the victim is too close to the situation to see it. Perhaps they never really learned to use it, so they’re only using a fraction of its potential. Or they’re using the wrong software for their needs. Many people even use two or three software packages that do basically the same thing — so the time wasted switching back and forth (not to mention the confusion that results!) outweighs any benefits. Last but not least is a problem that’s completely self-inflicted and easy to prevent - I refer to data loss due to failure to back up your data and guard against battery failure.

It’s Still Up To You

Truth is, calling such software or handheld computers “organizers” is a misnomer. They’re really just places to store information. In themselves, they do not organize anything. WE do –through a comprehensive system of time, paper, task, and information management. So, if you’re tempted to buy an electronic “Magic Tool,” choose very carefully. Then, once you’ve bought it, take the time to find out all it can do — and then use it to the max!

Copyright Jan Jasper 2005

Jan Jasper has been helping busy people to work smarter, not harder since 1988. She is the author of “Take Back Your Time: How to Regain Control of Work, Information, & Technology” (St. Martin’s Press). Jan has helped thousands of people juggle multiple projects, survive information overload, and get the most from office technology. She also does configuration and training for software such as Goldmine & Microsoft Outlook. Call 212.465.7472 or visit http://www.janjasper.com

Share This

Filed under: Database by admin
No Comments »

SAP like enterprise applications are specifically made up of programs with the data which are used by and created by those programs. In a meaningful way the data are organized within in a database, For the benefit of programmers, which are made easy so that they can access and find the necessary data to do something useful, for instance run a financial report or to create a sales order. The programs and the data will be in same database for SAP component or product like ECC, Normally each component will posses its own database (Even some exceptions exists) - a production system landscape composed of SAP Business Warehouse (BW), SAP ECC, plus SAP Customer Relationship Management (CRM) consists of three production databases. Given its basic station in the life of an SAP system, since it is important we have to understand the over all role of database.

Highlights of this hour comprise Exploring the concepts as well as structures of an RDBMS

Determine which databases are supported by SAP

Learning the disparity between a primary and foreign key

Find out why indexes speed up data retrieval

Structure of Database A database can be said as electronic warehouse where we can store information’s in an organized manner so that the system can find the desired information quickly.

The database is composed of tables, columns (called fields), and rows (called records or data). A simple example of a database is telephone book which are organized alphabetically so that it make the user to get their information very easily likewise the database is formed with the same concept. Instead of man the system will do the work so the work can be done easily and efficiently.

The basic structure of a database is somewhat comparable to a Microsoft Excel spreadsheet in which columns (fields) store row after row of records (data). The major difference between a database as well as a spreadsheet is simply that databases be able to contain multiple tables that are connected to one another through relationships. Thus, a database can be thought of as a much more complex, plus ultimately much more useful, spreadsheet.

The database plays an important role in each SAP system, as it houses all the data that are used by that particular SAP component or else product. Several brands of databases exist, making it easy intended for an IT shop to choose a database vendor with which they are probably already well-known. Currently, SAP can use a range of different brand name database releases ranging from very expensive as well as imminently flexible to very inexpensive as well as yet quite capable.

It is significant to note that not all database vendors as well as versions are supported by SAP. SAP is likely to stick with the market leaders, over the years adding as well as removing support intended for certain vendors. In this way they not just limit the amount of database-specific customization they have to perform, but they endow with IT shops with flexibility plus choices, keys to success both for SAP as well as the IT organizations tasked with organize and supporting SAP solutions.

Ron Victor is a SEO copywriter for http://www.simplysap.com
He written many articles in various topics.For more information visit http://www.simplysap.com
Contact him at ron.seocopywriter@gmail.com

Share This

Filed under: Database by admin
No Comments »