VB & Database, Error 13: Type Mismatch error

Error 13: Type Mismatch error

Author	Message
Bill Riege #1 / 7	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

Scot Ro #2 / 7	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

Bill Riege #3 / 7	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 - Hide quoted text - - 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

Bill #4 / 7	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 - Hide quoted text - - 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

Logicmysti #5 / 7	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 - Hide quoted text - - 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

Scot Ro #6 / 7	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

Logicmysti #7 / 7	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

Page 1 of 1

[ 7 post ]