At the request of a number of people, I've added this new forum to focus on database topics. Note that ADO.NET and XML have forums of their own. This forum covers everything else. This would include working with flat files as well as SQL, mySQL, SQLServer, Oracle, Sybase, Informix, MSDE, Cache...

Hi I am a fresher working on oracle and d2k 6i in a company.I wanted to know whether it is possible to get base table name from a form using sql statements.(for instance if there are lot of forms and i had to check the base table name present in each bloc of all the forms and check the presence o...

I have a Stored Procedure in a Sybase database and I have created an SQL pass through query in Access 2000 to run the procedure. When I run the pass through query in vbscript using ADO the stored procedure gets executed twice( I see it in the ODBC logs). If I use DAO the procedure only gets executed...

I am in the process of converting an MS Access database into Oracle. I hit a bump as I was converting queries. I have several corsstab queries within access that I would like to convert into standard SQL for our developers, but am not sure of the command. Below is the MS Access SQL cut and pasted...

Hello, i am building a small database of restaurants RestID (1) RestName (Sals Pizza) RestPhone# (555.555.5555) RestStreet (55 Main Street) RestTown (Boston) RestZip (01246) RestState (MA) RestType (italion, chinese etc) RestHours ( 9am to 5pm) RestRating (5 Stars) RestMenu (Sals_Menu.jpg) I think i...

Please help me!!:( I have built a database on members of a club, but would like to be able to connect this to a simple website (using PHP) which allows the user to submit their details via a form and log on to alter their details. What coding do I use? Also, what part does the web server play?? :rol...

I have developed an application with back end as MS Access,VC++ using DAO for database connectivity. Application is giving "Invalid Page fault" error , at the time of creation, and when ever code refers to database and this is happening in machines where Visual Studio is not installed. If I Insta...

Hello,Here is what I am trying to doNot sure if it is possible:SELECT [Activity File].[Computer Name], Sum([Activity File].[Total Time]) AS [SumOfTotal Time] INTO [ATT/IBM URL's By Computer]FROM [Activity File]WHERE ((([Activity File].[URL Address]) Like "*att*" Or ([Activity File].[URL Address...

I have problem with MS SQL Server during installationfirstly there was no problem with Standard Edition, then I uninstalled that and tried to install Enterprise Editionand faced the following problem:at the end of the installation the following message appears "... refer to sqlstd.log file"now I hav...

We are doing a project using Crystal Reports and while generating report using VB 6.0 as front-end we recieved a error called "Runtime Error 20532 Cannot Find Database DLL", this problem has been encountered on all except few machines , but we are unable to find the difference b/w the two machines....

Hi.I'm using Access 2002 on Windows xp and i get the following message when I try to import certain tables from dbase.This is what I did:I clicked on file/get external data/import.I set the file type as dbase5.I clicked on the table I wanted to import.Here is the error message I got:Invalid fie...

Hello;I am developping an app in ASP that connects to an Oracle database. I have just discovered the following problem:When I read data from a column defined as data type 'Number' in Oracle, and I reference it in ADO say like...if rs.Fields(2).Value <> 0 thenI get a type mismatch ev...

When creating a data type for a field in MS Access, when i specify date/time, it formats it as US format (ie mm/dd/yyyy), however, i wish to format it as European (ie dd/mm/yyyy). How is this possible? Thanks in advance for your time!

I would like to be able to read entries in the transaction log from an SQL server 2000.Does any body know a utility or a product that will support this. I would like a program that could find a transaction where a specific event is performed at a table. E.g.: "delete from tableX where x = 123"...

I need an SQL query that returns all records that are in one table but not in another table. I'm not too sure how to do it, and I'm still new with sql, but here's some very poor pseudo code:SELECT fldID, fldName, fldAddressFROM tblOneWHERE fldID <> (any fldID's in the othe...

Hello,i hope somebody could help me.Ok, ich work with Access 2k, i have six tables. The fist and second table with names InkaPro and InkaLite has five rows with the name date, aviable_to, version, description and compTime. The next three tables are the same view like date, name and description and t...

Hi all!<br/>I m new to this group.<br/>I hv started learning Visual C++ Database programing<br/>database is Oracle 7.3.4 and i want help (step by step)<br/>creating OLE DB/ADO app. with a table contained three<br/>data types (int, char, date) anybody plz can help me??

Hi,Here I have a strange requirement - I have a table with 2 columns, it is basically 1 to many relationship table. e.g. col1 col2 === === id1 map1 id1 map2 id2 map2 id2 map3 id3 map1 id3 map2 id3 map3Now I need to display in a spreadsheet...

Does .NET architecture allow to implement a solution where a Web Service exposes an ADO.Connection object so that an ASP.NET client could retrieve such object, open its local ADO.Recordset on it, and use it at its own discretion as thou the ADO.Connection object was created on the clients PC?If yes,...

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:\Progra...

I want to insert data from a web page into a microsoft access 2000 database using ADO. I wrote a routine that will do the job. Basically it is structured like that:dim CONNECTIONSTRING , rs Set Conn = CONNECTIONSTRINGrs. open conn, "tblname"rs.addnew...rs.updaters.closeThe problem is any time this C...

I'm using Access 2000 and I have 1 form which includes a subform. My main is linked to a table called Customer Names and my subform is linked to a table called Customer Sites. Whenever I use my main form to add a Customer when I try to click in my subform I get this error : The Microsoft Jet da...

I am wondering the best way to approach this.I need a DOS based program. This program will be called up by an *.exe file. The program will run on a Symbol Wireless Scanner. The program's interface will ask the user to enter a "part number", "location" and a "quantity". Then after the user enter...

Hi all.Thought I'd try this question in here ...Bear with me for a minute ... I have a form in Access that is bound to a table. This form calls another form (i.e. a "Review" form calling an "Entry" form) where the Entry form will add a record to the table the parent form is bound to. Now, I use...

Just wanted to know whether it is possible to call a method provided by a COM interface directly from a script in Oracle.

im making a inventory report in the language c<br/>i want that<br/>when i enter any data the data will automatically inserted into database nad how c is connected with orcale8

Hello Guys... Have to write a query or stored proc that would (given the day of the week) grab last 5 weeks data.. A week defined as Sun - SatSo, for example if today is Thursday, the stored proc wouldget last saturday's date and do a query to get the data for thelast 5 weeks (i.e up to las...

Hello,<br/> I keep having the same "table is full" error message while my .db reach 128Mb whereas it supposed to accept up to 2Gb.<br/>Any idea for the configuration ?<br/>:confused:

Hi allI m trying to learn VC++ database prog. 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 co...

I connected visual basic 5 and oracle. I am trying to addnew records in the database. I used the code as follows: Private Sub cmdAdd_Click() Set wst = CreateWorkspace("ODBCworkspace", "xxx", "xxx", dbUseODBC) Set db = wst.OpenDatabase("oracle", dbDriverNoPrompt, False, "ODBC;DATABASE=oracle;UID=xxx;...

I m trying to connect VB and oracle using DAO. I set the properties of DAO as follows :Connect:ODBC;DATABASE=oracle;UID=xxx;PWD=xxx;DSN=oracle;"DatabaseName: OracleDefault Type: 2-UseJetWhen I click on Recordsource I get the error:Cannot find Installable ISAMWhen I change the Default Type to 1-UseOD...

Hello Gurus, I am currently bumping on a strange problem on a Paradox database :The following query does not work :SELECT * FROM AnotherQuery.sql WHERE Col3 = 10where AnotherQuery.sql contains :SELECT Col3 FROM Table1 T1LEFT OUTER JOIN Table2 T2ON ( T1.Col1 = T2.Col1 ) AND ( T1.Col2 = T2.Col2 ) w...

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 DATABAS...

Hello everybody.I have a problem i cannot defeat. I created a database in mysql and now i want to retrieve records from it. I use VC++6.0I do it with fallowing piece of code: CDatabase db;CUserSet* pUserSet = new CUserSet();if(db.Open("firm")){ try { pUserSet -> Open(CRecordset::snapshot,"select...

Hi everybody!I have a problem while updating data in a database using ODBC.My application adds new records to the database and soon after tries to read these new records from the database. As a result of buffering, data I read mismatches data I've just written. Thus I need to force data in the...

Hi all!<br/>It's an addition to the previous message.<br/>I have a MS Access database, that is being used by application, written in VC++

I want to insert data from a web page into a microsoft access 2000 database using ADO. I wrote a routine that will do the job. Basically it is structured like that:dim CONNECTIONSTRING , rs Set Conn = CONNECTIONSTRINGrs. open conn, "tblname"rs.addnew...rs.updaters.closeThe problem is any time this r...

hiThis may be a very basic question to many...I have a form with provision for the user to enter a date.I have provided the user to select a date,month and year rom 3 diff combo boxes,but I want to store the data from all the three combo boxes in a singe date field in the database .Is it possible an...

hi alli open an access database from asp .. for some reason i need to know the number of records in the recordset before processing it as follows :set con=Server.CreateObject("Adodb.Connection")set rs=Server.CreateObject("Adodb.Recordset")con.ConnectionString=strConcon.CursorLocation=1 'serverc...

I'm inputting information into a database using a text input form and everything works except when I view the information in the database, I have "ﾬ￭tￖ" before the information I want to display. What is this and how do I go about keeping it out of my database?

In a vehicle maintenance application, I have a list box based on a table, (table1) displayed in a form. The listbox reflects the contents of 2 fields: [EquipmentID] and [PMName].1. EquipmentID refers to the identification of a vehicle.2. PMName refers to the name of a preventive maintenance routine...

i have a normalized dbase and i want to allow users to search the dbase from a 3G phone (webpage) can any1 plz tell me what areas i need 2 look into asp,.asp, .vb or cgi????

mySQL on a wind98 box is not secure:open the table.MYD in a hex editor and you can see the data.So mySQL relies on other security (eg Unix directory protection)Can anyone suggest a simple secure database for wind98?Access passwords are so easily cracked...cheers cts 3/3/03...

hi<br/>I am working with MSVC 6.0 C++, ADO, Jet, .mdb.<br/>When i use the -Seek- method on a recordset with the a single-column key, all is OK.<br/>I am not able to use the same method on a multi-column key.<br/>Thanks.<br/>Silvio

:) hi! I need help in access, im using 2000. I have a problem using the listbox. I have a table that i linked in the listbox, what i want to happen is when i double click the variables in the listbox i want to open another form. I'm tying to use the expresion builder but i dnt know what command...

Yes I'm a newbie and having a problem. I have created an Access2000 DB and made a connection thru VB6 to update records and all is working well. I need to periodically archive this information. I have tried using recordset.save which apparently saves the table that I'm connected to, unfo...

HELLO!<br/>I would like export my data with DTS from stored procedure to ASCII file. But in my stored proc i use table temporary and that don't run.<br/>How can i do?<br/>Thank's<br/>Gal

Hi, I have an application that use Access as the backend. Everything works fine when I run it on a single machine.. but if there is a lot of processing on the same database on a network the database get's corrupt and cannot be repaired. I have not done anything to handle concurrency except for...

Hi!<br/>How can I use "savepoints" with ODBC functions: SQLXXX?<br/>Thank you in advance.

I'm such a bum, and if anyone can at least guide me to where I need to go to find out how to do this, or maybe an example I can fool with, it would be appreciated.Oh boy. Here we go:My company has 25+ salesmen throughout the US, and 8 or so sales supervisors over them.I have a table (tblZip) w...