fryeguy

I started doing some data connection tests with the SDK test database and Visual Basic 2008 Express. Initially I had no problems connecting and creating table view forms and getting a look at some data.

Then I decided to copy my live DToolsProducts50 & DToolsProjects50 data files fro mthe server to my test environment so the data would be more valuable.

Now, my application has trouble connecting to the data.
I attempted to create a new data link and this doesn't appear to be working. When I try to make the new connection the login doesn't seem to be working properly.

Can someone give me some additional info on how to create a connection?
I added the data connection string info to the config file but this has no bearing on the matter.

Does this have something to do with changes in the database in the SDK vs. the live version?
Is it something to do with the credentials?

I would appreciate any input.

fryeguy

Here is another question:
What credentials should I be using to login to either the Products50 or Projects50 data files?
They are copies of my live data...

ManjitS

In the app.config file of the sample application has credentials to connect to the project and product database.

1) Are you trying to connect directly to the database or using SDK?

2) What credentials you are using to connect? What is the error?

3) Does sample application works for you?

fryeguy

I attempted to use the credentials in the app.config fille provided with the SDK.

1) Are you trying to connect directly to the database or using SDK?
I am trying to connect directly. This worked with the sample data but not my data.

2) What credentials you are using to connect? What is the error?
With the sample data I needed no credentials. When setting up the data connection VB 2008 the "Test Connection" just worked. As soon as I replaced the data files with my data I received errors.

3) Does sample application works for you?
VB Express 2008 gives me an error when trying to load the smaple projects. It says it doesn't support project file .csproj.

fryeguy

Does anyone have additional info in this area?

ogharib

Originally Posted by fryeguy

3) Does sample application works for you? VB Express 2008 gives me an error when trying to load the smaple projects. It says it doesn't support project file .csproj.

A .csproj file is a C# project (not a VB.NET project).

grichards

i know this post was from a year ago, but you (or any other users running into connection issues with the SDK) may want to try the following when changing the database that you are using. It's from an article i found somewhere, but can't seem to relocate. Basically you have to reset security setting for the dToolsData user. Using Microsoft SQL Server Management Studio Express:

1) connect to the server hosting your database
2) open the Security Folder of the database you are connecting to (DToolsProducts in this example)
step2.JPG
3)Under Security/Schema open the properties of the DToolsData Schema
step3.JPG
4) Verify that the Schema owner is "DToolsData" and press OK
step4.JPG
5) under Security/Users, delete the DToolsData user
step5.JPG
6) create a new User with the following info:

UserName: DToolsData
Login name: DToolsData
Default schema: DToolsData
Schemas owned...: DToolsData
Database Role...: db_backupoperator, db_owner

step7.JPG

Press OK
7) repeat 2-6 for each database you want to access (i.e. Projects, Users)

another thing to be aware of: make sure Mixed Login Mode is selected when creating the server.

happy hunting...