Error – You are not authorised to access this database
Hi, i have installed domino and notes on my home pc. i have created 3 users. now the problem is that when i try to access mail or click on new memo to write mail as a user following error encounters “You are not authorised to access this database” as a administrator i can do [...]

Answer Question   |  October 24, 2009  12:33 PM
Lotus Domino, Lotus error messages, Lotus Notes, You are not authorized to access that database

MySQL Stored Procedures in Crystal Reports
Hi, am using Crystal Reports 9 and MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won’t accept this stored procedure and cites ‘Incorrect Number of Arguments; expected 1, got 0′. Im pretty new to MySQL and perhaps I shouldn’t be creating stored procs the way I do: CREATE DEFINER=`admin`@`localhost` [...]

Answer Question   |  May 8, 2008  11:18 AM
Crystal Reports, Crystal Reports 9, MySQL, MySQL Stored Procedures

Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?
I’m setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

Answer Question   |  May 7, 2008  4:12 PM
Database mirroring, SQL Server 2005, SQL Server alerts

Is there a query to search text of all SQL Server database objects that reference a specific table/instance?
We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

Answer Question   |  May 9, 2013  3:49 PM
Database objects, Query, SQL Server migration

How to perform exploratory database testing using ERDs
Can you please advise me on how to perform exploratory testing on a database using ERDs?

Answer Question   |  May 15, 2008  3:05 PM
Database testing, ERD (Entity Relationship Diagram), SQL Server database design and modeling

While loop Vs Cursor
What is difference between navigating records in while loop and cursor ?

Answer Question   |  May 7, 2008  4:16 AM
Database, Development, WHILE Loop

Split Databases – BE Structural Changes Version: 2007 (12.0)
Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can’t you put their copy of the FE on the network, under a folder just for that user?

Answer Question   |  May 7, 2008  8:23 PM
Access 2007, Database, Database design, Microsoft Access

Update table to remove invalid char type (tab) Oracle
I need to update a table I have in oracle that has an invalid character type in it. It looks like it is a tab character. Can someone give me a script to update this field in the table to remove a tab character from a field and replace it with a space – I [...]

Answer Question   |  May 7, 2008  4:46 PM
Invalid char, Oracle

Save Access 2007 format as 2000 format with VBA
how can i save the curent database as a 2000 format with vba

Answer Question   |  May 8, 2008  10:23 AM
Access 2000, Access 2007, Microsoft Access, VBA, Visual Basic for Applications

Connect to Sybase ASE 15 via MS SQL 2005
I’m in a test phase and would like to connect to a Sybase ASE 15 server in much the same way as linking tables in access. How would I accomplish that?

Answer Question   |  May 14, 2008  9:06 PM
SQL Server 2005, Sybase, Sybase ASE 15

Embedded SQL in a Cobol program using a sub-select in the select clause
The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = ‘UG’ AND SOVLCUR_LMOD_CODE = SB_CURRICULUM_STR.F_LEARNER AND SOVLCUR_CURRENT_IND = ‘Y’ SSRMEET_ROOM_CODE FROM SSBSECT, SSRMEET, SGRSPRT WHERE SGRSPRT_TERM_CODE = ’200810′ AND (SGRSPRT_SPST_CODE IS NULL OR SGRSPRT_SPST_CODE = ‘ ‘) AND SSBSECT_CRN = SSRMEET_CRN AND SSBSECT_TERM_CODE = ’200810′ AND [...]

Answer Question   |  May 6, 2008  6:58 PM
COBOL, Embedded SQL, SQL, SQLPlus

Printing the contents property of an EXCEL file
I have an Excel spreadsheet that has 92 macros and many queries with a Data Connection to Access. I can view the contents of the Excel file in a narrow window. Does anyone know how to print the contents so I can read the full contents?

Answer Question   |  June 8, 2012  6:21 PM
Excel macros, Microsoft Access, Microsoft Excel

Deletion of Macros when doing a repair & compact
We are experiencing a problem of a number of macros being deleted after performing a repair & compact. Could this be a space problem or could it be a problem with how the environment is set up–what do you think could be the problem?

Answer Question   |  May 5, 2008  6:14 PM
Macros, Microsoft Access, Repair and Compact

SQL linking to database in XP
First of all, I tried to create an ODBC connection to a local SQL database. It successfully created but it does not show up. I know it is there because I can link to it via Access or if I try to create the same one again, it tells me it is already there and [...]

Answer Question   |  May 6, 2008  2:33 PM
Database, ODBC, SQL, Windows XP

Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!
Hello Community If you haven’t noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and [...]

Answer Question   |  May 14, 2008  3:51 PM
AS/400, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP

No such interface supported
“No such interface supported” msg shown in try method, while i m assining a dataset to crystal report viewer by following code, dim cr as rpt1 = new rpt1 cr.setdatasource(dataset) crviewer1.ReportSource = cr

Answer Question   |  May 1, 2008  8:44 AM
Crystal Reports, Database

Using shell execute from Visual Basic
How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland

Answer Question   |  May 1, 2008  5:34 AM
Microsoft Access, Oracle, ShellExecute, SQL Loader, Visual Basic

Online Masters degree in Networking and System Administration
Hey guys, I’m looking into an online masters program from Charles Sturt University in Australia in networking and system administration. Has anyone had any experiences with this school? I’m in the U.S., but this program seems better suited to my interests than most of the programs I’ve found here. Should I expect to run into [...]

Answer Question   |  February 27, 2012  9:08 PM
Career development, IT careers, Training

How to use partitioning in SQL Server database to avoid ‘timeout’ errors
We have over 300 stores, and with each store having 30gb+ databases, each server is being upgraded to at least 6gb+ memory which is being forced allocated to SQL Server. I want to start to partition the existing SQL Server database by date. How do I go about doing it, because I have absolutely no [...]

Answer Question   |  May 2, 2008  6:01 PM
Partitions, SQL error messages, SQL Server performance tuning, Timeout

Storing BLOB to file through SQL Server 2005
I want to know how to Export BLOB data to a JPG File at the SQL Server end … NOT USING C# or VB

Answer Question   |  May 2, 2008  2:46 PM
BLOB, Database, SQL Server 2005