Connecting Tech Pros Worldwide Forums | Help | Site Map

need some assistance on c#

Ivan
Guest
 
Posts: n/a
#1: Nov 16 '05
Recently i have encounter some problem with C# programming. The
application of mine can't seem to run well with sql server 2000 and i
think the reason for this is the connection between this two things is
incorrect. So i was hoping that someone out there can help me out with
this problem. When i run the program, some error generated saying
that the database is not found. Please drop me a word if somebody out
there who are willing to help me out. Maybe I just attach the whole
program for better understanding of my problem. Thank you.

Dean Bortell
Guest
 
Posts: n/a
#2: Nov 16 '05

re: need some assistance on c#


Make certain that the user name and password to the SQL Server Database is part of your connection string. It would help if you posted your connection string. If you are using a dataadapter, go to properties and copt the select command command text.

Dean


"Ivan" wrote:
[color=blue]
> Recently i have encounter some problem with C# programming. The
> application of mine can't seem to run well with sql server 2000 and i
> think the reason for this is the connection between this two things is
> incorrect. So i was hoping that someone out there can help me out with
> this problem. When i run the program, some error generated saying
> that the database is not found. Please drop me a word if somebody out
> there who are willing to help me out. Maybe I just attach the whole
> program for better understanding of my problem. Thank you.
>[/color]
Chua Wen Ching
Guest
 
Posts: n/a
#3: Nov 16 '05

re: need some assistance on c#


Hi Ivan,

Please do make sure that your sql server agent is connected. I do face it sometimes when it disconnected.

Also please make sure your Initial Catalog contains the right database name.

Are you using a thrusted connection or what? Means windows authentication or sql server authentication?

Yeah, will be wondeful if you can copy and paste your connection string.

Hope it helps.
--
Regards,
Chua Wen Ching :)


"Dean Bortell" wrote:
[color=blue]
> Make certain that the user name and password to the SQL Server Database is part of your connection string. It would help if you posted your connection string. If you are using a dataadapter, go to properties and copt the select command command text.
>
> Dean
>
>
> "Ivan" wrote:
>[color=green]
> > Recently i have encounter some problem with C# programming. The
> > application of mine can't seem to run well with sql server 2000 and i
> > think the reason for this is the connection between this two things is
> > incorrect. So i was hoping that someone out there can help me out with
> > this problem. When i run the program, some error generated saying
> > that the database is not found. Please drop me a word if somebody out
> > there who are willing to help me out. Maybe I just attach the whole
> > program for better understanding of my problem. Thank you.
> >[/color][/color]
Closed Thread