Error 13: Type Mismatch error 
Author Message
 Error 13: Type Mismatch error

I keep getting this type mismatch error on one of my users machines.  I am
not sure why this is happening, but there is a page that suggests that DAO
has a highre priority than Active X data abjects.
http://www.*-*-*.com/

I am not using dao anywhere that Ii know of.  If anyone else has experienced
Error 13 I could use some suggestions.

Thank you,
Bill Rieger



Fri, 23 Jan 2004 21:57:24 GMT  
 Error 13: Type Mismatch error
DO you have the same version (Or higher) of MDAC installed on your users
machine than is on yours development box?

Is DAO referenced in you project (If it were a DAO issue I would expect it
on more than one machine)

When you installed the program did you use the PDW or just copy the EXE to
the machine?

Are you sure the error is occuring on a Data Access portion of the code?
(You could get this error just as easily trying to punch a text value into
a Numeric datatype)

Make sure that the same version or Higher than your machine of the
MSVBVM60.DLL resides on the users machine.

Just a few things. I can think of lots more if we need to that can cause
this error, but most of them have to do with having the proper DLL's
installed, so IF you used the PDW,  make sure the version of MDAC  you
installe don your users machine is the same version as the one you are
running in your development environment (If you installed MDAC 2.5 make
sure to put the file you downloaded in the \\Microsoft Visual
Studio\VB98\Wizards\PDWizard\Redist folder and replace the one that is
there.)

--------------------

Quote:

>Subject: Error 13: Type Mismatch error
>Date: Mon, 6 Aug 2001 09:57:24 -0400
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
>X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

>Newsgroups: microsoft.public.vb.database
>NNTP-Posting-Host: 208.60.35.41
>Path:

cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.yosem
ite.net!nntp-relay.ihug.net!ihug.co.nz!newsfeed.online.be!newsfeed01.sul.t-o
nline.de!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp03
Quote:
>Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:74235
>X-Tomcat-NG: microsoft.public.vb.database

>I keep getting this type mismatch error on one of my users machines.  I am
>not sure why this is happening, but there is a page that suggests that DAO
>has a highre priority than Active X data abjects.
>http://support.microsoft.com/support/kb/articles/Q181/5/42.asp

>I am not using dao anywhere that Ii know of.  If anyone else has
experienced
>Error 13 I could use some suggestions.

>Thank you,
>Bill Rieger



Sat, 24 Jan 2004 00:12:29 GMT  
 Error 13: Type Mismatch error
I have put the latest version of MDAC on all machines.  What I have done is
remove the DAO from my reference list since I am not using it, I don't see
the harm in doing that.  The location is remote so I will have to go there
to reinstall and test.


Quote:
> DO you have the same version (Or higher) of MDAC installed on your users
> machine than is on yours development box?

> Is DAO referenced in you project (If it were a DAO issue I would expect it
> on more than one machine)

> When you installed the program did you use the PDW or just copy the EXE to
> the machine?

> Are you sure the error is occuring on a Data Access portion of the code?
> (You could get this error just as easily trying to punch a text value into
> a Numeric datatype)

> Make sure that the same version or Higher than your machine of the
> MSVBVM60.DLL resides on the users machine.

> Just a few things. I can think of lots more if we need to that can cause
> this error, but most of them have to do with having the proper DLL's
> installed, so IF you used the PDW,  make sure the version of MDAC  you
> installe don your users machine is the same version as the one you are
> running in your development environment (If you installed MDAC 2.5 make
> sure to put the file you downloaded in the \\Microsoft Visual
> Studio\VB98\Wizards\PDWizard\Redist folder and replace the one that is
> there.)

> --------------------

> >Subject: Error 13: Type Mismatch error
> >Date: Mon, 6 Aug 2001 09:57:24 -0400
> >Lines: 12
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
> >X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

> >Newsgroups: microsoft.public.vb.database
> >NNTP-Posting-Host: 208.60.35.41
> >Path:

cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.yosem
ite.net!nntp-relay.ihug.net!ihug.co.nz!newsfeed.online.be!newsfeed01.sul.t-o

- Show quoted text -

Quote:
> nline.de!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp03
> >Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:74235
> >X-Tomcat-NG: microsoft.public.vb.database

> >I keep getting this type mismatch error on one of my users machines.  I
am
> >not sure why this is happening, but there is a page that suggests that
DAO
> >has a highre priority than Active X data abjects.
> >http://support.microsoft.com/support/kb/articles/Q181/5/42.asp

> >I am not using dao anywhere that Ii know of.  If anyone else has
> experienced
> >Error 13 I could use some suggestions.

> >Thank you,
> >Bill Rieger



Sat, 24 Jan 2004 01:02:58 GMT  
 Error 13: Type Mismatch error
When you go there, run Component Checker (see www.microsoft.com\data). It
will tell you if the installation is correct.

--
William (Bill) Vaughn
President Beta V Corporation
www.betav.com


Quote:
> I have put the latest version of MDAC on all machines.  What I have done
is
> remove the DAO from my reference list since I am not using it, I don't see
> the harm in doing that.  The location is remote so I will have to go there
> to reinstall and test.



> > DO you have the same version (Or higher) of MDAC installed on your users
> > machine than is on yours development box?

> > Is DAO referenced in you project (If it were a DAO issue I would expect
it
> > on more than one machine)

> > When you installed the program did you use the PDW or just copy the EXE
to
> > the machine?

> > Are you sure the error is occuring on a Data Access portion of the code?
> > (You could get this error just as easily trying to punch a text value
into
> > a Numeric datatype)

> > Make sure that the same version or Higher than your machine of the
> > MSVBVM60.DLL resides on the users machine.

> > Just a few things. I can think of lots more if we need to that can cause
> > this error, but most of them have to do with having the proper DLL's
> > installed, so IF you used the PDW,  make sure the version of MDAC  you
> > installe don your users machine is the same version as the one you are
> > running in your development environment (If you installed MDAC 2.5 make
> > sure to put the file you downloaded in the \\Microsoft Visual
> > Studio\VB98\Wizards\PDWizard\Redist folder and replace the one that is
> > there.)

> > --------------------

> > >Subject: Error 13: Type Mismatch error
> > >Date: Mon, 6 Aug 2001 09:57:24 -0400
> > >Lines: 12
> > >X-Priority: 3
> > >X-MSMail-Priority: Normal
> > >X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
> > >X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

> > >Newsgroups: microsoft.public.vb.database
> > >NNTP-Posting-Host: 208.60.35.41
> > >Path:

cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.yosem
ite.net!nntp-relay.ihug.net!ihug.co.nz!newsfeed.online.be!newsfeed01.sul.t-o

- Show quoted text -

Quote:
> > nline.de!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp03
> > >Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:74235
> > >X-Tomcat-NG: microsoft.public.vb.database

> > >I keep getting this type mismatch error on one of my users machines.  I
> am
> > >not sure why this is happening, but there is a page that suggests that
> DAO
> > >has a highre priority than Active X data abjects.
> > >http://support.microsoft.com/support/kb/articles/Q181/5/42.asp

> > >I am not using dao anywhere that Ii know of.  If anyone else has
> > experienced
> > >Error 13 I could use some suggestions.

> > >Thank you,
> > >Bill Rieger



Sat, 24 Jan 2004 03:40:17 GMT  
 Error 13: Type Mismatch error
This was posted a while ago so I don't know if you will see this but . . .

I'm getting this error when I am using a class module that I have built.
One class works perfectly the other is almost a carbon copy and uses the
same private declarations.  The one that works is {*filter*}ized code from an
example and the one that doesn't is a copy with modifications in the SQL
sections.  (I never get as far as the SQL sections before I get the error.)

I have a variable declared m_oSearch as CSearch in the general section of
the form.

The variable is used in a button_click.

  m_oSearchRptF.DBConnection = DE01.HDConnect  (It is at this statement that
I receive the error message - Error 13 Type Mismatch.)

CSearch class module:

Public Property Let DBConnection(ByVal oDBConnection As ADODB.Connection)
  Set g_oDBConnection = oDBConnection
  Call LoadSearchConditions
End Property

I have another form that has idential code and it operates flawlessly.  It
doesn't matter if I start the session and run the form that errors first,
its' very consistent, or the one that works first.  One always works and the
other always doesn't.

Any ideas?

N.


Quote:
> DO you have the same version (Or higher) of MDAC installed on your users
> machine than is on yours development box?

> Is DAO referenced in you project (If it were a DAO issue I would expect it
> on more than one machine)

> When you installed the program did you use the PDW or just copy the EXE to
> the machine?

> Are you sure the error is occuring on a Data Access portion of the code?
> (You could get this error just as easily trying to punch a text value into
> a Numeric datatype)

> Make sure that the same version or Higher than your machine of the
> MSVBVM60.DLL resides on the users machine.

> Just a few things. I can think of lots more if we need to that can cause
> this error, but most of them have to do with having the proper DLL's
> installed, so IF you used the PDW,  make sure the version of MDAC  you
> installe don your users machine is the same version as the one you are
> running in your development environment (If you installed MDAC 2.5 make
> sure to put the file you downloaded in the \\Microsoft Visual
> Studio\VB98\Wizards\PDWizard\Redist folder and replace the one that is
> there.)

> --------------------

> >Subject: Error 13: Type Mismatch error
> >Date: Mon, 6 Aug 2001 09:57:24 -0400
> >Lines: 12
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
> >X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

> >Newsgroups: microsoft.public.vb.database
> >NNTP-Posting-Host: 208.60.35.41
> >Path:

cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.yosem
ite.net!nntp-relay.ihug.net!ihug.co.nz!newsfeed.online.be!newsfeed01.sul.t-o

- Show quoted text -

Quote:
> nline.de!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp03
> >Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:74235
> >X-Tomcat-NG: microsoft.public.vb.database

> >I keep getting this type mismatch error on one of my users machines.  I
am
> >not sure why this is happening, but there is a page that suggests that
DAO
> >has a highre priority than Active X data abjects.
> > http://www.*-*-*.com/

> >I am not using dao anywhere that Ii know of.  If anyone else has
> experienced
> >Error 13 I could use some suggestions.

> >Thank you,
> >Bill Rieger



Tue, 04 May 2004 02:52:00 GMT  
 Error 13: Type Mismatch error
What are these 2 objects? is  m_oSearchRptF.DBConnection an ADO connection
and is  DE01.HDConnect a dataenvironment connection object? if so did you
try

 Set m_oSearchRptF.DBConnection = DE01.HDConnect

Scot Rose, MCSD
Microsoft Visual Basic Developer Support

Want to know more? Check out the MSDN at msdn.microsoft.com or the
Microsoft Knowledge Base at support.microsoft.com

This posting is provided AS IS, with no warranties, and confers no rights.

--------------------

Quote:
>Subject: Re: Error 13: Type Mismatch error
>Date: Thu, 15 Nov 2001 11:52:00 -0700
>Lines: 101
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700

>Newsgroups: microsoft.public.vb.database
>NNTP-Posting-Host: te-64-113-215-70.transedge.com 64.113.215.70
>Path: cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp02
>Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:77508
>X-Tomcat-NG: microsoft.public.vb.database

>This was posted a while ago so I don't know if you will see this but . . .

>I'm getting this error when I am using a class module that I have built.
>One class works perfectly the other is almost a carbon copy and uses the
>same private declarations.  The one that works is {*filter*}ized code from an
>example and the one that doesn't is a copy with modifications in the SQL
>sections.  (I never get as far as the SQL sections before I get the error.)

>I have a variable declared m_oSearch as CSearch in the general section of
>the form.

>The variable is used in a button_click.

>  m_oSearchRptF.DBConnection = DE01.HDConnect  (It is at this statement
that
>I receive the error message - Error 13 Type Mismatch.)

>CSearch class module:

>Public Property Let DBConnection(ByVal oDBConnection As ADODB.Connection)
>  Set g_oDBConnection = oDBConnection
>  Call LoadSearchConditions
>End Property

>I have another form that has idential code and it operates flawlessly.  It
>doesn't matter if I start the session and run the form that errors first,
>its' very consistent, or the one that works first.  One always works and
the
>other always doesn't.

>Any ideas?

>N.



>> DO you have the same version (Or higher) of MDAC installed on your users
>> machine than is on yours development box?

>> Is DAO referenced in you project (If it were a DAO issue I would expect
it
>> on more than one machine)

>> When you installed the program did you use the PDW or just copy the EXE
to
>> the machine?

>> Are you sure the error is occuring on a Data Access portion of the code?
>> (You could get this error just as easily trying to punch a text value
into
>> a Numeric datatype)

>> Make sure that the same version or Higher than your machine of the
>> MSVBVM60.DLL resides on the users machine.

>> Just a few things. I can think of lots more if we need to that can cause
>> this error, but most of them have to do with having the proper DLL's
>> installed, so IF you used the PDW,  make sure the version of MDAC  you
>> installe don your users machine is the same version as the one you are
>> running in your development environment (If you installed MDAC 2.5 make
>> sure to put the file you downloaded in the \\Microsoft Visual
>> Studio\VB98\Wizards\PDWizard\Redist folder and replace the one that is
>> there.)

>> --------------------

>> >Subject: Error 13: Type Mismatch error
>> >Date: Mon, 6 Aug 2001 09:57:24 -0400
>> >Lines: 12
>> >X-Priority: 3
>> >X-MSMail-Priority: Normal
>> >X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
>> >X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

>> >Newsgroups: microsoft.public.vb.database
>> >NNTP-Posting-Host: 208.60.35.41
>> >Path:

>cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.yose
m

>ite.net!nntp-relay.ihug.net!ihug.co.nz!newsfeed.online.be!newsfeed01.sul.t-
o
>> nline.de!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp03
>> >Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:74235
>> >X-Tomcat-NG: microsoft.public.vb.database

>> >I keep getting this type mismatch error on one of my users machines.  I
>am
>> >not sure why this is happening, but there is a page that suggests that
>DAO
>> >has a highre priority than Active X data abjects.
>> > http://www.*-*-*.com/

>> >I am not using dao anywhere that Ii know of.  If anyone else has
>> experienced
>> >Error 13 I could use some suggestions.

>> >Thank you,
>> >Bill Rieger



Fri, 07 May 2004 23:17:03 GMT  
 Error 13: Type Mismatch error
Yes, I did try the Set command.  It hated it.

I just found the stupid thing yesterday!  I was checking and re-checking
everything again and a co-worker asked the right question.  I had declared
the variable but had forgotten to instanciate(sp?)  it.

I was missing this statement.
set m_oSearchRptF = New CSearch

I'll don't think I forget to do that again, I spent a lot of time
researching it and never found anything that clearly addressed it.  Must
have been too basic.

Thanks for your time in replying!

N.


Quote:
> What are these 2 objects? is  m_oSearchRptF.DBConnection an ADO connection
> and is  DE01.HDConnect a dataenvironment connection object? if so did you
> try

>  Set m_oSearchRptF.DBConnection = DE01.HDConnect

> Scot Rose, MCSD
> Microsoft Visual Basic Developer Support

> Want to know more? Check out the MSDN at msdn.microsoft.com or the
> Microsoft Knowledge Base at support.microsoft.com

> This posting is provided "AS IS", with no warranties, and confers no
rights.

> --------------------



> >Subject: Re: Error 13: Type Mismatch error
> >Date: Thu, 15 Nov 2001 11:52:00 -0700
> >Lines: 101
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
> >X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700

> >Newsgroups: microsoft.public.vb.database
> >NNTP-Posting-Host: te-64-113-215-70.transedge.com 64.113.215.70
> >Path: cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp02
> >Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:77508
> >X-Tomcat-NG: microsoft.public.vb.database

> >This was posted a while ago so I don't know if you will see this but . .
.

> >I'm getting this error when I am using a class module that I have built.
> >One class works perfectly the other is almost a carbon copy and uses the
> >same private declarations.  The one that works is {*filter*}ized code from
an
> >example and the one that doesn't is a copy with modifications in the SQL
> >sections.  (I never get as far as the SQL sections before I get the
error.)

> >I have a variable declared m_oSearch as CSearch in the general section of
> >the form.

> >The variable is used in a button_click.

> >  m_oSearchRptF.DBConnection = DE01.HDConnect  (It is at this statement
> that
> >I receive the error message - Error 13 Type Mismatch.)

> >CSearch class module:

> >Public Property Let DBConnection(ByVal oDBConnection As ADODB.Connection)
> >  Set g_oDBConnection = oDBConnection
> >  Call LoadSearchConditions
> >End Property

> >I have another form that has idential code and it operates flawlessly.
It
> >doesn't matter if I start the session and run the form that errors first,
> >its' very consistent, or the one that works first.  One always works and
> the
> >other always doesn't.

> >Any ideas?

> >N.



> >> DO you have the same version (Or higher) of MDAC installed on your
users
> >> machine than is on yours development box?

> >> Is DAO referenced in you project (If it were a DAO issue I would expect
> it
> >> on more than one machine)

> >> When you installed the program did you use the PDW or just copy the EXE
> to
> >> the machine?

> >> Are you sure the error is occuring on a Data Access portion of the
code?
> >> (You could get this error just as easily trying to punch a text value
> into
> >> a Numeric datatype)

> >> Make sure that the same version or Higher than your machine of the
> >> MSVBVM60.DLL resides on the users machine.

> >> Just a few things. I can think of lots more if we need to that can
cause
> >> this error, but most of them have to do with having the proper DLL's
> >> installed, so IF you used the PDW,  make sure the version of MDAC  you
> >> installe don your users machine is the same version as the one you are
> >> running in your development environment (If you installed MDAC 2.5 make
> >> sure to put the file you downloaded in the \\Microsoft Visual
> >> Studio\VB98\Wizards\PDWizard\Redist folder and replace the one that is
> >> there.)

> >> --------------------

> >> >Subject: Error 13: Type Mismatch error
> >> >Date: Mon, 6 Aug 2001 09:57:24 -0400
> >> >Lines: 12
> >> >X-Priority: 3
> >> >X-MSMail-Priority: Normal
> >> >X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
> >> >X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

> >> >Newsgroups: microsoft.public.vb.database
> >> >NNTP-Posting-Host: 208.60.35.41
> >> >Path:

>cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.yose
> m

>ite.net!nntp-relay.ihug.net!ihug.co.nz!newsfeed.online.be!newsfeed01.sul.t-
> o
> >> nline.de!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp03
> >> >Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:74235
> >> >X-Tomcat-NG: microsoft.public.vb.database

> >> >I keep getting this type mismatch error on one of my users machines.
I
> >am
> >> >not sure why this is happening, but there is a page that suggests that
> >DAO
> >> >has a highre priority than Active X data abjects.
> >> > http://www.*-*-*.com/

> >> >I am not using dao anywhere that Ii know of.  If anyone else has
> >> experienced
> >> >Error 13 I could use some suggestions.

> >> >Thank you,
> >> >Bill Rieger



Sat, 08 May 2004 01:14:15 GMT  
 
 [ 7 post ] 

 Relevant Pages 

1. Worked fine yesterday, today I get Error 13 Type Mismatch errors

2. Type Mismatch Run-Time error 13

3. Type Mismatch Error 13

4. type mismatch error '13'????

5. Using CurrentDB() receives Type Mismatch Error 13

6. Type mismatch, run-time error #13

7. type 13 mismatch error

8. ACC2000:Run Time Error '13': Type Mismatch

9. Invalid Reference (Error 13 - Type Mismatch)

10. Run -time error '13' Type Mismatch

11. Run-time error '13': Type mismatch

 

 
Powered by phpBB® Forum Software