Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

Connecting to Access database

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
Crit
Asked:
Crit
  • 4
  • 3
  • 2
1 Solution
 
PBallCommented:
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
 
MasseyMCommented:
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
 
CritAuthor Commented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
CritAuthor Commented:
also I know the actual path of the database on the server. should I use that instead of the virtual path?
0
 
PBallCommented:
Hehe, MasseyM, a bit more to be #1 expert in the category, eh :)
0
 
CritAuthor Commented:
Everything in my code was ok..............server folder was not set as an application...........
Thanks for all help, though.
Crit
0
 
MasseyMCommented:
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
 
MasseyMCommented:
I am reposting as an answer
0
 
CritAuthor Commented:
thanks for help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now