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 Wanet Telecoms Ltd 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: *

  • Users: bgruver
  • Content: Threads
  • Order by date
  1. 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;" & _...
  2. 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...
  3. 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...
  4. 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...
  5. 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?
  6. 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
  7. 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?
  8. 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