Visual Basic

Cmania11-Mar-07 23:36

Cmania

11-Mar-07 23:36

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!

Dave Kreskowiak12-Mar-07 3:07

12-Mar-07 3:07

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

Cmania14-Mar-07 22:21

Cmania

14-Mar-07 22:21

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!

Dave Kreskowiak15-Mar-07 2:39

15-Mar-07 2:39

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

Autorun in Pendrive

Kumaran21cen7-Mar-07 3:35

Kumaran21cen

7-Mar-07 3:35

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.......

Wink | ;)

Thanks & Regards
Kumaran

Dave Kreskowiak7-Mar-07 5:51

7-Mar-07 5:51

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

Kumaran21cen7-Mar-07 17:12

Kumaran21cen

7-Mar-07 17:12

Hi dave

Can u tell me what are all the registry entries we have to make for

enable the pendrive automatically.

Thanks & Regards
Kumaran

Dave Kreskowiak8-Mar-07 2:47

8-Mar-07 2:47

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

Rameshkumar Miriyala10-Sep-09 22:35

Rameshkumar Miriyala

10-Sep-09 22:35

disable the TurnoffAutorun in the Group polocies of windows,

Go to Run -> type "gpedit.msc" -> under administrative templaes->system change the setting for turnoffautorun

[Message Deleted]

shreya1237-Mar-07 1:45

shreya123

7-Mar-07 1:45

[Message Deleted]

Parwej Ahamad7-Mar-07 5:47

7-Mar-07 5:47

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

Parwej Ahamad9-Mar-07 6:08

Re: backup using vb.net [modified]

9-Mar-07 6:08

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

Parwej Ahamad10-Mar-07 7:21

10-Mar-07 7:21

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

Parwej Ahamad13-Mar-07 2:36

13-Mar-07 2:36

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

Dave Kreskowiak7-Mar-07 5:50

HOW CAN I CONNECT FROM VISUAL BASIC TO ORACLE 10G

7-Mar-07 5:50

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

Adekolurejo7-Mar-07 1:34

Adekolurejo

7-Mar-07 1:34

PLS I NEED CODE THAT WILL ALLOW ME TO CONNECT FROM VISUAL BASIC TO ORACLE 10G DATABASE.
THANKS

ADEMOLA

Re: HOW CAN I CONNECT FROM VISUAL BASIC TO ORACLE 10G

Colin Angus Mackay7-Mar-07 3:22

Colin Angus Mackay

7-Mar-07 3:22

This should help: http://www.connectionstrings.com/?carrier=oracle[^]

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: AJAX, SQL Server, Mock Objects

My: Website | Blog | Photos

Re: HOW CAN I CONNECT FROM VISUAL BASIC TO ORACLE 10G

Dave Kreskowiak7-Mar-07 5:48

Re: HOW CAN I CONNECT FROM VISUAL BASIC TO ORACLE 10G

7-Mar-07 5:48

DON'T YELL! It's considered very rude to post in all upper case.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Marcus J. Smith7-Mar-07 9:52

Marcus J. Smith

7-Mar-07 9:52

Me thinks COBOL programmer.

_Cle^aKO

"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)

Check Database after every 5 Seconds?

Abubakarsb6-Mar-07 23:44

Abubakarsb

6-Mar-07 23:44

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

Re: Check Database after every 5 Seconds?

Dave Kreskowiak7-Mar-07 5:47

Re: Check Database after every 5 Seconds?

7-Mar-07 5:47

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

Parwej Ahamad7-Mar-07 5:51

Re: Check Database after every 5 Seconds?

7-Mar-07 5:51

I think you should be use Ajax.

Parwej Ahamad
g_parwez@rediffmail.com

Guffa7-Mar-07 7:36

Guffa

7-Mar-07 7:36

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;

unnamed parameter [modified]

lopashree6-Mar-07 23:05

lopashree

6-Mar-07 23:05

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

Re: unnamed parameter

Dave Kreskowiak7-Mar-07 5:45