OpenDatasource Error 7399

Question

SQL 2000 Use OpenRowset is OK, LinkServer same OK, But use OpenDatasource is Error 7399:

OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005:  The provider did not give any information about the error.].

OLE DB provider 'SQLOLEDB.1' reported an error. The provider did not give any information about the error. OLE DB error trace [OLE/DB Provider 'SQLOLEDB.1' IDBInitial

Please Help me,....

Answer 1

Hi Phanthao,

Based on your description, we cannot diagnose what the problem is. For error 7399, there could be several reasons when you are using Jet database, please follow these kb articles to see if it solve your issue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;296711

http://support.microsoft.com/default.aspx?scid=kb;en-us;818182

http://support.microsoft.com/default.aspx?scid=kb;en-us;814398

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

I am usingSQL Server2000 (not usingJET) for verifydata a SQL 2000 Other, when using Scripts opendatasource:
Opendatasource ('SQLOLEDB', 'Data Source = ABC; User ID =sa; Password=mypass'). MyData 

OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005:  The provider did not give any information about the error.].

so on me when using: Opendatasource ('SQLOLEDB.1', 'Data Source = ABC; User ID =sa; Password=mypass'). MyData 

Please help me, to resolve this issue.

Answer 3

Phanthao,

Please first make sure your JET is the latest version, please see :

How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine

http://support.microsoft.com/kb/239114

If you are using windows 2000, please also make sure the version is later than SP3.

If the error still happens, follow these steps to troubleshoot it:

1.Log on to the computer by using the SQL Server start up account.
2.Create a folder named Temp in the operating system installation directory.
3.Permit full access to a non-administrator account on the Temp folder.
4.Set the value of the TEMP and TMP user variables of the SQL Server startup account to the newly created Temp folder. To do so, follow these steps: a.Right-click My Computer, and then click Properties.
b.Click the Advanced tab, and then click Environmental Variables.
c.In the User variables for Logon User list, click TEMP, and then click Edit.
d.In theVariable Value box, type C:\Temp as the location of the new Temp folder, and then click OK.
e.Repeat steps c and d to set the value of the TMP variable.
f.Click OK two times.

5.Log off, and then log on to the computer by using SQL Server startup account.
6.Restart the SQL Server services.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.