Hi, Just as a reference, this site has every connection string ... Here is the one for using ODBC connection to MSAccess
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForAccess GetSmartPaul On Wed, 12 Jan 2005 14:42:45 +0900, Charles Carroll <[EMAIL PROTECTED]> wrote: > > 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 > > > > > 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/
