MSDASQL Errors
Dec 18, 2002
I am having this problem with using a linked server to another dB. I can read tables from the server, but cannot update the same tables (permissions are ok). I get the message
The requested operation could not be performed because the OLE DB provider 'MSDASQL' does not support the required transaction interface
Does anyone have an idea where I should start looking? What interface are they talking about? I am linking with a system DSN running the Connx 8.3 driver.
Any help would be extremely aprreciated.
Robert Crooks
Ivaco Rolling Mills
View 1 Replies
ADVERTISEMENT
May 6, 2008
Hi,
I got the 64-Bit MSDASQL through the following link and install it on Windows xp 64-bit:
http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en
But
_bstr_t strConnect="Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/test/test.mdb;";
// create Connection object
m_pConnection.CreateInstance("ADODB.Connection");
hr =m_pConnection->Open(strConnect,"","",NULL);
...
I always get the error "Data source name not found and no default driver specified". I'm sure the test.mdb file exists and the code works well on windows xp 32-bit but fails on Window xp 64-bit even I install the above package. Anybody can help me? Thanks!!
View 9 Replies
View Related
Feb 17, 2007
Is microsoft going to provide 64 bit version of MSDASQL ( OLEDB Wraper for ODBC) in future? This was working great while accessing Data from IBM AS/400 on Iseries from 32 bit sql 2000. Now, it's all screwed up with rediculously slow OLEDB both from MS and IBM. I wonder if any of these guys really care!
View 30 Replies
View Related
Aug 10, 2006
Hello - hope this is in the right group:We have just started with linked servers and have successfully createda view on SQL Server linked to a Progress database. I can query thisview happily in Query Analyzer.I have created an ASP.NET application to display this view in adatagrid but I get the following error:System.Data.SqlClient.SqlException: OLE DB provider 'MSDASQL' reportedan error. at System.Data.SqlClient.SqlConnection.OnError(SqlExc eptionexception, Boolean breakConnection) atSystem.Data.SqlClient.SqlInternalConnection.OnErro r(SqlExceptionexception, Boolean breakConnection) atSystem.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObjectstateObj) at System.Data.SqlClient.TdsParser.Run(RunBehaviorrunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a() atSystem.Data.SqlClient.SqlDataReader.get_MetaData() atSystem.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,RunBehavior runBehavior, String resetOptionsString) atSystem.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Booleanasync) atSystem.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Stringmethod, DbAsyncResult result) atSystem.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Stringmethod) atSystem.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehaviorbehavior, String method) atSystem.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehaviorbehavior) atSystem.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehaviorbehavior) at System.Data.Common.DbDataAdapter.FillInternal(Data Setdataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,String srcTable, IDbCommand command, CommandBehavior behavior) atSystem.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32startRecord, Int32 maxRecords, String srcTable, IDbCommand command,CommandBehavior behavior) atSystem.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at...The code in my ASP.NET application looks fine and works on non-linkedviews on the same server. Do I need to add a command or change asetting on SQL Server?
View 2 Replies
View Related
May 2, 2007
Hi,I have some MSDASQL database files and I don't know this database at all.Can I get from somewhere SQL standard for this database?Greg.--
View 1 Replies
View Related
Nov 1, 2007
Hi, is here someone who can send me new dll libary. Itīs very important. Thanks ALL
View 1 Replies
View Related
Jul 23, 2005
Within an SQL Script is it possible to send a SQLDisconnectcommand? (server is MSDE)I have used sp_dropserver, sp_droplinkedsrvloginand do not get a SQLDisconnect.Each time I run the script a new nsql32.exe process loads up and theyaccumulate.use SalesGosp_dropserver 'M', 'Droplogins'goExec sp_addlinkedserver 'M', ' ', 'MSDASQL', NULL, NULL,'DRIVER=Lotus NotesSQL DRIVER(*.nsf);Database=C:eUROPEInstrument_Base.nsf;Ser ver=Local;UserName=XXXXXXXXXXXXX;EncryptPWD=XXXXXX X;'goselect * from M...MainForm where description= 'Described Here'Would like disconnect when this is done.......
View 2 Replies
View Related
Aug 20, 2007
I understand that the MSDASQL.dll is not available in 64 bit (unless you are running 2008 beta 3). I also understand that you can setup 32 bit ODBC without issues (using ODBCAD32.exe in WOW directory). My issue is how does SQL 2005 64 bit see these ODBC links? What is everyone doing to get around this? I want to be able to use openquery. Any advice would be much appreciated.
Carlton
View 6 Replies
View Related
Feb 8, 2007
I'm trying to set up replication on SQL Server 2005 (64-bit) and I am getting this error message when the replication kicks off.
'The OLE DB provider "MSDASQL" has not been registered.'
When I try and register the MSDASQL I get the folloing error message.
'LoadLibrary("c:program filesCommon FilesSystemole dbMSDASQL.dll") failed - the specified module could not be found.
View 3 Replies
View Related
Dec 16, 2003
I've seen several posts on linking an AS/400 to a SQL 2000 server.
I have created the link, I can use DTS packages to get data to/from the AS/400 to the SQL Server. However, I cannot write any SQL statements against the AS/400. Here is a basic one that doesn't work...
Select * from openquery(jdedwardspy, 'Select * from mhscrp.f0006')
If you look quickly enough, you can see that it does return a row or so, but then that is replaced by this error...
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver (32-bit)]Driver not capable.]
We're running Client Access V5R2, SQL Server 2000 SP3 and MDAC 2.7.1.
Any suggestions?
View 4 Replies
View Related
Jan 7, 2008
Hi all,
I have created a System DSN to a MYOB database file. I have SQL 2000 and 2005 Express editions installed on the same machine. I am logged in to PC as Local Admin. I am also logged into 2005 Express using 'sa' to avoid any security problems.
Creating a New Linked Server using SQL 2000 works fine using the System DSN I created, however, If I use exactly the same settings (Microsoft OLE DB Provider for ODBC) I get an error message.
"The OLE Provider "MSDASQL" for linked server "sname" reported an error. The provider did not give an information about the error."
"Cannot initilize the data source object of OLE DB Provider "MSDASQL" for Linked Server "name". (Microsoft SQL Server, Error: 7399)"
I have installed SL 2005 Express SP2.
As another test I created a data source using the same System DSN in Excel. It worked fine and queries the MYOB database file.
Any ideas to assist me??
Thanks.
Alan
View 5 Replies
View Related
May 17, 2006
I am having trouble with a linked server using MSDASQL. I'm connecting to a PostgreSQL database and pulling over data. This process has been working fine.
In trying to pull data from a different client database (same schema), I received an error that the MSDASQL couldn't read the column names.
The actual problem I want help on is that after this happens, I am no longer able to make valid connections to any of my Linked Servers using MSDASQL. The only way I can get my other linked servers to work again is to restart the SQL Service. Usually this is impossible for me to do because of the number of active users.
Two questions:
1) Is there another way to restart a more targeted service or sub-set to reset MSDASQL connections, and clear out my problem?
2) Any idea why I'm getting this error connecting to PostgreSQL on a large dataset when it worked fine for a small dataset using the same linked server? "The provider reported an unexpected catastrophic failure."
Any help is appreciated.
View 4 Replies
View Related
Mar 29, 2006
Hi all
I am migrating some DTS2000 packages to SSIS via the migration wizard. However there is an activex script in each DTS that connects to an AS400 to retrieve record count for integrity checking. Under SQL server 2000 this worked fine but now it errors with "The OLE DB provider "MSADSQL" has not been registered" how do i get this to work i suspect its because this is a 32 bit dll and my new system is a 64bit sql server on windows 2003. The odbc driver for the as400 has been installed also. The script is as follows:
dim cn 'sql connection
dim rs 'sql recordset for the insertion of new as400 records
dim insertstr 'sql insert string
dim rs1 'sql recordset for the insertion of new as400 records
dim insertstr1 'sql insert string
set cn = createobject("ADODB.Connection")
set rs = createobject("ADODB.Recordset")
Function Main()
'set up connection for sql
cn.provider="sqloledb"
cn.commandtimeout = 3600 'timeout in seconds
cn.open %sqlserver05%, %user%, %password%
'populate temporary table in sql with recordset from as400 odbc
insertstr1 = "Insert into db.dbo.%table% select 'table name',a.* from openrowset ('MSDASQL','DRIVER={Client Access ODBC Driver (32-bit)};SYSTEM=%system name%;UID=%username%;PWD=%password%','SELECT count(*) from %table%') as a"
set rs1 = cn.execute (insertstr1)
'close all objects
cn.close
Main = DTSTaskExecResult_Success
End Function
Does anyone know how i change this to work under sql server 2005. i need to resolve this quickly in order to deliver a project on time. Many thanks
Chris
View 6 Replies
View Related
Jun 21, 2007
When executing a query which joins against a large resultset from a linked server, SQL Server reports the following error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "foo" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "foo".
This is using SQL Server 2005 with SP2, and MyODBC version 3.51.16 (although previous versions also seem to have the same behavior).
Once the error occurs any subsequent query against the linked server (even something as simple as select top 3 * From foo...users) fails with the same error message. Queries using the OpenQuery syntax also fail with this error.
I've tried to determine if there are some error logs that might give me more insight into what's going on, but the above events don't seem to log to the ODBC trace logs. And I can't seem to figure out a way to trace the MSDASQL (i.e., oledb) events.
I initially thought there might be a problem with the MySQL myODBC driver, but the ODBC layer itself does not seem to have a problem. But the following steps indicate otherwise:
1. Create a new Linked Server to MySQL. Same error as above
2. Execute a query against the ODBC DSN directly, using a shell program. This works fine
I'm trying to clearly identify if the problem is with the MySQL driver or with the MSDASQL provider. It would appear that the latter is at fault, given the error message, and the lack of any ODBC logging.
Would anyone have any insights about what might be going on here, and if there is any possible resolution?
View 3 Replies
View Related
Jul 20, 2005
Help,I am running a pass through query to oracle from SQL server 2000 asfollows;select * from openquery(nbsp, 'select * from FND_FLEX_VALUES')I have run this query through both DTS and the query analyzer and getthe foloowing error;Server: Msg 7357, Level 16, State 2, Line 3Could not process object 'select * from FND_FLEX_VALUES'. The OLE DBprovider 'MSDASQL' indicates that the object has no columns.OLE DB error trace [Non-interface error: OLE DB provider unable toprocess object, since the object has no columnsProviderName='MSDASQL',Query=select * from FND_FLEX_VALUES'].The really strange thing is, I'll get this error the first time Iexecute the query but if I execute it immeadiatley after it will runfine.Any help would be most appreciated!Cheers
View 1 Replies
View Related
Jan 8, 2008
Hi everyone,
I'v finally managed to get a New Linked Server setup on SQL 2005 Express SP2 using the 'Microsoft OLE DB Provider for ODBC Drivers' MSDASQL. I have a Database setup on the SQL 2005 Express Database Engine which contains a query that OPENQUERY's the linked server. The query executes OK.
The problems in when I link an Access 2003 SP2 .adp file to the SQL 2005 Database Engine database. All objects, including the query containing the OPENQUERY (to the linked server) appear. However, when I run the same query within Access I get the following error:
"The OLE DB Provider for Linked Server "name" reported an error."
"The Provider reported an unexpected catastropic failure"
So the query works running within SQL 2005 Management Studio, but the same query doesn't work running within an Access 2003 SP2 ADP. I've closed down SQL 2005 Management Studio, but the same error is displayed.
I didn't know if the problem lies in Access 2003 SP2 or SQL 2005 Express SP2.
Any takers?? (I haven't logged this Thread in an Access forum)
Any assistance is appreciated.
Alan
View 1 Replies
View Related
Jul 1, 2015
I recently updated the datatype of a sproc parameter from bit to tinyint. When I executed the sproc with the updated parameters the sproc appeared to succeed and returned "1 row(s) affected" in the console. However, the update triggered by the sproc did not actually work.
The table column was a bit which only allows 0 or 1 and the sproc was passing a value of 2 so the table was rejecting this value. However, the sproc did not return an error and appeared to return success. So is there a way to configure the database or sproc to return an error message when this type of error occurs?
View 1 Replies
View Related
Jul 31, 2006
I have a parent package that calls child packages inside a For Each container. When I debug/run the parent package (from VS), I get the following error message: Warning: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
It appears to be failing while executing the child package. However, the logs (via the "progress" tab) for both the parent package and the child package show no errors other than the one listed above (and that shows in the parent package log). The child package appears to validate completely without error (all components are green and no error messages in the log). I turned on SSIS logging to a text file and see nothing in there either.
If I bump up the MaximumErrorCount in the parent package and in the Execute Package Task that calls the child package to 4 (to go one above the error count indicated in the message above), the whole thing executes sucessfully. I don't want to leave the Max Error Count set like this. Is there something I am missing? For example are there errors that do not get logged by default? I get some warnings, do a certain number of warnings equal an error?
Thanks,
Lee
View 5 Replies
View Related
Apr 20, 2006
Starwin writes "when i execute DBCC CHECKDB, DBCC CHECKCATALOG
I reveived the following error.
how to solve it?
Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -2093955965, index ID 711, page ID (3:2530). The PageId in the page header = (34443:343146507).
. . . .
. . . .
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1635188736)' (object ID -1635188736).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1600811521)' (object ID -1600811521).
. . . .
. . . .
Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -8748568, index ID 50307, page ID (3:2497). The PageId in the page header = (26707:762626875).
Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -7615284, index ID 35836, page ID (3:2534). The PageId in the page heade"
View 1 Replies
View Related
Feb 25, 2000
When using the following format & .cmd file keep getting this error . . .
DB-LIBRARY error:
Unexpected EOF encountered in BCP data-file.
Have checked the .fmt & .cmd files & also the table layout that the data is being loaded into. Any help would be appreciated.
FMT File
6.0
28
1 SQLCHAR 0 30 "" 1 UserName
2 SQLCHAR 0 32 "" 2 Password
3 SQLCHAR 0 8 "" 3 PasswordExpirationDate
4 SQLCHAR 0 2 "" 4 HintQuestionID
5SQLCHAR 0 25 "" 5HintAnswer
6SQLCHAR 0 40 "" 6EmailAddress
7 SQLCHAR 0 1 "" 7MarketingEmailInd
8 SQLCHAR 0 1 "" 8 StatusEmailInd
9 SQLCHAR 0 30 "" 9 FirstName
10 SQLCHAR 0 30 "" 10 LastName
11 SQLCHAR 0 1 "" 11MiddleInitial
12 SQLCHAR 0 3 "" 12 Suffix
13SQLCHAR 0 9 "" 13SSN
14SQLCHAR 0 8 "" 14DOB
15SQLCHAR 0 1 "" 15 CustType
16SQLCHAR 0 1 "" 16GradeLevel
17SQLCHAR 0 1 "" 17 SharedComputerInd
18SQLCHAR 0 8 "" 18 SchoolCode
19 SQLCHAR 0 2 "" 19CampusCode
20 SQLCHAR 0 50 "" 20 SchoolName
21 SQLCHAR 0 8 "" 21 SchoolLastVerfiedDate
22 SQLCHAR 0 8 "" 22 DateCreated
23 SQLCHAR 0 8 "" 23 LastLoginDate
24 SQLCHAR 0 4 "" 24 LoginCount
25 SQLCHAR 0 4 "" 25 BadLoginCount
26 SQLCHAR 0 1 "" 26 Status
27 SQLCHAR 0 30 "" 27 LastModifiedUser
28 SQLCHAR 0 8 ";
" 28 LastModifiedDate
CMD File
BCP DEVL_CUSTOMER_DB..tblRegistered_Users_TempX in T:custbasedataincomingRegistered_User.txt /f T:custbaseapplsqlcpbuser.fmt /e T:custbasedata
eportsbuseri.err /o T:custbasedata
eportsbuseri.out /b 1000 /SDataserverjmk /User /Password
View 4 Replies
View Related
Jul 23, 1999
I have been receiving 644 errors on an index for one of my tables. We have dropped and rebuilt the index. Even BCP out, drop the table, create the table and BCP in everything and still have problems.
Has anyone else experienced problems with 644 errors? Did you ever determine the cause and are they any preventative ideas?
TIA
View 2 Replies
View Related
May 24, 2005
I get this error when i try to modify or fix a job
Cannot add, update, or delete a job(or ists steps or shcedules) that aoriginated from an MSX Server.
error 14274
Why is this? Any ideas. I checked the sysjobs in the msdb and they have the correct server name for the jobs?
View 2 Replies
View Related
May 11, 2004
Ok, whenever I try to connect, I get the following Error messages:
"SQL Server Registration failed because of the connection failure displayed below.
SQL Server does not exist or access denied.
ConnectionOpen (Connect())"
"An Error 1069 occured while performing this service operation on the
MSSQLServer Service"
I even went as far as uninstalling and reinstalling, but to no avail. Does anyone have an idea what's causing this? It was working fine and then all the sudden one day I start getting these messages and it won't work.
Thanks!
Smitty
View 6 Replies
View Related
May 5, 2008
I have a dynamics db that is used for archival purposes and it is not used very often. Now that someone decided to get some info out of it it wont let them. when I run dbcc I get the following message:
Msg 5242, Level 16, State 1, Line 1
An inconsistency was detected during an internal operation in database 'PACIF'(ID:12) on page (1:19451). Please contact technical support. Reference number 6.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
I was just wondering if this meant anything to any of you? and since all of my backtapes have the same issue, is there any way to fix it?
thanks in advance.
View 11 Replies
View Related
Jun 5, 2007
Failer to generate user instance is the error.
View 1 Replies
View Related
Jan 21, 2008
Running SQL 05 Standard on a Vista box and I have about had it with Vista. Anytime I try to launch Config Manager I get Cannot connect to WMI provider. You do not have permission or the server is unreachable. So try I googled and tried everything I can fine from http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
C:Program FilesMicrosoft SQL Server90Shared>mofcomp "C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof" and now I get ..
An error occurred while processing item 10 defined on lines 73 - 79 in file C:s
qlmgmproviderxpsp2up.mof:
Error Number: 0x80041003, Facility: WMI
Description: Access denied
Compiler returned error 0x80041001
so I try every possible different permission setting for anything sql server - problem still happening... try procmonitor.. find the registry keys and grant full contorl to all of them.. problem still happending.. run the little fixwmi.cmd I found.. problem still happening..
try to uninstall SQL Server.. NOT - WMI error - try to reinstall over--- NOT WMI error.
What do I need to do to get this working. .this is becoming a serious hinderance to my productivity!!!
View 15 Replies
View Related
Jun 11, 2007
what a want to know is if there s a way to log sql server errors on a log file, table, these errors are not sql server logs which already exists, i want to log dead locks, sql server timeout errors vs on sql server or somewhere.
is it possible ?
may i use sql server profiler for that purpose?
thx in advance..
View 1 Replies
View Related
Jul 13, 2006
Hi Expert,
I have a datagrid which is filtering by a dropdownlist and a search textbox.
The dropdownlist allows to select the column they want to search.
The search textbox allows to enter the item they want based on the selection from dropdown.
Now I use a StoreProcedure to select the data they need, so I pass-in @DropDownListValue int and some others parameters, such as @ID int, @OrderType varchar(50) ... When I search for ID = 163
Input string was not in a correct format.
Then when I check with the SQL Server Profiler, I found out that:
exec usp_SelectOrder@DropDownListValue=N'1',@ID=N'163',@OrderType=N'163',@OrderSeries=N'163' ...
I already set every parameter's default value to NULL. How can I solve for this? Thanks!!
View 1 Replies
View Related
Sep 18, 2007
Why on earth is this not working, It WILL insert if there are NO apostheres (" ' "), but if I say like, "Cedric's Group" It will error out. I thought this approach was suppose to handle this character?
Thanks for any insight, String sqlStr = "Insert into cardgroups (username,groupname,insertdt,groupid) values (@username,@groupname,@insertdt,@groupid)";
SqlCommand cmd = new SqlCommand(sqlStr, connect);
cmd.Parameters.AddWithValue("@username", Session["memberusername"].ToString());
cmd.Parameters.AddWithValue("@groupname",this.namebox.Text.ToString());
cmd.Parameters.AddWithValue("@insertdt", DateTime.Now.ToString());
cmd.Parameters.AddWithValue("@groupid", myGroupStr);
connect.Open();
cmd.ExecuteNonQuery();
connect.Close();
View 2 Replies
View Related
Nov 17, 2007
Imports System.Data.SqlClientImports System.DataImports Microsoft.SqlServerPartial Class _Default Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub Protected Sub TextBox3_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox3.TextChanged End Sub Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting End Sub Protected Sub Save_Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Save_Button1.Click Dim conn As New SqlConnection() conn.ConnectionString = Data Source=REDSTONE;Persist Security Info=True;User ID=******;Password=******;Unicode=True End SubEnd Class
End of statement expected. C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb
'System.Data' is a namespace and cannot be used as an expression. C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb
C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb
View 1 Replies
View Related
Mar 25, 2006
Hello to all,
On my webPage I have Used one SQLDataSource to access DataBase. Now whenever some error occures it shows error page by default. I am not able to catch Errors and tackle in my way...
Furthermore in this new structure of accessing DataBase even I do not know where to write Try... Catch...
View 1 Replies
View Related
Apr 30, 2002
Hi,
Well there's always a first for everything!! I have a SQL 7.0 server on sP1
and ran upgrade to sp3 and recieved error 'error in upgrade script' retry or cancel. When I retried the upgrade ended. I tried to run the upgrade again and it tries continue where it ended before, but the upgrade ends unsucessfully. I even tried extracted the sp3 exe to a diffrent folder and ran the sp3 upgrade with same results.
I started the MSSQL service ok but not able to use Query Analyzer, DTS, EM.
Get the following message:ISQL.EXE - Entry Point not found. The procedure entry point?DeleteRow@CDataCTLStorage@@UAEJJPAPAG@Z could not be located in the dynamic link library SQLGUI.dll
I get similar msgs when trying to open DTS, Enterprise manager from the server. The user databases and appear to be ok. I am able to get to Query Analyzer, etc. from my worksation fine.
Has anyone encountered this before? Is there a fix for it or do I need to rebuild the server from SP1 and restore the databases, etc.??
Thanks Much,
Steve Bajada
Senior DBA
View 3 Replies
View Related
May 29, 2002
It gives following errors
1.time out
2.general network failure
* Are these due to large number of online connnections
*If so what is the maximum number of connections possible
*what is the hardware requirement to avoid this
*what is the impact on stored procedures
*How to tune the server to overcome the problems
*I'm currently using the standard edition what is the impact on enterprise edition
View 1 Replies
View Related
