Hi, Thanks for your help so far. Another question if I may:
I'm doing this from work and we have SQL server 2005 installed on a dev server. I've created the database on the dev server and called it YAF. What's confusing me is the id and password in the connection string. Should this be the id and password for the dev server or the actual database? As far as I can remember I didn't setup a username and password for the database, so would I need to do that?
This is how the connection string looks at the moment:
user id=sa;pwd=*server_password*;data source=dev;initial catalog=YAF;timeout=90Using this I keep getting the error:
"Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."
Just thought I'd mention this; I've created a access project and linked it to this database on the dev server. I've put that project in the YAF root folder. Setting that up connected to the dev server automatically, so can I link to that project in the connection string instead?
Can someone point me in the right direction please, I'm so lost! 😛
Edited by user
15 years ago
|
Reason: Not specified