Recent content by Doina

Hi all, I try to access an Accpac Plus system from java, using the jdbc-odbc bridge. I've defined a System DSN using ODBC Link Standard 3.58. The createStatement() function throws an SQLException: The resultset type is not supported. Does anybody know how to fix this? I defined a second System...

HI Smarty, Did you find a solution to the error? I have a similar situation. Thanks, Doina

Hi, You should post your question in a new thread since this is a different subject. Doina

You are missing the "*" from the LIKE operator: WHERE (((Left([All Contacts]![Postcode],2)) Like ([Postcodes].[Postcode]))) Doina

Hi all, Is there a way to create a query in ms-access using a command like: create myquery(custID, custName) as select custID, custName from customers; I need to update an existing ms-access database and I would rather create a VB program to execute this commnad along with other updates...

It works! Thanks, Doina

Hi all, An existing VB project is accessing an MS-Access 97 database and is referencing the "Microsoft DAO 3.5 Object Library". We would like to be able to access the same database but converted to MS-Access 2000 from the same project. I tried to add the reference to "Microsoft...

Hi Mirtheil, It's the NT server that has to be rebooted. I'll check the logs and turn on ODBC tracing. Thanks, Doina

Hi all, I've developed an application with ASP that is connecting through to a remote database (Pervasive SQL running on Novel). Once in a while, the users get the error bellow: "Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Pervasive Software][ODBC Interface][Pervasive...

Hi Ken, No, I can not. I even created a new MS-Access database, a new DSN using ODBC and tried to create a new report. I get the same pwd prompt. More than that, I tried to create a new report, and I selected Database File instead of ODBC for the data source. I get an error 'file type...

Hi, There is a file IMPLODE.DLL in \winnt\system32 folder. It has 19kb in size and Date/Time shows 11/19/1996 12:00am. What program is responsible for this file? Thank you, Doina

Hi Ken, Yes, I can open the file while I'm not Administrator. And I can open the file using a small program called "ODBCTest". It seems that only Crystal Reports has this problem. Thanks, Doina

Hi all, I've written a report in Crystal Reports 7 that reads data from an MS Access database through an ODBC connection. The report used to work. I do not know what got changed, but now this is what happens: -when I try to run the report, it prompts for a pwd to log on to the MS Access...

Ok, I'll do that as soon as I'll have access to the system. Thanks, Doina

No, I have not. I got some instructions from Microsoft on how to unregister/register some .dll files from Program Files\Microsoft SQL\Server\80\Tools\Binn directory. I'm tempted to try that, first. Thanks, Doina