satishind Reddy

Hi Floks,
I have created one DSN using Oracle Driver.
DSN Name = jdbctest
DSN Description = ""
Service Name = ""
User id = scott
After creation of DSN i tried to test Oracle ODBC Test i got below error can any one have any idea why i got below error.
SQL STATE:01000
Native Error Code :444
Driver Message : The Driver returned invalid [or failed to
return]
SQL_DRIVER_ODBC_VER:03:51
Thanks in advance for help
Bye
Satish

Thanks 2 all

I want to access the private member functions of a class from a static member function. (Even though I know that some books says it is not possible?? ). I feel that by means of having some(???) mechanism we may be able to handle this. If any one have some idea please let me know.
My mail id is : 'satishind@123india.com'

Thanks
Satish

Hi sreedhar,
I think your requirement full fill if you declare field data type as 'BLOB'(binary large objects). This Data type supports in MS-SQL also.
Satish

Hi paul,
Paul i havn't noticed that 'MM' should be Caps otherwise it is taking minutes insted of month. Due to this i got error every time.
Thanks for all your replies.
Satish

Hi Thomas,
Thanks for reply. Still it is giving problem because in table level my date field data type is 'datetime'.
SimpleDateFormat fmt = new SimpleDateFormat ("MM/dd/yyyy");
String todate = fmt.format(date);
here 'todate' is string. and table level field data type is 'datetime'. so it is giving data mismatch error.
please help to me. If i am not clear i can send code if u provide mail id.
Thanks
Satish

Hi,
I have a table in Microsoft SQL data base. In that table one field is a Date field. I am getting error while inserting record. I am giving code snippet please help me. what am I doing wrong here.
a.util.Date date = new java.util.Date(); SimpleDateFormat fmt = new SimpleDateFormat ("MM/DD/YYYY"); String dtstr = fmt.format(date); try{ fmt.setLenient(true); todate = fmt.parse(dtstr); }catch(ParseException pe){ msgout.append("Date Format problem\n" ); } String query = "INSERT INTO orders " + "(ordno,id,OrderDate,cake,naan,bagel,wheat)" +"VALUES ("+forno+","+ screenvar.id.getText() + ",'" + todate+ "'," + String.valueOf(icake) + "," + String.valueOf(inaan) + "," + String.valueOf(ibagel) + "," + String.valueOf(iwheat) + ")";
Thanks in advance.
Regards
Satish


[This message has been edited by Thomas Paul (edited December 07, 2000).]

Hi,
Can any one explain how to create Connection pool.
Thanks in advance....

Regards
Satish

Hi,
Short answer is No. But Trusted Applet's Comunicate with database.

Regards
Satish

Hi Manik,
It's quite possible. Just see the below mentioned site which is having one prototype project which is used jdbc & Swing.
'http://developer.java.sun.com/developer/technicalArticles/Database/dukesbakery/'
Hope this will help u.
Regards
Satish

Hi
In my table orders i have a column date which is having data type is 'datetime'.
insert into orders(column1,column2,column3)values(1,'12/02/2000',3)

if i used above syntax in MSSql it insert's record into table. But in java program it is giving some error.
can any one tell me how to insert date and time in MSSql. as below mentioned format.
'MM/DD/YYYY HH:MM:SS'
Thanks in advance.....
Regards
Satish

Hi,
In which class i can found this method. This method returns Container.
Thanks in advance
Regards
Satish

Hi,
Can any one tell or give to me some sample code to display my data in JTable. as below mentioned format.
Column1 Column2 Column3
Satish 99999 1998-03-02
Column1,Column2... are header this should be 'Bold' and Some coloured text. and rows should be in some colour...
i will be more appricate if any one give to some sample code...
Thanks in advance...
Regards
Satish

hi Guys,
The output which i got is
2 1
anonymous5142
can any one tell me why others got 'anonymous5152' i think '4' is correct because inside anonymous class 'i' variable is having value '4'.
if i am wrong please explain to me....
regards
Satish

Hi Anybody,
How to display Frame on Center of screen.
Thanks in advance
Regards
Satish