one database file is on my server path is http:\\www.myservername\dbFilename.mdb.
i want to conect this file through ADO its connectionstring is
CString strConnection = _T("Provider=MSOLAP;Data Source=http://www.myservername.net/;"
but it gives error..it can't connect to database
plz...tell me which connection string is set to ado to connect to my database file. or any other way...how i connect to mydatabase...
Hi, thank for the articles.
I built some COM dll and this COM was
creating a new ado connection and execute some sql command.
My problem is, when a huge numbers of client was calling this COM, my sql connection was drop and i need to restart my COM server to make this situation back to normal (i'm afraid there is some memory leak but i'm not sure), so what should i do???
There are at least two ways to add a new record into a table,
one is to Execute SQL 'INSERT' statement, and another using
Recordset. I'm going to consider the second way, since it
is faster and more efficient.
So, In order to add a new record into the database, we need to do the following.
1. Instantiate and open a new record set as a table using existing Connection object:
great article. would really like to see part III on ADO, apartments, threading and passing ADO interfaces back and forth between apts. Or MTA, what to lock. Dealing with thread safe ADO and non-thread safe ODBC drivers in a multi-threaded app.