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: General / Current Version (Old)
 I can't get it to work..help!!!		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Duch
Starting Member

3 Posts
Posted - 25 March 2001 :  07:15:26  Show Profile
Hi.. i have a problem.
my isp says that i need to make this script to connect to mysql server...

<%
SQLserveradr="mysql.trab.dk"
SQLdatabase="your_database"
SQLlogin="your_username"
SQLpassword="your_code"

Set RS = Server.CreateObject("ADODB.Connection")

conStr = "driver={MySql};server="& SQLserveradr &";database="& SQLdatabase
conStr = conStr & ";uid="& SQLlogin &";pwd="& SQLpassword & ";OPTION=16386"

RS.Open conStr

' Your code

RS.Close
Set RS = Nothing
%>

and when i just put in the info snitz forum asks for i get this...

There has been an error !!

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 : -2147467259


Click here to retry.

I hope that someone will be abel to help :)



RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 25 March 2001 :  07:45:37  Show Profile
Here is what I use on my account at trab.dk:


'#################################################################################
'## 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!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\database\v32a6.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
strConnString = "driver=MySQL;server=mysql.trab.dk;uid=richard;pwd=********;database=richard" '## MySQL
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 25 March 2001 :  07:51:46  Show Profile
looks like they may be having some problems with the MySQL Server right now.

I am getting this message when trying to access my forum:


Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
 
[TCX][MyODBC]Unknown MySQL Server Host 'mysql.trab.dk' (0) 
 
/forum/inc_top.asp, line 48
Go to Top of Page

Duch
Starting Member

3 Posts
Posted - 25 March 2001 :  08:01:26  Show Profile
Ok.. i have put it like this.

'#################################################################################
'## 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!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
strConnString = "driver=MySQL;server=mysql.trab.dk;uid=sonol;pwd=******;database=sonol" '## MySQL

but it still dont work..
Go to Top of Page

Duch
Starting Member

3 Posts
Posted - 25 March 2001 :  08:04:43  Show Profile
when i shall run the setup.asp it is done like this..
http://xxxxx.trab.dk/forum/setup.asp
right ??
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.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07