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.
| Author |
Topic |
|
blasterv
Starting Member
1 Post |
 Posted - 2007-06-06 : 11:06:18
|
| Is it possible (and if so how) to put the username, password, and connection information for a database inside a stored procedure? I want to call stored procedures on html and asp pages without hard-coding in a username/password to the page or using a udl.Any help would be appreciated |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-06-06 : 11:25:46
|
| The problem is that you can't get to the stored procedure until you've already connected to SQL Server using a user name, password and connection information.In ASP pages can you use a common include file that has the connection information? That stores the information in one place that can travel with the web site.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-06-06 : 11:26:21
|
| 1. no....at that stage you've already connected to a database...which requires the userid/passwordalternatives...2. put it into an .ini file, .xml startup file, or into a registry entry.3. change to using windows authentication. |
|
|
|
|
|
|
Passwords in Stored Procedures