Re: ODBC Error Connecting to SQL



Looks like you have the server in the same machine of your client. Make
sure:
1. The server is up running.
2. You have the correct UID and PWD.


"Jaz" <Jaz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:914DF325-FFCD-49EB-9698-0834B356C7DB@xxxxxxxxxxxxxxxx
>I very clear that i configured SQL database with no problem but while i
>going
> to setup DSN in ODBC and this error occured, I do not understand what is
> the
> problem that keep this error exist.
> '
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 2
> [Microsft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist
> or access denied.
> '


.



Relevant Pages

  • =?Utf-8?Q?RE:_Connection_failed:_SQLState:?= =?Utf-8?Q?_=E2=80=98S1T00=E2=80=99?=
    ... SQL Server Error: 0 ... This happened in computers with the firewall client of ISA server. ... I stop the firewall client of ISA server service, ...
    (microsoft.public.vc.database)
  • Device errors in Maintenance plans
    ... Server Driver]Cannot open backup device ... See the SQL Server error log for more details. ... AND afterwards the maintenance plan transaction log also works for a while ...
    (microsoft.public.sqlserver.server)
  • SQL Error 53
    ... I'm getting a SQL error 53 when one of my workstations opens Project ... Pro 2003 and tries to connect to Project Server 2003: ... SQLState: '01000' ... SQL Server Error: 53 ...
    (microsoft.public.project.pro_and_server)
  • Re: SQL Error 53 and 17
    ... How many connections are being allowed to the server? ... > SQLState: '01000' ... > SQL Server Error: 53 ... > Both PCs had the application installed from the same installer. ...
    (microsoft.public.sqlserver.server)
  • Re: Connection failed SQL State 01000 SQL error 52
    ... Try posting on the server newsgroup. ... Please see FAQ Item: 24. ... > Connection failed ... > SQL Server Error: 52 ...
    (microsoft.public.project)

Loading