Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LinuxKommy

    Chevy Nova awards (lost in translation)

    I hate to start up this thread again, but if anyone uses SAP, they'll know of its horrible translations. :-) The one that comes to mind is the german word for "contractor" got translated as "Insignificant employee"... I always tease my contractor friends at work when it comes to our safety...
  2. LinuxKommy

    Select one value as another

    thanks....i feel really stupid now...actually i was coming back to write a reply like that. It had just occurred to me! i wanted Y=1 so that i could do sum(Flag*qty), but then i realized that i would select the "Y"'s only anyway. thanks for your help, and please don't laugh :)
  3. LinuxKommy

    Select one value as another

    How would i select one value based on another? the table stores its value as "Y" or "N", but i want 1 or 0. if they were numbers, i could perform the operation much more easily. if anyone can suggest a better way to do this operation, i'd love to hear it because i'm running out of ideas here...
  4. LinuxKommy

    Using two recordsets from different sources

    Cjac, thanks for the info! i had never even thought of that. So you're saying that the current db i have now with the linked tables will suffice? the only thing i'm worried about is now it should run even slower, as i'm using OLEDB to connect to access, and then through the already slow...
  5. LinuxKommy

    Using two recordsets from different sources

    thank you for your replies. Artichoke, Does looping through the recordset significantly increase query time? The problem is that the query (as it is now) takes two hours. Part of this is because it has to go over a T1 line. The other part is that the DBA doesn't re-index the table very...
  6. LinuxKommy

    Using two recordsets from different sources

    I need to use two recordsets from different sources. specifically, I query our main DB (ODBC) to get updated price information. In an access DB, i have some extended fields for the products, like length, width, and height. I need to have it update the pricing in the existing table and also...
  7. LinuxKommy

    Database Security

    oh i know....that was just an old bit of code....i changed it to first look for the open connection, and use it if it is open. i tried to do: sConn = "DSN=PPC;USER=user;PASSWORD=pw;" and also adding those lines to the file DSN (using notepad) neither way worked.
  8. LinuxKommy

    Database Security

    here is my db sub: Public Function DbOpenGAP() As Boolean On Error GoTo Err_dbConnect DbOpenGAP = False sConn = "DSN=PPC;" Set GAPcn = New ADODB.Connection GAPcn.Open sConn DbOpenGAP = True Exit Function Err_dbConnect: MsgBox Error MsgBox "Database did not...
  9. LinuxKommy

    Database Security

    I can't use a connection string b/c it never would work....however this is from the file DSN that i use. [ODBC] DRIVER=Transoft ODBC Driver Description=wtrans Timeout=35 Port=7000 Server=ppwsco TSDSN=wtrans I even tried adding lines for the username and password, but that didn't work. I can...
  10. LinuxKommy

    Database Security

    First, thank you for your replies. Secondly, the database is called TechGAP, which i believe now belongs to integrasoft. The ODBC driver is the Transoft U/SQL driver, v3.10.0.400. koala15, thank you for the article...i will try it this morning, but from an initial read, it seems to be what i...
  11. LinuxKommy

    Database Security

    I'm writing a program that ultimately will dump data into our old DB server (COBOL) using a 3rd-party ODBC driver. I have absolutely no problem with the SQL statements, but the server requires that you log on EVERY time. it pops up a window titled "GRANT and REVOKE Security," and there is no...
  12. LinuxKommy

    INSERT INTO problem

    thanks...you're right...access doesn't like having a field called "Date" i thought that the Database Password=" part was for a password...i haven't protected it yet...it's still in development thanks again! lk
  13. LinuxKommy

    INSERT INTO problem

    hi, i'm having a problem with this code objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.Mappath("loginlog.mdb") & "; Jet OLEDB:Database Password=" sqlString = "INSERT INTO Distributor (Company, Date) VALUES ( '" & login & "'...
  14. LinuxKommy

    MSHFlexGrid: picking wrong row

    I know this sounds crazy, but I made it auto select the first row after it loads the data and this seems to have fixedd it. If anyone has an explanation, I'd be glad to hear it. thanks, lk
  15. LinuxKommy

    MSHFlexGrid: picking wrong row

    I am using VB6 SP5, but i'm relying on the recordset to set the first row. when you say "set the first row", do you mean set the columns to the number of fields in the recordset? thanks, lk
  16. LinuxKommy

    MSHFlexGrid: picking wrong row

    Ok, i've looked all over and now i can't figure this out. I use a HFlexgrid to display records from a access database. first i tried using an ADODB recordset and setting the felxgrid's datasource to the recordset. then i tried using an ADODC control as well. the result is the same. if the...
  17. LinuxKommy

    Should I use SOAP?

    Right now i use a query string to send the variables. (zipcode and an origin zip code) The ASP page reads these, writes them to session variables and then goes to another stage of the web program. the program needs some more info to determine a freight price, like which type of truck to use...
  18. LinuxKommy

    Should I use SOAP?

    ok....maybe what i meant wasn't SOAP :) the examples that i saw used a SOAP envelope with XML, and made a reference to the MS XML library. i guess one question would be, can i make my program wait for a response from the server?
  19. LinuxKommy

    Should I use SOAP?

    I'm trying to integrate a web-based progrram into a VB6 program. basically, the VB program sends a ZIP code to my web program, and then the user selects some variables, and the web program outputs up to three options. The user then selects one and i need that data (a company and a price) to...
  20. LinuxKommy

    Onboard LAN not working

    I have a new MSI (VIA KT266A Chipset) with a VIA onboard LAN. the Link and activity lights come on while the computer is booting, but after the windows 98 splash screen appears, they go off and the network will not work. Windows still recognizes that the card is present in the system, but the...

Part and Inventory Search

Back
Top