Connection to Database problem

[ev14n]

Hi,

I have a problem when testing my web, logging in.

The error messages shown is:
unspecified error
line 30

Which is should be found around here:
ConnStr="DRIVER={Microsoft Access Driver (*.mdb)}"
ConnStr=Connstr & "DBQ=" & Server.MapPath ("db\password.mdb&quot
MyCon.Open (ConnStr)

Anyone know what the error is?

Thanks in advance,
-EvIaN-

 

[Mighty]

Try leaving out the parenthesis around ConnStr.

i.e.

MyCon.Open ConnStr Mise Le Meas,

Mighty

 

[ev14n]

Nope.. i don't think it works...
Thanks anyway..
-EvIaN-

 

[Shuchi]

Hi ,
Try this and let me know
set db=Server.CreateObject("ADODB.Connection&quot
db.ConnectionString="DBQ=c:\test\itpdb.mdb;Driver=Microsoft Access Driver (*.mdb)"
db.open

 

[Mighty]

You are missing a emi-colon in your connection string. Try the following:

Dim MyCon
set MyCon = Server.CreateObject("ADODB.Connection&quot
ConnStr="DRIVER={Microsoft Access Driver (*.mdb)}; "
ConnStr=Connstr & "DBQ=" & Server.MapPath ("db\password.mdb&quot
MyCon.Open ConnStr

Mise Le Meas,

Mighty

 

[jonscott8]

First, try seperating the DRIVER & DBQ arguments with a semicolon.

Next, see

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q251254

Last, try doing a compact -n- repair on your database, it may have reached max capacity. Jon Hawkins

 

[ev14n]

Sorry I forgot somthing.. I'm using Windows 2000, does it make any difference?

 

[krappleby025]

ok do the following


1.. make sure the actual database, has authorisation for IUSER(blahblahblah) to write to, this is normally what happens to me, do this by going to the actual database, using my computer, and right click, choose security, and make sure the option for the above user is their and set for read & write permissions... if not add it from the database...
2.. use the following code

<%
dim con
Set con = server.Createobject( &quot;ADODB.Connection&quot; )
Con.Open( &quot;DRIVER={Microsoft Access driver (*.mdb)}; DBQ=&quot; & server.MapPath(&quot;db\password.mdb&quot; ) )
%>
place your page here
<%
con.close
set con = nothing
%>

changing Con to the coding you want

3.. Hopefully that will solve the problem, if not contact me i will help all i can