| Author |
 Topic  |
|
|
hopey7
Starting Member
United Kingdom
7 Posts |
 Posted - 09 May 2009 : 12:45:16
|
database type: mySQL
url: www.addleeforum.co.uk/forum/setup.asp
host: pixelinternet.co.uk
forum version: 3.4.07
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=localhost;user=***********;password=*******;DATABASE=************;" '## MySQL w/ MyODBC v3.51
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] Data source name not found and no default driver specified
Hello,
I initially tried to install the forum on a linux server but was getting the above message. After reading the forum, I changed to Windows server but I still have the same error message. I have checked and re-checked the config file but cannot find the problem.
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 09 May 2009 : 16:15:54
|
| have you uncommented the correct strDBType line in your config ? |
 |
|
|
hopey7
Starting Member
United Kingdom
7 Posts |
Posted - 10 May 2009 : 05:09:13
|
| I have uncommented the strDBType line in the config file. |
|
|
|
hopey7
Starting Member
United Kingdom
7 Posts |
Posted - 10 May 2009 : 05:12:19
|
| I posted all that data cos the guideline I read required that I do so. This being my first post I had to follow the guideline strictly. But the values have been changed anyway. Thanks for the advice. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
hopey7
Starting Member
United Kingdom
7 Posts |
Posted - 10 May 2009 : 12:48:37
|
quote:
Originally posted by ruirib
I have been looking at your host. Am I wrong, or MySQL databases are only available on Linux plans? Maybe you are using a MS SQL Server database?
I was initially on the linux server when I experienced the problem. Having read the forums topics and realised that snitz forum won't work on linux, I then changed my hosting plan to Windows server. So I am using MySQL on the Windows server which should be fine, I think!! |
|
|
|
hopey7
Starting Member
United Kingdom
7 Posts |
Posted - 10 May 2009 : 12:51:18
|
quote:
Originally posted by ruirib
Can you post a text version of your config.asp, with the database details (username,password) removed?
The whole of the config.asp file or specific lines? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
hopey7
Starting Member
United Kingdom
7 Posts |
Posted - 11 May 2009 : 16:03:33
|
<!--#INCLUDE FILE="inc_adovbs.asp"-->
<%
'#################################################################################
'## Snitz Forums 2000 v3.4.07
'#################################################################################
'## Copyright (C) 2000-09 Michael Anderson, Pierre Gorissen,
'## Huw Reddick and Richard Kinser
'##
'## This program is free software; you can redistribute it and/or
'## modify it under the terms of the GNU General Public License
'## as published by the Free Software Foundation; either version 2
'## of the License, or (at your option) any later version.
'##
'## All copyright notices regarding Snitz Forums 2000
'## must remain intact in the scripts and in the outputted HTML
'## The "powered by" text/logo with a link back to
'## http://forum.snitz.com in the footer of the pages MUST
'## remain visible when the pages are viewed on the internet or intranet.
'##
'## This program is distributed in the hope that it will be useful,
'## but WITHOUT ANY WARRANTY; without even the implied warranty of
'## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
'## GNU General Public License for more details.
'##
'## You should have received a copy of the GNU General Public License
'## along with this program; if not, write to the Free Software
'## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
'##
'## Support can be obtained from our support forums at:
'## http://forum.snitz.com
'##
'## Correspondence and Marketing Questions can be sent to:
'## manderson@snitz.com
'##
'#################################################################################
Session.LCID = 1033 '## Do Not Edit
Response.Buffer = true
'Anti-ForumPoster code
Dim isSpambot : isSpambot = 0
agent = LCase(Request.ServerVariables("HTTP_USER_AGENT"))
If InStr(agent, "forum poster") > 0 Then isSpamBot = 1
If InStr(agent, "fp.icontool.com") > 0 Then isSpamBot = 1
If InStr(agent, "icontool") > 0 Then isSpamBot = 1
If isSpambot = 1 Then Response.Redirect("http://" & Request.ServerVariables("REMOTE_ADDR"))
'End Anti-ForumPoster Code
Dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix, strFilterTablePrefix '## Do Not Edit
Dim counter, ConnErrorNumber, ConnErrorDesc, blnSetup '## Do Not Edit
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
'strDBType = "access"
strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("dbase/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbase\snitz_forums_2000.mdb" '## MS Access 2000 using physical path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("dbase/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbase\snitz_forums_2000.mdb" '## MS Access 97 using physical path
'strConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("dbase/snitz_forums_2000.accdb") '## MS Access 2007 using virtual path
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "Provider=SQLNCLI;server=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 2005 w/ SQL Native Client
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=localhost;user=user_id;password=password;DATABASE=db_name;" '## MySQL w/ MyODBC v3.51
'strConnString = "driver=MySQL;server=localhost;uid=user_id;pwd=password;database=db_name" '## MySQL w/ MyODBC v2.50
'strConnString = "DSN_NAME" '## DSN
... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 May 2009 : 16:16:01
|
I didn't mean it like that, so I cut it a bit. I don't see anything wrong with it, so I would guess that maybe your host has no MyODBC drivers installed.
Have you talked to the host about it? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
hopey7
Starting Member
United Kingdom
7 Posts |
Posted - 11 May 2009 : 17:21:39
|
| I just got a reply back from my host. They checked it out and suggested I replace MySQL ODBC 3.51 to 5.1 and that has sorted out the problem. Thanks guys for all your help and time. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
