Hi all,
I have some errors in connecting to SQLserver20005 express.
In a project, I connect directly (by sqlconnection) and indirectly (by code), if I run this connect successfully then the other can't connect.
I use ADO.NET and connectionstring the same.
The error appears at:
Error:
Cannot open database "BeBi" requested by the login. The login failed.
Login failed for user 'BUCA\hoalt'.

Thanks in advance.
SLKT

It is not clear what you are asking. Are you saying that you have Multiple Data Sources? I am using SQL Server 2005 Express and I had to pay close attention of the placement of the web.config file.

Peace95, I have only a database, and only a table, in only the project I have 2 forms.
In a form(call A), I connect to this table by sqldataadapter.
In other one(call B), I connect by code not sqldataadapter.
If I run A before, A connects successfully; then B runs, B fails
And if B runs before, it is successfully, the other fails.
I can connect by this 2 types to the same database in the same project?

Make sure to CLOSE the open connection before opening the connection for the next form. For example, u have form A open, the close form A, before attempting to open connection to Form B, even though it is the same table. Not sure, what you mean by opening form B by code. You are using either the Data Reader or Dataset(DataAdapter).

Hope this helps.

Peace95,
I've found the reason.
In B-form, connectionstring="Data soucre=HoaLT\SQLEXPRESS;AttachDBFilename=BeBi...."
I must use Initial Catalog instead of AttachDBFilename
It attach one more file into my database, this is the reason of errors.
Thank you anyway.
SLKT