Re: Trying to access to SQL Server database using named pipes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Most likely this is the Windows XP firewall settings.

http://support.microsoft.com/default.aspx?kbid=842242

You need to add an exception for SQL Server for port 1433.

--
Matt Neerincx [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Filip Heyvaert" <Filip Heyvaert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5EF1FB99-3D17-41B8-85D0-93D7094AB880@xxxxxxxxxxxxxxxx
> Hi,
>
> I come to the conclusion that I can only access a SQL Server DB via ODBC
> on
> servers that have Win2003 Server installed. But I need to be able to
> access
> this same database via ODBC on a XP SP1 machine.
>
> I've instaled MDAC 2.8 on this XP machine (which contains the ODBC sources
> of Win2003); but I still can't access this database. It keeps on being
> unable
> to access this database.
>
> Does anyone know what can be missing here?
>
> Thanks,
> Filip


.

Relevant Pages

  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Need ODBCDirect-ion
    ... Just as a side note, ODBC, or so called "jet" direct is simply a way to ... You need experience with sql server. ... "Upsizing to Microsoft SQL Server" White Paper Available in Download ... Choosing Database Tools White Paper Available in Download Cente ...
    (microsoft.public.access.modulesdaovba)
  • Re: Supporting a variety of database types in an app?
    ... Ralph, thank you for your insightful response. ... To get experience with MS SQL Server and client/server development. ... My rationale for using a file-based database location/selection method: ... ODBC API, but modified it to enhance performance). ...
    (microsoft.public.vb.database)
  • Re: Trusted Connection
    ... HOWEVER, for one of my users, I will create an ODBC DSN ... for my test database ON THEIR COMPUTER, ... So, when I set up the ODBC DSN connection for this user, ... >> Our SQL Server was set up NOT by me, ...
    (microsoft.public.sqlserver.security)