| Author |
 Topic  |
|
Leodemario
Starting Member
Brazil
34 Posts |
 Posted - 28 January 2007 : 23:05:49
|
Hello.
I have read all posts about MySQL but not solve the problem.
I have a Snitz forum with SQL Server 2K5 running fine, now I try to install the same forum with MySQL Server 5.0.27-comunity-nt and receive the folowing error message:
----------------------------------------------------------
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
[Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado
-----------------------------------------------------------
I have tryed all options in:
strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
--------------------------------------------------------------
and in the other strConnString but received ever the above message. 
 I have a phpbb2 and phpbb3 forums running in the same machine and he works fine with the MySQL Server.
What can be wrong
Since now many thanks |
The stairs of Humility have low and large degrees, the one of pride, high and strait degrees... |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 28 January 2007 : 23:56:08
|
| Not to be insulting, but did you check to make sure you had the right strDBType uncommented? |
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 29 January 2007 : 00:45:51
|
And since you're speaking english, please post the error in english.
But it sounds like it has something to do with the driver. |
Support Snitz Forums
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 29 January 2007 : 00:54:43
|
| One more comment, are the myODBC drivers installed on the web server? |
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 January 2007 : 04:27:09
|
quote:
Originally posted by AnonJr
Not to be insulting, but did you check to make sure you had the right strDBType uncommented?
It's the standard error message stating that the data source name was not found and no standard driver was specified.
I think Doug G's advice was probably right on the money, it seems MyODBC is not installed... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 29 January 2007 : 04:31:19
|
Well at least I got the driver part right. It was the MyODBC drivers. Do I at least get a dollar?  |
Support Snitz Forums
|
|
|
|
Leodemario
Starting Member
Brazil
34 Posts |
Posted - 29 January 2007 : 08:41:28
|
AnonJr has not insulted me, I have uncommented the line: strDBType = "mysql"
Davio the message is:
Data source name not encountered and no default driver specifyed.
Doug G I have 2 forums phpbb instaled in the same machine using MySQL Server, when I install MySQL Server in the machine the myODBC drivers is not installed
ruirib The truth is: the 2 phpbb's forums run in the Apache Web Server but he are using the myODBC driver not?
Davio Peace  |
The stairs of Humility have low and large degrees, the one of pride, high and strait degrees... |
Edited by - Leodemario on 29 January 2007 12:14:35 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Leodemario
Starting Member
Brazil
34 Posts |
Posted - 29 January 2007 : 13:26:34
|
Ok ruirib many thanks! I go to mysql.com.
Now I understand the origin of my problems with IIS and MySQL.
Thank You Again. |
The stairs of Humility have low and large degrees, the one of pride, high and strait degrees... |
|
|
|
Leodemario
Starting Member
Brazil
34 Posts |
Posted - 29 January 2007 : 14:11:08
|
Ufa! The worst than the atomic bomb is the ignorance.
Now the setup.asp page run but I receive a error message:
The Installation has NOT been completed !
There were 11 Critical Errors...
But I think wich this trouble have solution in other post. |
The stairs of Humility have low and large degrees, the one of pride, high and strait degrees... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Leodemario
Starting Member
Brazil
34 Posts |
Posted - 29 January 2007 : 14:41:05
|
I have deleted the strSql ok?
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'F_DESCRIPTION' can't have a default value
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Invalid default value for 'MEMBER_ID'
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Invalid default value for 'MEMBER_ID'
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Invalid default value for 'MOD_ID'
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Invalid default value for 'REPLY_ID'
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Invalid default value for 'TOPIC_ID'
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Invalid default value for 'COUNT_ID'
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'familia2.forum_members' doesn't exist
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'familia2.forum_forum' doesn't exist
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'familia2.forum_topics' doesn't exist
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'familia2.forum_totals' doesn't exist
Thanks in Advance. |
The stairs of Humility have low and large degrees, the one of pride, high and strait degrees... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 29 January 2007 : 15:13:10
|
quote:
Originally posted by ruirib
Are you using a 3.4.06 version? I thought the default errors were removed from that one...
It was. Although the F_DESCRIPTION error exists in the current version. Don't know if that was reported before or not, or if I had just missed it. |
Support Snitz Forums
|
|
|
|
Leodemario
Starting Member
Brazil
34 Posts |
Posted - 29 January 2007 : 15:32:33
|
The version of my forum is 3.4.04 and I have substitued the inc_create_forum_mysql.asp by the 3.4.06 version and the error list diminished for 5 errors.
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'F_DESCRIPTION' can't have a default value
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'M_SIG' can't have a default value
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'M_SIG' can't have a default value
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'familia2.forum_members' doesn't exist
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'familia2.forum_forum' doesn't exist |
The stairs of Humility have low and large degrees, the one of pride, high and strait degrees... |
|
|
|
Leodemario
Starting Member
Brazil
34 Posts |
Posted - 29 January 2007 : 16:05:40
|
Ok, for now I have removed the DEFAULT '' in the CREATE statements and the setup is completed with no errors.
But I go to set the dbs setups why my forum is the Image forum 2001 with various MOD's wich I have installed, and various modifications in the asp files for styles changes. Next I make a complet test in the forum functions and make a report in case of faults.
Thank You teachers!  |
The stairs of Humility have low and large degrees, the one of pride, high and strait degrees... |
|
|
|
Topic |
|
Topic Locked
