What iam sure of is that it is not an issue from SQL server. i have tried to ping the AS400 server and the reply is <1 ms then i wrote a query to check the linked server and it is giving an ok reply b4 it stops suddenly. i have seen soo many possible issues and read articles abt the same error Msg 7303 and i will be trying to update the server with hotfixes. Are there any fixes that came to your mind?

We have a linked server on SQL 2005 to database on AS400. the linked server is made using Microsoft DB2OLEDB provider. when we are using the linked server, we are getting the following error: OLE DB provider "DB2OLEDB" for linked server "AS400PROD" returned message "". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "DB2OLEDB" for linked server "AS400PROD". When we restart the SQL server machine, the linked server works fine for about 5 minutes then we receive the same error as described before, The script of the linked server is : EXEC master.dbo.sp_addlinkedserver @server = N'AS400PROD', @srvproduct=N'AS400', @provider=N'DB2OLEDB', @datasrc=N'S6595D7F', @provstr=N'Provider=DB2OLEDB;Password=ISA108;Persist Security Info=True;User ID=ASI;Initial Catalog=S6595D7F;Data Source=AS400;Network Address=192.1.1.50;Package Collection=KFILFNB;DBMS Platform=DB2/AS400;Process Binary as Character=True' /* For security reasons the linked server remote logins password is changed with ######## */ EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'AS400PROD',@useself=N'False',@locallogin=NULL,@rmtuser=N'LOGINRPORT',@rmtpassword='########' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'collation compatible', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'data access', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'dist', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'pub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'rpc', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'rpc out', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'sub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'connect timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'collation name', @optvalue=null GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'lazy schema validation', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'query timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'AS400PROD', @optname=N'use remote collation', @optvalue=N'true'

while executing ssis package to execute an access macro and end up by getting error "The script threw an exception: Retrieving the COM class factory for component with CLSID {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} failed due to the following error: 80080005." i googled a lot and all i have found is to edit the access application properties in componant services. any ideas?

Hi all i need to develop a web application using Telerik controls. One of the application tasks is to send emails to facebook friends and i need to add it as a facebook applciations section so users can add it from thie face book accounts. I have been googling and i found some articles related to developing .net web applicatons using the toolkit. Is this applicable also using third party tools?? Any help or suggestions??

Hi all, i have developed a MS BI using SSAS cubes and Performance point dashboards and published them on Sharepoint2007. now iam thinking of making a windows mobile version. any suggestions and thanks

hi i am using table {page-break-after:always} in printing HTML page and it is working fine but when i export the same report to word and print the word document the page break is not working. Any ideas or is there another work around so if i have multiple reports to print each new report on new page example report1 on pages 1,2,3 report2 starts on page 4 and so on

I have set bottom margin to 0.5 in but the problem is that i dont know where the page begins and ends and thats why the bottom appears cut when printed.

Hi I have a very long HTML report that contains several tables and grids. After exporting this report to word, iam trying to print this word document. I am facing an issue at the end of the page because some times it cuts the words listed at the end of each page. Is there a way that i can handle this issue?

Hi all, i have a domain on windows 2003 server with 8GB memory and session management is done via SQL. We have created around 4000 subdomains and sence then we have been suffering from serious memory problems. Can anybody help? thanks

Hi All, I have a cube created using SSAS 2005. 1- I need to create Roles related to this cube using ASP.net. Any help or suggestions. 2- Is it possible to develop some code that opens the window that pops up when creating a Role from SSAS and the manipulation is done through this window instead of code. Thanks

What is the best practice to stop a web application to stop from working on IIS in a marketing image. I am distributing an image that has a published web application to customers and i need this applciation too stop from working after a month from that first login. Any ideas and thanks in advance!!!!!

I am deploying a web application and getting an error "could not load file or assembly microsoft.sqlserver.manageddts, version=9.0.242.0 ....." i have in my bin a DLL named "Microsoft.SqlServer.DTSRuntimeWrap.dll" i have added this file in GAC, restarted the IIS, restarted the Computer and still having the same error. Any Ideas. On the web server iam deploying on i have .net framework 2.0 & 3.0 & 3.5 with sp1 and VS2008 installed.

Thanks for ur answer, however this is the issue. I am not being able to find the parent window in any way, there is no parent at all. i tried to use parent.location.reload(True) but gives an error parent is nothing.

Hi all i need to refresh the whole page when pressing a button inside an iframe. i have a page View inside View.aspx i have an iframe named folder when i press save inside folder i return an id. I need to refresh the whole page (View.aspx) and pass querystring id to Iframe Folder. Any help, thanks

Hi all, how can i embed excel sheet with everything it holds (pivot table, charts ...) in an aspx page. any ideas, thanks

Thank you for ur reply, What access rights exaclty? i am an administartor :) The problem is not found in projects with .net framwork 2.0 Shall i uninstall VSS from clients machine and try?

You dont have to be mad, thanks anyway :)

Hi all, I am creating a new project from VS2008 .net framework 3.5 and when adding to source safe 2005 having problems between team members and locally is not checking in or out and several issues. I googled a little and got 2 different updates, installed them but didn't work. Any ideas why and how to solve it.

Thanks for ur reply This is what iam doing right now decaring the size the same as i declare them in stored procedures. But for some types there is a default or max size we should commit to. Is there a list where i can get these defaults? Thanks

Hi all i need to know exactly the size of sql parameters when definning them. Ex: SqlParameter foo = new SqlParameter(parameterName, dbType, size); this.Add(foo); I need to know size that should be send for each datatype, Ex: Bigint, float, varchar(max)... Thanks