Re: database project

Hello TS,

1) DataBase project's Database reference is stored in .dbp file.
Such as:

Begin DBRefFolder = "Database References"
Begin DBRefNode = "sha-dng-wywang.testVisio.dbo"
ConnectStr = " Data Source=.;Initial Catalog=testVisio;Integrated
Security=True"
Provider = "{91510608-8809-4020-8897-FBA057E22D54}"
Colorizer = 6
End
End

VS 2005 IDE used ConnectStr to connect Database. Personal Credentials is
aslo included in ConnectStr. "Integrated Security=True" means using Windows
Authentication. It works fine for SQL database. With this setting, each
person uses their own credential (windows account).

However, I'm not sure whether Sybase DB supports Windows Authentication. If
not, we would have to define user credential for the connection such as
"...;UserId=Your_Username;Password=Your_Password;".
This setting will store in .dbp file and keeped by Visual SourceSafe.
Therefore, each member in your team will use the same user credential for
DB Project's Database reference.

One approach is to modify the .dbf file, delete user credentials from its
connection string. Such as Begin DBRefFolder = "Database References"
...
ConnectStr = " Data Source=.;Initial Catalog=testVisio;"
...
End

When a member checked-out solution from VSS, connect to underlying database
by double-clicking DB project's DB reference, VS IDE will found the connect
string is lack of user credential. VS IDE will prompt a dialog for user to
enter his own credential. This information will be stored in User's
Document (not in .dbf file). Therefore, the credential will not be shared
by other user. Each one should use their own credential.

For this method, note that the VS 2005 IDE will register a new Database
connection for each time you double-click the DB project's DB reference.
(sha-dng-wywang.testVisio.dbo, sha-dng-wywang.testVisio.dbo1,
sha-dng-wywang.testVisio.dbo2..). You may delete them if you feel they are
unnecessary.


2) About the connection license:
The data connection in server explorer has a red x, which means VS 2005 IDE
hasn't connected to the underlying Database. Therefore, I think the client
license isn't used.


3) For the issue about how to color code the file extensions in VS IDE.
In SQL Server Management Studio, we could approach this by adding the
extension in Tools|Options|Text Editor|File Extension.
But, under my test, in VS IDE, there is no SQL editor in this option.
I think I need perform more research on this and reply you if I get any
information.

Hope this helps. Please let me know if you have any more concern. I'm glad
to assist you.
Sincerely,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: database project
    ... data connection was created and i entered credentials. ... i am prompted for credentials. ... Another DB reference is (Database References) in DataBase Project. ...
    (microsoft.public.vsnet.ide)
  • Re: database project
    ... There are two different DB reference in VS 2005 IDE. ... each connection is encrypted and stored on local for each ... The .dbp file is the Database Project file. ...
    (microsoft.public.vsnet.ide)
  • Re: Connection string not working when moving from sqlexpress to sqlserver
    ... When you connect to the database using integrated security from the ide the ... application passes your credentials to the database. ... > I am manually able to create a connection to my db in the vs2005 ide using ... > connection string and 'NET Framework Data Provider for SQL Server' as the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: database project
    ... DataBase project's Database reference is stored in .dbp file. ... One approach is to modify the .dbf file, delete user credentials from its ... note that the VS 2005 IDE will register a new Database ... connection for each time you double-click the DB project's DB reference. ...
    (microsoft.public.vsnet.ide)
  • Re: database project
    ... DataBase project's Database reference is stored in .dbp file. ... One approach is to modify the .dbf file, delete user credentials from its ... connection for each time you double-click the DB project's DB reference. ...
    (microsoft.public.vsnet.ide)
Quantcast