Re: SQLServerAgent will not start - "Event ID: 103" - URGENT HELP

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/15/04 

Date: Sun, 15 Aug 2004 12:39:20 -0600

You can get ODBC errors using Query Analyzer - Query
Analyzer connects to SQL Server using ODBC. Plenty of apps
can connect via ODBC and without any ODBC data sources set
up (i.e. DSN-less connections).

-Sue

On Fri, 13 Aug 2004 15:06:46 -0400, "Andy Svendsen"
<andymcdba1@NOMORESPAM.yahoo.com> wrote:

>Don't let the ODBC errors get you thrown off. They are used for ODBC Data
>Sources, not Query Analyzer. When you are able to connect with SQL Query
>Analyzer, an entry gets written to SQL Client Network Utility (cliconfg.exe)
>under Aliases. Have you tried running client network utility and SQL server
>network utility on the server to make sure both programs are communicating
>on the same protocol.

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: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... the ODBC source using named pipe, but I don't know how to enable named pipes ... If it is not working I am going to use ado to connect to sql server. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: [PHP] ODBC and long text fields
    ... We've a PHP app that uses ODBC to talk to a MS SQL server. ... The internal code for a query is ...
    (php.general)