April 15, 2008 at 6:13 pm
I have a connection string here that produces, or should produce, a connection to an SQL database:
This sits inside my web config file. The problem is that everytime i go to execute my program, it used to go as far as User ID and then the program used o crash citing invalid keyword at UserID. Having done some research, i have ensured both User ID, Password and Initial catalog are valid keywords for a SQL Connection however now the program moves forward to the point where the connection opens in my program before crashing. The user ID, password and stuff is fine but still no joy. Is anyone able to see where i am going wrong so i can make corrections?
April 16, 2008 at 1:11 am
[font="Verdana"]does it throwing any error? Or whether do you able to connect to DB or not ?
Meantion some more details.
By the way, at UserId add domain name. i.e. UserID should be:
@domainname\{your UserId} and then try with password.
Mahesh[/font]
MH-09-AM-8694
April 17, 2008 at 8:04 am
I think you have to escape the less than and greater than signs (angle brackets) as < and > or else everything in brackets is stripped out, thus the connection string you tried to post is gone.
Yes, the escaped brackets in my post appeared. Use the ampersand + lt/gt + semicolon escape sequence.
April 17, 2008 at 8:13 am
Is your SQL Server window authenticated? I have been tried to solve this problem since last month. Somehow even I put the password in the connection string, it dropped during the execution. If you search the internet, a lot of people having this problem. The best way is to have the SQL Server window authenticated.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply