|
Well Im using VB6.
By Database Objects I mean using objects of the classes imported after adding the reference Microsoft DAO 3.6 object library.
Spread wat u Know!
|
|
|
|
|
Cmania wrote: Microsoft DAO 3.6 object library.
Why? That was the last version of DAO Microsoft put out, about 7 years ago (I think!) You might want to move up to something a little more modern and, more importantly, still supported, like ADO.
Better yet, move from VB6 to VB.NET.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Fine!
Wat i exactly wanna no is that whether i can connect DataBound controls to Database Objects of DAO and ADODB library at runtime or not?
I tried but couldnt make it.
If it can be will plz give some code....
To remind u im using VB6.
Spread wat u Know!
|
|
|
|
|
Yes, it's possible. But, I have no examples. I haven't used VB6 in about 6 years now. Examples using DAO are few and far between. If you Google for "VB6 DAO"[^], you'll see some examples, but many problems too.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi,
I want to enable the autorun in pendrive when i insert into my usb port.
By same as CD Autorun
I already tried with autorun.ini and put to pendrive but no use.
Please tell me if anybody knows.......
Thanks & Regards
Kumaran
|
|
|
|
|
This has to be a setting enabled in the O/S. There's nothing you can do in code on the pendrive to enable this functionality.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi dave
Can u tell me what are all the registry entries we have to make for
enable the pendrive automatically.
Thanks & Regards
Kumaran
|
|
|
|
|
I said you couldn't enable it from code autolaunched on the USB key. I didn't say you couldn't enable it at all.
It's amazing what 10 seconds of Googling can find when you type in "autoplay udb drive[^]".
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
disable the TurnoffAutorun in the Group polocies of windows,
Go to Run -> type "gpedit.msc" -> under administrative templaes->system change the setting for turnoffautorun
|
|
|
|
|
|
Yes write an stored procedure and pass path parameter.
If your question is how then plz find below url
http://weblogs.sqlteam.com/tarad/archive/2004/06/16/1607.aspx
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
Hello actually i don't have much idea about the oracle but your can try on the basis of that code.
if you have further problem then you can discuss with me.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
Hi, But i don't know oracle stored procedure. so i would like, which part of code not converted.
In which part of code you have face the problem, then i will try.Because i have no oracle server, that i can test it.
send me line of the code or whatever you have problem.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
Please read below link.
http://www.dbasupport.com/oracle/scripts/Backup_Recovery/
I will try to convert in oracle.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
This really should be done by the database and not your code. Adding this would make your code not very scalable since multiple copies of your application (on multiple servers) would all be trying to backup the database themselves.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
PLS I NEED CODE THAT WILL ALLOW ME TO CONNECT FROM VISUAL BASIC TO ORACLE 10G DATABASE.
THANKS
ADEMOLA
|
|
|
|
|
|
DON'T YELL! It's considered very rude to post in all upper case.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Me thinks COBOL programmer.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Hi Friends,
I am developing a website to watch online movies. User needs to call a number to view movie (A company provide service to check whether user is connected to line or not They will call a script that will save or delete record in the database when user connects or disconnects phone line).
The only think which I need is that I need to run a script that checks database after every 5 or 10 seconds whether user record exists or not. I know it is possible to 'Refresh' page after certain time but my client doesn't want to do like this. I am using vb.net and Access database for this. I am struggling in it so waiting desperately for your reply.
Regards,
Abubakar Malik
|
|
|
|
|
This would probably require some JavaScript code on your page to do the 5 second timer and the checking of the database.
No, I don't have any examples. I don't do web development for living...
Your question would be better asked in the ASP.NET Forum.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I think you should be use Ajax.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
Would you please stop asking the same question over and over and over and over and over again, at least until you have read the replies that you already have gotten.
---
single minded; short sighted; long gone;
|
|
|
|
|
how to pass the unnamed parameter in the database in vb.net?
If con.State = ConnectionState.Closed Then
con.Open()
End If
Try
cmd = New OleDbCommand("insert into resume_details(Name,Skill,City,Experience,Email,Filetype) values(?,?,?,?,?,?)", con)
cmd.Parameters.Add(New OleDbParameter("", namee))
cmd.Parameters.Add(New OleDbParameter("", skill))
cmd.Parameters.Add(New OleDbParameter("", city))
cmd.Parameters.Add(New OleDbParameter("", year))
cmd.Parameters.Add(New OleDbParameter("", mail))
cmd.Parameters.Add(New OleDbParameter("", exts))
cmd.ExecuteNonQuery()
MsgBox(" 1 Record is inserted")
con.Close()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
-- modified at 5:10 Wednesday 7th March, 2007
|
|
|
|
|
Just give the parameters any name you want. In OleDB, named parameters are not supported, and are ignored, but the order in which the parameters are added MUST match the order of the question marks in your SQL statement.
You are also missing the parameter data types. You can do what you're doing and it might work, but it's always a good idea to specify the database data types for each of your parameters. Otherwise, the parameter objects will "guess" at what they're supposed to be by looking at the type of data that is being passed into it.
cmd.Parameters.Add(New OleDbParameter("@name", OleDbType.VarChar, 30, name))
cmd.Parameters.Add(New OleDbParameter("@skill", OleDbType.VarChar, 30, skill))
cmd.Parameters.Add(New OleDbParameter("@city", OleDbType.WChar, 20, city))
cmd.Parameters.Add(New OleDbParameter("@year", OleDbType.Integer, year))
cmd.Parameters.Add(New OleDbParameter("@mail", OleDbType.WChar, 30, mail))
cmd.Parameters.Add(New OleDbParameter("@exts", OleDbType.VarChar, 5, exts))
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|