| Author |
 Topic  |
|
|
bk
Starting Member
37 Posts |
 Posted - 20 July 2001 : 03:09:22
|
Have been trying to connect to database.
Have forum running fine localy, have uploaded to server and no go.
All read/write permissions have been set.
Have used whereami.asp to determine path.
Using.mdb
Still getting the following errors.
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
and
when trying to update through admin:
ADODB.Connection.1 error '80004005'
SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified
/register/forum/setup_login.asp, line 59
Help would GREATFULLY BE APPRECIATED!!!
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 20 July 2001 : 03:16:51
|
Is this on Linux + Chili!Asp ?
Because in that case you can't use DSN-less connections with Access
Pierre
Join the Snitz WebRing |
 |
|
|
bk
Starting Member
37 Posts |
Posted - 20 July 2001 : 10:33:52
|
No it is IIS
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 20 July 2001 : 11:52:45
|
You did uncomment the strDBType line in config.asp ?
Pierre
Join the Snitz WebRing |
|
|
|
bk
Starting Member
37 Posts |
Posted - 20 July 2001 : 11:57:28
|
Oh yeah..............among other things!!
Do I have to set up a dsn or is this done through the setup file?
Tx,
Brian
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 20 July 2001 : 12:04:22
|
Can you post the strConnString you are using ?
You can use it to connect to the database without using a DSN.
Pierre
Join the Snitz WebRing |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 20 July 2001 : 22:10:52
|
quote:
ADODB.Connection.1 error '80004005'
SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified
That isn't an error you get on an IIS server. He must be on a *nix server running Chili!ASP.
- David |
|
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 21 July 2001 : 00:44:15
|
Reading around, it appears to be a Cold Fusion error. Are you running Cold Fusion?
quote:
Error Diagnostic Information
ODBC Error Code = IM002 (Data source not found and no default driver specified)
[INTERSOLV][ODBC lib] Data source 'court' not found and no default driver specified
Hint: In order to use ODBC data sources with Cold Fusion you must create the data source using the Data Sources page of the Cold Fusion Administrator. In addition, if you are running under Windows NT you must make sure that the Data Source is created as a System DSN in order for it to be available to ColdFusion.
Edited by - Dan Martin on 21 July 2001 00:48:24
Edited by - Dan Martin on 21 July 2001 00:49:14 |
|
|
|
bk
Starting Member
37 Posts |
Posted - 21 July 2001 : 14:25:45
|
These are the two connection strings.strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("http://www.mjbaskets.com/register/forum/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=: /home/sites/site42/web/register/forum/fpdb/snitz_forums_2000.mdb;" '## MS Access 2000
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 21 July 2001 : 14:30:25
|
You can't use a url to point to your database. It has to be a direct path to the database. Go here http://forum.snitz.com/archive/default.asp?catid=11&cattitle=Forum+Setup+Tools and download the "Where Am I?" tool. Extract the script to your database folder and browse to it using your browser. It will tell you the path to your database. You will use that path in your config.asp file.
If your database folder is outsite of your www root, you can place the script in your forum folder and using the path it gives you, you can determine the path to your database.
Then this is what you will have in your config.asp file:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=PATH TO DATABASE;" '## MS Access 2000
Replace the text in red with the path you get from the where am I script.
- David |
|
|
|
bk
Starting Member
37 Posts |
Posted - 21 July 2001 : 15:18:34
|
It is a Linux platform.....is that not good?
|
|
|
|
bk
Starting Member
37 Posts |
Posted - 21 July 2001 : 15:23:48
|
Hi David,
Thanks for your reply.
I have posted two strings. Like you mentioned I already have used whereami to determine path and have used that path in the second string. It doesn't seem to be working either. have i got the virtual and relative paths mixed up?
Thanks,
Brian
|
|
|
|
bk
Starting Member
37 Posts |
Posted - 21 July 2001 : 18:12:20
|
Hi Pierre,
Yes it is on a linux + chili.asp system. Do you know what kind of connection I need to use?
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
|
| |
Topic |
|
Topic Locked
