Search results for query: *

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

I figured it out.

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;" & _...

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

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

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!

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

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

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?

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

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

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

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

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