Solved

ODBC Errors

Posted on 2000-03-14
5
320 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
  • 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

832 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