Requested operation requires an OLE DB Session object, which is not supported by the current provider. - Visual Basic Discussion Boards

Matt Cavanagh9-Aug-09 21:38

9-Aug-09 21:38

Ok so what ive tried is:
1)save my new dll
2)register it
3)start iis and test the site
4)stop iis
5)unregister it
6)overwrite dll with a new one

And at the point(6) it is still giving "..may be in use.." error.
Something im missing?

Thanks

Re: Registering COM dll's

Matt Cavanagh9-Aug-09 23:23

Matt Cavanagh

9-Aug-09 23:23

Fixed

http://www.tek-tips.com/faqs.cfm?fid=700[^]

VB/VBA Windows API help needed

gvi700009-Aug-09 8:26

gvi70000

9-Aug-09 8:26

Hello,

In Catia (a 3D cad application) VBA i start a Catia command - a dialog box - for which i know the class and the handle. This dialog is modal.
From the same vba macro i start a user form right after the first dialog is opened.
My problem now is that my macro get's stuck.
Is there any way to convert that dialog to modeless so that i can continue my macro?
Or how can i start and interact with the dialog and my user form?

Re: VB/VBA Windows API help needed

Dave Kreskowiak9-Aug-09 16:11

Dave Kreskowiak

9-Aug-09 16:11

gvi70000 wrote:
Is there any way to convert that dialog to modeless so that i can continue my macro?

No. That's entirely up to Catia, not your code.

gvi70000 wrote:
Or how can i start and interact with the dialog and my user form?

These are questions better asked on forums dedicated to Catia. It's very unlikely anyone who answers questions here on a regular basis is going to have any experience with Catia and it's object model.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: VB/VBA Windows API help needed

gvi7000010-Aug-09 7:24

gvi70000

10-Aug-09 7:24

Well..this is not about catia, it can be lets say ...excel
Any way thank you for the response

I manage to do it from VB Express.

machine id

ppeterr9-Aug-09 5:27

ppeterr

9-Aug-09 5:27

im' looking for an source code for visual basic 6 to getting the machine id.
help meeeeee

Re: machine id

Dave Kreskowiak9-Aug-09 16:09

Dave Kreskowiak

9-Aug-09 16:09

And by "machine ID", you mean what exactly?? The machine name? SID? Motherboard serial number?? ...?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Requested operation requires an OLE DB Session object, which is not supported by the current provider.

Matt Cavanagh8-Aug-09 3:16

Matt Cavanagh

8-Aug-09 3:16

Hi, Ive been given a VB and ASP site to get working and Ive tried everything I can think of.
Firstly, the files I have, have worked before so its not a coding problem.
The error im getting is this:
"Requested operation requires an OLE DB Session object, which is not supported by the current provider."
It reads a connection string from the registry and then tries to connect. Now ive tried lots of different connection strings and they all give this same error. Every solution to this error that I find online is related to the code being wrong, but as stated, its not. Its the setup.
Im running SQL 2005 on Windows Server 2003. The code is all VB6 and classic ASP.
Someone suggested that I try MDAC 2.7, so I installed it, but same error.

Any help would be greatly appreciated!

Re: Requested operation requires an OLE DB Session object, which is not supported by the current provider.

riced9-Aug-09 1:30

riced

9-Aug-09 1:30

This might be of help. Long time since I used VB6 but do remeber it could be problematic when using MDAC. Smile | :)

http://p2p.wrox.com/pro-vb-databases/1907-requires-ole-db-session-object.html[^]

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis

Re: Requested operation requires an OLE DB Session object, which is not supported by the current provider.

Matt Cavanagh9-Aug-09 12:18

Matt Cavanagh

9-Aug-09 12:18

Thanks.
Tried that and unfortunately doesnt work either Frown | :(

Re: Requested operation requires an OLE DB Session object, which is not supported by the current provider.

Luc Pattyn9-Aug-09 1:36

Luc Pattyn

9-Aug-09 1:36

roguemat wrote:
have worked before so its ~~not~~ somewhat less likely to be a coding problem

FTFY

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Setting FONT Name for MAPI Message

specialdreamsin8-Aug-09 0:09

specialdreamsin

8-Aug-09 0:09

Hi,

I have a program in which I have to send mail to a list of users. with a text report. Mail sending is working fine with MAPI Messages Control. But how to set the FONT of the message ? Because the Report is not align is getting distrubed.

Or Other wise tell me how to change the MAPI message type to HTML Message?

Please help me out

Ramesh Sambari

Knowledge is like honey.
Collect it, to make life sweet.

Re: Setting FONT Name for MAPI Message

Dave Kreskowiak8-Aug-09 5:41

Dave Kreskowiak

8-Aug-09 5:41

If youre sending a straight-text message, you don't send a font description. The font is chosen by the email program on the receivers-side, not yours.

The only way you can pick the font is if you send the report in an HTML formatted email body. Google "html email body vb.net" for examples.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Online Inventory system

Anubhava Dimri7-Aug-09 23:10

Anubhava Dimri

7-Aug-09 23:10

Hello All,

I am trying to build Online Inventory system. So i have some Question for that

1. Which Database is sutable for that.
2. How to Connect to Server database from my Application

Thanks and Regrad

If you can think then I Can.

Re: Online Inventory system

Moreno Airoldi8-Aug-09 0:28

Moreno Airoldi

8-Aug-09 0:28

MySQL[^] may be the database for you.
You can connect to the db server using ODBC or a specific .NET connector. You will find all info and downloads on the website.

Good luck!

2+2=5 for very large amounts of 2
(always loved that one hehe!)

Check Codeplex

David Mujica9-Aug-09 4:48

David Mujica

9-Aug-09 4:48

Try this link ... http://www.codeplex.com/site/search?projectSearchText=inventory[^]

You might get a head start on your project.

Re: Check Codeplex

Anubhava Dimri9-Aug-09 23:21

Anubhava Dimri

9-Aug-09 23:21

Thank For Helping but There are not any source related help regarding my requirement.

If you can think then I Can.

Re: Check Codeplex

LloydA11110-Aug-09 14:24

LloydA111

10-Aug-09 14:24

Yes there is, did you not see the button that says: "Source Code"?

If everything was not true, would it be not true that everything is not true? So by saying everything is not true, you are automatically denying that everything is not true. Im so confused...

FreeDOS
- An open source modern
MS-DOS replacement.

Saving Modified Column Value in Datagridview to Database

Dambod7-Aug-09 21:35

Dambod

7-Aug-09 21:35

hi there,
i have a datagridview controls that gets its data from database, i want to edit (modify) some rows and send back the modified content of all rows that are found under the same column to databases. Any help?

Thank u in advance

Re: Saving Modified Column Value in Datagridview to Database

Mycroft Holmes7-Aug-09 21:57

Mycroft Holmes

7-Aug-09 21:57

It is actually quicker and easier to try a search[^] before posting a question. This probably ranks as one of the most asked questions in the forums.

Never underestimate the power of human stupidity
RAH

Re: Saving Modified Column Value in Datagridview to Database

Dambod7-Aug-09 22:31

Dambod

7-Aug-09 22:31

would help me with it plz, my code under save button is this?
thank u in adnvance

For i As Integer = 0 To DataGridView1.Rows.Count - 1
'DataGridView1(3, i)
Try
c.cmd = New SqlCommand("update courseregistered set lettergrade='" & DataGridView1(3, i).Value.ToString & "' where courseno='" & (ComboBox1.SelectedItem.ToString).Substring(0, 7) & "' and studid='" & DataGridView1.SelectedCells(i).Value.ToString & "'", c.cn)
c.cmd.CommandType = CommandType.Text
c.cmd.ExecuteNonQuery()
Catch ex As NullReferenceException
MsgBox(ex.Message)
End Try
Next
c.da.Update(c.ds, "courseregistered")
MsgBox("update has been succesful")

it will save the last row under the column and display "update successful" message but ignores other rows in the column

Re: Saving Modified Column Value in Datagridview to Database

Mycroft Holmes7-Aug-09 22:42

Mycroft Holmes

7-Aug-09 22:42