ADO help needed - Database Discussion Boards

ylaine2-Mar-03 3:56

2-Mar-03 3:56

pcustomerid = ocm.Parameters.Add("@customerid", SqlDbType.VarChar, 50)
oopss.. that was an error(due to cut & paste).. i forgot to change that.. it's suppose to be Int.

ok Andy.. thanks a lot for ur help. i'll try this out asap..

Laine

Database ACCESS 97 to linked server SQL 2000

youssef26-Feb-03 23:23

youssef

26-Feb-03 23:23

Hi,

I have a SQL SERVER 2000,
I have a Database ACCESS 97 ( db.mdb)
I use Entreprise manager for link the DB ACCESS 97 by linked servers to SQL2000.
The only choice for PROVIDER NAME I have Microsoft Jet 4.0 OLE DB but for ACCESS 97 it is not good.

I don't have the possibility for chabge the DATABASE ACCESS 97 with other.

If anyone can help me or suggest a solution. Please contact me.

Best Regards

youssef

Re: Database ACCESS 97 to linked server SQL 2000

David Salter27-Feb-03 23:20

David Salter

27-Feb-03 23:20

Does the OLE DB Driver for ODBC drivers work?

Dave

Textbox Control databinding, a bug?

DionChen26-Feb-03 5:27

DionChen

26-Feb-03 5:27

Hi, all:

I have WinForm app to edit MS Access DB. On the dataset I have serveral Master-detail tables( the Relation is edited in the schema editorat design time, not runtime). The Master table is databind to a datagrid and detail tables are databind to either datagrids or a set of textbox controls. When I first load ( fill) the data, everything works fine and textboxes display the correct data. When I change selections in the master table, the textboxes change accordingly. Now, when I REOPEN the MDB file, the the tables which databind to the datagrid works as before, but the table that bind to a set of Textboxes do not have any data displayed. I can NOT figure it out what is wrong. I appreciate any help/insight you have. Thanks very much. The following is the code I used to bind the data after I open and fill the dataset: dsMain1

***************

textBox1.DataBindings.Clear();
textBox1.DataBindings.Add(new Binding("Text", dsMain1, "MyMaster.MasterToDetail.name"));
textBox2.DataBindings.Clear();
textBox2.DataBindings.Add(new Binding("Text", dsMain1, "MyMaster.MasterToDetail.Title"));
textBox3.DataBindings.Clear();
textBox3.DataBindings.Add(new Binding("Text", dsMain1, "MyMaster.MasterToDetail.Company"));

***************

Dion

DB access problem!!

Andrea Ferraro26-Feb-03 3:13

Andrea Ferraro

26-Feb-03 3:13

Hello guys,
I have a problem with my application.
I'd like to execute the store procedure with a datetime parameter.
It'll seem easy do it but in my case I have to convert a DBTIMESTAMP type from VC++ application.
So I need to know how pass the SQL datetime parameter to my SP having the DBTIMESTAMP value in my Server application.
Can anyone help me???

Thanks in advance for your support!!!;)

Andrea

Re: DB access problem!!

DiWa26-Feb-03 6:21

DiWa

26-Feb-03 6:21

Can only tell you how i do it with ODBC. There are Escape-Sequences, i.e. '{d 26-03-02}', the driver will convert it to a date your DB can understand.

dirk

Re: DB access problem!!

Andrea Ferraro28-Feb-03 3:06

Andrea Ferraro

28-Feb-03 3:06

Hi Dirk,
thanks in advance for your support
Fortunatly I resolved my problem!! Big Grin | :-D

Simply instead of pass the datetime value to my SP,I pass the TCHAR string and inside the SP use the CONVERT function.
In this manner in the C++ side (server) I can pass simply a BSTR parameter.

Bye
Andrea Smile | :)

ADO help needed

odeveloper26-Feb-03 1:09

odeveloper

26-Feb-03 1:09

Hi all

I m trying to learn VC++ database prog. in this regard i need help if
someone can create a small sample app as follows:

> IDE = VC++ 6
> Using ADO DSN less connection (Provider='' user='' password='' data source='')
> db contains two tables (table_a, table_b)
>each table contain 3 fields of datatypes Numeric, Char, Date
>data must populate in Edit Boxes via SQL statement which stored behind a button
>other buttons Add Update Delete (Add/Update will not work automatically as in Access or VB)
>data validation of table_a thru table_b during Add/Editing

I will be very grateful. This will help alot to understand VC database programing.
Suspicious | :suss:

Re: ADO help needed

Jon Hulatt26-Feb-03 4:22

Jon Hulatt

26-Feb-03 4:22

Look at http://www.codeproject.com/database/simpleado.asp[^]

#include <beer.h>

single access on store procedure

Delz25-Feb-03 21:00

Delz

25-Feb-03 21:00

Hello,

Is their a Critical section function on store procedure? Or what is the counter part of CriticalSection of C in store procedure script?

Re: single access on store procedure

SimonS25-Feb-03 21:22

SimonS

25-Feb-03 21:22

What are you trying to do?

You can lock tables, etc... yourself if you want, but that could slow your whole architecture down.

Cheers,
Simon

"I ask candidates to create an object model of a chicken.", Bruce Eckel on interviewing programmers.
animation mechanics in SVG (latest pic 1) (latest pic 2)

Re: single access on store procedure

Antares68626-Feb-03 0:15

Antares686

26-Feb-03 0:15

Yeah, you should by default allow SQL to handle locking. If you concern is that all processes should complete or fail look at

BEGIN TRANSACTION
ROLLBACK TRANSACTION
COMMIT TRANSACTION

Accessing Visual Fox Pro 3.0 Data

sybux200025-Feb-03 11:00

sybux2000

25-Feb-03 11:00

Hi,

I need to migrate an old database under Visual Fox Pro 3.0 to SQL Server 2000. I was looking around to got the connectionString for the olddbConnection object but I can't find anything.
I've tried to use the this one :
("Provider=MSDASQL; Persist Security Info=False;Data Source=Test")
but I got the following error message :

The .Net Data OLE DB Provider(System.Data.OleDb) does not support the MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers.

Does anyone know how to read data from Fox Pro ?
Thanx
Sybux

Re: Accessing Visual Fox Pro 3.0 Data

andyharman26-Feb-03 0:43

andyharman

26-Feb-03 0:43

You could try the ODBC.NET database provider:
msdn.microsoft.com/downloads/sample.asp?url=/ MSDN-FILES/027/001/668/msdncompositedoc.xml

ADO.NET specifically does not support the MSDASQL ODBC->OLEDB provider.

Regards
Andy

Re: Accessing Visual Fox Pro 3.0 Data

sybux200026-Feb-03 5:06

sybux2000

26-Feb-03 5:06

Thanx for your answer.

But the good url for other people in the same case is
http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/msdn-files/027/001/668/msdncompositedoc.xml[^]

Select statement

User 988525-Feb-03 8:34

User 9885

25-Feb-03 8:34

I want a select statement to have an index like

1, col1, col2, col3 ...
2, col1, col2, col3 ...

The first field should contain the row index of that row.

Is it possible without creating a temporary table?

My article on a reference-counted smart pointer that supports polymorphic objects and raw pointers

modified 29-Aug-18 21:01pm.

Re: Select statement

Jeremy Oldham25-Feb-03 14:19

Jeremy Oldham

25-Feb-03 14:19

Sure it is possible.

<br />
Create Table #tempTable<br />
(ID INT IDENTITY,<br />
col1 type,<br />
col2 type,<br />
...)<br />
<br />
Insert Into #tempTable (col1, col2, ...)<br />
Select col1, col2, ...<br />
From .....<br />
<br />
<br />
Select * from #tempTable<br />

This will add an incremented ID to the temp table, you can then select from.

Hope this helps.

Jeremy Oldham

Re: Select statement

User 988525-Feb-03 15:28

User 9885

25-Feb-03 15:28

Thank you very much. Rose | [Rose]

I wasted a lot of time trying to do it without a temporary table, and without luck.

My article on a reference-counted smart pointer that supports polymorphic objects and raw pointers

modified 29-Aug-18 21:01pm.

Re: Select statement

karl_w26-Feb-03 0:03

karl_w

26-Feb-03 0:03

This solution is for Oracle, I don't know if and how you can use it in other systems:

SELECT rownum, col1, col2, col3 FROM table;

--

karl

new CDaoRecordset in a DLL Problem

Crercio O. Silva24-Feb-03 17:02

Crercio O. Silva

24-Feb-03 17:02

Hi,

I have created a DLL which access the DAO objects (specially MSAccess
databases). In the code I create the CDaoRecordset with the new operator,
like this:

CDaoRecordset * CDaoClass::Query(CString query)
{
CDaoRecordset * pNewRecord = new CDaoRecordset(&m_pDatabase);
pNewRecord->Open(AFX_DAO_USE_DEFAULT_TYPE, query, 0);

return pNewRecord;
}

CDaoClass::CloseRecordSet(CDaoRecordset * pRecord)
{
pRecord->Close();
delete pRecord;
}

This works just as it should if the classes are in the main application,
but I'm getting an exception when in DLL the CDaoRecordset::Open() method
is executed. The other DAO methods are working fine, so I can list the
tables, change them, create indexes, relationships, etc. But I can't
execute queries that returns data.
When debugging the application I found out that there is an exception in
DAOCORE.CPP line 4855, shown bellow:

void CDaoRecordset::BuildSelectList()
{
ASSERT_VALID(this);
ASSERT(m_nFields > 0); // This line will assert since m_nFields is 0

m_strSQL += _afxSelect2;

CDaoFieldExchange fx(CDaoFieldExchange::AddToSelectList, this);
DoFieldExchange(&fx);
}

Does anyone have any clues about it?

Thanks in advance.

Crercio O. Silva / DBTools

Crercio O. Silva / DBTools Development
http://www.dbtools.com.br

MS SQL Server Licencing issues

Scorp1us21-Feb-03 4:23

Scorp1us

21-Feb-03 4:23

http://www.theregister.co.uk/content/53/29419.html

Oh what a tnagled web we weave, when what we use is not free!

Use PostgreSQL (www.postgresql.org) instead!
PS. Native Windows port coming soon. In the meantime, you can run it under Cygwin.

Re: MS SQL Server Licencing issues

Topper Price21-Feb-03 14:42

Topper Price

21-Feb-03 14:42

No thanks.

Re: MS SQL Server Licencing issues

Antares68625-Feb-03 0:51

Antares686

25-Feb-03 0:51

Makes you wonder what other MS Licenses may have holes in them. But did anyone figure out exactly what pieces they are barking about? Sounds like Olap/Analysis services but maybe even DTS as well.

ADO,VC++,AutoNumber,Access

Kamesh20-Feb-03 22:43

Kamesh

20-Feb-03 22:43

I need to create a table programatically in MS Access with
a field having data type AutoNumber.
I am using VC++ tool and ADO and Catalog Smartpointer for creation of tables.
Send me suggessions how to do it.

With Thanks & Regards
Kamesh

Problem with SQLDMO

fabjoe20-Feb-03 21:05

fabjoe

20-Feb-03 21:05

I have a problem with SQLDMO, in my MFC Application I use DMO to restore/backup a SQL DB; when I specify a path that contains blank spaces DMO fail to perform the operation because the resulting path is a merge from my path and the default one.
i.e. mypath = "D:\My Folder" resulting path =" C:\ProgramFiles\Microsoft SQL Server\.......\My Folder"
Can anyone suggest me any possible solutions ?
Thank you all!!!!

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