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
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
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
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
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
What is difference between navigating records in while loop and cursor ?
Answer Question | May 7, 2008 4:16 AM
Database, Development, WHILE Loop
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
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
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
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
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
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
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
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
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” 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
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
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
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
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