| Author |
 Topic  |
|
|
phylhamlyn
Starting Member
Germany
6 Posts |
 Posted - 15 June 2001 : 14:14:54
|
Hi
i am trying to set up the forum but not usre what line to put for strConnString.
I have used whereami.asp but still no luc.
Can anyone help please.
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=/home/sites/site7/web/_vti_bin/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
'c = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
|
|
|
phylhamlyn
Starting Member
Germany
6 Posts |
|
|
BlueBallz
Starting Member
9 Posts |
Posted - 16 June 2001 : 11:28:11
|
use strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/(dir where db is)/snitz_forums_2000.mdb") if you are using Access 2000.....
or if uing 97 then use
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("(dir where db is)/(97 ver. of Database)")
I havn't tried the second because i don't have a 97 ver of the db...Anyone got this version?
|
 |
|
|
phylhamlyn
Starting Member
Germany
6 Posts |
Posted - 16 June 2001 : 14:49:10
|
Hi,
I still don't get any results
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("(/home/sites/site7/web/_vti_bin/snitz_forums_2000.mdb)/(97 ver. of Database)")
is this right?
Somehow, I need to get the access database part to work
phil
Edited by - phylhamlyn on 16 June 2001 15:31:25 |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 16 June 2001 : 15:50:06
|
No, try
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("/home/sites/site7/web/_vti_bin/snitz_forums_2000.mdb")
Though even if this works I expect that you get a new error where it says you need to have an updatable query.
Judging by the url you posted this is a Frontpage managed web.
There should be a directory called fpdb, that is the correct place to put the database.
If that directory was below the web directory you would then use:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("/home/sites/site7/web/fpdb/snitz_forums_2000.mdb")
Pierre
Join the Snitz WebRing |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 16 June 2001 : 15:53:00
|
Just a wild guess, are you trying to install this on http://www.hamilton-perroud.com/ ?
And if so, could that be a Linux server with Chili!Asp ?
Because in that case I've got bad news:
You can't use DSN-less connections to an Access database on Chili!Asp, you're only other option in that case would be to connect to a Sql Server or MySql database.
Pierre
Join the Snitz WebRing |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 16 June 2001 : 15:54:31
|
quote:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("(/home/sites/site7/web/_vti_bin/snitz_forums_2000.mdb)/(97 ver. of Database)")
I don't get the extra parentheses unless you were putting them in for illustration. Also, _vti_bin is a Frontpage internal folder, not a user folder, and shouldn't be in the url.
Try something like this, assuming your database file is in a folder 'fpdb':
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("/home/sites/site7/web/fpdb/snitz_forums_2000.mdb")
If you are using the snitz_forums_2000.mdb that came with the download, it is an Access 97 database file.
======
Doug G
====== |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 16 June 2001 : 15:55:37
|
Gor, you apparently type faster! :)
======
Doug G
====== |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 16 June 2001 : 15:59:25
|
quote:
Gor, you apparently type faster! :)
I think less 
Pierre
Join the Snitz WebRing |
|
|
|
phylhamlyn
Starting Member
Germany
6 Posts |
Posted - 16 June 2001 : 16:20:17
|
thanks for your fast replies.
whats special about the fpdb folder? - and as my provider uses Chilisoft asp, whats the best solution from here. I only really know Access 97 database. Can I not use this at all?
I recently changed provider so that I could use ASP pages :(
is there a quick solution?
Cheers
Phil
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 16 June 2001 : 16:46:20
|
quote:
thanks for your fast replies.
whats special about the fpdb folder? - and as my provider uses Chilisoft asp, whats the best solution from here. I only really know Access 97 database. Can I not use this at all?
I recently changed provider so that I could use ASP pages :(
is there a quick solution?
All I know, from the Chili!Asp documentation, is that you can't connect to them without DSN. You could see if you provider is willing to setup a DSN to the database for you.
That's about all the all the options I can think of besides checking if they offer MySql or Ms Sql Server support (which probably isn't free).
Pierre
Join the Snitz WebRing |
|
|
|
phylhamlyn
Starting Member
Germany
6 Posts |
Posted - 17 June 2001 : 10:01:41
|
Now I am stuck
Is there a good provider which will let me use ASP and Snitz forums (providing I can work it all out)!!
thanks in antipation
8D
|
|
|
| |
Topic |
|
Topic Locked
