Connecting to an access database problem

[jijk5]

Hi,
well, i have a problem connecting to an access database, that made me so desperate, cuz i tried many ways, but all failed..
first, i'm not a professional. just a beginer..

i made a multiple choice test, which get the data from a database.
My database name is "VBQUIZ1.mdb"
and i tested it by IIS on my computer, and oh yeah, it works :) , now the time to publish it on the site, but oh no, it doesn't work :eek: :( .

i tried many way to connect to the database, with DSN or without DSN, or using physical path.
but all the time i recieved many error messages.

The ODBC DSN that i attached the database to it, its name "VBQUIZ1123"

What shall i do??


bellow the code that i recently tried, i tried before many many ways, but that was months ago, ( oh i have the problem since a long time ago :rolleyes: )

<% Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open"DSN=DSNname" %>

and thats the code for me
<% Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open"DSN=VBQUIZ1123" %>

and thats the error
Microsoft VBScript runtime error '800a01a8'
Object required: '[undefined]'

/ReportM2/UG73/VBQUIZTF.ASP, line 53

i changed the Server name from "Server" to the the host name server but still same error.
also my database size is 3.6 mb.

Is there some thing wrong with the code?

Can any one help me please..

[Ubik]

Try something like this:


set objWgRS = Server.CreateObject("ADODB.Recordset")
objWgRS.ActiveConnection = "dsn=strMyDSN;ServerName=strMyServerName;UID=strMyUsername;PWD=strMyPassword;"
objWgRS.Source = SQL
objWgRS.Open()
aMyArray = objWgRS.GetRows
objWgRS.Close
Set objWgRS = Nothing

[russell_g_1]

here's an example of a dsn-less connection string

connstr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & server.mappath("VBQUIZ1.mdb") & "';User Id=admin;Password=pwd;"

(assuming your database is in the same folder as your page)

take a look at http://www.connectionstrings.com if you want some other examples.