|
Thanks for ur reply, I am trying to create OLE-DB provider. But its giving error. Should I register the COM component? I didn't do this. Please help me.
ALL THINGS ARE POSSIBLE UNTIL THEY ARE PROVED IMPOSSIBLE-AND EVEN THE IMPOSSIBLE MAY ONLY BE SO,AS OF NOW
|
|
|
|
|
Typically a provider will be registered properly by its installer, so that's unlikely to be the problem. Have you called CoInitializeEx or OleInitialize on this thread?
I suggest checking the return value of CoCreateInstance in winerror.h to see if there's a better description of the error.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Hi Friends,
Is it possible to have both servers installed on same machine and concurrently working?
Vikram S
VikramS
|
|
|
|
|
You mean 2000 - is that 8.0?
You can have them both installed on the same machine. I believe you want 7.0 to exist and then install 2000 as a new instance - but I not sure that is a requirement.
Barbara
|
|
|
|
|
As the other reply... the answer is YES... but I was wondering 'why would u need that'
I was born intelligent
Education ruined me!.
|
|
|
|
|
Am having major problems trying to connect an Access database to my webpage via dreamweaverMX.
|
|
|
|
|
What connection string are you using?
Michael Flanakin
Web Log
|
|
|
|
|
I created a database application in Acess and I want to connect to my website. I published my web using DreamweaverMX. For example I have a login page that I want to be validated with the data(names) in my Acess table. Eartlink is my webhost and they do not support ASP. So, my question is three folds.
1. Do you know the steps to make the connect using a login page as an example?
2. Do I have to convert to MySql in Acess?
3. Do you know of any good book? they ones that i'v tried pretty much suck
|
|
|
|
|
What language do you plan on doing this with? Or, do you even have a plan? You will first need to find out what Earthlink can support. If you're deploying to their servers, you are limited to their list of supported technologies. It is very likely that they don't support scripting (ASP, PHP, Perl, etc.) or compiled (ASP.NET, JSP, etc.) technologies. You need to find this out first.
Michael Flanakin
Web Log
|
|
|
|
|
iamucha wrote:
Am having major problems trying to connect an Access database to my webpage via dreamweaverMX.
If u get error message... whats the error message
I was born intelligent
Education ruined me!.
|
|
|
|
|
Hello all.. I use CDatabase and CRecordSet to access to MS Access database
Here what I did to update some record of the table
I have database called db1 and it contains table1
table one contains three columns, data1, data2, and data3
and I have an array to insert to the table1,
I want to update data2 if data3 = true
so I wrote the following code..
<br />
CDatabase db;<br />
MyCRecordSet(&db);<br />
<br />
BOOL bSuccess = db.Open(mdsn, FALSE, FALSE, "ODBC;",FALSE);<br />
tablename = "table1";<br />
rs.Open(CRecordset::forwardOnly,tablename); <br />
for(int i=0;i<5;i++)<br />
{<br />
CString qstr = "Update " + tablename + " set data2 = '" + arr(i) + "' where data3=1";<br />
rs.m_pDataBase->ExecuteSQL(qstr);<br />
rs.Requery();<br />
<br />
}<br />
db.Close();<br />
but the table didnt' get updated..
why..is it?
Thank you
|
|
|
|
|
Bill Gates says  :
CRecordset::forwardOnly A read-only recordset with only forward scrolling
|
|
|
|
|
Hello,
I've got the problem to keep a datagrid updated, everytime
changes at the database-table(sql-server) are made.
My first idea was to do this by polling (timer) and filling a DataSet,
but it seems not the best way
Does anyone have suggestions?
thanks
Jörg
|
|
|
|
|
There's currently no way for SQL Server to tell you when an update has occurred - this feature is coming in the next version, now due next year.
For the moment, you have to poll.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Hi Friends,
I have some workflows created using office 2000 on sql server 2000(default instance). Now I want to port this workflows over Office XP developer using sql server (named instance). Here I am using template for parting. While Instantiating the template it gives me follwing error dialog box
---------------------------
DCOM Server modTBAD failure
---------------------------
The wizard is unable to create an application from the template because the DCOM server modTBAD failed to successfully complete the task.
---------------------------
OK
---------------------------
Does Anybody know the problem soln?
Vikram S
|
|
|
|
|
I'm trying to update an access database via the update method from a modified dataset.
I know the dataset is modified, and the DataAdapter is valid and functional.
I fill my dataset with this command in the data adapter:
"SELECT [File Extentions].*
FROM [File Extentions]"
Then, i add a number of rows via this method:
private bool Add(string extention, Type castType)<br />
{<br />
DataTable currentTable = ds_Data.Tables["Table"];<br />
<br />
DataRow newRow = currentTable.NewRow();<br />
<br />
newRow["File_Extention"] = extention;<br />
newRow["File_Type"] = castType;<br />
<br />
currentTable.Rows.Add(newRow);<br />
<br />
ds_Data.AcceptChanges();<br />
<br />
adapter.Update(currentTable);<br />
<br />
return true;<br />
}
The changes are reflected in the data adapter, but not in the database.
Does anyone know why this is?
Cheers
Cata
|
|
|
|
|
I think it is because you are calling ds_Data.AcceptChanges().
It commits all the changes made to your dataset which means the DataRowState for all rows are changed from Added to Unchanged. Therefore, your adapter.Update(currentTable) won't update your database as the data in the table is considered original/unchanged.
Just remove the ds_Data.AcceptChanges() as the adapter.Update() will automatically call this for you. As long as you set the right InsertCommand your database should be updated.
Edbert P.
Sydney, Australia.
|
|
|
|
|
[EDIT]:
Sorry, found out why it was spitting it out. Didn't like spaces in the table name. My mistake, thanks for the help.
[EDIT]
If i don't use AcceptChanges, it throws an OLEDBException when i try to run the update method.
Any other ideas?
I'm pretty new to DB programming, just trying to get all the n00b stuff under my belt.
Cata
|
|
|
|
|
In trying to create a recordset I keep getting an error when I open it under C#. I would use ADO.NET, but for backwards compliance with the application it talks too, I need ADO 2.6. Below is a snippet of the code I am using. If anyone has input as to what the problem may be, please let me know.
[code]
ADODB.Recordset rs = new ADODB.Recordset;
Object obj1 = null;
Object obj2 = null;
rs.Fields.Append( "Name", adVarChar, 32, adFldMayBeNull, null );
rs.CursorLocation = adUseClient;
rs.Open( obj1, obj2, adOpenForwardOnly, adLockReadOnly, -1 );
[/code]
This code causes a COMException under C# that says: "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." The same code works fine under regular c++ and VB6. Does anyone have any input to this?
|
|
|
|
|
If you need to omit an optional parameter in a COM call using C#, you should use System.Reflection.Missing.Value.
ADODB.Recordset rs = new ADODB.Recordset();
rs.Fields.Append(
"Name",
DataTypeEnum.adVarChar,
32,
FieldAttributeEnum.adFldMayBeNull,
null );
rs.CursorLocation = CursorLocationEnum.adUseClient;
rs.Open(
Missing.Value,
Missing.Value,
CursorTypeEnum.adOpenForwardOnly,
LockTypeEnum.adLockReadOnly,
-1 );
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Thank you very much. I am still learning the intricisies of C# and haven't looked into the System.Reflection namespace much yet. Everything works fine now. Thanks for the help.
|
|
|
|
|
just one small question
in my prog i have an i_data value from listctrl and i want to move in recorset
to record with the same ID member, so i'm doing this:
pDoc->m_fmediaMDBSet.MoveFirst();
while (!pDoc->m_fmediaMDBSet.IsEOF()) {
if (pDoc->m_fmediaMDBSet.m_ID == i_data)
break;
pDoc->m_fmediaMDBSet.MoveNext();
}
ASSERT(pDoc->m_fmediaMDBSet.m_ID == i_data);
...
and i don't like it 
is there a better (and faster) way to do this job?
thanks again
Chris
|
|
|
|
|
(Beep) not enough information to proceed (Beep)
My solution to such a problem:
I keep the recordset and the list-control in sync, so that the index of the list-element is the same as the one in the recordset, ie
int nIndex;
if( -1 ==( nIndex =GetListCtrl().GetNextItem( -1, LVNI_SELECTED )))
{
return;
}
m_pSet->SetPosition( nIndex+1 );
hope it will help ,
dirk
|
|
|
|
|
yess (: it is what i was looking for
I was using old mfc4.1.hlp documentation and there is nothing about
CRecordset::SetAbsolutePosition(..)
thanks
Chris
|
|
|
|
|
Hi
I need a free SQL Server 2000 E-Book
Who can help me
i fpund one but it was in chinees language..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
