Search results for query: *

It connected, i found out that the error is on the insert statement not the driver. Thanks, Kiwuji

yes, I think something is wrong with the connection string. Here my configuration function public void configJDBC() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //Driver String URL = "jdbc:odbc:;DRIVER=Microsoft Access Driver...

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

johndweidauer : SourceTable = "DMKIIS_TIIS_MOVEDETL" is an ODBC Link table statically created in Access using Link manager tool. Does make a difference using DAO verus ADO? (performance?) Thanks, Kurz

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

Thank you so much jrbarnett...it works [2thumbsup] kiwuji [afro]

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

Thank you both Creepers and cotton, both method work very good. the only thing i have to upgrade 150 databases :( but it's for a good cause. Thank you again kiwuji

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

Thank you so much drtree, it's working nice 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

this is the error message Unsuccessful execution because DB2 resource limit was exceeded. Resource name = ASUTIME, limit = 000000000030. THX, 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...

Dear Friends, Thank you very much for your replies...everything is working great kiwuji

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