Posted by Danieltbt05 on 01/31/06 18:36

Hi, i was wondering how do you create a connection to sql server. I'm a
novice in sql server. Pls advise. Thanks

Daniel

aspsql wrote:
> I have a website which runs off a Access database which I am currently
> converting to sql server database. I would like to still use my access
> front end for reporting and queries..
> I created an odbc connection on my computer to the remote sql server
> and created a link in access to my sql server tables. All my report and
> Queries run fine I just have one problem it keeps on prompting me for
> ther password of the remote sqlserver database. I check the odbc
> connection and I see the password is not saved in there even though I
> put it in. Is there a way I can have the password saved. I do not want
> keep on having to enter the password.

[Back to original message]