Solved

ODBC Errors

Posted on 2000-03-14
5
324 Views
Last Modified: 2012-06-27
Hello,
I've written an app in VB 6 that is basically a search program of a foxpro file (dbf).  The program connects to the datasource via ODBC.
The program works fine on the development machine.  When I create the setup program (via the package and depolyment wizard) and then run it on a test machine, everything works fine except that whenever a request is made of the dbf file it generates the error:

Err.number = 713
err.decription = Application defined or object defined error

I suspect it is an ODBC thing.  Both ODBC links and set up in excatley the same way with the same driver versions.

So, is there a way I can fix this, or is there a way I can verify the ODBC link in the code so that I get more sensible error messages?
Malcolm
0
Comment
Question by:trevena
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 

Author Comment

by:trevena
ID: 2617996
On another machine a get the following error when a database request is made:

err.number =429
err.description = ActiveX component can't create object

Don't know if this will help or not
0
 

Accepted Solution

by:
martingp earned 200 total points
ID: 2618014
Hi Trevana

I have had the same problem. I found out that I needed to include the Msdbrptr.dll in my setup package.

Open your project, and include a reference to the Msdbrptr.dll file. This file is listed as Microsoft Data Report Designer v6.0 in the References dialog box. You may see Microsoft Data Report Designer v6.0 listed more than once. Make certain that the file associated with the reference is Msdbrptr.dll. Once the reference has been verified, rebuild your setup package.
0
 

Author Comment

by:trevena
ID: 2618220
Hi,
That didn't work (sigh)...

The references I do have are:

Visual Basic For Applications
Visual Basic runtime objects and procedures
Visual Basic objects and procedures
Microsoft Data binding Collection
Microsoft Active X Data Objects 2.0 Library
Microsoft Data Formatting Object Library
and the newly added
Microsoft Data report Designer v6.0

Are there (perhaps) any others I should have.
0
 

Author Comment

by:trevena
ID: 2618369
Hi,
I put the all the project items (forms, Data Env etc) into a new project, recomplied and run the deployment wizard and it worked!

Two problems though:
1. The cab file is about 10(!) meg.
2. it only worked on one machine.

I can get around (1).

When I ran setup on another machine it ran the setup program for Microsoft Data Access Components 2.0, which is fine.  After the DAC setup program had nearly finished, it gave two error messages which were:

msdasc.dll was unable to register itself in the system registry

and

sqloledb.dll was unable to register itself in the system registry

The first setup program ran fine after these errors, but the program itself died horribly when the .exe was run.

So, how can I get around this one?

Malcolm
0
 

Expert Comment

by:ysivaram
ID: 2618771
I found this reference in MS Knowledgebase article Q194197 Hope this helps Also try to build your distribution after installing Visual Studio Service Pack 3

You can work around this issue by installing Distributed Component Object Model (DCOM) for Windows 95 or Internet Explorer version 4.0 or later.

You can install DCOM for Windows 95 (DCOM95) from the following Web address:

http://www.microsoft.com/COM/resources/downloads.asp

You can install Internet Explorer 4.0 or later from the following Web address:

http://www.microsoft.com/ie/download/windows.htm




0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question