|
Have you tried the DataAdapter.Update(DataSet) method?
|
|
|
|
|
Hi..
I want to compact and repair an Access 2000 file
i used DAO ( DBEngine.CompactDatabase )
but i get an error about an unrecognized format or corrupted file.
I think that compact and repair could be done by ADOX.
can any one tell how ???
|
|
|
|
|
I am writing a program which runs just fine in the computer where I am developing it. The OS is Windows XP. Since I wanted someone else to see my program I tried to run it on an old laptop that I have which runs on Windows 95. Unfortunately I got an error generated with _com_error which says:
Error Number: 0x80040154
Error Message: Class not registered.
This is part of the code
// Initialize the COM environment
if( FAILED( hr = ::CoInitialize( NULL ) ) )
{
_com_issue_error( hr );
return FALSE;
}
// Create a connection with the database
// THE PROGRAM FAILS RIGHT HERE
if( FAILED( hr = m_pConn.CreateInstance( __uuidof( Connection ) ) ) )
{
_com_issue_error( hr );
return FALSE;
} // end if
m_pConn->Open(L"Provider=Microsoft.Jet.OLEDB.3.0;\
Data Source=SomeDbFile.mdb;",
L"", L"", adOpenUnspecified );
I tried to register msado15.dll with regsvr32 in the computer which runs on windows 95 but that didn't work. Is there anything that I can do to to make the program run in Windows 95?
none
|
|
|
|
|
|
Thank you for your reply. I have a dial-up connection so it will take me a while to download the required files and see if they will work, but this is a very good start thanks to you.
none
|
|
|
|
|
hello @all,
i would like to tie up an access data base to a java program. i would like to make this gladly over JDBC and ODBC (is so desired). can someone explain to me as simply as possible, how i can make that?
thank you!
sunny
|
|
|
|
|
Helo
I know that I have done this before, controling howe the output-xml is formated.
The default i:
<newdataset>
<col1>val<col2>val
<col1>val<col2>val
But I want it to be:
<newdataset>
What is the property to set ????
|
|
|
|
|
And the xml visible.....
The default i:
<NewDataSet>
<table>
<col1>val</col1>
<col2>val</col2>
</table>
<table>
<col1>val</col1>
<col2>val</col2>
</table>
<NewDataSet>
But I want it to be:
<NewDataSet>
<table col1="val" col2="val">
<table col1="val" col2="val">
</NewDataSet>
What is the property to set ????
|
|
|
|
|
I answered your question in the C# forum.
|
|
|
|
|
Hi weird bug
on some PC's using a cdaodatabase to open(or create) a .mdb file,
the app crashes (yes i am trying to catch the cdaoexception), not on all PC's but they all do have office with access so you would think it would be ok
weird coz i cant seem to predict which PC's the code will crash on!
has anyone encountered this before?
Bryce
---
Publitor, making Pubmed easy.
http://www.sohocode.com/publitor
|
|
|
|
|
Try establishing a pattern for the crash.
Try checking the MDAC versions on the machines where it crashes and compare that to the MDAC versions on the machines where it doesn't.
|
|
|
|
|
indeed
one of them has office xp installed, so one would assume that a suitable version of mdac would have been installed
Bryce
---
Publitor, making Pubmed easy.
http://www.sohocode.com/publitor
|
|
|
|
|
is there a way to hook on system stored procedures or replace it, i want to hook or replace sp_who2, is there a way?, im using sql server 2000
|
|
|
|
|
This is NOT recommended since other users might rely on the system stored procedure for correct functionality.
However, you can replace them by going into the master database, dropping the procedure and then recreating it.
|
|
|
|
|
thanks let me try it
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
but i cant drop it i get an error
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
|
ok sorry.. forgot to tell you.. you need to perform the following steps first to enable changing of system stored procedures:
<br />
execute sp_configure 'allow updates',1<br />
go<br />
reconfigure with override<br />
go<br />
Once you are done, set allow updates to 0:
<br />
execute sp_configure 'allow updates',0<br />
go<br />
reconfigure with override<br />
go<br />
You do know that this is highly unsupported and not recommended..
|
|
|
|
|
still doesn`t work i dont know why, any other idea?, thanx for the help .
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
Please tell me what error you are getting.
|
|
|
|
|
i get a messagebox telling me that i cant erease system objects, im trying to delete sp_who from master database.
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
You need to perform the entire query with T-SQL as follows:
<br />
use master<br />
go<br />
execute sp_configure 'allow updates',1<br />
go<br />
reconfigure with override<br />
go<br />
drop procedure sp_who<br />
go<br />
execute sp_configure 'allow updates',0<br />
go<br />
reconfigure with override<br />
go<br />
|
|
|
|
|
thanks that worked , thanks for your help.
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
[^]
|
|
|
|
|
Is it possible to specify the port of a server in a DSN (when it not 1433, for instance)?
|
|
|
|
|
Yes it is:
connection.ConnectionString="driver={SQL Server};server=myserver;port=5000;uid=myuser;pwd=mypassword;database=mydatabase;"
|
|
|
|