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

    Connecting to DB in Visual Basic

    Phil, Try this: DIM cnnTeradata as ADODB.Connection strConnection = _ "Provider=Teradata;" & _ "DBCName=[ip address of server];" & _ "Database=[database name];" & _ "UID=[UserId];" & _ "Password=[Password];" & _ Set cnnTeradata = New...
  2. bgruver

    Anyone know how to create a DSNless connection to Teradata from VB?

    I figured it out.
  3. bgruver

    Anyone know how to create a DSNless connection to Teradata from VB?

    I'd like to try to connect without using a pre-existing DSN. When I try to open a connection to Teradata from within VB I get the following error: "Provider cannot be found." Any suggestions? Here's my code: oconn.Open "Provider=Teradata;" & _...
  4. bgruver

    Need help with ODBC API call...

    I'm trying to establish a connection to a specific DSN using the ODBC API. Within a call to SQLDriverConnect I pass the value "DSN=MyConectionName;". The call returns successfully and the value of StringLength2Ptr, (the length of the returned value), returns a number, which to me says...
  5. bgruver

    SQLDriverConnect doesn't return a connection string...

    I'm trying to establish a connection to a specific DSN using the ODBC API. Within a call to SQLDriverConnect I pass the value "DSN=MyConectionName;". The call returns successfully and the value of 'StringLength2Ptr ' returns a number, which to me says there is a connection string being...
  6. bgruver

    How to convert numeric fields to character fields...

    Oh, I get it now. I misread your post. I obviously have been misunderstanding the definition of a decimal datatype! You learn something everyday! Thanks Again!
  7. bgruver

    How to convert numeric fields to character fields...

    Tony: Thanks so much for the quick response! I do have a question for you about the decimal. You stated that the (9,2) decimal would only need 10 spaces. Why wouldn't it be 12 spaces (9 digits + decimal point + 2 digits after decimal)? Brian
  8. bgruver

    How to convert numeric fields to character fields...

    I need to create a table in which I'm inserting decimal and integer fields into character defined fields. How can I figure out how big each character field should be? An integer field is 4 bytes, correct? How many character spaces will be needed to hold the largest possible integer value? The...
  9. bgruver

    Is there a TOP function or equivalent in Teradata?

    I'm pretty sure there is no "TOP" function, but was wondering if there is some easy way to do a TOP-like function. Any ideas?
  10. bgruver

    My program isn't appearing in the taskbar...

    I just found the answer by SEARCHING this forum, duh!
  11. bgruver

    My program isn't appearing in the taskbar...

    When I run my compiled .exe file a rectangle with the icon and program name doesn't appear on the taskbar. Isn't this a default setting? Could someone please explain the reason why it's not appearing? Thanks, BG
  12. bgruver

    Is it possible to use a CASE WHEN statement in a where clause?

    If so could someone show me an example of how it's done?
  13. bgruver

    Is it possible to FTP text files from PC to Teradata?

    Are you saying that there is a Windows version of Fastload? The only way I could think of to use fastload via a VB program was through the use of Sendkeys, which I don't want to use. <i>You can FTP the file over to the PC which is running teradata although that still won't get the File inside...
  14. bgruver

    Is it possible to FTP text files from PC to Teradata?

    I can't seem to find any information on this. I'm writing a VB program that needs to transfer text files to Teradata. The only way that I can think of is by sending the file to MVS and then running a Fastload program. Anyone have some suggestions? Thanks, BG

Part and Inventory Search

Back
Top