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 / Classic ASP versions(v3.4.XX)
 Don't think I have the string correct
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Anthrax
Starting Member

Denmark
8 Posts

Posted - 18 July 2003 :  09:22:47  Show Profile  Visit Anthrax's Homepage
Hail to all :)
a very elaborate question :)

first: Pentium 4 northwood, 256 mb Kingston RD ram, gigabyte 8ihxp Mainboard, 2 X barracudea Seagate, Watercooling (cpu+chipset) ATI, radeon 8500 GFX, Terratec Aureon 5.1 sky. Razer 2k mouse and sony screen. That takes care of the hardware.
Running windows 2k

My ISP is cybercity, zyxel 650 router and my homepage host is B-one. for additional information www.b-one.com. it should suports access and mysql.. but I try to use access as it is the only thing I am partly familiar with

But my problem is that I can't seem to get the string correct. Or at least that appears to me as the most logical place I am mistaken. Read and re-read the readme and tried finding posts alike on this forum. I can't find something that I could use.. or appeared to be useful. I am not very skilled in homepaging/forum settings etc.

But here is what I have tried:

first attempt:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

string:

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=/customers/cacophony.dk/cacophony.dk/httpd.www/1/con9ss.mdb" '## MS Access 97

result: 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 : 3001

Second attempt:

'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

string:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/customers/cacophony.dk/cacophony.dk/httpd.www/1/con9ss.mdb" '## MS Access 2000

result:
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 :
SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified

I tried without renaming the forum.. with the same syntaxes.. what am I doing wrong?

I have to forum files in: forum2
the databse is for the time being located in folder: 1
And so is the "whereami" in the folder: 1

Please help.. either here... mail or msn.. msn=my email log on

Kindly

Ant

Ryan
Average Member

USA
858 Posts

Posted - 18 July 2003 :  09:55:41  Show Profile  Visit Ryan's Homepage
First a link to the forum itself would be most productive.
I had tons of trouble doing the connection string but maybe this time I could be of help.
As a side note: as soon as you get the forum working rename the database and the database name in the connection string (to reflect the it) It is not a good idea to post the name of your database. It makes it public. As it is maybe one of the admins or moderators will "hide" it in your post. From now on I recommend doing it like this:
Quote:
quote:
Originally posted by Anthrax:

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=/customers/cacophony.dk/cacophony.dk/httpd.www/1/[MY DATABASE NAME]" '## MS Access 97




The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help

Edited by - Ryan on 18 July 2003 09:56:49
Go to Top of Page

Anthrax
Starting Member

Denmark
8 Posts

Posted - 18 July 2003 :  10:31:48  Show Profile  Visit Anthrax's Homepage
A link to the forum itself? What am I missing? :)
I keep trying to run the "setup.asp" but it won't find the database...

am I missing something else essential?

and I did deliberatly post the file names etc... as I do not intend to use those I posted.. but they will work for the time being till I know how things work.. and for someone to help me make the right lines etc.. :)

Ant..

btw.. I need things with a shovel.. or I won't get it :)

Edited by - Anthrax on 18 July 2003 10:32:17
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 18 July 2003 :  11:10:34  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message
try using this as a connection string:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/1/con9ss.mdb")

The Internet ClubHouse
www.internet-clubhouse.com
Go to Top of Page

Anthrax
Starting Member

Denmark
8 Posts

Posted - 18 July 2003 :  11:22:49  Show Profile  Visit Anthrax's Homepage
attempt:

Inserting the string. so that the line looks as follows:

'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/1/con9ss.mdb")

The result:
The database you are using needs to be upgraded !!

Code : 3704

remembering to remove the "'" gives following result:

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 :
SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified

and I inserted it as the third string in the string lines of the config file..

what do I do.. or what do I do wrong :)
But the last attempt.. when I do not uncheck the ' has yielded more result than the other attempts :)

thanks tho :)
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 18 July 2003 :  12:44:23  Show Profile
You can't use an Access database on a *nix server.

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

Anthrax
Starting Member

Denmark
8 Posts

Posted - 19 July 2003 :  01:30:27  Show Profile  Visit Anthrax's Homepage
Nix server? så I have to use the Sql one instead? or MY sql.. whatever it is that my server suppoerts?

How do I know it is a NIx server? whatever that is?
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 19 July 2003 :  01:48:34  Show Profile
*nix means : Unix/Linux/whatever, just loosely Unix based. You must use mySQL on *nix servers.

Access & SQLServer are only available on Windows-based servers.
Go to Top of Page

Anthrax
Starting Member

Denmark
8 Posts

Posted - 19 July 2003 :  02:12:55  Show Profile  Visit Anthrax's Homepage
Well...
it is saturday morning.. and it seems my database works.. at least I now have a running forum.
So that completes this step.

Thanks to those who helped.. but your troubles are not over yet.. now I am going to start working on customizing it.. and who knows how that will go

but thanks again :)
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.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07