Recent content by Dilyias

The newest versions of IIS still support ASP. I doubt that will go away any time soon. The real power for ASP.net is that you can develop more robust code in less time. Hopefully someone can give you a better answer than this. You also could ask Microsoft.

You could also just check if the string (or the last character) contains any illegal characters and if so truncate it.

First off - why would you want to have your db files on a network drive? You should keep it local or on a san. Yeah you can point it to a different drive. Easiest way for you is to use enterprise manager, right click on the database and do perform a full backup. Then right click on it and...

Could it have something to do with your otype = 'c' ?

In regards to your corruption - do you have the latest SP4 + hotfix? Have you butil save/recover and loaded the affected databases to clean them of the corruptions? I prefer Sql Server to Pervasive 2000i in practically every way except Pervasive is easy maintenence. You just let it sit there...

I'd say quicksort is the best bet. I wrote a quicksort function in QB that was faster than the bubble sort in directqb (asm). :-) I used it in a 3d engine and it didn't even drop the FPS at all.

The only way to directly access memory in QB is via the POKE and PEEK commands. Most QB programs that use QB double buffering use memcopy routines written in ASM or machine code. One method I've seen used is to GET a portion of the screen, and write to the memory of the array used to store the...

There are some IPX routines that can be downloaded from http://www.qb45.com , search the files for 'IPX'. Or search google.com for 'qbasic ipx'.

Actually, I have that part working just fine. I can loop through and transfer the same source table to multiple text files with different names (and, I used the looping example from sqldts.com to get me started :) But when the source table changes (I change the SQL statement to select from a...

I would look at your client access configuration about the connection settings. And look at the ODBC you are using to connect to the AS400. There may be something that differs from your client pc and the server. I've run DTS's on servers no problem with AS400 connections, but I've seen this...

Have you tried using a mapped drive instead of a UNC? Unless you are and it still produces that message.. hmm.

Hi, I am trying to transfer about 30 or so tables from the AS400 to text files via DTS. I CAN do it by manually adding a text connection for each of the 30 text files, but am wondering if there is a simpler way to do this. I have gotten the package to loop via scripts, but after the first...

No, you must encrypt the password on the client end and store the password already encrypted in the DB. Sql server does not allow you to "encrypt" certain fields, etc..

Try running a trace (with the profiler) on queries that take a long time (or > 1000 msecs or something) , look at the ones that occured during the time of the slowdown...

Probably some incorrect joins (linked tables) . I Would create a new temp report with just one of the tables, test run it, then add the next table, test run it, etc.. to find out what table/join is causing the duplication. Or build a test query of the same joins you use in your report. -Eric