All of you using the DBQ connection string that connects via ODBC. strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" strconn=strconn & server.mappath(accessDB) & ";" 'strconn=strconn & "Password=whatever;"
is the better way as http://www.learnasp.com/learn/dbopen.asp documents in fair detail and links to all KB articles and other sites that discuss the WHYs. NOTE: An ODBC connection string to Access often results in the dreaded: Unable to open registry key or 'Unspecified Error' usually occurs with an ODBC connection string to Access, i.e. I have proven on my site time and time again that if one connects with DBQ the connection will fail mroe frequently. ODBC is just a less scalable driver technology that has many bottlenecks and problems. On Wed, 12 Jan 2005 05:33:18 +0000 (GMT), suba shini <[EMAIL PROTECTED]> wrote: > hai , > > this is from selvam i give some idea pls try this > > dbname=("../db/users.mdb") > set conntemp=server.createobject("adodb.connection") > cnpath="DBQ=" & server.mappath(dbname) > conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath > > regards > selvam > > > > > > > Charles Carroll <[EMAIL PROTECTED]> wrote: > Never use the DBQ settings. Leads to intermitten errors. > > http://www.learnasp.com/learn/dbopen.asp > is the one you want to use as a model for connecting to Access. > > > On Tue, 11 Jan 2005 17:05:05 -0000, sheriff <[EMAIL PROTECTED]> wrote: > > > > im trying to solve the prob by using this: > > > > set conn=Server.CreateObject("ADODB.Connection") > > conn.Provider="Microsoft.Jet.OLEDB.4.0" > > conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & > > Server.Mappath("../db/users.mdb") & ";" > > > > BUt got Another Error: > > > > Microsoft JET Database Engine error '80004005' > > > > Could not find installable ISAM. > > > > /module/comment.asp, line 28 > > > > > > wat do u think could have caused this. > > > > > > thanx > > > > > > > > > > ________________________________ > > Yahoo! Groups Links > > > > To visit your group on the web, go to: > > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > > > To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > --------------------------------- > ALL-NEW Yahoo! Messenger - all new features - even more fun! > > [Non-text portions of this message have been removed] > > > > ________________________________ > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
