• Delivery system

    hi there, i was wonderinf if you guys have any codes in VB.6 about Delivery system. i'm using using it as a reference for my thesis. any help would be great! thanks! :)

    Playah070 pointsBadges:
  • Database Tuning Advisor “not permitted” error on SQL Server 2005 DE

    Hi! I've bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I've installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: "Tuning this edition of...

    Volrat0 pointsBadges:
  • Daylight savings – Change in politics

    Greets to all, First off, where I live (WA, Australia) we have had a change in politics. We now have daylight savings starting in 1 week. The problem is as follows. Details * 3 Domains (not linked to each other) * Multiple external sites (not tied back to base) * Multiple DB systems and...

    Nephi10 pointsBadges:
  • DB Migration from 8.1.7 to 10gR1

    I want to migrate from 8i(8.1.7) to 10gR1 in a new server. I will shutdown 8i and run with 10gR1 in a new server. If any of my application not working with 10g ,i need to fall back to 8i in old server. Is it possible to take only the delta changes from 10gR1 which has happend for such duration and...

    Ajmalziyad0 pointsBadges:
  • Oracle Parse – Instr

    I'm receiving a string pipe delimited I need to extract the data between pipes until the end of string. How do I do this? I currently have FUNCTION fParseValue (pValueMeters varchar2) return varchar2 is v_meter1 varchar2; begin v_meter1 := instr (pValueMeters, '|', 1, 1); v_meter2 := instr...

    Dava190 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • Testing how long an SQL script will takfe to run

    Running Oracle 9.2.x. We have to sun a couple of SQL scripts that will make some changes to tables/data. Is there a way of finding out approximately how long these scripts will take without actually running them? Is there some tool I can use to do this? Or some rule of thumb?

    Pingsc0 pointsBadges:
  • OPNQRYF’s MAPFLD

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • Tools for DDS to DDL migration

    Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...

    Newbie4000 pointsBadges:
  • ODBC connections

    We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to...

    Jade057110 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • dynamic visual basic form based on access database table

    I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100 picture...

    YitoGraft0 pointsBadges:
  • Simple but not so

    I have 2 table 1) Product_Inf and 2) Product_attribute_details I have prod_key, dye_class, prod_range in both the table. Their is no relation exist between both the table than how can i find the records available in Product_Inf but not in Product_attribute_details?

    Ilink880 pointsBadges:
  • CLOB and VARCHAR2

    Hi Isn't there a mid way between using the VARCHAR2 and CLOB datatypes? I need to have a column that will contains upto 6000 characters so I can not use VARCHAR2 for this. And i don't want to use CLOB as it might bring in some other problems like space management (coz it can occupy upto 4gb)....

    Abhivyakti0 pointsBadges:
  • Installing Oracle 9i on Windows XP

    When trying to install Oracle 9.2 on a computer that has Windows Xp, I am receiving this error message: Unable to install Orcale 9i: EDS cannot support more than two Oracle homes. Then the installation aborts. How can I fix this problem?

    Bushka0 pointsBadges:
  • Changing Server Name Where ORACLE is Loaded

    I was wondering other than to edit the TNS names, would changing the server name andor the IP address where ORACLE is loaded and the data files are located, what other parameters or files do I need to changeedit? Is this doable without too much work? Many thanks, Sam

    SamAvella30 pointsBadges:
  • please solve this query

    Create Emp table containing an Empno column with the following sample data:- EMP ------- EMPNO ----------- 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ------------ 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 Don?t assume...

    Sairam170 pointsBadges:
  • Uploading a file from a USB up to Mainframe & re-generating a PDS

    I created a flat file from a PDS using IEBCOPY, downloaded that flat file to hardrive and subsequently copied to a flash drive. Now, I'm trying to upload this file & re-create the PDS that it originally came from but am getting errors: "wrong length record" Have tried uploading to various record...

    Hervey0 pointsBadges:
  • need help in vb code

    Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example [CODE] id Time Code Price Res 1 10:00:00 AM 1010 905...

    Rosy990 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