• How to Test for Numerics in AS/400

    I need to test for Numeric. I have to check, If a variable contains Numeric values. I wanted to use TESTN opcode, but people are saying not to use it; as it does not work properly some times. Is there any other alternative to this? Has anybody done this before? Any help would be of great help....

    svankipu620 pointsBadges:
  • What’s the better choice: VMware or Virtual PC?

    I've been experimenting lately with some build script (and since I already have ASP.net web part under source control) the script should do that at the end. Grab the "naked" Windows 2003 IIS VMware or Virtual PC image from the networkBoot it upCopy the files from the Build Folder to the...

    ITKE357,260 pointsBadges:
  • Testing VMware Perl SDK with ESXi 5.1

    I’m running a VMware ESXi 5.1 server and I need some help with Perl Scripts. I have downloaded and installed these packages on a Ubuntu 12.04 LTS machine: VMware-vSphere-CLI-5.1.0-780721.x86_64.gz VMware-vSphere-Perl-SDK-5.1.0-780721.x86_64.gz VMware-vSphere-SDK-5.1.0-774886.zip When packages...

    ITKE357,260 pointsBadges:
  • How to run a stored procedure directly from a begin- end; statement?

    I have a stored procedure with some dbms_output statements in it , i want to run this stored produre directly from begin end; statement in order to check how it woks...

    hussain22juzer525 pointsBadges:
  • API to determine if software is running on Citrix or Terminal Services

    I'm trying to figure out an API/function that I can call to find out what software is running on Citrix, Terminal Services or a stand-alone PC. Here's an example of what I'm looking for: Select Case APIWhatSystem.Type.ToString Case "Citrix" bCitrix = True Case "TS" bTerminalServices = True Case...

    ITKE357,260 pointsBadges:
  • How to tell which virtual machine is running?

    How does one find out if an application is running in VMware or Virtual PC? I’ve seen a few hacks that do this, but often they create performance issues that I’d like to avoid. Is there a way to do this using Delphi code?

    ITKE357,260 pointsBadges:
  • How to fix run-time error 3709 with my computer

    When I try to run my program it says run-time error 3709 the connection cannot be used to perform this action, it is either closed or invalid in this context. mean while I used a module in which i put the following codes : Public cn As ADODB.Connection Public Sub Main() Dim cn As ADODB.Connection...

    beginner15 pointsBadges:
  • SQL Server 2000 Database Table Limit?

    Is there a limit to how many tables a single database can hold in SQL 2000?

    Xarly25 pointsBadges:
  • How to make installer of VB.NET including SQL Server 2000?

    I had done my project in vb.net with sql server 2000 but it's installer doesn't work properly as it displays the message unexcepted error while connecting to the database.I know setup and deployment in vb.net but doesn't working please help me.I am stuck in here.thanks in advance.

    Rebi97745 pointsBadges:
  • SQL Server 2008 SSIS Update Command Performance Issue

    Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB with 500,000 rows using a...

    Sflatbush60 pointsBadges:
  • Ping SQL server in VB6.

    I need to use VB6 to detect if an SQL server is running. Looking for the easiest way whether it is pinging or something else or even detecting the database itself. Preferably by network device name.

    Jstropp5 pointsBadges:
  • store image to sql server

    would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end

    Azad10 pointsBadges:
  • Cannot connect VB program with SQL Server 2005 in local machine

    The simple program of fetching the data of table through vb.net program. I am retrieving the data into DatagridView . I am writing following String str for connection: Dim str As String = " Data Source=COMP1SQLEXPRESS ; Initial Catalog=Atuldb; User Id=COMP1comp11;Password= " my database name is...

    AtulMCM5 pointsBadges:
  • SQL Server 2005 with VB.net

    Hello, I am hareen. I am working on collegedatabase managment software, which is developed in vb.net. I'm using SQL Server database 2005 and my database name is collegedatabaseMV.mdf . I have some questions. What is necessary to load SQL Server 2005 on client computer when I'm installing my...

    HareeDeveloper5 pointsBadges:
  • Slow query response time in SQL Server 2005

    Why is their a slow query response time in my SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Problem inserting data using OPENROWSET in SQL Server 2000

    When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Software to automate backups for SQL Server 2008 databases

    I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up to do this? It's not...

    Phrathepmali30 pointsBadges:
  • How to load an Image from an SQL Server 2005 database using VB.NET 2005 coding?

    After a lot of trying and hard work I finally manged to store an image into an SQL Server database using a byte array. But now I'm stuck at how to retrieve it back into my application's picture box control. This is what I need to do: I need to retrieve the saved image straight back into my...

    Obhasha0795 pointsBadges:
  • Changing databases at run time in SQL Server 2005

    I am using Crystal Reports 8.5, Visual Basic 6 and SQL Server 2005. In my server, I have two databases named Eng_School_Database and Guj_School_Database with the same structured tables. I want to change the databases at run time so that the report should contain the data of desired medium. I have...

    SQL Server Ask the Experts2,585 pointsBadges:
  • I want to load XML to a table in SQL Server 2005

    i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.

    Mitha10 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