Search results for query: *

Hi I want to connect a Oracle Database thru VB by ADODB connection. I've used Dim Conn As ADODB.Connection Dim ObjRec As ADODB.Recordset Private Sub Form_Load() Set Conn = New ADODB.Connection Set ObjRec = New ADODB.Recordset Conn.open "DSN=misuat;UID=misuat;PWD=misuat007;&quot...

thanx andy for your reply. Bye

yes Andy My excel file is in database format only, can u give me the sample code for this. Thanx, Geeta

Hi to all, I want to read Excel file, and insert those records in Oracle table thru VB programming. Can anyone thru light in this matter. Thanx.

thanx to all of u guys. It was a great help to me. Thanx once again.

Thanks for ur reply. i got connection thru ODBC. now i want to try it thru ADODB. problem is what DataSource I have to give, since MYSQL doesn't show me any DataSource. If someone can through light on this matter, it will be a big favour. Bye

How to access a MySQL database from VB , Urgent Thanks Bye

First export all records, then delete duplicate records. there are several options for this such as Method 1: SQL> DELETE FROM table_name A WHERE ROWID > ( 2 SELECT min(rowid) FROM table_name B 3 WHERE A.key_values = B.key_values); Method 2: SQL> create table...

thanx for ur response. I have tried with .csv , it was not working, then I tried with MS-DOS .csv, it worked finally. thanx once again.

hi how to bring data from excel file or txt file into oracle tables. thanx.

I want to attach Crystal Report to VB, and also want to connect Oracle data with it. For that I have to make connection in VB or in Crystal Reports. Can anyone put light on this matter. Thanx.

thanx to all of u, i've done it thru ADODB connection and provider MSDORA thanx once again

how to connect to oracle from vb , what are all the methods, one is ODBC, how u connect, if anyone can help me, its urgent. bye Geeta

try using TOAD software, download it from site quest.com

i don't understand ur question clearly, u might want to increase your tablespace size, do that by ALTER TABLESPACE <tablespace_name> ADD DATAFILE 'anyfile.DBF' SIZE 50M AUTOEXTEND ON NEXT 50M

Use PRE-INSERT trigger at RECORD level

hi ktameirao (Programmer) i've seen your problem, the repeating frame which is getting created, set its properties, Maximum Records per page to 3, if maximum exceeds 3 , check this, it should work. bye