Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Error on a fresh install using MySql and a DSN
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

roa360
Starting Member

USA
12 Posts

Posted - 30 July 2009 :  03:53:55  Show Profile
Im getting this

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
snitz/default.asp, line 926

Not really sure whats goin on, I did a search for "line 926" on this forum found nothin.

pls help

thnx

side note: if I run the install using an access database all goes well no error hope that helps.

Edited by - roa360 on 30 July 2009 03:55:47

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 30 July 2009 :  04:18:22  Show Profile
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=67584&SearchTerms=Type,mismatch

default.asp has probably changed since the post above was posted, so they are probably getting the error on the same line of code you are.
Go to Top of Page

ZkilfinG
Starting Member

10 Posts

Posted - 30 July 2009 :  04:25:41  Show Profile
If it's a fresh install with 3.4.07 the issue in the thread RichardKinser posted should be resolved, so I think this is something else. I don't have the forum code in front of me right now though, so I can't check what might be wrong at the moment.

Edited by - ZkilfinG on 30 July 2009 04:25:58
Go to Top of Page

roa360
Starting Member

USA
12 Posts

Posted - 30 July 2009 :  04:29:41  Show Profile
Im reading this and seeing how it could fix the prob if i was using a mysql connection string, but im using a DSN

ive been toying with the code and fount that if I wrap the the var that are type mismatch in Cint() (ex:default.asp line:829 User_Count = Cint(rs("U_COUNT"))) the page loads fine since it is no longer mis matched but i fear this will be an ongoing problem with alot of pages.

I checked the inc_create_forum_mysql.asp and its setting the tables up fine just not pulling it correctly?
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 30 July 2009 :  04:46:44  Show Profile
Why not use a DSN-less (the connection string) connection instead? It will be less hassle for you.
Our fix for this was to change the connection options to the database. With a DSN, all the connection settings are set on the server, which means you would need to ask your host to modify the DSN for you.

If you absolutely don't want to use another connection string or can't, your other option would be to make the same fix you just made, to every type mis-match error you come across in the forum.

Support Snitz Forums
Go to Top of Page

roa360
Starting Member

USA
12 Posts

Posted - 30 July 2009 :  05:05:09  Show Profile
agreed. Fortunately this mysql server is on my home computer so i could make the changes and now its wrking fine. but when i go live i will change the connection string to something DNS-less. thnx for the help
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07