Search results for query: *

I am tryin to to setup an application to connect to MS Access without having to setup DSN from control panel every time that take the application to another machine. this is the Driver code but it's not working ... Any Suggestion!!! Thanks, Kiwuji...

I am developing an application that transfer files amoung peers, client/server , using socket. The requerement for the project is to send request to other peer using xml file. Several things are happening that's driving me crazy. Here are the scenerios: 1. When I connect to my own peer (setup...

I've working getting data from DB2 using VB codes. The code that I wrote works for a while (about 3 - 4 minute), then i get a message that say "ODBC call failed" If anybody knows how to fix my code to prevent ODBC failure, please HELPPPPP!!!!!! code: Public Function TransferMonth()...

Hi everyone, I've been stuck with this problem all day, may be someone can help Scenerio: 1. I have three database A, B, C -- A is on my hard-drive -- B is the production database -- C is the backup of the production database 2. database A feeds database B by importing...

Does anyone know how to automate Compact and Repair utility add-ins? Is there a way to write codes that would automatically execute the compact & repair utility? Please Help...Thank you kiwuji

I have a query that retrieve month from database but i want the single digit number to be pad with a leading zero. this the query select Month(date()) as [MONTH] from TABLENAME currently returns 1 to 9 i want it to return 01 to 09 Thanks, kiwuji

I m tryin to execute the following query but i get an exceed resource error. is there any way i chance the resource limit, or may change my query around.... This is the query: SELECT YEAR(ACCRUAL_DATE), MONTH(ACCRUAL_DATE), SC, OJ, ONR, OC, ONRMP_ST, OFC, OFST, FFRT, OFFRD, CSNE_CITY, TCND...

I m trying to retreive data from a table and the date field in the table are defined as charter. so i figure if i can extract just the month and year portion of current_date and converted to character, everything should work...but i m getting errors after error. this is the query: SELECT...