Server configuration denies access to data source

2001-07-10 Thread sagar tamhane
hi. I had installed mysql on redhat-7.0 I have a java program that inserts, deletes from mysql. It used to work fine. I had to reinstall linux and hence mysql. Now the same program doesnt work. I get the error: Server configuration denies access to data source I can access the databases from

newbie question on variable length records.

2001-05-01 Thread sagar tamhane
Hi, I am a newbie to Mysql. I would like to know how to create a table with variable length records? i have an object with following variables: varchar v, int a, int b, int c. and i want to store variable number of such objects into the rows. varchar v is the primary key. the entries in the

Re: Query Question

2001-05-01 Thread sagar tamhane
Hi, Since you have over 10,000 member ids it depends on the exact appln that you have. If the length of the SQL query increases above a certain length (i am not sure abt the exact figure), an error is thrown saying query too complex. such wont be the case in your former method. but, if there

Is it possible?

2001-05-01 Thread sagar tamhane
hi, I was reading the manual for the full-text search. It is really interesting to have a search engine embedded into the database itself!!!. Mysql uses the criterias defined by the mysql developers. Is it possible for the user to specify the the criteria in his/her program and mysql rank the

Re: column count doesn't match and updating 2 tables

2001-05-01 Thread sagar tamhane
Hi Suzanne, When you say: insert into table_2 select * from table_1 alls fine. All the records and fields will get copied. But when you say: insert into table_2 select fieldname_1 from table_1 you are just selecting fieldname_1 from table_1 while table_2 consists of fieldname_2