<div>
check here for dBase connections<br />
<br />
<a href="http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForDBASE" rel="ugc">http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForDBASE</a><br />
<br />
<br />
oConn.Open &quot;Driver={Microsoft dBASE Driver (*.dbf)};&quot; &amp;&nbsp;_<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&quot;DriverID=277;&quot; &amp;&nbsp;_<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&quot;Dbq=c:\somepath&quot;<br />
<br />
oRs.Open &quot;Select * From user.dbf&quot;, oConn, , ,adCmdText<br />

</div>


check here for dBase connections

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForDBASE [http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForDBASE]


oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
           "DriverID=277;" & _
           "Dbq=c:\somepath"

oRs.Open "Select * From user.dbf", oConn, , ,adCmdText


<div>
I have set up a DSN to the database, does the query string change?
</div>


I have set up a DSN to the database, does the query string change?

<div>
I meant that I have set up a dsn so how does that alter the connection string
</div>


I meant that I have set up a dsn so how does that alter the connection string

<div>
If I understand your question, it should look like this:<br />
<br />
set objConnection=Server.Creat<wbr />eObject(&quot;A<wbr />DODB.Conne<wbr />ction&quot;)<br />
objConnection.ConnectionTi<wbr />meout = 15<br />
objConnection.CommandTimeo<wbr />ut = &nbsp;10<br />
objConnection.Mode = 3 'adModeReadWrite <br />
objConnection.Open strYourDSN<br />
<br />
<br />
where strYourDSN is the name of the ODBC DSN that you created.<br />
<br />
FtB
</div>


If I understand your question, it should look like this:

set objConnection=Server.CreateObject("ADODB.Connection")
objConnection.ConnectionTimeout = 15
objConnection.CommandTimeout =  10
objConnection.Mode = 3 'adModeReadWrite
objConnection.Open strYourDSN


where strYourDSN is the name of the ODBC DSN that you created.

FtB

<div>
<div class="content wysiwyg-content">
Can any of y'all help me out with the query string to a dbf table via &nbsp;odbc. I am implementing this on an ASP page using ADO. Any help will be appreciated.
</div>
</div>


Can any of y'all help me out with the query string to a dbf table via  odbc. I am implementing this on an ASP page using ADO. Any help will be appreciated.

Query String to connect to a DBase(.dbf) database via an ODBC connection

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.