Does anyone have any idea what is wrong with this create statement for mysql? EDIT: now it states the error is near: revised VARCHAR(20), paypal_accept TINYINT, pre_terminat' at line 4 Thanks for the help everyone Still errors after using sql beautifier though CREATE TABLE AUCTIONS ( ARTICLE_NO VARCHAR(20), ARTICLE_NAME ...
I am trying to use MS access to connect to a Oracle database. I keep on getting the following error message: ORA-12154: TSN- could not resolve the connect identifier secified The Oracle Drivers OracleClient10g can verify that the database server exists. I have a section in my tsnnames.ora file that looks like this: UBASEP10G = (DESC...
I need a data(and metadata) mapping tool for mapping one database metadata to other. Are there any cheap tools available for that purpose? ...
Hi, I can access the database either from a .NET program (using ODBC) or through a database management tool (written in Java). If I write a 'é' character to the database from the .NET program, it appears as 'Õ' (capital O with tilde) in the DB management tool. If I write a 'é' character to the database from the DB management tool, it ...
I'm writing an application from scratch, I am not pretty sure which one to use. Microsoft Entity Framework NHibernate Gentle.NET Other Any guidance or opinions on the advantages and disadvantages of each would be helpful. ...
I am not a 'programmer' but want to develop a database application using Alpha Software Platinum v 9. The app would allow users to list classified ads via a web site and browse for items being sold etc. Does anyone have experience with Alpha software and is it really as easy they state on their site? Again, I am not a programmer but t...
Hi! I'm at a client doing some quick fixes to their access application. It was a while I had a go with access, but I'm recovering quickly. However, I've discovered an interesting problem: For some reports, I get a "Record is deleted" error. I've checked the reports, and it seems like there's a problem with one table. When opening that ...
Obviously (methinks), creating an index on a BIT column is unnecessary. However, if you had a column that you need to search in which every value is likely unique, like BlogPost or StreetAddress or something, then an index seems appropriate (again, methinks). But what's the cutoff? What if you expect 10,000 rows and you'll have about 20...
I am currently working within a custom framework that uses the database to setup a Page Object which contains the information about Module, View, Controller, etc which is used by a Front Controller to handle routing and the like within an MVC (obviously) pattern. The original reason for handling the pages within the database was because...
I have a session class that needs to store session information in a MySQL database. Obviously I will need to query the database in the methods of this class. In general I may need to connect more than one database simultaneously and may or may not be connected to that database already. Given that, what's the best way to access datab...
Which language for quick GUI app + sqlite database CRUD (2-4 tables). Java, Python? (Please no jokes like VBasic), some reference, source code to look on? added: First idea: 1 database SQLite (Win) + client GUI app (Win) clients table + orders table + others import, export database add, del, edit, etc. entries Second idea: 1 hosted da...
I need a database where one (or more) fields behave like a wiki. I want the free-form content creation aspects of a wiki bolstered by the strict semantic structure of a database. Specifically, I need this database field to hold wiki-style markup, track multi-user changes, allow reverts, etc... I've come at this from a few directions: ...
I am synchronizing tables using a stored PL/SQL procedure as part of a web application - when they hit a button it does the sync. The PL/SQL is executing as user A, but needs to disable indexes and sync a couple of tables in schema B. I can't get user A to 'alter index B.indexName unusable' despite granting it 'alter any index', and in...
Our app (already deployed) is using an Access/Jet database. The upcoming version of our software requires some additional columns in one of the tables. I need to first check if these columns exist, and then add them if they don't. Can someone provide a quick code sample, link, or nudge in the right direction? (I'm using c#, but a VB.NE...
Hi, I have a bunch of *.TBC files from a very old application that runs in MS-DOS called TURBOLAB. Anyone know which DB System use files with a TBC extension. I've tried renaming the files to *.dbf to check if they are dBase files with no luck. Any idea? ...
I am developing a website using SQL Server Express on my development machine. My web hosting company is providing me with SQL Server 2005. At the moment all I have is a database that I develop with and a database that is on the live server. I do not have the original scripts to generate the schema but I can auto generate the create scri...
Please forgive my long question. I have an idea for a design that I could use some comments on. Is it a good idea to do this? And what are the pit falls I should be aware of? Are there other similar implementations that are better? My situation is as follows: I am working on a rewrite of a windows forms application that connects to a SQ...
When designing user table what would be the must have fields from the security/user authentication point of view for a Web based Application (.NET and SqlServer 2005) I came with with the following fields: userID username -- preferably email passwordHash onceUsePassword -- to indicate that the password should be changed after login al...
For example if I have an auto-numbered field, I add new records without specifying this field and let DB engine to pick it for me. So, will it pick the number of the deleted record? If yes, when? // SQL Server, MySQL. // Follow-up question: What happens when DB engine runs out of numbers to use for primary keys? ...
Since DBs do not reuse numbers of deleted records it is possible to run out of numbers, especially if you pick not really a big integer type for this column. What would happen and how to prevent it if it's bad? // SQL Server, MySQL // ...