You searched for the word(s): userid:733260

More Search Options

RSS Available

• Css friendly Tabcontainer not rendering in firefox

  I am using the Css friendly adapters in VWD 2008 and in general working well I have a page that contains an Ajax Tabcontainer that uses OnClientActiveTabChanged ="loadTabPanel" to manage the loading of data into the panels In IE 7 this renders fine and tab loading works well In an equivalent page not using the CSS Friendly adapters this renders and works fine in both IE7 and firefox In firefox the TabContainer does not render with the CSS frienly adapters. If I remove the OnClientActiveTabChanged

  Posted to CSS Friendly Control Adapters (Forum) by michael_y on 6/19/2009
  Filed under: "css friendly adapter", "TabContainer", "firefox", "OnClientActiveTabChanged"

• Re: Css friendly Tabcontainer not rendering in firefox

  After much trial and error I have fixed the problem which would appear to be associated with my code rather that a problem with firefox Sorry about the false alarm

  Posted to CSS Friendly Control Adapters (Forum) by michael_y on 6/19/2009

• Re: Create a CSV file in stored procedure using BCP Timeout

  Hi Jiang Thanks for the response I double checked the schema and it is .dbo Regards Michael

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by michael_y on 12/22/2008

• Re: Create a CSV file in stored procedure using BCP Timeout

  Hi I removed the .mdf and got the same result. Why would I get the error: Error = [Microsoft][SQL Native Client][SQL Server]Invalid object name 'CIMODELDATA.dbo.TaskCustomer'. I have found that if I run the sql statement in a separate query it runs only if the prefix CIMODELData.dbo is NOT there. The table is not recognised. What would stop the table from being valid? PS I tried the first of your alternate sql statements with no luck Thankyou Michael

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by michael_y on 12/22/2008

• Re: Create a CSV file in stored procedure using BCP Timeout

  Hi Jiang This is what I have done so that I am clear what is required Set SQLexpress for remote access Set the sqlbrowser to automatic I use Norton Internet and added the two executables to program controll I copied the database to the inetpub wwwroot directory and attached the database to Mgt studio express THe main part of the code looks like this: SET @SQL = 'SELECT TaskCustomerCode, Customer FROM [CIModeldata.mdf].[dbo].[TaskCustomer] ORDER BY TaskCustomerCode' SET @CMD = 'BCP "'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by michael_y on 12/22/2008

• Re: Create a CSV file in stored procedure using BCP Timeout

  Thanks for response Changed the procedure to: SET @SQL = 'SELECT TaskCustomerCode, Customer FROM CIModelData.dbo.[TaskCustomer] ORDER BY TaskCustomerCode' Gives the same error? Michael

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by michael_y on 12/18/2008

• Re: Create a CSV file in stored procedure using BCP Timeout

  Thanks for the response I modified the procedure to: SET @DB_NAME = '[C:\Users\Michael\Documents\Visual Studio 2005\WebSites\taskskillmanager10122008\APP_DATA\CIMODELDATA.MDF].[dbo]' SET @SQL = 'SELECT TaskCustomerCode, Customer FROM ' + @Db_Name + '.[TaskCustomer] ORDER BY TaskCustomerCode' I end up with the same error message Thoughts? Ta Michael

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by michael_y on 12/18/2008

• Create a CSV file in stored procedure using BCP Timeout

  I am trying to create a csv file using BCP in an VWD Express 2005 strored procedure. So far I have given remote access to my local machine The procedure is: ALTER PROCEDURE dbo.ImportCustomers AS DECLARE @CMD Varchar (8000) DECLARE @SQL Varchar (8000) Declare @servername varchar (500) Declare @filename varchar (500) begin set @serverName = rtrim (@@servername) set @Filename = @servername + '\sqlexpress' SET @SQL = 'SELECT TaskCustomerCode, Customer FROM TaskCustomer ORDER BY TaskCustomerCode'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by michael_y on 12/17/2008
  Filed under: Timeout, bcp sql, stored procedure, CSV

• Re: Acess tables from different databases

  Thanks My understanding is that if the databases are on the same server then it does not need to be referred to. That aside I tried: sqlexpress.TaskMgr.dbo.TaskTable and got the following error "Could not find server in sys.servers". Do I need to add the server to sys.servers? If so could someone explain what is happening

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by michael_y on 1/23/2008

• Acess tables from different databases

  I am using Vista Business with Visual Web Developer and Sql Server Express 2005. I want to be able to access the data from two tables in a query. Both tables are attached to the application. To refer to the two databases I have used the following DATABASE.OWNER.TABLE (specifically TaskMgr.dbo.TaskTable) For both databases I get the error " Invalid object name" What am I missing? Thanks

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by michael_y on 1/23/2008
  Filed under: query, SQL Server Express, visual web developer, Database