Database Discussion Boards

Making ATL OLE DB Provider templates support updating of data

haiyonghan3-Jan-06 20:14

3-Jan-06 20:14

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!
D'Oh! | :doh:

SQL SERVER log file increasing remarkably

Member 20731413-Jan-06 20:03

Member 2073141

3-Jan-06 20:03

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.

Sql statement error with ntext field

MJay3-Jan-06 15:48

MJay

3-Jan-06 15:48

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? Frown | :(

Re: Sql statement error with ntext field

Mike Ellison3-Jan-06 17:32

Mike Ellison

3-Jan-06 17:32

Is this article applicable to your issue?

http://support.microsoft.com/default.aspx?scid=kb;en-us;320434&sd=tech[^]

Re: Sql statement error with ntext field

MJay3-Jan-06 19:35

MJay

3-Jan-06 19:35

no...
i upgraded to SQL 2000 SP 4, the problem still occur... Cry | :((

Re: Sql statement error with ntext field

Mike Ellison4-Jan-06 7:07

Mike Ellison

4-Jan-06 7:07

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.

Re: Sql statement error with ntext field

albCode4-Jan-06 0:18

albCode

4-Jan-06 0:18

try by converting column extendeddescription into varchar

select itemlookupcode,Convert(varchar,extendeddescription) as description from item where itemlookupcode = '14010006'

Re: Sql statement error with ntext field

MJay4-Jan-06 2:30

MJay

4-Jan-06 2:30

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?? Cry | :((

E Fail Problem

rchokler3-Jan-06 10:31

rchokler

3-Jan-06 10:31

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?

Creating new Child records with a DataSet

WindSailor3-Jan-06 9:17

WindSailor

3-Jan-06 9:17

How do I create new records in a table which contains multiple foreign keys using a DataSet?

.net

bikshamaiah.g3-Jan-06 5:47

bikshamaiah.g

3-Jan-06 5:47

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

Re: .net

Colin Angus Mackay3-Jan-06 9:26

Colin Angus Mackay

3-Jan-06 9:26

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

Re: .net

Christian Graus3-Jan-06 16:06

Christian Graus

3-Jan-06 16:06

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++

Getting an image from dataSet

Sasuko3-Jan-06 0:32

Sasuko

3-Jan-06 0:32

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?

Re: Getting an image from dataSet

S. Akif Kamal3-Jan-06 1:59

S. Akif Kamal

3-Jan-06 1:59

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

SQL Server / IIS incompatibility

hairy_hats2-Jan-06 23:48

hairy_hats

2-Jan-06 23:48

Hi all,

Any ideas why SQL Server 2003 stopped working when I installed IIS?

TIA,

Steve.

Re: SQL Server / IIS incompatibility

Colin Angus Mackay3-Jan-06 2:02

Colin Angus Mackay

3-Jan-06 2:02

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

Sort By Date??

tadhg882-Jan-06 23:15

tadhg88

2-Jan-06 23:15

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

Re: Sort By Date??

S. Akif Kamal3-Jan-06 2:46

S. Akif Kamal

3-Jan-06 2:46

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

Re: Sort By Date??

tadhg883-Jan-06 5:46

tadhg88

3-Jan-06 5:46

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

pls help me out..its urgent...

rs_net2-Jan-06 22:14

rs_net

2-Jan-06 22:14

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

SQL Server upgrade Problem

dl4gbe2-Jan-06 16:02

dl4gbe

2-Jan-06 16:02

Hallo All

Happy New Year.

I run into a big problem. I used for quite a time SQL Server Express Sql non-release 587. Now I would like to migrate the data to another server using sql Express release. Everything I tried did not work. Attaching the database, Backup restoring the database , nothing worked. Always I get an incompatible version error.

Is there a tool avaiable like imp/exp in Oracle or mysqldump?

Sincerely

Chris

Vietiane/Laos

P.S. I can't use graphical tools or sqlwebadmin. Non of them work with 587
P.P.S. I already contacted Microsoft for this. They say 587 is too old for migration. Only the full SQL Server could do this, not Express.

-- modified at 1:25 Tuesday 3rd January, 2006

Re: SQL Server upgrade Problem

JimmyRopes2-Jan-06 17:16

JimmyRopes

2-Jan-06 17:16

sawat dii bi mai

Try an import/export format recognized by both DB engines.

For example comma separated values (.csv) or any other format both DB engines understand.

Export to a CSV file and then use it to import to the new DB.

I'm on-line therefore I am.

JimmyRopes

Re: SQL Server upgrade Problem

dl4gbe2-Jan-06 17:52

dl4gbe

2-Jan-06 17:52

sawat dii Jimmy Ropes

Sawat di bpii mai duay
Chook dii mak
kop hkun krap khian jotmai hai pom

The problem is that the database is quite complicated. Tons of foreign keys for example. I need a way to extract the structure. Like create table statement e.t.c. I do not have a complete table creation script. Some parts of the application were done by different people. I really need something like mysqldump. I just now try to download Sql Server Eval to the new server in Europe. Microsoft SQL Team sugjested that!

Sincerely

Chris
Vietiane Laos (PDR)

P.S. Just now I am in Bangkok (oriental city) So greetings from Bangkok Smile | :)

Are you in BKK or Thailand just now?

Re: SQL Server upgrade Problem

JimmyRopes3-Jan-06 5:43

JimmyRopes

3-Jan-06 5:43

Sawat dii Chris,

The export to CSV may still work because when you export the CSV formatted file you can make it copy the Field Names in the first line as the column headers and the following lines are the data that were in those columns.

On the file menu select get external data and then import. When you import you can select your own primary key and you will have the same table structure as in the old data base. After all the tables are built you go back to the file menu and select get external data again but this time select Link Tables. You can make the table links from here one at a time.

In this way you can preserve the structure of the old data base.

If the old DB manager does not allow you to put the field headers in you can do it manually in notepad. If the new data base does not accept CVS format (I think they all do) you can import to a newer version of SQL Server or Access and then export to a format that the new data base engine knows about.

chok dii mak krap

I live up-country in Issan (North East Thailand). Changwat Buriram, which is in the southern end of Issan and is a border province with Siem Reib - Oddar Meanchey Province in Kampuchea. I do not go to Bangkok very often. I grew up in New York City and do not like big city life very much. A few days at a time are enough to get the things I need and then I am back on the train to Buriram. What part of Bangkok are you staying in?

I used to go to ViangChan for three month visas from the Thai embassy but when a border crossing opened up not too far from my house (near KapCheong) about two years ago I find it less expensive to go there every month than to have my wife drive me to NongKhai, stay in ViangChang for three days and then have her drive back to NongKhai to pick me up again. Now that petrol is so expensive the cost is even higher.

It costs around 2500 Baht (662,050 Kip) for transport and visa fees to go once a month to KapCheong. If I go to ViangChang it used to cost me around 10,000 Baht (2,648,200 Kip) and that was 2 years ago. The cost will be higher now. When I add up all the expenses by getting 3 one month visas I save around 2500 Baht.

In some ways I miss going to ViangChan because it is a small city and I do not mind going there. The last time I was there there was a very big road being built running in front of the Morning Market so it looks like ViangChan was starting to grow but it will probably be a few more years (hopefully many years) before you have traffic jams like Bangkok, Hanoi or HoChiMin City.

I do want to go to LouangPhrabang some time but the last time I was in ViangChan was not too long after the bus and truck were attacked (on Highway 13) 2 or 3 years ago. A few people died so was afraid to be going by road at the time. I haven’t heard of any more attacks so the next time I decide to take a break and go LPDR for a visa I think I will take 3 or 4 days and go north to see the interior.

I once crossed the Nam Mae Kong and visited a little village in the south. It was north of Pakse but that is as far as I have visited LPDR. When I do get to ViangChan again we will have to meet and have a BierLao.

I'm on-line therefore I am.

JimmyRopes

-- modified at 11:48 Tuesday 3rd January, 2006

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.