• I need to up load an excel file to sql server db with vb

    I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don't rememeber. does somebody an idea? thanks in...

    Xs4010 pointsBadges:
  • Unable to use delete statement in SQLRPG

    Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.

    0 pointsBadges:
  • priority queuing

    Why is priority queuing not recommended for anything other than VoIP?

    Rgaz115 pointsBadges:
  • Sum of Donations for current year

    I have a query that sums donations and groups them by year. When I print receipts, it gives me two receipts -- one for year-to-date donations for 2009, and another that includes 2008 and 2009 donations. How do I get just the one receipt to print?

    RonleeG5 pointsBadges:
  • Date insert problem into Access from .NET

    I have a procedure that inserts a record including a date into an Access database. If the dd portion of the date can equate to a month then the dd and mm parts of the date are switched otherwise the date remains as is. eg 12/11/2007 is being stored as 11/12/2007 but 13/12/2007 is stored as...

    RobOfTage5 pointsBadges:
  • Transposing a table using SQL Server Reporting Services in VB.NET

    How can I transpose a table using SQL Server Reporting Services in VB.NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Network Management

    I have 4mbps ADSL with over 100 user. I want to schedule the FTP traffic and HTTP traffic and wanted to maximize traffic for the management team. What should I do.

    Niftypiece10 pointsBadges:
  • How to pass Stored procedure to Crystal reports

    I have created a report in Crystal report using stored procedure and i have to call that report in delphi by passing parameters to stored procedure..?

    Raghuvenu5 pointsBadges:
  • SAN questions – SAN array sizing

    1. SAN: Can it support multiple concurrent accesses? 2. What are the trade-off's between SAN array size and number of concurrent indexer processes (take note indexers will be constantly polling, renaming and deleting files) if i am creating an indexer? 3. SAN: Upon scaling are there any potential...

    ITKE827,890 pointsBadges:
  • can you help on this query?

    I am new to sql and cannot work out the query for this: >>>List the films in which 'Harrison Ford' has appeared <<< movie(id, title, yr, score, votes, director) actor(id, name) casting(movieid, actorid, ord) The whole exercises can be found on http://sqlzoo.net/3.htm thanks in...

    Cateye5 pointsBadges:
  • MS Access 2003 write in SQL query to convert string to numeric

    How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks

    SacramentoSil25 pointsBadges:
  • How to replace a record in Microsoft Access 97 with VB 6.0

    I create a program with vb 6.0 and i connected with ms access 97. Now i don't know how to replace an existing record. For example i have the field "A" and the record is "20" now i want to replace "20" with "15"

    Panossg75 pointsBadges:
  • updating to autocad 2009

    if i install auto cad 2009 on my computer will i still be able to use auto cad 2006

    Jewsus15 pointsBadges:
  • Query won’t access open form field for parameter

    I want to open a group of receipt forms using the "client ID" from the open form "Client" as the parameter. I created a button which runs the "openform" action macro using "[Client ID]=[Forms]![Client]![ID]" as the Where Condition. This was working until I closed the access program and reopened the...

    Bbenson5 pointsBadges:
  • Problem with delimiter in CPYTOIMPF

    I have used pipe symbol | as the delimiter to seperate fields.I used this in a DS and moved it to a flat file.From the flat file CPYTOIMPF was used to created a text file and ftpd.The problem is that the | symbol is read as ! in another system.Wat could be the reason

    0 pointsBadges:
  • INSTR ()

    Hi Experts, My test case s working fine for the INSTR() but the same if i use in implemenation its not raising the error giving below the pseudo code IF INSTR (v_lm,pcd,1,1) = 1 OR INSTR(vlm,pc,1,1) = 1 OR INSTR(vlm,pcn,1,1) = 1 THEN raise_application_error( err_pkg.nt_val, err_pkg.nt_val_msg ||...

    Inprise610 pointsBadges:
  • Need SQL query

    I have two tables DETAIL and USER. Detail table have two columns (projectid and projectdetail). Projectid is a primary key in DETAIL table. USER table have two columns (projectid and Userid). User table is like more than one userid can be under each projectid, one user can access more than one...

    Minuvinu35 pointsBadges:
  • Deploying software package through group policy

    I am trying to deploy software via an .msi file through group policy. There are multiple branches in my domain. I have copied the .msi file to the local domain controller for each branch. I want to create a gpo for each branch that will deploy the .msi file from their respective domain controllers....

    Sturdy2725 pointsBadges:
  • Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • ASP getting increasing

    Hi All, One of the our production server its V5R4.3 months back only we bought this server.Perviously its working fine.But Nowadays ASP is getting increasing some times its went 55% also.we deleted some JRNRCVRs which are in SAVED status.but still its getting increasing.Any one know why its...

    MQ admin110 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