<div>
Hi,<br />
<br />
I would recommend to use the SQLNCLI driver instead (must be installed on Windows XP machines, not available by default).<br />
<br />
Moreover you should make sure that TCP/IP is enabled on the SQL Server if you access the server by IP address.<br />
You can find examples of connection strings here:<br />
<a href="http://www.connectionstrings.com/sql-server-2005#p2" rel="ugc">http://www.connectionstrings.com/sql-server-2005#p2</a><br />
<br />
There is also an example of how to use the IP address.<br />
<br />
And I hope that this string was only an example and you don't really try to connect to the SQL Server using the &quot;sa&quot; account...:-)<br />
<br />
Cheers,<br />
<br />
Christian<br />

</div>


Hi,

I would recommend to use the SQLNCLI driver instead (must be installed on Windows XP machines, not available by default).

Moreover you should make sure that TCP/IP is enabled on the SQL Server if you access the server by IP address.
You can find examples of connection strings here:
http://www.connectionstrings.com/sql-server-2005#p2 [http://www.connectionstrings.com/sql-server-2005#p2]

There is also an example of how to use the IP address.

And I hope that this string was only an example and you don't really try to connect to the SQL Server using the "sa" account...:-)

Cheers,

Christian


<div>
<div class="content wysiwyg-content">
In Access 2007, (trying to access SQL Server) I have the following code:<br />
&nbsp; &nbsp; Dim cn As New ADODB.Connection<br />
&nbsp; &nbsp; Dim strCN As String<br />
&nbsp; &nbsp; strCN = &quot;Provider=SQLOLEDB;Server=<wbr />10.10.10.1<wbr />;&quot; &amp;&nbsp;_<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&quot;Initial Catalog='Websites';User ID=sa;PWD=xxxxxxxx&quot;<br />
<br />
&nbsp; &nbsp; cn.CommandTimeout = 3000000<br />
&nbsp; &nbsp; cn.Open<br />
<br />
This gives the following error:<br />
[Microsoft][ODBSC Driver Manager] Data Source Name not found and no default driver specified
</div>
</div>


In Access 2007, (trying to access SQL Server) I have the following code:
    Dim cn As New ADODB.Connection
    Dim strCN As String
    strCN = "Provider=SQLOLEDB;Server=10.10.10.1;" & _
             "Initial Catalog='Websites';User ID=sa;PWD=xxxxxxxx"

    cn.CommandTimeout = 3000000
    cn.Open

This gives the following error:
[Microsoft][ODBSC Driver Manager] Data Source Name not found and no default driver specified

oledb connection to SQL Server not working

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.