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)
 Connection Line.....ldb and .mdb		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

lafrentz06
Starting Member

USA
4 Posts
Posted - 11 July 2003 :  01:09:46  Show Profile  Send lafrentz06 an AOL message  Send lafrentz06 a Yahoo! Message
On my connection line:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("lafrentz45mavs06.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/raeflafrentz/db/lafrentz45mavs06.mdb") '## MS Access 2000 on Brinkster

My access file is a .ldb, not a .mdb. In the connection line, I tried to change the .mdb to .ldb, but it still doesn't work. I changed the extension back, so .mdb.

Now my setup for my config.asp, won't work, because the connection line isn't right..

My question:
How do I get the connection line to work? Do I have to change my access file to a .mdb, from the original .lbd? Thanks alot, any help is appreacited...

Neil

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 11 July 2003 :  01:18:38  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Huh?
There should be a snitz_forums_2000.mdb file in the zip you've downloaded.
This is the Access database where all the member information, posts, etc are stored.
The .ldb file is just a temporary file created by access.
BTW - do you get any error messages?
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Edited by - OneWayMule on 11 July 2003 01:19:16
Go to Top of Page

lafrentz06
Starting Member

USA
4 Posts
Posted - 11 July 2003 :  02:00:41  Show Profile  Send lafrentz06 an AOL message  Send lafrentz06 a Yahoo! Message
OKay,
I got that fixes...NOW

Here is my connection lines:
'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("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/raeflafrentz/db/raef45mavs06.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/raeflafrentz/db/lafrentz45mavs06.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'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 = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
'strConnString = "DSN_NAME" '## DSN

I removed the ', from the connection line I wanted, I uploaded my access database into my server, into the /db/. I am using Brinkster, and it STILL doesn't work. Do I need to upload the config.asp, and where?

Thanks,
Neil
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 11 July 2003 :  02:05:18  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Yes, you have to upload the config.asp file to the forum folder.
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

lafrentz06
Starting Member

USA
4 Posts
Posted - 11 July 2003 :  02:14:47  Show Profile  Send lafrentz06 an AOL message  Send lafrentz06 a Yahoo! Message
Which one, the /bd/ or the index folder?
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 11 July 2003 :  02:17:44  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
You should upload all the files from the zip except the .mdb file to a folder where your forum will be located, eg a folder called "forum" or "board".
If you don't have a site there, just the forum, then the index folder should do it.
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

lafrentz06
Starting Member

USA
4 Posts
Posted - 11 July 2003 :  02:19:26  Show Profile  Send lafrentz06 an AOL message  Send lafrentz06 a Yahoo! Message
O, ok...I see now...Let me try it...

Neil
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 1.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07