Data Sources for SSAS 2000
I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

Answer Question   |  June 12, 2008  2:14 PM
Data warehousing applications, Data/Application Integration, Database, SQL Server 2005, SSAS 2000

MDE to updating table in backend database
I inherited a few databases which were created in Access 2000. I only have Access 2003 and I needed to make a new MDE file, I converted to Access 2003 then created the new MDE file. Now the problem is this, the new MDE won’t write to the backend database.

Answer Question   |  June 27, 2008  12:29 PM
.MDE files, Access 2003, Database conversion, Microsoft Access

AR server
we r using the AR server 7.0 the backend database is sql 2000 under window platform, so now if I need to change the database table format to CLOB then, any one could tell me what is the format of changing the database format, I mean the table format to In-row and Out-row method. Could [...]

Answer Question   |  September 20, 2008  7:51 AM
AR server, CLOB, SQL, SQL Server 2000

return array in postgres
when i execute following function in postgres, it gives me null. select get_strelements(’1000-2000-3000-4000′,array[''::text]); here, “get_strelements” function is as follows: CREATE OR REPLACE FUNCTION “public”.”get_strelements” (str varchar, dummyarr “pg_catalog”.”anyarray”) RETURNS “pg_catalog”.”anyarray” AS $body$ declare —————————————————————————————————————— len integer; len1 integer; len2 integer; v_str varchar; repl_char varchar := ‘-’; i integer; num numeric; noarr varchar[10]; splstr varchar; —————————————————————————————————————— [...]

Answer Question   |  June 12, 2008  6:48 AM
Database, Postgres

Order by using case statement SRS 2000
I am using a case statement to order data on a SRS report, when the statement is ran, it returns the correct order, but when I save the RDL and preview it, it returns to ascending order. How do I correct this?

Answer Question   |  September 20, 2008  6:38 PM
CASE statement, SQL Server Reporting Services, SRS 2000

How do I Autopopulate a few field on my my form?
I have a database created in Access 07 and in this database I have tables, forms and reports. I have a table where I have all the Plan info and I also have a table into where the info is stored after being entered on the form. On my form I have a plan number, [...]

Answer Question   |  June 11, 2008  5:12 PM
Access 2007, Access autopopulate

Copy Attachments to Folder
Anyone have a lotusscript to copy attachments to a folder? Also need to extract to excel a view but right now i think i can handle that with NotesSQL ODBC. The attachments part is buging me the most. This is not a mail system…. We have a database setup for document approvals. Lotus Domino 6.5

Answer Question   |  June 13, 2008  1:29 PM
Domino, Lotus Domino, Lotus Notes 6.x, LotusScript, ODBC, SQL

Optimizing Query
Hi, I am having a table which is having around 170 Columns(Don’t blame me but my Developer) and there are only 989 records in the table.I created all sorts of Indexes but still the query (Select * from Table) takes almost 2 mins to display 989 records.I need all the columns to be displayed.Is there [...]

Answer Question   |  July 4, 2008  11:30 AM
Database performance and tuning, Query optimization, SELECT statement

How to optimize results coming from database
Sir, I hv created a software which searches for the information the user wants. If only one user is using database at a time then it gives response in milliseconds. But when at a time 10 or more than that start using it then throughput decreases. So how i should do optimization

Answer Question   |  June 11, 2008  10:48 AM
Database performance and tuning, Java, MySQL

Entry Level IT job??
Hello, I am looking to get into IT. I’ve always been awesome at computers but haven’t had any formal training or experience in the industry. I’m in full time ministry and do not plan to go to school to get any type of degree. I’m doing my own research and online training, reading, etc. Here’s [...]

Answer Question   |  June 11, 2008  12:50 AM
A+, Certifications, Degree, degrees, Entry level IT, IT careers, just starting, Network+, rookie, Security+, Server+

Can I use filler to skip a column in a csv file on SQL*LOADER rel 8.0.6.3.0
We are running Oracle E-business suite 11.5.10.2 on db 9i but when I execute sql*loader it gives me version 8.0.6.3.0. Is the key word FILLER available for me to use to skip unwanted columns in a comma delimited input file? I know FILLER became a key work in 9i – is that the db 9i? [...]

Answer Question   |  October 18, 2010  4:47 PM
CSV, CSV input file, Oracle E-Business Suite, SQL

Rookie using DSNTEP2 and IBM JCL – Need Help with JCL
I’d appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I’m having problems creating a JCL – my brain can’t remember command syntax’s from that long ago. I need to create a JCL that will accept an input [...]

Answer Question   |  June 11, 2008  1:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL

What is the significance of incarnation and DBID in the RMAN backups
What is the significance of incarnation and DBID in the RMAN backups

Answer Question   |  June 11, 2008  11:08 AM
Database Identifier, Database incarnation, DBA, DBID, Oracle Recovery Manager, Recovery Manager, RMAN

What are the steps which need to be performed in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software ?
What are the steps which needs to be performed in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software ?

Answer Question   |  June 11, 2008  11:02 AM
DBA, NetBackup, Oracle Recovery Manager, ORACLE_HOME, RMAN, TSM Tape Library

Database Permissions
Is there anywhere that I can find out an explanation of what the database permissions are? An example would be what does grant view definition actually do? or What does grant view database give rights to or permissions to?

Answer Question   |  June 10, 2008  5:13 PM
Database, Database permissions

Creating and importing data into a relational database
I just started programming six months ago. I have a project to import data into a relational database. I have data in an Excel file that I need to import into a database. The application is recruiting software, for government jobs. I have a list of applicants and the jobs they applied for. First, I [...]

Answer Question   |  July 4, 2008  5:09 PM
C#, Microsoft Excel, Relational database management software

database
What should you do when you find a stacktrace in the server errorlog

Answer Question   |  June 9, 2008  8:55 AM
Database administration, DBA, Server errorlog

Linked Servers????
Hi everybody, I’m an IT student and i’m doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC’s and stores this information in a MSSQL database. A manager checks this information and fills another database located in another server. For example, in the SMS [...]

Answer Question   |  July 4, 2008  3:51 PM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003

mdb talk to jdbc
is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not [...]

Answer Question   |  June 6, 2008  3:40 PM
Flat files, JDBC, Microsoft Access, Query

DB Web interface
What would be the easiest language to use/learn if I want to create a web interface for my Access DB?

Answer Question   |  June 6, 2008  7:26 AM
Database frontend, Database programming, Microsoft Access