Encoding from utf-8 to SQL Latin1 General CP1 CI AS

I would like your help on the following matter. I have a JavaScript file currently reading from another site xml file in (utf-8) and I would like to store those data in my database which is in SQL_Latin1_General_CP1_CI_AS. Is there any function in JavaScript that can encode (convert) text from utf-8 ...

writing to MSAcess: Sql Error: General?

I am writing an app to parse a massive csv file and enter the data into a MSAccess database using jdbc.odbc. The csv file has about 7,000 lines but it gets to just over 5,000 lines entered into the database but then gives a sql error : general error.Is there a limit to the amount of data you can pus ...

java.sql.SQLException: General error

Hai I am getting the following exception for my code..java.sql.SQLException: General error ...This is my jsp code<%try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection con=DriverManager.getConnection("jdbcdbcriver={MicroSoft Access Driver (*.mdb)};DBQ=D:\\wizforum.mdb ...

java.sql.SQLException: General error

Hai I am getting the following exception for my code..java.sql.SQLException: General error ...This is my jsp code<%try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection con=DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=D:\\wizforum.mdb ...

rdf utf-8 to mysql sql latin1

My purpose is to transform an rdf utf-8 file into sql for mysql.Data are both in french/english, in french there are stange characters that doesnt render well (çèé...)What the output had to be ?Mysql only support latin1 ?I m lost in all that encodage !Help me I dont know how to parametrer the php ...

Oracle SQL Client -- General Conceptual Question

I have don't really have much knowlege with SQL - Oracle relationships so any general conceptual knowlege would be greatly appreciated.I want to write a SSIS package in SQL Server that will use the OLE DB Provider for Oracle that comes with SQL 2005 x64 to make a connection to load two tables in an ...

C++, ADO, SQL Server General Question

I have a situation where I was in the midst of developing an application using c++, ado, and sql server. I did not know, or am not sure if sql server could be installed on a novell network server. I was instructed by the networking consultant that I would need a seperate server for SQL Server. I am ...

SQL Exception :General network error

When i try to run the PPC apps in VS 2003 , i got the above error.How to solve "General n/w error. Check n/w documentation." error? ...

Ubuntu (or an operating system in general) with AI? Would this work?

Seeing how lively and friendly Ubuntu feels got me thinking about this concept. Could AI (Artificial Intelligence, of course :) ) be worked into an operating system to make it know what to do, how to react, what you probably want to do, what it should say, etc?Sounds frickin' CRAZY I know... but... ...

MySQL Import SQL file from codepage 850 to Latin1

I have a simple problem, so a simple question, but am not able to find the solution. I have old data made with a MSDOS application in Codepage 850 dbase files. I dumped this data in sql files ( creating the table and inserting the rows) and I want to import this Codepage 850 data into my new Mysql d ...

java.sql.SQLExceptio n: General error

I am doing a servlet program that connects to a MSACCESS database,retrieves data and redirects the user to another page. I find the following error java.sql.SQLException: General errorLogin.java accesses esql.java which retrieves data from MSACCESS server.PLease help!!!My Servlet code: Login.javaimp ...

Question on SQL statement

I am porting Informix SQL calls to SQL Server and am pretty new to SQL in general. Could anyone tell me what the question mark in the following SELECT statement means?select sl.tsnfrom taxonomic_units tu,wrk_synonym_links slwhere tu.tsn = sl.tsnand usage = ?usage is a field name in the taxonamic uni ...

Sql server service blocking

I have w2k enterprise sql server with 2k3 windows enterprise. 180 users connects and runs video editing system. user connection value of Sql server:General Statistics is about 1400.I upgraded my hardware from 4X xeon 2.2ghz. server to 8XAMD opteron dual core CPUs server system.after this upgrade, in ...

MySQL Scan directory for music, add to SQL

I'm a bit of a newb to SQL in general, but would like to write a script (in whatever language) that does this: Scan a directory containing ~20000 mp3s. Scan ID3 data such as artist, album and song length, and add to appropriate rows/ids in a new mysql database. How would I best go about doing this, ...

Oracle Vs SQL 200X A decision to be made at early stages

i am building a system which will have tons of real time data insertions to it.the system will not have so much data (or clients)at first , yet must be scalable, because when the amount of clients will rise, then the amounts of data will be HUGE.From what i have heard so far (consultance), Oracle is ...

MySQL Migration from SQL Server - TIMESTAMP causing errors

I'm trying to use the The Migration Toolkit to copy a db from MS SQL Server (2000) to MySQL, but get the following error due to the "TIMESTAMP" field that is used by MSSQL 2000: Data truncation: Incorrect datetime value: '' for column 'TimeStamp' at row 1 I'm fairly novice at SQL in genera ...

Microsoft SQL Server error caused by "TIMESTAMP" field used by MSSQL 2000

I'm trying to use the The Migration Toolkit to copy a db from MS SQL Server (2000) to MySQL, but get the following error due to the "TIMESTAMP" field that is used by MSSQL 2000: Data truncation: Incorrect datetime value: '' for column 'TimeStamp' at row 1 I'm fairly novice at SQL in genera ...

SQL execution won't stop on errors in ODS 2.2

I'm using ODS 2.2 to run sql scripts on a production database. The RDBMS is DB2 9 for z/OS running in compatability mode for version 8. The JDBC driver I use is the IBM Data Server Driver for JDBC and SQLJ that is included with ODS. JDBC version is 4.0.My problem is that sql-execution does not stop ...

general error

Hai Iam getting an error while retriveing an video field from a table.I don't know what the error is ,i am displaying the code and error message,can any one helpthanks <HTML><HEAD></HEAD><BODY bgcolor="pink"><%@ page import="oracle.ord.im.OrdVideo" %><%@ page import= ...

using LOAD DATA LOCAL INFILE with java.sql

I am trying to load a file onto a table in a remote database that is running MySQL version 4.04 . Using the query String -- LOAD DATA LOCAL INFILE 'myfile.ext' IGNORE INTO TABLE `mytable` -- through java.sql.Statement.execute() method from inside my Java program I get the error message -- java.sql.S ...

Sql error?

yes, I know the board is in vBulitin, but perhaps I could get some help with SQL in general.I am receiving an error when trying to access any part of my site that uses template files. This first occured when uploading a database backup file (strait to the database, not in phpbb admin toolbar). some ...

mySQL general error

Please help me..i m getting this error in vista...java.sql.SQLException:General errorat sun.jdbc.odbc.createSQLException(JdbcOdbc.java:6986)at sun.jdbc.odbc.StandardError(JdbcOdbc.java:7114)at sun.jdbc.odbc.SqlExecDirect(JdbcOdbc.java:3110)at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbc.java:311 ...

another MS SQL timeout problem

Hello! I have two tables in an MS SQL database that I'm trying to join and display through PHP. My connection is fine and I've done it many times before, so don't worry this isn't a PHP problem. It's a my-query-won't-finish-executing problem. Table A: (about 2 million entries)id | lat | lon1 | -1 | ...

SQL operator override/creation?

This isn't a question about any paticular flavor of SQL in general, but is there a version that allows you to create operators for individual databases?So there are some basic arithmatic operators such as *-+/^Lets say I wanted to define an operator "|~|" that does something like this:tabl ...

Oracle SQL Intermediate to Advance level book required

When I go the the books store there are many books that cover beginners SQL, but I am looking for a book that is at a more advance level.Can people recommend any. Looking for ORACLE SQL or SQL in general.Brendon ...

Statement in Java.sql

My code :64: stmt2 = con2.createStatement();65: 66: if( stmt2.executeUpdate(query.toString()) > 0 ) 67: {68: query = new StringBuilder();69: query.append(" UPDATE TrJenisSoal ");And its produce root cause javax.servlet.ServletException: General errororg.apache.jasper.runtime.PageContext ...

MySQL Cannot import French and special characters

When I try to import a dump file into MySQL, for some reason none of the special characters are imported. I have a bilingual Web site that has options in two languages, one being French, the special characters are not imported. For instance: INSERT INTO `options` (`id`, `type_id`, `sort_order`, `eng ...

MySQL Database Modeling: PKs, FKs, AIs...

MySQL 5.1, Workbench 5.2.35 (on Kubuntu 11.04) My compliments to the devs of all MySQL products - they're just great! Please forgive me if my questions seem stupid, but I'm a newbie coming from DBFs. And sorry for the long post. Suppose 4 tables for controling a website access: Users, Accounts, Conf ...

MySQL Loading Data in Tables with Foreign Keys

To teach myself MySQL and SQL in general, I am using the book, "SQL The Complete Reference" published by Osborne. It's sample database contains tables with foreign keys. When I created the tables (with Type = InnoDB), I did so without creating the foreign keys and then went back and did ...

MySQL Find items near another - How do I do this?

I'm fairly new to SQL in general, and I have a problem I don't know how to solve. I have a bunch of records in a database that have an ID that is indexed. The IDs are not necessarily contiguous - there may be missing IDs. Now say that given an ID, which may not even exist in the database, I need a r ...

MySQL ACCESSING DIFFERENT TABLES OF DIFFERENTS DATABASES WITH THE SAME USER

I'm not able to solve the following problem. I want to have just one datasource in a Tomcat server to access to every tables in every databases of my MySQL Server. url = jdbc:mysql://localhost/interd4u (interd4u is an empty database) user = interd4u pw = int2912d4u The idea is to connect to mySQL se ...

MySQL multi table query

I am not that good in making some complex queries in MySQL or SQL in general. I have a bit of a problem in my database design that I wanted to implement. I created the following tables (i jst disregard some of the fields for brevity): user ----- username password group ------- group_id group_name gr ...

MySQL How to export a single table (verbose)?

Hi, I am relatively new to MySQL but have been running it on my Linux server for the past year now for other applications that require a SQL database. Up until now it's been great and, the database, is still rock solid. I just started using a new application though and I've run into a snag. What I'v ...

MySQL help understanding query...

Let me start by saying that I am not looking for a handout. I am having trouble wrapping my head around this query and was hoping someone might be able to break it down a little for me. Maybe it isn't possible, but based on what I've seen, it sure seems like it should be. I've got two columns, keywo ...

MySQL How to put old database files back into a new install

I'm a relative newbie to mysql, but not sql in general. I've inherrited a product that is trying to use mysql. Noone seems to recall the root password. I tried all the published methods I could find (--skip-grant-tables and the other one where we set the password in the init files) and none of them ...

MySQL Line break problem

Howdy all first i just want to say im fairly new to mysql and sql in general so please if you do reply don't go crazy with the technical jargon. Im using Mysql 5.0.26 and coldfusion 7. when ever i insert a paragraph into my database the character that gets inserted is "¶" according the co ...

Errors Extracting Blob data

IsabellaThanks for your prompt response.I still have the problem with BLOB data.As u suggested i tried to do the conversion in two steps,extracting and loading.The problem seems to be in the extracting itself.When i looked at the MTK.log file,this is what i foundSqlException 0 Caught : java.sql.SQLE ...

MySQL Auto update timestamp

I am extremely new to mysql and sql in general. I hope someone can give me a quick answer to this. Here is my example: I have 3 fields. Field 1 is a unix timestamp which is 0000-00-00 00:00:00 by default. Field 2 is a number integer which is 30 by default Field 3 is a unix timestamp which is a rando ...

Help - displaying MySQL data on website

I created a phpBB forum for our Neighborhood. Currently, our neighborhood directory is in Microsoft Access, and every few years we would have it printed professionally and bound. I have Reports which formats the data for the printed directory. I would like to add the directory to the website, to rep ...

MySQL whatchamacallit?

hi, is there a way, in MYSQL, or in SQL in general, to associate multiple tables (with, of course, the same column definitions) with one single entity, meaning that I could do a query on this one entity and get results back from rows in any of the tables in the group? possible? ...

MySQL Column compare

I've got a problem, and i'm a newbie to SQL in general, so here goes and fingers crossed someone can help. I've a table with four columns and about 200000 rows in, it looks like this Recid HOUSEID Name LastName 1 1232321 John Smith 2 1232321 Sue Smith 3 1232321 Jon Smith 4 1343434 Dave Jones 5 13438 ...

MySQL Tricky Query Question

I'm using MySQL (4.x) to implement a forum, but since I'm new to SQL in general, I'm having difficulty designing a particular query. I have Forum, Thread, and Post tables. I want a query that returns rows listing the threads inside a particular forum in reverse order of date of last posting in each ...

help with error "The process could not enumerate changes at the 'Publisher"

This may be a duplicate post as I think I placed the first in the wrong location. Top of the day all..I'm new to replication as well as SQL in general so please excuse my ignorance..I've run into a replication problem which is driving me nuts and any help would be appreciated..The basicsTwo MS SQL 2 ...

MySQL finding next available appointment

I'm a relative newbie to mysql and sql in general. I'm using Mysql 5 to build an appointment booking system. Here's the schema for the table in question: CREATE TABLE `bookings` ( `id` int(11) NOT NULL auto_increment, `emp_id` int(11) default NULL, `starts_at` datetime default NULL, `ends_at` dateti ...

System MonitorCounter Results

Our company had an Reporting Server which runs very slow. I have put some counters and run System Monitor. And the results are below.Objects\Counters Avg Min MaxMemory\Available Mbytes 2106 1818 2141Memory\ Pages/Sec 0.141 0 246Network Interface\ Total Bytes/Sec 23536713 2107 5526893Physical Disk\ A ...

MySQL using 80-90% of CPU

I have a Dell PowerEdge 2950 with 4GB RAM running RHEL 5.2 and mysql-5.0.45-7.el5 cacti shows that CPU utilization is always around 80-90% and the load is always about 1. top confirms that it's MySQL that is using all those cycles. I know next to nothing about MySQL, or SQL in general, but I have a ...

Security: Front End vs. Back End

** Disclaimer -- I'm not an IS person! I'm an aerospace engineer who is quickly becoming the company's SQL expert I'm starting to think about the security scheme for the database I'm developing. Database is in SQL Server. Front Ends could be Access, web pages in a SharePoint site, stand alone client ...

Cannot connect to DB over network

I have a JAVA application using a MySQL database. It worked as long as it was local.When I try to use it on the network, I got errors.(I have read the MySQL documentation several times but it just doesn't say anything useful.Also, it seems oriented to a DB Administrator and not to programmers who ha ...

finding next available appointment

I'm a relative newbie to mysql and sql in general. I'm using Mysql 5 to build an appointment booking system. Here's the schema for the table in question:CREATE TABLE `bookings` ( `id` int(11) NOT NULL auto_increment, `emp_id` int(11) default NULL, `starts_at` datetime default NULL, `ends_at` datetim ...

How to select two columns from a multiple table query

I'm new to SQL in general but I was wondering if someone could help me with a question I have.I have a single table that I'm trying to decompose into tables that are in 3nf. I'm working away on this and seem to be getting through this OK.I want to create three tables 'Orders', 'Items' and 'orderItem ...