Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Auto Login

Author  Topic 

RichardSteele
Posting Yak Master

160 Posts

Posted - 2003-12-08 : 21:35:52
I'm connecting to a remote web-based shared sql server (that I do not have admin rights to) using a remote view in my local Visual FoxPro that updates information every 30 minutes. Right now, SQL always asks for a password. How is it possible to have it automatically connect to sql? How can I automatically put in the password? Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-12-09 : 12:30:42
You need to put the password in your connection string.

Tara
Go to Top of Page
   

- Advertisement -