I set passwords in access so they can't be opened seperately, how do I specify the password within the asp code when it accesses the DB? Within the code below:
<%
Dim connect
connect = "catalogo_" & base & ""
%>
<%
Set DataConn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.RecordSet")
DataConn.Open connect
Set rsDsp = DataConn.Execute("SELECT * FROM modelos WHERE pagina = '" &pagina& "' ORDER BY referencia,modelo,aplicacion,cartucho,ar,sustuido")
If rsDsp.EOF Then
Response.Write "Sorry, no entries in the database!"
Else
%>
i usually do my connection strings like this...
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(".") & "\data\rob.mdb; User Id=; Password=;"
and then connect the same way you did...this way you don't need a dsn either (which i think is the way you were doing it???)
hope this helps...rob
Thanks but I do need to use dsn. can anyone figure out why the code below gives me an 'Expected end of statement' error?
Set DataConn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.RecordSet")
DataConn.Open = "catalogo_holset","admin","turbott"
i think you want it to look a lil more like this...