Solved

Connecting to Access database

Posted on 1999-01-22
9
169 Views
Last Modified: 2013-12-25
I have some pages that are connected to an access database. The pages work fine on my computer (using personal web server), but as soon as I upload the pages to my isp I get an error:
ADODB.Connection error '800a0bb9'

The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

I know the exact path that my access database has on the isp, so I created a file dns on my system, using the same path, I then uploaded the .dns to the server, but I keep getting the above error message. HELP!!!
Crit
0
Comment
Question by:Crit
  • 4
  • 3
  • 2
9 Comments
 
LVL 6

Expert Comment

by:PBall
ID: 1859139
OK, how are you actually connecting to the access database? using databinding? using ASP?

Usually ISP that support ASP will have a online DSN creator that you can use thru a web browser.  At least that is how I created my DSN at intermedia.

0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1859140
Check this:

ADsn.dsn
---------------
[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=512
ImplicitCommitSync=Yes
FIL=MS Access
DriverId=25

TDSN.asp
-------------
<%
  sDB   = "YourDB.mdb"
  sScriptDir = "/Virtual/Path/To/Database/"
  sPath = Server.MapPath(sScriptDir) + "\"
  sDSN = "filedsn=" & sPath & "ADsn.Dsn;DefaultDir=" & sPath & ";DBQ=" & sPath & sDB & ";"
%>

YOurASP.ASP
----------------
<!-- #include Virtual="/CRM/GoldenPlates/TDSN.Asp" -->
<%
      Set conn = Server.CreateObject("ADODB.Connection")
      conn.Open sDSN
%>

rest of ASP... you know then rest....

If you need more help, please let us know.
0
 

Author Comment

by:Crit
ID: 1859141
Massey -
I am on my way out to work to give it a shot, but I was wondering where this path comes from:'CRM/GoldenPlates/TDSN.Asp'
and do I need to create a 'TDSN.asp', and that's all I need on it?
Crit

0
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 

Author Comment

by:Crit
ID: 1859142
also I know the actual path of the database on the server. should I use that instead of the virtual path?
0
 
LVL 6

Expert Comment

by:PBall
ID: 1859143
Hehe, MasseyM, a bit more to be #1 expert in the category, eh :)
0
 

Author Comment

by:Crit
ID: 1859144
Everything in my code was ok..............server folder was not set as an application...........
Thanks for all help, though.
Crit
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1859145
Sorry everyone.  I was in California for the past week.  That is why I have been absent from answering the questions... Mt apologies.

Basically, you include all the files above in the same folder.  Then use the virtual path to the database.  The script will change the virtual path to the physical path and all will work.

0
 
LVL 10

Accepted Solution

by:
MasseyM earned 150 total points
ID: 1859146
I am reposting as an answer
0
 

Author Comment

by:Crit
ID: 1859147
thanks for help
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Remove lines by logo 2 37
remove background quote mark from widget 6 67
ebay seller html tags 2 33
move expression web site to a new server 13 53
"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question