Showing posts with label querying. Show all posts
Showing posts with label querying. Show all posts

Thursday, March 22, 2012

Error '8007007f' after upgrading to Windows Server 2003

After upgrading to Windows Server 2003, i receive Error '8007007f' when quer
ying the database, it says i have an error on this line. I am running SQL Se
rver 2000 with SP 3a
Specter.Open "Provider=SQLOLEDB;User ID=;Password=;Data Source=Excursion;Dat
aBase=AE;Integrated Security=SSPI"I had the same problem after upgrading to Windows 2003 Server. I called Mic
rosoft and here is the fix:
Symptoms:
After upgrading from Windows 2000 to Windows 2003 attempting to access a dat
abase or data component will result in a '8007007f' or "The specified proced
ure could not be found" error.
Status:
This is a known issue with some installations of Windows 2003
Workaround:
Extract oledb32.dll from the zip file into these two directories. It's impo
rtant that it be done in this order:
1) C:\WINNT\system32\dllCache
2) C:\Program Files\Common Files\System\OLE DB
3) Reboot the server
Cause:
This issue is caused when the Windows 2003 installer did not update the oled
b32.dll file.
You can dowload the oledb32.dll file here: [url]http://www.promiseweb.com/oledb32.zip[/
url]
This is per Malcolm Stewart at Microsoft Developer Support

Monday, March 19, 2012

Error 7347

We are getting Error 7347 error while querying via link server to Sybase. No
w this error is produced only in case of few tables. Query for other tables
is fine. There is another link server to the same sybase server but to a dif
ferent database and that it
fine.
Any help is appreciated
Here is the complete error message
****************************************
Server: Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'Sybase.ASEOLEDBProvider' returned an unexpected data length
for the fixed-length column '[pds].[pds].[dbo].[product].cu
stodian_code'. The expected data length is 15, while the returned data lengt
h is 4.
OLE DB error trace [Non-interface error: Unexpected data length returne
d for the column: ProviderName='Sybase.ASEOLEDBProvider', TableName='[p
ds].[pds].[dbo].[product]', ColumnName='custodian_code', Expecte
dLength='15', ReturnedLength='4'].Hi,
////
The IDENTITY function should be used only when the SELECT statement has an
INTO clause.
Explanation:
Command failed due to invalid or illegal request. Check syntax, semantics,
and permissions. Take any corrective action indicated by message.
////
The sybase manual gives this explanation for the Error number 7347.I dont
know what query u are firing onto the server but just check if u are missing
something specified in the explanation
regards
Dilish
"Nishu" <anonymous@.discussions.microsoft.com> wrote in message
news:A98F91AB-9EFB-4F31-9281-2407BB0D2BE7@.microsoft.com...
> We are getting Error 7347 error while querying via link server to Sybase.
Now this error is produced only in case of few tables. Query for other
tables is fine. There is another link server to the same sybase server but
to a different database and that it fine.
> Any help is appreciated
>
> Here is the complete error message
> ****************************************
> Server: Msg 7347, Level 16, State 1, Line 1
> OLE DB provider 'Sybase.ASEOLEDBProvider' returned an unexpected data
length for the fixed-length column
'[pds].[pds].[dbo].[product].custodian_code'. The expected d
ata length is
15, while the returned data length is 4.
> OLE DB error trace [Non-interface error: Unexpected data length returned[/col
or]
for the column: ProviderName='Sybase.ASEOLEDBProvider',
TableName='[pds].[pds].[dbo].[product]', ColumnName='custodi
an_code',
ExpectedLength='15', ReturnedLength='4'].