Search results for query: *

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

ODBC Directly.

I got a type mismatch error.

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

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

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.

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

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

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

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

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

Thanks.

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

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

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

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

Thanks, that works great!

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

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

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