• 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:
  • Installation and updates

    Howdy folks, Tryin to keep things going around here....need some advice. I have Win2003 servers and Active Directory.....single domain....approx. 100 client computers.....one location. Am upgrading all computers from Office XP to Office 2003. My project: Install Office 2003 and all updates remotely...

    TheVyrys0 pointsBadges:
  • How to save a document as current date ?

    I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please

    Data Mgt5 pointsBadges:
  • Need vbscript that can pop up alert when services go down on a remote computer

    Hi, I have tried many scripts at my local machine. It gave pop up when service for one particular application went down. But the same thing is not happening for the remote computer. Please look at the script below: strComputer = "." Set objFirewall = CreateObject("HNetCfg.FwMgr") Set objPolicy =...

    Naaz30 pointsBadges:
  • What are Web services, and how can they benefit my clients?

    Our expert on SearchSystemsChannel.com says the advantages of Web services are that they're "platform independent (your customers can essentially run any OS), secure and scalable. They're also Web-based, so they run over Port 80, which many firewalls do not block." Are you a fan of Web services?...

    Donnellymp430 pointsBadges:
  • SQL COMMAND to see table relation

    Which command I can use to get the relation between all tables in a system application?

    Arielmx5 pointsBadges:
  • Is it possible to find out the name of an excel worksheet

    I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql? Query used to import where sheet name = data SELECT * INTO tmp_test2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel...

    Smf170 pointsBadges:
  • What is the difference between using a rpc over http and OWA?

    What is the difference between using a rpc over http and OWA? Which one do you feel is more secure? Do OWA have some limitations to the outlook clients than rpc over http?

    ITKE354,800 pointsBadges:
  • SQL Query for time data only

    I need to query a large remote weather database for events reported within time frames without regard for the day. For instance, I need all data that was reported for the fifteen minute window closest to noon each day for the last twelve years. I don't care about specific dates, just the daily time...

    C Pete15 pointsBadges:
  • Looking for a stored procedure to monitor size of Transaction Log file

    Is there any way I can create a stored procedure which will check for the Transaction Log file size - where we have a specified limit to grow - and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?

    SQL Server Ask the Experts2,585 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.

Following