Hi
i have a windows xp pro, i using odbc to connect to sql 2000 server. i have
two connection that work fine. Now when i try to connect i receive a popup
message of error.
If i try to configure or recreate my odbc i receive the followin errors:
impossible make connection
sqlstate: '01000'
sqlstate: '08001'
sql server error 17

can help me to resolve this problem?
Tia Pupo

Pupo
Can you show us your connection string?

"Pupo" <123star@libero.it> wrote in message
news:%23zziVZeqEHA.3896@TK2MSFTNGP15.phx.gbl...
> Hi
> i have a windows xp pro, i using odbc to connect to sql 2000 server. i
have
> two connection that work fine. Now when i try to connect i receive a popup
> message of error.
> If i try to configure or recreate my odbc i receive the followin errors:
> impossible make connection
> sqlstate: '01000'
> sqlstate: '08001'
> sql server error 17
>
> can help me to resolve this problem?
> Tia Pupo
>
>

Can tell me where find the string please, because i use odbc procedure in
administratirve tools.
Thanks


"Uri Dimant" <urid@iscar.co.il> wrote in message
news:uxiYQdeqEHA.2724@TK2MSFTNGP14.phx.gbl...
> Pupo
> Can you show us your connection string?
>
> "Pupo" <123star@libero.it> wrote in message
> news:%23zziVZeqEHA.3896@TK2MSFTNGP15.phx.gbl...
> > Hi
> > i have a windows xp pro, i using odbc to connect to sql 2000 server. i
> have
> > two connection that work fine. Now when i try to connect i receive a
popup
> > message of error.
> > If i try to configure or recreate my odbc i receive the followin errors:
> > impossible make connection
> > sqlstate: '01000'
> > sqlstate: '08001'
> > sql server error 17
> >
> > can help me to resolve this problem?
> > Tia Pupo
> >
> >
>
>

Pupo
Do you have ACCESS application to read the data from SQL Server?
You've said "i have
two connection that work fine. Now when i try to connect i receive a popup
message of error." What could be changed? Did you change a SA password?





"Pupo" <123star@libero.it> wrote in message
news:OH8CFkeqEHA.1152@TK2MSFTNGP11.phx.gbl...
> Can tell me where find the string please, because i use odbc procedure in
> administratirve tools.
> Thanks
>
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:uxiYQdeqEHA.2724@TK2MSFTNGP14.phx.gbl...
> > Pupo
> > Can you show us your connection string?
> >
> > "Pupo" <123star@libero.it> wrote in message
> > news:%23zziVZeqEHA.3896@TK2MSFTNGP15.phx.gbl...
> > > Hi
> > > i have a windows xp pro, i using odbc to connect to sql 2000 server. i
> > have
> > > two connection that work fine. Now when i try to connect i receive a
> popup
> > > message of error.
> > > If i try to configure or recreate my odbc i receive the followin
errors:
> > > impossible make connection
> > > sqlstate: '01000'
> > > sqlstate: '08001'
> > > sql server error 17
> > >
> > > can help me to resolve this problem?
> > > Tia Pupo
> > >
> > >
> >
> >
>
>

I'm running SQL2000 on an Win2k box also running IIS.
I would think it would be faster to connect using a "localhost" type of
connection rather than a machine name but I haven't been able to get the
syntax. For security conecrns we changed the default port.

The Connection string I am using for my web apps is:

Dim Connect
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.open "DRIVER={SQL
Server};SERVER=SERVERNAME;DATABASE=DATABASENAME;UI D=USERID;PWD=PASWSWORD;"

Is there a faster way to connect?
Thanks --
Michael Shiffman
shiffman@mettaworks.com