• Network Access Permission

    Network access problem description: • My network is a hybrid wired & wired mix, simple peer to peer • Purpose is shared internet access along with file & printer sharing • A single Router / modem connects to DSL • One computer connected to the router with a wired – Ethernet cable • The...

    Rgw5 pointsBadges:
  • MS Access IIF Statement

    I am pulling options from a table of "1", "2" or "3" and cannot get the Iif statement to produce the results that I need. Please find the Iif statement below: =IIf([lepamtpaid]=1, “Your premium bill will reflect this new premium amount.)”,(lepamtpaid = 2, “This lump sum amount will be...

    Jsweitzer15 pointsBadges:
  • SQL Server 2000 connection to multiple databases using variables

    I have a fairly simple select statement that joins three tables from two SQL Server 2000 databases. It works fine, but now I need to run the stored procedure against different servers, so my hardcoded reference to the second database (currently coded as "secondDB.tableName.columnName") needs to be...

    CO Bill120 pointsBadges:
  • Guest Access IAS policy

    I am trying to set up guest access of 802.11 wireless access points. My IAS policy puts domain computers into vlan1 and on the AP they show "Forwarding Allowed". I have set up a policy which recognises the mac address of my test guest and on the event log this is shown as a successful...

    Jrubinstein70 pointsBadges:
  • How can we startup our DB if any one redologs is corrupted totally 2 redologs

    how can we startup our DB if any one redologs is corrupted totally 2 redologs.the corrupted redo is in archivemode.1st redo is corrupt tat is in current use of archive mode

    Kkvsaathish5 pointsBadges:
  • Analyzing Existing Indexes

    Hello, I am trying to analyze existing indexes on few tables. I think I can do this by using system views like sys.db_dm_index_usagestats, physicalstats and operationalstats. I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc I am wondering if ,Apart these...

    Sqloholic25 pointsBadges:
  • Improving the performance of full-text searches in SQL Server 2005

    Why does a full-text search perform so slowly in SQL Server 2005? How can i improve the performance, in general, of query results ?

    SQL Server Ask the Experts2,585 pointsBadges:
  • LSXODBC and MS-SQL Stored Procedure Parameters

    Using LSXODBC and ODBCResultSet, how do you pass parameters to a stored procedure using result.Execute or result.ExecProcedure? I am looking for a working example not just syntax.

    Mzrn1x5 pointsBadges:
  • Accessing an SQL 2005 Synonym with ODBC

    Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?

    Randym1,740 pointsBadges:
  • VB 2005-SQL CONNECTIVITY

    HOW DO I UPDATE A FILED IN SQL THROUGH VB 2005?

    N74015 pointsBadges:
  • Database Quality Control measures?

    Hi, I'm a developer working in a rather simple systems/data environment: three database systems - development, testing and live. obviously as the developer I work on the development server, once my development is done (and tested), the changes are implemented on the user testing server for...

    Les za30 pointsBadges:
  • Automated data entry for some controls based on data in other controls in Access 2003

    Hi: I am creating a bilingual (english/french) database wherein I need to have the french controls automatically filled when I choose an english term from a dropdown list in the correspopnding english control. Example: I have a list of terms in a combo box control (named 'domain') containing the...

    Willis125 pointsBadges:
  • How to pass value at run time from VB 6 to Access 2000 Query for reporting

    I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is...

    Mayuri155 pointsBadges:
  • How to create a temporary table in sql 2005 via SSIS

    I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

    NewBee7105 pointsBadges:
  • Field editing for DB2 WebQuery

    How can I provide field editing for DB2 WebQuery? For example: phone number(length 10, decimals 0) as (123)456-7890 and Customer Id# (length 6, decimals 0) as 1234-56 . DB2 WebQuery doesn't seem to pay attention to the edit words/edit codes of the PF DDS, so I am trying to do my own "editing". I...

    AS400 - Ask the Expert485 pointsBadges:
  • Making OMIT command inactive after a some count

    I have to write a JCL step in which I have to copy a file in to another file after omitting ONLY 5 records in which starting 4 position are having character 1644. Can you please help? Thanks in advance, Sushant Sharma

    VisionPlus5 pointsBadges:
  • How to mirror two databases (PRD to DEV)?

    HI, I am trying to mirror my DEV box data lib with Production box. Currently i am creating a save file and then i FTP it to DEV box and restore lib. Any other way to do this? FTP takes a lot of time to transfer so, any suggestions on fast transfers would also be helpful. thanks

    Rockleadme385 pointsBadges:
  • Copy old database as new

    Sir, I have SQL server 2003 Ex i have A database and closed the fincial year for new year entry totally new transaction i want create same databse New name B and then blank the record for new transaction pldase help me kishor.aware@rediffmail.com

    Krrish25 pointsBadges:
  • Data mirroring

    Hi Guys, Can any one tell me how can i keep two databases in sync? My problem : I have two boxes DEV and PROD and have a data library in each box. What i want is to keep my DEV data library in sync with the PROD real time. If real time is too difficult to achieve ......how about end of day?...

    Rockleadme385 pointsBadges:
  • Text Box Only Allows Certain Characters

    I have a VB6 app running on windows application server, accessed via Symbol scan gun. Sometimes the user can't enter data they need to into a text box. I could enter spaces but no other characters or numbers. After entering spaces I tried to backspace and a box showed up (in the txtbox field) for...

    Rbsauls5 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.

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

Following