• Managing SQL 2000 server over the internet

    I have an SQL 2000 server behind a firewall. I have set the ports to be forward to this server. I would like to manage this server from home using enterprise manager. How can I accomplish this.

    SQLDEV5 pointsBadges:
  • Oracle Database Issue

    Hi all We have a 10g oracle server but the problem is that it keeps dying out every now and then. we are usind it on red hat. i tried opening the emctl dbconsole for oem . it opens up but the instance status shows the error ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach) and on top it...

    Newkipper0 pointsBadges:
  • Visual Basic 2005

    My task is to write a program to take a input from a user which in this case is a name (forename & surname) and create a VB 2005 program to capitalise the first letter of the first name and surname although also ensure that the remainder of the name is lower case. How do I do this ???

    Genius260 pointsBadges:
  • malformed packet alert

    I get this message from my router every 2 minuets or so. I tried blocking to ports that it attacks and the IP but the major issue is that, that IP is a broadcast IP, so i don't know where it is coming from. What my question is, is how do is stop these alerts (short of removing my e-mail from the...

    Carnage66690 pointsBadges:
  • GENERATED KEYS…

    I want to generate the next avalable key when INSERTing new rows. For an example... Create Table DBALIB/PARENT ( PARKEY BIGINT NOT NULL WITH DEFAULT PRIMARY KEY, PARNAME CHAR (30) NOT NULL WITH DEFAULT); INSERT INTO PARENT ( PARKEY, PARNAME) VALUES ( PARKEY(MAX) + 1), (<=====> just for...

    Znason460 pointsBadges:
  • Front End Development for AS400

    Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some initial research on that and...

    Pgsdeb20 pointsBadges:
  • database access

    how can i connect to a ms access database which resides on other computer in a network using vb6.0

    Vijaycse0 pointsBadges:
  • DB2/400 Stored Procedure Security

    I am new to the DB2/400 world and am tasked to speed up some of the reports and a GUI application. To accomplish this I am heading in the direction of using stored procedures and UDFs. My problems is that the shop that I am working in is basically a AS400 shop that has never used SP or UDFs so...

    LegalDev0 pointsBadges:
  • Moving into the InfoSec role

    I work at a company that currently does not have a position dedicated to information security. I come from a background in networking with a good portion of my focus on firewalls and other security related technologies. I am interested in positioning myself into the role of InfoSec Admin at my...

    Kushalp0 pointsBadges:
  • SQL Logical Functions

    Which is better to use and why? Also, which function is faster and why? Coalesce -or- IfNull

    maryann465 pointsBadges:
  • Authenticating a Domino application using LDAP

    Hello, I have an online training application that allows users to connect anonymously but then requires them to authenticate with their Notes username and password after completing required courses. About 8% bomb because they enter their network username and password instead of the Notes username...

    MHanson35 pointsBadges:
  • Converting datetime (time portion) to varchar

    I have an issue with a report I am converting from Crystal Reports to SRS. The reports datasource is a SQL stored procedure, that converts a datetime column to a varchar column containing just the time portion of the data. The time is converted to 24 hr format. CR was able to with it's built in...

    Lacain20 pointsBadges:
  • RUN TIME ERROR 339

    I have an application written in Visual Basic. The application runs on windows XP system with oracle 8i and Crystal report 8.5 The application suppose to interface with an oracle 8i database. In attempt to run the application it gives this error: 'Run-Time Error 339 component 'CRYSTL32.OCX' or one...

    IdongesitDaniel5 pointsBadges:
  • Query

    I need to create a query on a file that has several detail lines for the same shipper number, I would like to see only one line per shipper number, using SQL I get the result I want by using the following command --- SELECT DISTINCT compny, shpinv, acode, cabbv, dabbv, shipdt, oem FROM...

    ATitus85 pointsBadges:
  • 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:
  • convert public folder IPM.POST to IPM.NOTE

    i have an sbs 2003 with exchange runing on it and gut a public folder that i've created for general mail to the employee's. i've routed all mail to that folder from specific account, the problem is that the mail's arrived as a IPM.POST format mails and not like the traditional mails that is more...

    Drorbeny0 pointsBadges:
  • Accessing Mail Server

    I have remote users who are not allowed on the domain... At times they need to work in the main office and log in via wireless directly to the Wirelss ADSL modem/router.. putting them in a different ip range to the domain. Internet access works well with this arrangement but they are unable to get...

    Arron250 pointsBadges:
  • Using an array in embedded SQL in RPGLE

    Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should give you the general...

    Vatchy1,410 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:

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