ODBC Connection Hangs after 15 minutes of non-use

I have several workstations that login to a WIN_2000 Server and Connect just
fine to a SQL-2000 Server (different machines) over a dedicated VPN....
They have a x.x.2.1 addressing scheme and we have x.x.1.1 addressing scheme.
Everything works beautifully for a while.
My application runs a MailMerge with Word and Access 9.0 with tables linked
to the SQL Server 2000 server.... The code uses a pre set up ODBC
connection (SQL Server) that connects just fine right after start up...
Code works and ODBC connection works.... However, after 15-45 minutes the
ODBC connection stops working... This can be verified by testing the ODBC
applet which hangs
I have 50 local users who have no issues with the setup - only these few
remote users.
I have set the server autoconfigure to never disconnect. (I can still
browse the servers)..
Any clues as to why the ODBC connection would become disabled after a short
period of time - requiring a reboot to work again?To me this sounds like an issue with the VPN not ODBC and SQL Server.
Mike O.
"Bob" <rrowe68@.hotmail.com> wrote in message
news:%23jMJEVX1DHA.536@.tk2msftngp13.phx.gbl...

quote:

---

> I have several workstations that login to a WIN_2000 Server and Connect

---

just

quote:

---

> fine to a SQL-2000 Server (different machines) over a dedicated VPN....
> They have a x.x.2.1 addressing scheme and we have x.x.1.1 addressing

---

scheme.

quote:

---

> Everything works beautifully for a while.
> My application runs a MailMerge with Word and Access 9.0 with tables

---

linked

quote:

---

> to the SQL Server 2000 server.... The code uses a pre set up ODBC
> connection (SQL Server) that connects just fine right after start up...
> Code works and ODBC connection works.... However, after 15-45 minutes

---

the

quote:

---

> ODBC connection stops working... This can be verified by testing the ODBC
> applet which hangs
> I have 50 local users who have no issues with the setup - only these few
> remote users.
> I have set the server autoconfigure to never disconnect. (I can still
> browse the servers)..
> Any clues as to why the ODBC connection would become disabled after a

---

short

quote:

---

> period of time - requiring a reboot to work again?
>
>

---

ODBC connection fails

I'm running SQL 2000/SP3 on a W2k server. I have a database with a standard
user (dbo rights). From any of my workstations I can create an ODBC
connection using SQL authentication.
When I try to create an ODBC connection on the server itself with the same
credentials, I get an error msg "login failed, username is not associated
with a trusted server connection". Using Windows authentication with another
user that has access to the SQL server works fine.
This doesn't make sense to me. What am I overlooking here? Any help/hint
would be appreciated.
Thanks
Claus"cjobes" <cjobes@.nova-tech.org> wrote in message
news:O6t6OxyBEHA.3928@.TK2MSFTNGP11.phx.gbl...
> I'm running SQL 2000/SP3 on a W2k server. I have a database with a
standard
> user (dbo rights). From any of my workstations I can create an ODBC
> connection using SQL authentication.
> When I try to create an ODBC connection on the server itself with the same
> credentials, I get an error msg "login failed, username is not associated
> with a trusted server connection". Using Windows authentication with
another
> user that has access to the SQL server works fine.
> This doesn't make sense to me. What am I overlooking here? Any help/hint
> would be appreciated.
The user account itself needs to have access to the server running SQL
Server. One way to verify, temporarily enable (don't leave it that way ;)
the server GUEST account.
Steve|||Hello,
Define user id "sa" and set pwd for sa account on sql server and try to
login that account on odbc connection.
i hope it will working fine.
Thanks,
Warm Regards,
Ayaz Ahmed
Software Engineer & Web Developer
Creative Chaos (Pvt.) Ltd.
"Managing Your Digital Risk"
http://www.csquareonline.com
Karachi, Pakistan
Mobile +92 300 2280950
Office +92 21 455 2414
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Actually that is a not a good idea (at least as a permanent solution) as sql
security is sent over the network in clear text.
Steve
"Ayaz Ahmed" <ayaz@.csquareonline.com> wrote in message
news:e4EAqBkDEHA.2712@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Define user id "sa" and set pwd for sa account on sql server and try to
> login that account on odbc connection.
> i hope it will working fine.
>
> Thanks,
> Warm Regards,
> Ayaz Ahmed
> Software Engineer & Web Developer
> Creative Chaos (Pvt.) Ltd.
> "Managing Your Digital Risk"
> http://www.csquareonline.com
> Karachi, Pakistan
> Mobile +92 300 2280950
> Office +92 21 455 2414
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!