Recent content by LinuxKommy

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...

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 :)

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...

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...

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...

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...

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.

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...

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...

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...

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...

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

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 & "'...

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

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