Error about PowerCenter 8.1.1 connecting SQL Server 2005 throught OLE DB
Provider for SQL Server.
Error log:
---------------------------------------------------------------------------------
WRT_8299 Database errors occurred:Microsoft OLE DB Provider for SQL Server:
Timeout expired
SQL State:HYT00 Native Error:0
Database driver error...
Function Name:Execute Multiple
SQL Stme:Insert into
---------------------------------------------------------------------------------
We upgraded SQL Server 2000 to SQL Server 2005,and then we got the Error,who
knows the reason?
.
Re: Disabling ASP.net 2.0 Membership ... I checked out the article you referenced and implemented my own provider.... as a FoxPro database, an Oracle database, or other data sources. ...custom connection string so that I can use the Commerce Server SQL Server... (microsoft.public.dotnet.framework.aspnet)
Re: ERROR: Provider Management - Could not establish a connection to t ... If you have not yet created the SQL Server database,... Can any data provider be used to ...Exception Details: System.Data.SqlClient.SqlException: A connection ... (microsoft.public.dotnet.framework.aspnet)
Re: .NET data provider or OLEDB provider? ... >I don't see where you see a built-in query engine....>service provider, ...>OLE DB providers don't have to support SQL however, ... > SQL Server linked server, SQL Server can handle the queries. ... (microsoft.public.data.oledb)
Re: Need Help: Operating system error 3706 ...Installing an additional component resolved the problem and the software is now able to connect to the database ... The developer is currently doing a complete rewrite/update of the program, including database functions.... While this would require a modest re-write, it's not that tough to convert to a managed-code provider instead of the COM-based OLE DB provider. ... If the application is not based on .NET, then make sure the application is upgraded to use the SNAC (SQL Server Native Client) provider which is less trouble-prone than the older MDAC-based providers. ... (microsoft.public.sqlserver.connect)
