ODBC connection to SQL Server

[Fizzack]

I'm very new to SQL Server. I have just installed it and setup a few tables. I've created a new login using Sql Server Authentication. Now I have set up an ODBC connection to use in Access 2000 to the SQL Server and the connection tests successfully. But when I go to open the table in Access, I am prompted for the password again. The ODBC connection does not seen to store the password. Any help please?

 

[tlbroadbent]

ODBC does not store the password. You can link the table and tell Access to store the password. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[jitter]

Just like Terry says when you are initially creating the linked table in Access one of your options is 'Save Password'. If you select this then you will not be prompted for the password.

 

[Fizzack]

Thanks for the help but now I have to ask where or how do I store the password. I look at using a pass-through query but there has to be a better way then that. Any ideas?

 

[tlbroadbent]

When you link a table or create a pass-through query, Access provides an option for saving the password.

On the Link Tables screen click Save password.

When creating a pass-through query, you'll need to create the ODBC connection string. When you save the string Access will ask if you want to save the password in the connection string. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[Fizzack]

Hey Terry,

I don't see a save password option any where when I link a table in?

Jeremy

 

[tlbroadbent]

Lower right corner of the Link Tables dialog. That's where I find it in Access 2000. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[Fizzack]

Thanks Terry. I feel kinda dumb right now but hey what can you do. Thanks again

 

[tlbroadbent]

We're all learning! Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.