Hi,Does anyone know if MSSQL stored procedure can return a string? As far as I know a stored procedure can only return an integer that tells whether the stored procedure fails or not. What I want to do is to use two stored procedures - one calls the other procedure, that returns a string to the call...

the hoilidkqjfliqefjailezfhpaoIF

I use an ADO to connect to my Access database .When I update the database and print the updated table via a DataReport, the update is printed at the first update, but any subsequent update is not shown on the print, although, when I open the table, the update has been made.Anyone can explain ? Any...

How do I create table using ADO<br/>My DSN is IBM DB2 ODBC DRIVER<br/>I've tried to use ADOX but it's incompatible with my DSN

I have an application that accesses an MS Access (Office 97) database.Differerent Recordsets may be selected by clicking on a menu item. I can scroll through them with out any problems...and they do contain the right amount of records no matter which one I select.My problem is that I cannot update a...

hi all,there r 2 different databases e.g. databaseA and databaseB.when i am connecting to databaseA all the things r going well,but when i am connecting to databaseB i am facing the following problem.1)it is allowing moving the recordset forward(movefirst and movnext),but when i am trying tomove the...

hi all,<br/>how to take backup ofa particular table in a database(ms sql7.0) directly into a dat drive.<br/>all other methods are welcome..<br/>regards<br/>amol

I am working with SQL Server, and I am using ADO in a com object.When this com object runs under COM+ transaction there is a block for 15 seconds approx. when going out of scope (when Connection object cleans itself).The next sample will show you what i mean:STDMETHODIMP CTestLob::raw_Run(){{_Connec...

What is the best way to query a database using an ever changing SQL statment. I am try to query one batabase with values from another. The way I am doing it is slow(9min to process 3300 records). So for each recorded in the one database(text file) a SQL String is created and the second database is t...

Hi!<br/>I would like to use ADO to connect to MS Access 2000 database which is stored on remote computer (access via ftp). When I try to connect to database I get "Could not find installable ISAM" error. I am sure I have all the necessary drivers, so what could be wrong?<br/>Thanks, Simon

I have a small question about microsoft access databases. Is it possible to insert multimedia objects (sounds for example) with OLE technology into access databases, and "import" these objects in an visual C++ application?If yes HOW? If not, what sort of database do I need?ThanksSébastien Zinsius...

Hi, I'm using VC++/SQL Server with ADO/OLEDB. My development enviorment is Windows NT 4.0. My code works fine with NT but gives Invalid Pointer error in Win 2000 server. I resolved the problem by recompiling the whole code in Win 2000 but don't know why it happens. It fails...

can I use the ADO RecordBinding in ADOCE ?? if not what can I do to replace this utility ?

I have an application using ADO for database management. Sometime when I add a record the AddNew() returns HRESULT(SUCCEEDED) and I can query the new row index, but the row does not appear in the database until I close down the application (code shown). UInt32 tableId = (UInt32) -1; try { HRESULT...

I'm using ADO's IADORecordBinding Interface to interact with an MSSQL DB. My table has a unique key field which is defined as an Autonumber. How do I add a row and get back the new ID field? The DB is supposed to generate it automagically, but I don't see how/if the Recordset class su...

Good afternoon folks, I am working on a web application (Oldsmobile classified ads), which will allow a user to submit some info to a SQL 7 database. I am trying to add the functionality of allowing the user to upload a picture. I am trying to do this via Visual Interdev 6.0 SP3 running on Windows...

hI All. i have a ATL COM Service where iam using ADO open methood using VC++ and MSAccess, first time it is opening and iam able to diplay all the values from it using UI, but second time open function returning error , I Checked the error description it says "Operation is not allowed when t...

Hi,<br/>I get the name of a field using ADO with the GetName() method (I use C++), but I can't find anywere the description of the field (the one at the right in Microsoft Access).<br/>Thanx for your time.

I'm trying to learn ADO 1.5. I'm using an Access database as I don't have SQL server and I can read records OK. BUT I'm having great difficulty in inserting records. Can someone please supply a few hints, pointers (not the c++ type) or c++ snippets of code that will guide me.Many...

I'm querying from Oracled db and one of my table have a field with a data type with size 38, Number(38). When i display the recordset from the query in a grid control on an ASP page, it also displays the leading 0's (38 times) up to the number. How do i go about deleting this?? Is this nor...

I'm trying to build dailog based ADO program with .mdb file. There are several tables and several dialogs. Each dialog should have connection to database.How do I set up my program? If it is dialog based, can I use document/view architecture? Or should I set it up as SDI with document/view...

How do I update fields in a returned recordset from a query. Do I replace field data or delete and re-insert.<br/>Thanks - Nik

I have an ADO RecordSet in Visual Basic which is built from a join of two MS-Access tables:Select Con.First_Name, Con.Last_Name, … , Cust.Customer_NameFrom Contacts Con, Customers CustWhere Con.Customer_Id = Cust.Customer_IdI want to add rows only to one of the tables (to the "Contacts" one). I try...

I am using ADO to connect Visual Basic to SQL Server. I can run the small queries using connection or command objects..<br/>Can I run the query (createViews.sql) using ADO? this query is about 200 lines.<br/>Please help me on this.<br/>Thanks in advance...

I am using ADO to connect Visual Basic to SQL server.I would like to read external text file and execute partial string from the file each time..so file may be in following format...create table()GOINSERT ()GOI would like to first read just create table() .. run that string.. then again read insert(...

I have a problem with an ADODC in Visual Basic 6.I have an ADODC which is displayed using a DataGrid control. I use the AddItem method of the ADODC.Recordset in order to add a new record and then the Update method of the ADODC.Recordset in order to perform an update to the data base (MS-Access). The...

Does any body have any idea how to retrieve the Identity vAlue (I mean the one that has auto increment). After AddNew, changing the data and finally Update() there is no changes in the Recordset. pRS->AddNew(); pRS->Fields->Item["Value"]->Value = _bstr_t(Value); pRS->Update();...

Hi,I'm trying to call a SQL Server stored procedure using the ATL OLE DB template library.The procedure is CREATE PROCEDURE DWaterwo.test;1 AS SELECT 999The ATL Wizard creates an Accessor Classclass CDWaterwotest1Accessor{public: LONG m_RETURNVALUE;BEGIN_PARAM_MAP(CDWaterwotest1Accessor) SET_PA...

Hi,Iam using VB 6.0 Data Environment.Private Sub ConModule_WillExecute(Source As String, CursorType As ADODB.CursorTypeEnum, LockType As ADODB.LockTypeEnum, Options As Long, adStatus As ADODB.EventStatusEnum, ByVal pCommand As ADODB.Command, ByVal pRecordset As ADODB.Recordset, ByVal pConnection As...

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_NULL. I know the stored proc is fine coz it works when tested in the iSQLw environment (SQL Server).Here...

Please help,<br/>I need to access the oracle database residing on unix machine from NT/W2K using ADO. What software should i load onto my NT/W2K machine for this purpose.<br/>thanks in advance<br/>newHeights

Supposing to have a table with an autoincremental field.When I add a new row, to get the value of auto-generated ID value I do this:Rs.AddNewRs("Name") = "Jim"......Rs.UpdateRs.MoveLastnewId = Rs("id")The code seems to function, but is it really correct?...

Whats the current version of ADO and where can i get that info?<br/>thanks in advance<br/>Bhadri

I defined a cursor as: <br/>declare @cursor_subject CURSOR <br/>set @cursor_subject = CURSOR SCROLL DYNAMIC <br/>for <br/>select subjectno <br/>from callin <br/>How can i known it that there is some record included in the cursor or not?

Hi,I am trying to access records in the table which has 35+ fields. I am connecting to the data base using Ado connection object and setting the connection objects "CommandTimeOut" property to 10,000 secs. Now I am using Recordset object to fetch records from data base. With in the single connection...

Hi, One will find these post in VB forum also.I do not want my client to open Access Database file, even to view data or objects - so protecting entire DB thru password. I opened my Access DB file with 'Exclusive' option and then from menu TOOLS->SECURITY->SET DATABASE PASSWORD, and...

Hello! How can I write data into Excel worksheetusing ADO, without Automation? ..._ConnectionPtr pConnection = NULL;_RecordsetPtr pRecSet = NULL;_bstr_t strCnn("Driver={Microsoft Excel Driver (*.xls)}; DBQ=.\\Book1.xls;");hr = pConnection.CreateInstance(__uuidof(Connection));hr = pConnection->Ope...

Hi, I have a DB2 database. In one table I have a field, whose datatype is a CLOB. I am using VC++ for adding records into the database thru' ADO. I don't know how to proceed for the fields whose datatype is CLOB/BLOB. Is it that, these datatypes are not supported by OLEDB? Can any of you...

I am trying to connect to a database using ADO.Any examples I have seen use the following format, which I have tried. However it fails to create an instance of the connection object.header:#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \ no_namespace rename("EOF", "EndOfFile")cpp...

I need to keep track of the size of an MDB file as I am inserting records. I connect to an Access database using ADO. Using the Connection object, I insert records into a table using the Execute() method. As I am doing this, the file size of the MDB file doesn't change when viewed in the Window...

Hello Everybody!<br/>Can someone please tell me what are the differences between this 3 api's?<br/>thank you very much,<br/>Asaf.

I'm testing an application on 2 web servers(IIS) on Win2K using load balancer. They connect to a SQLServer 7.0 backend running on NT behind the firewall. At the high stress scenario we get some errors like: Description = [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error....

I have created 2 tables in MS-Access: Companies and Persons. The Companies table consists of CompanyId, CompanyName and CompanyAddress. In the Persons tab, i have the foreign key CompanyIdFk, which references CompanyId of Companies table.In my screen, i am using a Ado Datacombo to load the company n...

What are the features of Artifical Intelligence(AI) and how programming languages that are involved in AI(Lisp and Prolog) are distinguish from other programming languages(C++ or java or SQL etc).

I am trying to fabricate a hierarchial recordset. I want to create two sibling recordsets below one parent. I do this all the time with regular queries but I can't figure out how to do it without a data provider. This is what I have so far: strShape = _ "SHAPE APPEND NEW adChar(30) AS Foo...

HiHere's my problem... I have a relatively big query with about 10-15 tables and lots of RIGHT JOIN or LEFT JOIN or INNER JOIN and several criterias (using ANDs and ORs) on several fields.When I use Access 2000 to build the query, I have no problem at all. It works fine all the time. If I copy...

I'm using ADO and select statements for creating recordset. Select statements like that:select * from flsol with (index(flsol_key2))where flsol_obj > '1050'or flsol_obj = '1050' and flsol_flno > '9752' or flsol_obj = '1050' and flsol_flno = '97...

i have to write a VB program to monitor MS Access database being updated or not periodically. Is there any variable or trigger so that i can know the database is updated by other users or not.<br/>thanks a lot!

When I use xp_logerror to place something in the event log, it makes SQLServer the Source (and Server the category). I don't want to blame SQLServer for this. Can I change the source (and category) for xp_logerror ?<br/>Brendan.

since i am new to VB, can anyone tell me how to insert a new record to MS Access using ADO? Thank you very much.