I have an NT server with a datasource called datHelp, it is an access database. The database also resides on the server. What do I tell my connectionstring to attach to the database, I tried using Machine name but I keep getting the datasource not found message. CAn I connect to an access database w...

I have 2 connections to the same database which both have the following properties: Mode = adModeShareExclusive and IsolationLevel = adXactReadCommitted;I then run a "SELECT * FROM TABLE_A FOR UPDATE" query for each connection by creating a recordset with a dynamic cursor and pessimistic locking...

I want to use IADORecordBinding to get the tablefields, under is source code :(temp_doc->m_pRecordset) ->PutRefSource( temp_doc->m_pCommand) ; (temp_doc->m_pRecordset) ->Open( &vNull , &vNull , adOpenDynamic,adLockOptimistic,adCmdText) ; (temp_doc->m_pRecordset) -> QueryInterfa...

I cant get any output parameters to work. I use CreateParameter on the _CommandPtr and append them all to the parameters collection ... values get passed in but output parameters come back as VT_EMPTY. I know the stored proc is fine coz it works when tested in the iSQLw environment (SQL Server).

How can I call 'Seek' on a recordset that contains two tables?

Hi, <br/>Can anyone tell me how can I set autoincrement field via SQL Statement or ADO.<br/>Thanks

Can anyone help me how to connect to SQL Server database using ADO recordset in VB? can you enlighten my mind about ODBC and DSN? I would appreciate a sample code. TY

Hi In my ASP code ,I have a problem .I want to add a new record in a Access DataBase. But IE reportserror like this"ADODB.Recordset error'800a0cb3' The operation requested by the application is not supported by the provider. "/guestbook/AddUserInfo.asp, line 8 my ASP Code is"LocalArray=App...

I wan't to pass a connection object from my<br/>ActiveX control to my ATL COM client. I have tried<br/>to pass the dispatch interface but it didn't really work.<br/>I'm thankful for any source code on this! (VC6)

Hi all, I need to use a Grid control and I want to avoid use a Adodc control, someone knows how I can connect a recorset directly <br/>to a grid?<br/>Thanks for your time,<br/>Regards,<br/>Persi

Can anyone specify which is the data provider for oracle 8i,as "msdaora.dll" is the data provider for Oracle7....

Hi. I have a question.I want to insert record into mdb file with sql "INSERT INTO Statement" .but the record values need read from a array.how can i do?code is likeconn.execute("insert into userinfo (name,sex,age,email,ccmail,Subscribe) values(array(1),array(2),array(3),array(4),array(5),array(6))...

How do I connect to MS Access using ADO?I used the following functionHRESULT CDBO::OpenConnection(_bstr_t pConnectionString){ //ConnectionString should be of the format //"DSN=;UID="";PWD="";" int li_Error = 0; HRESULT lhr; try { if (mPv_pConnectionPtr == NULL) CREATE_INSTANCE(mPv_pConne...

can i use ADO object within my worker thread(create by AfxBeginThread)?<br/>who can help me ?<br/>ADO Object:<br/>_ConnectionPtr m_pConnection;<br/>_RecordsetPtr m_pRecordset;<br/>hello

hi All,I am working on an application in which I am trying to insert some data in the SQL database version 7.0 My ADO version is 2.10.3711.9. I have written a VC++ client which "#imports" the ADO dll. My problem is that when I test this application with a single thread on the executors I can insert...

Hi I have a long SQL query which is to be execute through ADOIs there any property of ADO which set the length of Query because if i trims my query it gives me the data ,and if i use my full query then it dose'nt give the data ,though the DATa is on the table Thanks And RegardsAjay...

I have made a query in MS access which I am trying to call from ADO.I do not get any compilation or run time error but the query does not work on execution.In debug it says ADO unable to find the object referred to by the application.I have set CommandType as CmdStoreProc.Why is the access query not...

Hi,<br/>I would like to write and read audio/video data into/from a database.<br/>Could any one tell me how to do it?<br/>Thanks in advance.

Could someboy tell me where to find more information ( White Paper ) for ADO+. I would appreciate if some hot links could also be given.

Dear ladies and gentlemen,I am trying to use ADODB.Connection My code is working fine without the password but if I try to create database password I got the following error:Run time error ‘-2147467259(80004005):Could not find installable ISAM.The following is my code:Private Sub Form_Load()Dim cn ...

A while back, I'd developed a C++ SQL statement generator that would accept any series of column names (which for convenience were written by the user as an aliased/descriptive name) and would produce an SQL string with all appropriate JOINS as determined by the relationships in the database(s)...

using a MS ACCESS database through ADO, I meet some erratic errors when copying blob from one table to a new one using the following code.The original table contains 140000 records dim lnev as long,fld as field, localv as variant, str1 as string,rec as ADODB.recordset l...

Dear ladies and gentleman,I am using VB6.0 and Access 97. I am trying to open access Databas.mdb.This Database has a password. I did try to use Shell command but I found shell command work only for the EXE file and also I can not open it Automatically without typing the password. The reason I am usi...

I wrote three functions: dbgrid1_OnAddNew, dbgrid1_AfterColEdit, dbgrid1_AfterDelete, but these three events seems never triggered after I edited the column, deleted the column, and add new entries in the dbgrid1. I just do not how to make them work?<br/>Thanks.<br/>Sunny

Hi, I hava a connection to SQL server - cnnIn a given sublime momement i do the followingI use VBcnn.BeginTransaction//i do some stuff herecnn1.CommitTransactionFrom this moment on, the first try to do somethingwith some table from the connection i getthe message "Catastrophich failure".Can anyone t...

Dear ladies and gentlemen,I would like to know if there is any way to protect Access 97 database. I had the password and disconnect the shift key but I do not want any one to Import or Export from this Database. Also I want to open this database only from my application I am using vb6.0. I am thinki...

Hi,I am using OLEDB provider for SQL server to access the database. I am using the following code in VC++:BEGIN_ADO_BINDING(MyClassderived from CAdoRecordBinding)ADO_FIXED_LENGTH_ENTRY(1, adDBTimeStamp, mMyDateVar, status, FALSE)END_ADO_BINDING()where mMyDateVar is defined as:COleDateTime mMyDateVar...

Hi<br/>i wish to retrieve the list of contacts together with the details in my OUTLOOK from VC++ and possible to add to the contact list from VC++. I heard that we must use ADO for this. Can someone xplain how to do this. ANy sample code is welcomed.<br/>Thanx for the help<br/>Patrice

Hi, I have a program that use sql server.<br/>It keeps its tables in catalog.<br/>When I start it for the first time I want to create the catalog where I will keep my tables.<br/>Can anyone tell me how do I create it.<br/>Thanks

I can't seem to find this anywhere. Can someone please give me an explanation of all the parameters required in the Find function of an ADO recordset?Find (criteria, SkipRows, searchDirection, start)I know criteria is a search string, that's all. I do not know how to utilise the others. My...

I am trying to use ADO control,which is provided in microsoft registered ActiveX control.I am unable to use the wrapper classes which the wizard add.Can someone help me to use these classes.

We have a problem in accesing the records from the SQL Server Database. We do not have any Date field incorporated in the table which will show when the record is last added/modified (Record TIMESTAMP). We want to access the records added on specific date or records added/modified after specified da...

Dear ladies and gentlemen,Is it possible to let the system find the server and the volume for my application automatically without hard coded? My code is:With cn .Provider = "Microsoft.Jet.OLEDB.4.0" .Properties("Jet OLEDB:Database Password") = "Password" .Open "\\ServerName\Vol...

hi ,<br/>can anybody send me download URL for ADO+ component <br/>thankx<br/>venukumar.B

How to create a generic database application using the ADO which must be capable of exploring and modifying a database when only DSN is given. Every other information regarding the database must be fetched direectly from the databse.

I have the following code which works perfectly with SQL server.In Access it works perfectly for a select query.But the moment I change it to an Insert/Update/Delete query it fails at parameter binding.Can someone tell me what has to be done?int li_Error = 0;My code for the function is:try{ HRES...

does anyone know how to use a standalone vb program to invoke vb functions in a access database?

Hi,I'm attempting to insert date/time values into an Oracle database, and am having trouble with the syntax of the command. I'm formatting a BSTR within C++ that is going to hold my Insert command. The command looks like this:_bstr_t strSQLInsert("INSERT INTO Table VALUES"); strS...

Hi, <br/>I want to make a dialog that will connect my application to sql server and I want to load all available in an combobox so that the user can choose to which one he would like to connect.<br/>Is there a way to get the name of all available(running) sql servers?<br/>Thanks

How can I access the Fields information in the WillChangeField event?<br/>Thank in advance?

Hi everybody,<br/>I would like to know how to create INI file and how to connect to VB6.0.<br/>If you have simple example I appreciated a lot.<br/>Thanks for your help. <br/>Bill

Does anyone know the cause of this error? I got this error in a visual basic program. The program was running fine and suddenly the program got stuck. I had to restart my computer to recover the program. I contacted my DBA and he said nothing was wrong on Server side.This is the message:-2147467259,...

I am creating a disconnected custom recordset. I want that one of the fields in this recordset be of a user defined type. We have "adUserDefiend" type constant defined. But I am unable to add values to this field..<br/>Please help..

my problem is that i don't known how i can display my picture database after use the GetChunk function and after store in a COleVariant.<br/>I have make a test with COleVariant value.<br/>The test create a file with the COleVariant picture value but the format of the file isn't valid. Why?...

Hi All!I need to get data from database using ADO.When I get numbers or short strings, I use:_variant_t v;v = rs->Fields->Item[(long)0]->Value;v.ChangeType(VT_BSTR); // here I get assertionint iLVItem = lst->InsertItem(0, (LPCTSTR)(CString)v.bstrVal);It works.But when I need to get data...

I have a DB with 2 tabels I've created a Sql query in the data enviroment,it's a join from the 2 tables.(when T1.id=T2.id return the "name" of the specific id from the sec' table).when I place the a DataGrid on the form,and make .Addnew & .Update I don't get the "name" for that s...

i have store a picture in my database.When i use ADO for read my picture, i have a display problem, because i have already use the GetChunk function and already store my picture value in COleVariant but my problem is how i can display my picture database with the COleVariant value.Thanks for your he...

How to access the field secondary property(such as IsNullable, MaybeNull etc.) in ADO with C++

there is a bug with column creation. _Catalog *tmpCatalog; _Table *tmpTable; _Recordset *tmpRecord; Columns *tmpColumns; Tables *tmpTables; strConnection = L"Provider=Microsoft.Jet.OLEDB.4.0;" L"Jet OLEDB:Engine Type =4;" L"Data Source="+CString(accessFile)+";"; tmpCatalog = new _Cat...

how can i know that which is the primary key in a table using ADO..I am working with VC++