| Author |
 Topic  |
|
|
JW999
Starting Member
5 Posts |
 Posted - 27 May 2001 : 01:35:42
|
Okay, I am not very knowledgable about setting these type things up, so bear with me. I have uploaded the forum to my remote server, but I don't understand how to complete the next step regarding the "strConnString" part. I do not have SQL access, so which one of the five strings do I select? And what do I place in the string as to the location of my mdb file? As of now, I just have \forum\snitz_forum_2000.mdb. Do I need more than that? Right now, when I try to begin set up, I get a error message stating:
ADODB.Connection.1 error '80004005'
SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified
inc_top.asp, line 42
So what do I need to do to get this going? Thanks in advance.
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 27 May 2001 : 01:43:54
|
what directory is your database in?
this is what you should use:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database_directory/snitz_forum_2000.mdb") '## MS Access 2000 using virtual path
Dayve |
 |
|
|
JW999
Starting Member
5 Posts |
Posted - 27 May 2001 : 01:59:37
|
My directory is in the cgi-bin. So I would put in "/cgi-bin/snitz_forum_2000.mdb"?
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 27 May 2001 : 02:15:45
|
Quick question (because of the INTERSOLV driver): you are on Linux ?
Pierre
Join the Snitz WebRing |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 27 May 2001 : 02:21:08
|
cgi-bin? uhhh, you need a PERL/PHP version of a forum, this one does not work that way.
you may want to check this place out...
http://www.phpbb.com/
Dayve
Edited by - dayve on 27 May 2001 02:21:27 |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 27 May 2001 : 02:30:58
|
quote:
cgi-bin? uhhh, you need a PERL/PHP version of a forum, this one does not work that way.
Just because he has a cgi-bin directory doesn't mean he can't run ASP.
If he couldn't he wouldn't have recieved the errormessage, so he can, only thing he has problems with is installing the database. No need to panic yet though.
Pierre
Join the Snitz WebRing |
|
|
|
JW999
Starting Member
5 Posts |
Posted - 27 May 2001 : 12:01:01
|
My account is on a Linux server, yes.
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 27 May 2001 : 15:45:01
|
I asked because I know using Access on Linux isn't very easy, assuming you also are using Chili!Asp, because you can't use DSN-less connections.
See this info in the online documentation of Chili!Asp:
In addition when you use DB2, Microsoft SQL Server 6.5 and Microsoft Access databases with Chili!Soft ASP for UNIX or Linux, you must use system DSNs in connection strings; you cannot use DSN-less connection strings or file DSNs. For you to use a system DSN for connecting to a particular database, your administrator must create a DSN for the database on the ASP Server. In addition, for SQL Server 6.5 and Access, your system administrator must configure SequeLink, as described in "Configuring SequeLink" in "Chapter 3: Managing Chili!Soft ASP."
(http://www.chilisoft.com/caspdoc/360docs/html/using_frontpage_database_connections.htm)
Pierre
Join the Snitz WebRing |
|
|
|
JW999
Starting Member
5 Posts |
Posted - 27 May 2001 : 18:08:47
|
I have no idea what that last post meant. Anyway, I am now getting this as an error message. It has a different error line mentioned:
ADODB.Connection.1 error '80004005'
SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified
/forum/setup_login.asp, line 58
I have "/cgi-bin/snitz_forum_2000.mdb" listed in the strConnString line; is that right?
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 27 May 2001 : 20:35:43
|
quote:
quote:
cgi-bin? uhhh, you need a PERL/PHP version of a forum, this one does not work that way.
Just because he has a cgi-bin directory doesn't mean he can't run ASP.
If he couldn't he wouldn't have recieved the errormessage, so he can, only thing he has problems with is installing the database. No need to panic yet though.
Pierre
Join the Snitz WebRing
I am a die-hard PERL programmer so when I see cgi-bin I quickly jump to this conclusion which I know was wrong. I do know for a fact that ChiliSoft does not support DSN'less connections so you need to set up a DSN. A DSN is like a virtual name that points to the database location. For example your connection string could look like:
strConnString = "myDB"
myDB would be setup in ChiliSoft to point to the database location...
Dayve |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 May 2001 : 23:17:26
|
You would need to ask your hosting provider to setup a DSN connection for you, if they allow you to have DSN connections. And tell them the location of your database.
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 28 May 2001 : 01:04:55
|
quote:
I am a die-hard PERL programmer so when I see cgi-bin I quickly jump to this conclusion which I know was wrong. I do know for a fact that ChiliSoft does not support DSN'less connections so you need to set up a DSN. A DSN is like a virtual name that points to the database location. For example your connection string could look like:
strConnString = "myDB"
myDB would be setup in ChiliSoft to point to the database location...
JW999,
Dayve is partially right here. Chili!Soft does support DSN less connections but not for Access, Sql Server 6.5 or DB2 (Dayve, it does i.e. work for MySql using a DSN less connection !)
That was what I was trying to explain by pointing to that page at the ChiliSoft site.
What Dayve and Davio say is the only way you'll be able to get Access on Chili!Asp working.
You'll have to ask your hosting provider to setup a DSN for you (they'll know what a DSN is!).
Pierre
Join the Snitz WebRing |
|
|
|
JW999
Starting Member
5 Posts |
Posted - 28 May 2001 : 13:30:33
|
Thanks for the help, but it appears I am out of luck. My service provider told me they do not support Access or DSN connections. The only thing it sounds like I could do was convert the Access database to a DBASE format. Is that feasible? If not, no big deal, I'll look for something else. I like the board format though, so it's disappointing.
|
|
|
| |
Topic |
|
Topic Locked
