Can't determine which database is updated

Can't determine which database is updated

I have a microsoft database in my project. Versions of it are in debug, release, and the folder with all the forms and other files.

I have the compile properties set to release.

If I run the project from visual studio, the debug copy is updated.

If I run by double-clicking the release version, the release copy is updated.

If I add or change a table, the configure dataset with wizard won't recognize it unless I use the copy with all the forms85 and other files.

How do I resolve this?

dennist685

Hi,

During development it is good to compile your application with the configuration set for Debug. In that case, it will always use the MDB file within the debug folder.
As for the Configure Dataset, you need to check the Data Connection in Server Explorer and change that path as well to Debug folder.

Regards,
Vikram|||I have two of the same mdb's. One to the debug, and one without any path at all, just Hasbara.
dennist685

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

Cant connect to any database not owned by servername\ASPNET

I'm developing an intranet application and am using the Express versions of VWD and SQL Server 2005 for initial development before obtaining full licensed versions.

Database connections work fine when testing from within VWD but when testing from browser, unless the database owner is the IIS servername\ASPNET, there are various errors depending on the specific connection settings, i.e.

Login failed for user ''. The user is not associated with a trusted SQL Server connection.-

Receive this error when a GridView is connected to a remote SSE db.

--

SELECT permission denied on object 'Table_1', database 'TEST', schema 'dbo'.

Receive this error when GridView is connected to local SSE db not owned by servername\ASPNET.

--

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

This happens when using any control that is connected to SSE db created in VWD and stored in App_Data folder (owner is the user logon name)

--

Any help or ideas would be appreciated. I want to have all local data stored in App_Data folder.

Thank you.

You need to set SQL Server to use both Windows and SQL Server, that is covered below. Post again if you still need help.

http://msdn2.microsoft.com/en-us/library/ms188670.aspx