Search results for query: *

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

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

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

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 "step into" 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...

I have an app that I would like to start as a service. I want the app to start when the machine is turned on, and not be dependent upon someone actually logging on to the machine for it to start. We were starting the app by putting it in the startup folder, for allusers, but this weekend we...

We have some in house applications that we run (VC++) that have been running fine for years. We recently upgraded our ODBC version from 02.06.00.03 to 03.02.00.00 and they are all failing miserably. (DBC Version from V2R3 to V2R5) Does anyone know of any "major" changes to the driver...

I'm baffled, and hopefully someone can help me out. We use a pass through query to get results from our main dataabse. We then have other queries that call this query to produce different reports. Here is an example: SELECT BEGRNGNR (FORMAT '999999999999') (CHAR(8)) BEGIN_CHAR8, BEGRNGNR...

How difficult is it to do a backup from a V2R3 (5100) system and restore to a V2R5 (4475) system? We re planning on doing this in the near future, and I want to see if anyone knows what all it involves and what problems may arise. The reason we're doing this instead of NPARC (or other similar...