ODBC Errors

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
trevenaAsked:
Who is Participating?
 
martingpConnect With a Mentor Commented:
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
 
trevenaAuthor Commented:
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
 
trevenaAuthor Commented:
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
 
trevenaAuthor Commented:
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
 
ysivaramCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.