Database

Database Questions
- how to make the access 2000 non unicode data?
  acyually i am trying to make my database not unicode i want it a localcode 1256anyone know how to ma...
  By aua_usama_yahoo_com
- FAQ! for Date: 20030919 - New Users Look Here! [La...
  An HTML version of this document is available at:http://www.mvps.org/access/netiquette.htmFeeling le...
  By faqposter_cdma_invalid
- FAQ! for Date: 20030918 - New Users Look Here! [La...
  An HTML version of this document is available at:http://www.mvps.org/access/netiquette.htmFeeling le...
  By faqposter_cdma_invalid
- Windows XP tips and tricks -
  Optimize your operating system, minimize background activities,repair registry base, uninstall unnec...
  By tdr911turbo_gmail_com
- Data not being display in Access Report via an ODB...
  I am having difficulty creating a report. The report is notdisplaying/showing any data for a particu...
  By davids
- Machine Activty Log Table design issues
  I have a number of checklists for my machineryi have attached a couple of check sheets I have attach...
  By chimp8471, 4 Comments
- Oracle ODBC error
  I have an Access2K app with ODBC Oracle 9i backend. Permissions on allof the Oracle tables are ident...
  By dgmoore_erols_com, 3 Comments
- Data not in table
  Hello,I have a large database with tables and forms for data entry. With some of my forms, the data ...
  By vickie57, 4 Comments
- SQL command LIKE and ADO
  Hi,I ran into this odd problem when trying to make a query in Excel VBA with ADO. When using SQL cla...
  By jnyman, 8 Comments
- Blocking form changes
  HiI have a main form with a sub form (Subform1). The sub form only has a tabcontrol on it and then e...
  By john, 2 Comments

Database: is the Category's subject.It's has 3,094 questions..., Include:
- Microsoft Access
- Machine Activty Log Table design issues
- I have a number of checklists for my machineryi have attached a couple of check sheets I have attached my table structure and an example of my check list in XLS formati need to track which of these checks are being carried out each week..I have created 3 tables so far, 1 called tLine and 1 calle...
- chimp8471, Sat, 13 Mar 2010 20:27:00 GMT, 1,922 bytes, 4 Answer
- how to make the access 2000 non unicode data?
- acyually i am trying to make my database not unicode i want it a localcode 1256anyone know how to make it access2000 or access 2003 , and how toconvert a database from unicode to 1256 code...
- aua_usama_yahoo_com, Sat, 13 Mar 2010 19:17:00 GMT, 208 bytes
- FAQ! for Date: 20030919 - New Users Look Here! [Last Updated July 24, 2002]
- An HTML version of this document is available at:http://www.mvps.org/access/netiquette.htmFeeling left out? Alone? Wondering why everyone's ignoring you?Or why you're being flamed for what you deemed an innocent post?The following tips will not only help you, they will help us help you...
- faqposter_cdma_invalid, Sat, 13 Mar 2010 18:27:00 GMT, 15,243 bytes
- Oracle ODBC error
- I have an Access2K app with ODBC Oracle 9i backend. Permissions on allof the Oracle tables are identical. When attempting to open some, butnot all, of the tables in datasheet view in Access, or to run a storedAccess query against those tables, I get a Jet "ODBC Error" message andAccess displays...
- dgmoore_erols_com, Sat, 13 Mar 2010 15:02:00 GMT, 483 bytes, 3 Answer
- Data not in table
- Hello,I have a large database with tables and forms for data entry. With some of my forms, the data I enter show up in the corresponding table. The problem I'm having is this: some of the forms, when data is entered into them, the data do not show in their table; I hope I'm making sens...
- vickie57, Sat, 13 Mar 2010 15:01:00 GMT, 353 bytes, 4 Answer
- Oracle
- BLOB vs. CLOB
- I am creating an application that will store and search documents in various languages in an Oracle 9i database.Should I use BLOB or CLOB to store the documents?Does Oracle Text care either way?Advantages/disadvantages of either?...
- sxhans, Sat, 13 Mar 2010 20:27:00 GMT, 245 bytes
- HELP ME! Could you guide to me some problem about GeoRaster!
- Hi everybody!I have some problem with GeoRaster:- First, My Image (570,760). I do not know BottonLep&TopLeft and BottomRight and TopRight.I do not know MBR for Image also I do now know device blocksize suitable and MBR of each Block.How I device PyramidLevel suitalbe. If I do not device Pyra...
- yumi, Sat, 13 Mar 2010 16:42:00 GMT, 659 bytes
- BLOB to File
- 9i and up - Anyway to get a 4 mb & up BLOB to file on disk ?UTL_FILE error:blob length:3967200 error in PUT_LOCAL_BINARY_DATAORA-29285: file write errorso UTL_FILE is out of the questionthanks...
- robert, Sat, 13 Mar 2010 15:35:00 GMT, 228 bytes, 9 Answer
- BLOB Upload via ASP ORA-00600 Error
- I have a routine that successfully uploads a file into a blob field of a table via ASP. Yet, approximately once a day (and it seems to be on the first attempt of upload each day), the routine returns an error. I have gotten these errors with all file types and sizes and can usually reproduce it...
- ryan_bolchoz_ur_, Sat, 13 Mar 2010 15:01:00 GMT, 782 bytes, 1 Answer
- External procedure
- I want to invoke from PL/SQL (VfmVerify and VfmCreate) functions that exists on DLL.How can I invoke p.e. function VfmCreate(&matcher) from PL/SQL? Can I do that? matcher is of type HVFMatcher but the argumet is just a reference to matcher.And about define object types that exists on C++ but...
- user504347, Sat, 13 Mar 2010 15:01:00 GMT, 1,744 bytes, 2 Answer
- Pervasive.SQL
- Importing into Pervasive SQL 2000i
- I have a software product that was developed in VB 6.0 and the developer used Pervasive SQL 2000i for the database. It's a program we had custom developed for our hobby store to track club events and data on club members. The developer is no longer around literally. He passed away 9 mont...
- acerocks, Sat, 13 Mar 2010 20:27:00 GMT, 543 bytes, 6 Answer
- btrieve on XP desktops
- I am running a legacy btrieve application with no support from the defunct vendor. The system is running fine on a W2K server and NT desktops but will not even install on XP (Btrieve error 11 - error file could not be located). Eventually, WBT32 causes a General Protection Fault.I have read so...
- shuth, Sat, 13 Mar 2010 19:39:00 GMT, 608 bytes, 1 Answer
- Scheduling Exports
- I'm looking for some suggestions on what might be the best way to accomplish what I'm describing below...I'm an ASP web developer looking for a way to regular push some database data to a web server for use in our online applications.Currently I'm stuck with a commercial soft...
- probelaw, Sat, 13 Mar 2010 16:29:00 GMT, 1,106 bytes, 12 Answer
- max computers for workgroup engine.
- Hello Pervasive group...My client has 50 computers, each generates 100 transactions/entries per hour.Rightnow Package has microsoft Access(97) tables as backend. Package is not browserbased. We are planning to convert MDB(97) to pervasive sql tables with stored procedures and triggers.Does per...
- cdt, Sat, 13 Mar 2010 15:01:00 GMT, 834 bytes, 19 Answer
- ODBC Client 16 bit for Access 2.0
- Thank you Bill Bach. But where i can download an older Btrieve 6.15 ODBC driver for connect Access 2.0 to Pervasive SQL 2000i ? We cannot upgrade now Access 2.0 to 2000....
- ghiraldotti, Sat, 13 Mar 2010 03:35:00 GMT, 169 bytes
- DB2
- "CONNECT" failed using DB2 system:DSN running ODBC on z/OS, help !
- I compiling/running an ODBC application on z/OS.I call the following functions:SQLSetConnectAttr....SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&henv); SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc) --> at this point I get error: SQLSTATE: 58004...
- jsolis33, Sat, 13 Mar 2010 20:27:00 GMT, 785 bytes
- ORACLE MIGRATION - EQUIVALENT IN DB2
- All:What is the equivalent of Oracle BULK COLLECT in DB2 UDB?I do see MUTIPLE-ROW SELECT in DB2 ON Z/OS, where in INTO hostvariablescan be declared as arrays.Is this possible in UDB V8.2?...
- db2sysc_yahoo_com, Sat, 13 Mar 2010 15:01:00 GMT, 201 bytes, 4 Answer
- Oracle Migration - LAG function equivalent.
- What is the equivalent of ORACLE LAG FUNCTION in DB2 on Z/OS and UDB onLUW??LAG FUNCTION RETURNS THE PREVIOUS ROW.select id, createdate, name old_name, lag(name) over(partition by idorder by id,createddate desc)new_namefrom(select id,name,createdatefrom peopleunionselect id,name,createdatefrom p...
- db2sysc_yahoo_com, Sat, 13 Mar 2010 15:01:00 GMT, 382 bytes, 4 Answer
- Sql DB2
- Hi,Can someone help me please get the result i need. I have two tables(tableA and tableB). These tables are linked thru field2. I would liketo get the last record in TableA (field1 = 002) but with field3 value'abc' NOT dashes matches with TableA.field2 = TableB.field2. Therecords in Ta...
- tthai, Sat, 13 Mar 2010 15:01:00 GMT, 632 bytes, 4 Answer
- Data Retrieval
- Currently when I issue a conditional select statement to a table it retrieves all the rows satisfying the condition, which is normal. I am intrested in knowing, say if the condition returns 100 rows, i would like to retrieve only 10 records at a time, display and if user wants more and fetch the...
- muthuprakash99, Sat, 13 Mar 2010 14:41:00 GMT, 789 bytes, 1 Answer
- MySQL
- ORACLE and Mysql: Create tables, constraints, swquences, storage...?
- Good morning,I have scripts to create constraints, sequences, storage, tables fromRACLE and I don't know if I can create them in MySQL?Appreciated your help,Thank you,Phong...
- nguyen_phong, Sat, 13 Mar 2010 20:27:00 GMT, 213 bytes, 2 Answer
- order by "version number"
- Hi,in my table I have one varchar(20) column where I store version number.Version looks like:1.1.21.2.11.10.3It is possible order this column in natural order (1.2 before 1.10)?Stano....
- stanopaska, Sat, 13 Mar 2010 15:01:00 GMT, 219 bytes
- Oracle sequence simulator
- all,I have need to simulate the somewhat unique behavior/properties of ansequence object in MySQL (obviously for porting legacy code).I have come up w/the following solution which seems to work but wanted torun it by the collective to see if I failed to consider anything:create table sequence_na...
- sidlane, Sat, 13 Mar 2010 14:51:00 GMT, 1,382 bytes
- data time wrong format between mysql 5.01 and visual.net
- helloi'm developing a program on visual.net 2003 where i need to extract data from a date time format columnworking with mysql.net component for extract via mysqlcommands and dataadaptersim fillin datagrills but the column displayed only presents the date but not the timeim still analizing...
- robertowilliamaranda_wroman, Sat, 13 Mar 2010 09:09:00 GMT, 457 bytes, 1 Answer
- MAC OS X backup after crash
- Michael,You are very correct - I renamed those fields and boom- it started working like magic, thank you so much.I have another question - the database in questionthat got crashed had mysql root password but the guysI took over from forgot the password and didn't do anymysql dump. So, I had...
- alla_amin, Sat, 13 Mar 2010 08:09:00 GMT, 951 bytes, 1 Answer

Database

Database Questions

Microsoft Access

Oracle

Pervasive.SQL

DB2

MySQL