VB 6 ADO SQL server 7

[DougP]

I created a program that uses all of the above and also Interacts with AutoCAD 2000 through VBA

It works perfect on my machine.

When I go to run it on other PC's I get an Error number 429
Active X component can't created objects.
and also Error 430 on another machine.

I suspect it comes from a reference to the ADO
I created an install program using the Wizard but it still won't work. The install procedure say's several files are out of date and asks to update and I do and reboot. It even shows the Microsoft Data Objects 2.0 which is the latest ODBC stuff right.

Any help would be apreciated I would hate to have to go back to DAO and Access which is where it was working before this.
And worked OK on those PC's

TIA

 

[asotmhg]

Have you tried installing DCOM98 or DCOM95, depending on the operating system, on the PC that gets the error number 429? You can get these from Microsoft's Website:

http://www.microsoft.com

 

[DougP]

Sorry I figured the problem out. I am using NT 4.0 BTW.
I installed MDAC 2.5 which is the newset version of ODBC and ADO on My NT workstation. So when I went to the others they of course did not have it. and I did not know that and making install CAB setup files does not include it either. So I read in documentation snooping around trying to find it again.
I tried several things before I remembered (See below). Then I thought well maybe I have to Create a SQL Server DSN cause I have one on My PC. Even though the ADO code I am using is DSN-less.

That's when I noticed that their machines had SQLSRV32.dll version 3.6 xxxx when I was making a System DSN on one machine. Mine has version 3.70.08.20 which is the latest one.
So then I remembered installing the MDAC thingy on both our NT server running SQL Server 7, and My PC.

After 1 hour of hunting for that file not knowing the name again on Microsofts site I found it.
The file you want is mdac_typ.exe if you are interested in using the latest drivers for ODBC to SQL and ADO and whatever it puts on.

But keep in mind that if you create Installable copies that th ecorect latest versions are NOT going to be included in the CAB files.

 

[chiph]

Doug -

I wrote a FAQ about this in the Visual Basic - Databases forum.

Chip H.

 

[DougP]

Sorry I did not find it!!!! your FAQ