• 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

    Rolandsk5 pointsBadges:
  • Changing the default DTD

    Does anyone know how to change the default DTD in Domino6.5? From what I understand it is an environment variable that has to be changed in notes.ini or a configuration document in the Domino Directory. Does anyone know if it can be changed on a page-by-page basis? Right now it's showing:...

    Mrg285 pointsBadges:
  • sql query

    from this table i have to take those records that have common gridcode and then from these records i have to store the records having maximum area in another table... gridcode state area 13013 rajasthan 50000 13013 gujarat 45000 13014 rajasthan 25000 13014 gujarat 25000

    Aanshi1235 pointsBadges:
  • Sql subquery

    how can we use sql subquery in jsp?i am trying to write it but it gives me an error of missing operand?

    Shruti5 pointsBadges:
  • MOSS 2007 Server Installation and configuration problem

    Need to know how I can get SharePoint to recognize a second partitioned drive on the same server where I've installed SQL server 2005 and want the SharePoint configuration database and everything held. Server (Mars) is set up with local C drive where I've installed Server 2003 OS. Then I have...

    Mpolak275 pointsBadges:
  • update a field from a file with a field from a selection from two files

    Hi! When I try this: update fileD d set d.value = (select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c where d.key = c.key) I get the message "Null values not allowed in column or variable VALUE." on the other hand, when I do this selection:...

    Mr.70 pointsBadges:
  • Critical error in event logs

    Why do I get this message; "SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller."?

    Dbs1379015 pointsBadges:
  • Saving form calculations to tables

    I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table

    Rv49495 pointsBadges:
  • IS It Possible to create Recusrive function using sql udf or stored procedures?

    Hi i have a scenario of n level tree structure.in order to traverse to my desired node i am using Recursive function until i get my desired node in my vb code but i am getting a performance issue. SO i reckon that this performance can be overcome by using sql udf or stored procedure. If so please...

    Balajisairam15 pointsBadges:
  • VB error: Can’t edit module

    Hi all! After compling and packaging my project, I got to notice some bugs in the program. On trying to open the project again, I get the "Can't edit module". I tried everything I could get from google with no success. Please help.

    Wanaug5 pointsBadges:
  • Coding for library in stored procedures

    A reader wrote in with this SQL stored procedure question. Our AS/400 experts weren't as familiar with this topic. So, any SQL experts out there with an answer? Do I have to hard code the library in my stored procedure? I have my procedures in sqltblsrc and have to edit the library to create the...

    Leah Rosin575 pointsBadges:
  • SQL Error: Conversion of char data type to a datetime data type resulted in an out of range datetime value

    A reader wrote in with this question, but it's not one that our AS/400 experts could answer. So any Microsoft SQL experts out there, please chime in: I am an SQL novice.......I am getting the following error message: [Microsoft][ODBC SQL Server Driver][SQLServer] The...

    Leah Rosin575 pointsBadges:
  • Network design and infrastructure for a small business with on-site and remote access workers

    My company occupies a small self-contained, single-story business unit (of which they are the sole occupants) which is part of a larger business park. They employ 24 staff comprising of a CEO, 5 administrators, 2 business development managers and 16 specialist consultants. The administrators and...

    NetworkingATE1,545 pointsBadges:
  • connect sys as sysdba

    how to connect sys as sysdba in toad software and in isqlplus. When i tried in isqlplus and in toad by connecting as "sys as sysdba" i got the error. please give me a solution.

    Itsee10 pointsBadges:
  • SQL 2005 error code = 80004003: Invalid Pointer

    After (successfully???) attaching a database to a VM Ware instance of MS SQL Server 2005 and setting what appear to be appropriate access to the SQL server itself and the database involved, and making sure that sharing and security are properly set on the SQL server, I am receiving the following...

    Pressler29042,190 pointsBadges:
  • Convert report to HTML and tag using invoice number

    Using Crystal Report, I have imported the database to a created form, now I wish to export to HTML and create individual invoices using the invoice number as the document name in order to create a search engine to call up the required invoice. How do I create the proper tag or invoice name for each...

    SIMCO5 pointsBadges:
  • How to open new page in frame without being framed by old page frame

    Our site uses a frame for navigation (not my design), and one of site owners wants to redirect users to a new page on the site if they bookmarked the old page URL, giving them a message page first that says the old page has gone away and to bookmark the new one. Message page then closes after 5...

    Catullus1320 pointsBadges:
  • Formula workshop – using AND/OR

    Using the formula workshop, I am trying to display all records from 10am to 11am that have EITHER data in "field A" OR data in "field B". What is returned are records in the correct time frame (10am-11am), that have data in the "field A", however the records that have no data in "field A" but do in...

    LouJ5 pointsBadges:
  • what is error message write of address 00000034 in delphi5 mean?

    what is error message write of address 00000034 in delphi5 mean?

    Oracleunix5 pointsBadges:
  • SQL 2005 Active/Active/Passive

    We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. Because...

    Kjrichmond15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.