|
Add the Access database to the SQL Server as a "Linked Server" then you should be able to write an update statement from a regular SQL statement.
"People who never make mistakes, never do anything."
My Blog
|
|
|
|
|
What do you want to do. Update MS-Access Database with the stored procedure of SQL server or have your own update stored procedure for MS-Access.
Akif
|
|
|
|
|
When attaching a database that was detached from another SQL Server instance.
I got the error message below:
Error 602: Could not find row in sysindexes for database ID 25, object ID 1,
index ID 1. Run DBCC CHECKTABLE on sysindexes.
how can i solve this problem. i am using SQL Server 2000
Thanks and Regards
|
|
|
|
|
check out this
http://databasejournal.com/features/mssql/article.php/2224361
|
|
|
|
|
I have read article "Making ATL OLE DB Provider templates support updating of data" at www.codeproject.com. Through reading your article, you must be a professional in "OLE DB Provider" field, I think so. Now, would you like to give me some help about this issue? You will be pretty appreciated.
1. In the file "IRowsetChangImpl.h" of your "Simple Data Object with update support", there is a row of code "HRESULT hr = pT->GetDataHelper(hAccessor, pColInfo, (void**)&pBinding, pDstData, cCols, spConvert, pRow);"(lies in method "SetDataHelper"). But there is not definition and implementation of "GetDataHelper". How to resolve it?
2. Now, I'm building up a updatable OLE DB Provider. This provider will be run in MS SQLServer DTS. First "Transform Data Task" of MS SQLServer DTS get the rowset from SQLServer, then call this provider, and pass rowset data to my provider by calling IRowsetChange::SetData(HROW hRow, HACCESSOR hAccessor, void* pSrcData). My questions are as following:
1) "Transform Data Task" pass the new data(a row of data include 10 columns) to my provider through method "SetData(HROW hRow, HACCESSOR hAccessor, void* pSrcData)". Is it correct?
2) I have get the DBBINDING info by the next code:
STDMETHOD (SetData)(HROW hRow, HACCESSOR hAccessor, void* pSrcData)
{
DBACCESSORFLAGS *pdwAccessorFlags;
DBCOUNTITEM *pcBindings;
DBBINDING **prgBindings;
DBBINDING *pBindings;
pdwAccessorFlags = (DBACCESSORFLAGS *)::calloc(1, sizeof(DBACCESSORFLAGS));
pcBindings = (DBCOUNTITEM *)::calloc(1, sizeof(DBCOUNTITEM));
pBindings = (DBBINDING *)::calloc(1, sizeof(DBBINDING));
prgBindings = &pBindings;
HRESULT hr = this->GetBindings(hAccessor, pdwAccessorFlags, pcBindings, prgBindings);
return S_OK;
}
Now, how can I extract data from pSrcData? I'm puzzled.
Expect for your reply!
Thanks in advance!
|
|
|
|
|
Hi All,
I am using SQL server 2000, one of my data base log file size has reached to the size of 30 gb. Even after transactional back up size did not decrease. Then I delete the log file and recreated it, still it is growing remarkably.
My datbase setting for Recovery Intreval is 0(zero) minutes.
Can anybody tell me why this file is increasing so fast?
Thanks for the help.
|
|
|
|
|
select itemlookupcode,extendeddescription from item where itemlookupcode = '14010006'
the extendeddesription data type is ntext
i get the error when executing the command
An error occurred while executing query:<br />
<br />
Page (1:735), slot 40 for text, ntext, or image node does not exist.
i cannot even execute the delete and update statement to amend this row, any1 can help me?
|
|
|
|
|
|
no...
i upgraded to SQL 2000 SP 4, the problem still occur...
|
|
|
|
|
Well then, here's another possibility:
http://support.microsoft.com/kb/890755[^]
Incidentally, I have found these by Googling for the following:
Page slot for text, ntext, or image node does not exist.
so if the technote doesn't apply for you, you may want to Google the above phrase yourself and see what you can get.
|
|
|
|
|
try by converting column extendeddescription into varchar
select itemlookupcode,Convert(varchar,extendeddescription) as description from item where itemlookupcode = '14010006'
|
|
|
|
|
Albanian wrote: try by converting column extendeddescription into varchar
select itemlookupcode,Convert(varchar,extendeddescription) as description from item where itemlookupcode = '14010006'
Still cannot solve the problem, below is the Error Return by Query Analyzer:
<br />
Server: Msg 7105, Level 22, State 6, Line 1<br />
Page (1:26314), slot 66 for text, ntext, or image node does not exist.<br />
<br />
Connection Broken
Any1 can help me please??
|
|
|
|
|
Framework 1.1Access 2003 DB WEBFORM
I'm Trying to generate to Dataset some detail using adapter and OLEDbconnection
but i have strenge error Message IErrorInfo.GetDescription fail with E_FAIL(0X80004005).
the Query is very simple something like that
select * from found
i did every thing with qureybuilder etc...
Do have any idea what is the Problem?
|
|
|
|
|
How do I create new records in a table which contains multiple foreign keys using a DataSet?
|
|
|
|
|
hai this is bikshamaiah i am the new friend of ur group
please give me windows services programing give me the ex programing
bikshamaiah.g
|
|
|
|
|
bikshamaiah.g wrote: please give me windows services programing give me the ex programing
What does that mean?
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
bikshamaiah.g wrote: please give me windows services programing give me the ex programing
You want to know how to write a service ? Google is your friend. And it has nothing to do with SQL, why did you ask here ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I've a database access with 1 OLE OBJECT field contained an Image.
I've queried the database the result is in the DataSet.
Now i would to get the image contained here:
myDataSet.Tables[0].Rows[i]["Image"]
how?
|
|
|
|
|
You can read data from a DataSet simply by using the following code:
byte[] _Image = (byte[])myDataSet.Tables[0].Rows[0]["Image"];
MemoryStream ms=new MemoryStream(_Image);
Image image=Image.FromStream(ms);
Now you have your image reconstructed if you have stored it as binary data.
Akif
|
|
|
|
|
Hi all,
Any ideas why SQL Server 2003 stopped working when I installed IIS?
TIA,
Steve.
|
|
|
|
|
viaduct wrote: SQL Server 2003
No such product.
In general installing IIS should not stop SQL Server from functioning.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Hi i am using this sql statement on (SQL Server 2000) and tryin to sort the results on tl.Date but as i have already casted it to a nvarchar it sorts it like a char so im just wondering if anyone has any idea how to sort it by date correctly. thanks in advance Tim
select SUBSTRING(CAST(tl.Date as nvarchar), 0, 12) as 'Date',<br />
tft.BodyWeight from Person as p<br />
left join TrainingLog tl on tl.PersonId = p.Id<br />
left join TrainingFitnessTesting tft on tl.Id = tft.TrainingLogId <br />
where p.Id = 8 <br />
and tl.Date >= '01 January 2005' <br />
and tl.Date <= '03 January 2006' and tft.BodyWeight IS NOT NULL <br />
order by tl.Date asc
|
|
|
|
|
As per my knowledge this query will work fine and will display the result sorted based on tl.Date as Date. I may be mis-understanding your question but I think as you have converted Date into nvarchar in select clause not in Order By clause, hence it will have no effect on the sorting.
Akif
|
|
|
|
|
someone has actually solved the problem now but just in case u would like to know when i got a substring of the date i got dates like
Dec 12 2005
Sept 23 2005
sorted incorrectly as sept should be before dec but because they are nvarchar they are sorted as characters as in D comes before S in the alphabet hopes this clears it up
thanks anyway Tim
|
|
|
|
|
hi all,
In crystal report pull model i am getting following error.
Logon failed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
how can i rectify ths problem.
expecting immediate response.
thanks n advance
rs_net
|
|
|
|