Solved

Connecting to Access database

Posted on 1999-01-22
9
165 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
 

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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Problem to be resolved in this article Currently, development of website and web application can be done without writing thousands of lines of programming code by hand. Description This can be done through by using a open source framework such …
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now