Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SunnyDee
Yak Posting Veteran
79 Posts |
 Posted - 2007-02-15 : 08:57:51
|
| Hi everyone:I have an vb application that reads from a sql file to an excel file and after the excel file is edited, the user can send the excel file to sql after some validations take place. The sql file can either be msde or sql 2000 depending upon selection of user from within the app.My problem is that I'm getting the error message "2147217900 - OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEdB.4.0' IDBInitialize:: Initialize returned 0x800040005: The provider did not give any information about the error.]. This occurs only when I try to write from the excel file to the SQL db. I can read and write from and to msde, and I can read from SQL 2000. So I am assuming this must be some sort of rights issue on SQL Server 2000. I am using excel 2003. Can someone please tell me where I can look to get more information on this issue.Thanks. |
|
|
SunnyDee
Yak Posting Veteran
79 Posts |
Posted - 2007-02-15 : 11:18:21
|
| As a followup, when I run a trace on the connection, I receive this message:Failed to set proper user name ('NT AUTHORITY\SYSTEM') for the connection[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'TblXMyTable' because this table does not exist in database 'master'. (State 42S02) (Code 4902)[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TblxMytable'. (State 42S02) (Code 208)[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error. (State 42000) (Code 7399)[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]. (State 01000) (Code 7300)I am especially puzzled by the second message because I am specifying the database name in my connection string as: "provider=sqloledb;data source=MyServer;initial catalog=MyDatabase;user id=UserX;password=PasswordX;database=MyDatabase"Any suggestions? |
 |
|
|
|
|
|
OLE DB Error Trace