About the DataSet - Database Discussion Boards

First Prev Next

Re: Code generator?

Davy Mitchell9-Apr-03 23:09

Davy Mitchell

9-Apr-03 23:09

Not sure about your question (first one). I once wrote some ASP to generate ASP pages using the FSO which worked fairly well. Maybe a starting point if you have to roll your own?

Davy

Blog for Software Testing, Bugs, Quality, Security and Stability - www.latedecember.com

News From Angus, Scotland - The Angus Blog
My Personal Blog - Homepage.

Re: Code generator?

Roger Alsing10-Apr-03 0:01

Roger Alsing

10-Apr-03 0:01

no , what i ment with asp like template was that i want to be able to script the output of the generator in the same way as you script an asp page , but instead of outputting the result to a browser , i want to output it to a file.
(and not make the asp'ish code itslef write to a file via fso)

ive seen lots of template based generators , but none that actually can handle relations in a database...

//Roger

Re: Code generator?

coge13-Apr-03 12:08

coge

13-Apr-03 12:08

llblGen will follow relations.
take a look at www.sd.nl

Take Care

HOWTO: Insert SQL NULL using ADO Recordset and VC++?

Dan Thurman9-Apr-03 8:52

Dan Thurman

9-Apr-03 8:52

One of these darn things I keep forgetting is how
to insert a SQL NULL value into a column using ADO
in VC++ code!
Grr... Mad | :mad:

I do not want to use a SQL statement or
a stored procedure!! That is too easy. Here is what
I am looking for, something like:

pRst->Fields->Item[colAdminSvrPwd]->Value = (LPCSTR)NULL;
pRst->Fields->Item[colAdminSvrPwd]->Value = (LPCSTR)0;
pRst->Fields->Item[colAdminSvrPwd]->Value = (LPCSTR)'\0';

Keep in mind that these are VARIANT types so
conversions are applied implicitly and the above
code does not work.. so what does?

Thanks in advance!

Re: HOWTO: Insert SQL NULL using ADO Recordset and VC++?

Le centriste11-Apr-03 7:17

Le centriste

11-Apr-03 7:17

Try

pRst->Fields->Item[colAdminSvrPwd]->Value = _variant_t();

Re: HOWTO: Insert SQL NULL using ADO Recordset and VC++?

Dan Thurman11-Apr-03 8:30

Dan Thurman

11-Apr-03 8:30

Do you have to declare a variant variable first
then it's type? I mean is that what _variant_t()
is doing? I will try this out! Currently I am
using the code below and it works:

_variant_t vtNull;
vtNull.ChangeType(VT_NULL);
pRst->Fields->Item[colAdminSvrPwd]->Value = vtNull;

Blush | :O

Re: HOWTO: Insert SQL NULL using ADO Recordset and VC++?

Le centriste11-Apr-03 10:37

Le centriste

11-Apr-03 10:37

ADO treats VT_EMPTY and VT_NULL as the same (SQL NULL).

About the DataSet

DS__9-Apr-03 5:50

DS__

9-Apr-03 5:50

hi all ,
i am not a newbie (i've been programming for 9 years) , but i am a newbie to .NET.

i have 2 questions a bout the dataset...
1)briefly , i have 3 simple queries to execute and insert the 3 tables to the dataset . can i execute all 3 of them at the same time (or one after the other) , but sending the SQLs to the server at a single time and get the result of all 3 queries in the same time (instead of executing 3 Queries...)? (i only read the data , so do i have to use the DataAdapter or can i just use the Reader?)

2)i want to update the table with the changes maded to the dataset's Table , but i have 21 keys (its not actually 21 keys , but its 21 fields that are critical to determing which rows to update) , so how can i make the DAtaTable update my rows (its a lot of rows , i dont want to execute so much UPDATE commands...

thanks.

Re: About the DataSet

Le centriste11-Apr-03 7:19

Le centriste

11-Apr-03 7:19

Have you tried the DataAdapter.Update(DataSet) method?

Compact and repair ADOX

Hesham Amin8-Apr-03 12:30

Hesham Amin

8-Apr-03 12:30

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

ADO Error I assume

Toni788-Apr-03 11:20

Toni78

8-Apr-03 11:20

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

Re: ADO Error I assume

Rein Hillmann8-Apr-03 11:29

Rein Hillmann

8-Apr-03 11:29

See this article:

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

Thank you Reinout Hillmann

Toni788-Apr-03 12:22

Toni78

8-Apr-03 12:22

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

JDBC!! HELP!!!!

Sunnygirl8-Apr-03 6:00

Sunnygirl

8-Apr-03 6:00

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

Formating the xml-output from a DataSet

Andreas Knapp8-Apr-03 3:46

Andreas Knapp

8-Apr-03 3:46

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

Re: Formating the xml-output from a DataSet

Knappen8-Apr-03 3:57

Knappen

8-Apr-03 3:57

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

Re: Formating the xml-output from a DataSet

Le centriste8-Apr-03 11:01

Le centriste

8-Apr-03 11:01

I answered your question in the C# forum.

cdaodatabase create/open causes crash

bryce8-Apr-03 3:30

bryce

8-Apr-03 3:30

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

Re: cdaodatabase create/open causes crash

Rein Hillmann8-Apr-03 10:59

Rein Hillmann

8-Apr-03 10:59

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.

Re: cdaodatabase create/open causes crash

bryce8-Apr-03 11:54

bryce

8-Apr-03 11:54

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

modify system stored procedures?

Rene De La Garza7-Apr-03 7:41

Rene De La Garza

7-Apr-03 7:41

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

Re: modify system stored procedures?

Rein Hillmann7-Apr-03 8:56

Rein Hillmann

7-Apr-03 8:56

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.

Re: modify system stored procedures?

Rene De La Garza7-Apr-03 11:18

Rene De La Garza

7-Apr-03 11:18