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

    Is there a way to change ODBC behavior?

    The final verdict on this problem we had is to make sure the most current ODBC release from the vendor is working properly, and not a version that they accidently commented some code out in... Basically we stepped thru numerous versions of the driver to find out that every version prior to the...
  2. ZemogSC

    Is there a way to change ODBC behavior?

    ODBC Directly.
  3. ZemogSC

    Need help with very syntax.....

    I got a type mismatch error.
  4. ZemogSC

    Is there a way to change ODBC behavior?

    Hi all, We've got alot of legacy code and have been doing a major upgrade to our production system, and realzed that we may have to change possibly thousands of lines of code, and of course we're looking for a short cut. The newer ODBC Database we are using has the version 3 ODBC, while the...
  5. ZemogSC

    Is there a way to change ODBC Behavior?

    Hi all, We've got alot of legacy code and have been doing a major upgrade to our production system, and realzed that we may have to change possibly thousands of lines of code, and of course we're looking for a short cut. The newer ODBC Database we are using has the version 3 ODBC, while the...
  6. ZemogSC

    Need help with very syntax.....

    CS is the connect string, It's connecting fine, but it's not finding the correct table in the ODBC DB.(getting a generic -7722 reserved error) Thanks for the input, I'll give them a shot and let you know what happens.
  7. ZemogSC

    Need help with very syntax.....

    Hi all, I don't claim to know much about Access, so be kind. Here's what I've got I've been given some code to convert to work with a newer ODBC driver. THe code runs fine under ODBC2 (the old driver) but no longer works in ODBC3 (new driver). Here's the problem (as far as I can tell): Dim ws...
  8. ZemogSC

    How to reference a component thru code?

    Hey all, I'm writing a console app (this question does not have anything to do with creating a console app, I am aware of the issues involved with that) and have a small problem. As a console app, the project has no forms. So, I cannot use the components to add the winsock functionality. If I do...
  9. ZemogSC

    Question about left outer join...

    Thanks, that explained it very well. I was very confused yesterday :-)
  10. ZemogSC

    Question about left outer join...

    This is a pretty basic question, but I'm having trouble understanding it (Please be kind :-) ). Given the following information: tbl1 has 2,500 rows tbl2 has 55,000,000 rows the UPI for both tables is col1 Will these two SQL statements yield the same results? sel a.c1,a.c2,a.c3 from tbl1 a...
  11. ZemogSC

    Changing case of text?

    I don't know of any way to get the results you are looking for using Teradata SQL. Defining a column as CASESPECIFIC or NOT CASESPECIFIC is as close as I think you are going to get. By your example, it looks like you are trying to have the first letter of each word capitalized. Is this...
  12. ZemogSC

    Where is the spam folder located???

    Thanks.
  13. ZemogSC

    Upgrade from V2R4.1 to V2R5.1

    WE jsut did an upgrade from V2R3 to V2R5 and there were minor problems. Run the reserevd word scriptson yoru system to check for V2R5 reserved words that you may be using in yoru current system. This one will save you some heart-ache later. Another issue we came across is "update by...
  14. ZemogSC

    Where is the spam folder located???

    I opened my email this morning, and saw a very important email get whisked away by Norton AV as spam. I will be changing the settings on how the email is handled in the future, but I need to get that email back, and would like to see what else it has deleted. My system is setup as follows: MS...
  15. ZemogSC

    Fastload EBCDIC from a network attached client?

    I don't think you can do it without converting the file to ASCII first. I may be wrong, and I'm sure someone will correct me, if I am. There are several software packages out their that will do the conversion (EBCDIC <=> ASCII). Some are free, some are not. I can't recommend one, as I have...
  16. ZemogSC

    ODBC Call failing with new TDAT32.dll...

    We just (right before the holiday break) figured out what the problem was with this code, and I'm posting the answer in case anyone is interested. The SqlSetParam function is not mapped properly by the ODBC manager, so old code needs to be changed to the SQLBindParam function call. This will...
  17. ZemogSC

    Novice ? - How to pass args in debug?

    Thanks, that works great!
  18. ZemogSC

    Novice ? - How to pass args in debug?

    Someone sent me some code to test, and it requires arguments to be passed to it at execution time. I know how to do this from a command line (MyProg arg1 arg2 etc), but how do I pass the arguments when doing a debug. I normally rebuild my prog, then use the &quot;step into&quot; method to see...
  19. ZemogSC

    ODBC Call failing with new TDAT32.dll...

    We have a problem with a new installation of TDAT32.DLL. Hopefully someone knows what teh problem is, and can get me on the right track to fix it... Here is our execute command: rc = SQLExecDirect(Hstmt,szSqlStr, cbSqlStr); Here are the values in the variables: Hstmt 0x007f1b48 - szSqlStr...
  20. ZemogSC

    clispb.dat Bad Format???

    We keep getting this error when trying to run BTEQ on a network drive? *** CLI error: CLI2: BADSPB(319): SPB file has bad format. *** Return code from CLI is: 319 *** CLI error: CLI2: BADSPB(319): SPB file has bad format. *** Return code from CLI is: 319 *** Error: Internal error, exiting...

Part and Inventory Search

Back
Top