Visual Basic

Re: How do I check programmatically if installed version of ACE OleDb is 64 or 32 bit version?

9-Feb-12 23:59

I stand corrected.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

Dave Kreskowiak10-Feb-12 2:11

Dave Kreskowiak

10-Feb-12 2:11

Curious...why would you want to check?

You're code is going to use the ACE that matches your code bitness. The connection string wouldn't change at all AFAIK.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: How do I check programmatically if installed version of ACE OleDb is 64 or 32 bit version?

Jörgen Andersson10-Feb-12 3:05

Jörgen Andersson

10-Feb-12 3:05

It seems that the ACE OleDb that's getting installed with Office is always 32 bits, no matter what your operating system is.
But if you install the Microsoft Access Database Engine 2010 Redistributable you'll have the choice of 32 or 64 bits.
So I want to check not just whether it's installed or not, but also the bitness.
And if it doesn't check I will fallback to Jet OleDb which is preinstalled with the same bitness as the OS.
Or am I missing something obvious here?

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

Re: How do I check programmatically if installed version of ACE OleDb is 64 or 32 bit version?

Dave Kreskowiak10-Feb-12 3:33

Dave Kreskowiak

10-Feb-12 3:33

Well, you have no fall back. Why? Bcause you cannot mix 64 and 32-bit code in the same process. This problem is solved at installtime, not runtime.

If your app is compiled as x64 or AnyCPU (and running on a 64-bit O/S), you cannot use the 32-bit drivers. The reverse is also true. If compiled x86 or AnyCPU (and running on a 32-bit O/S), you can't use 64-bit drivers.

The best solution to the problem is to install the requisite software your app needs to run, as is. If your app is compiled x86 or AnyCPU (on a 32-bit machine), then chances are everything is already installed. If your app is compiled AnyCPU (on a 64-bit machine) or x64, then you have to install the Reidistributable engine.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: How do I check programmatically if installed version of ACE OleDb is 64 or 32 bit version?

yanghua9414-Feb-12 5:42

yanghua94

14-Feb-12 5:42

In my opinion, user can install both x64 and x86 version of any COM/Activex component with the same GUID, but when a program runs in 64bit mode, you can check registry entries to ensure which version is installed. The real registry key for a x86 component in WOW64 could be found at HKEY_CLASSES_ROOT\Wow6432Node\CLSID node instead of HKEY_CLASSES_ROOT.

vsFlexgrid 8 ActiveX

Jim Giles9-Feb-12 10:39

Jim Giles

9-Feb-12 10:39

Does anyone have a LICENCED copy of vsFlexgrid 8 ActiveX surplus to their needs that they wish to sell?

I need to update 1 VB6 prog to run on Win7 but find ComponentOne price is prohibitive for a 1 off job

I understand that this is permitted by the Licence agreement.

Jim

What should i install ?

alejx9-Feb-12 3:55

alejx

9-Feb-12 3:55

Hello !
i have finished my application in vb.net 2010 / Net Framework 4 / with Entity Framework 41/ Crystal reports.

on My PC where i have created the application , everything run fine.
now , i want to install and run my application on another PC where Visual studio is not installed .
Except my application , what other packages should i install on other pc to run my application.

Thank you !

Re: What should i install ?

Simon_Whale9-Feb-12 4:22

Re: What should i install ?

9-Feb-12 4:22

you will more than likely need to make sure that the 4.0 framework is installed and also the crystal reports runtime

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

alejx9-Feb-12 7:23

alejx

9-Feb-12 7:23

Thank you !
But can you give me some link where to download these packages ?

Thank You !

Re: What should i install ?

Framework .l.9-Feb-12 14:18

Framework .l.

9-Feb-12 14:18

check this out..

http://www.microsoft.com/download/en/details.aspx?id=17851

Problems with marshaling

Florian Krätschmer8-Feb-12 23:42

Florian Krätschmer

8-Feb-12 23:42

I want to integrate an "old DLL" in which a function is called, in which I must pass two structures ByRef. The functions and structures:

<System.Runtime.InteropServices.StructLayoutAttribute(System.Runtime.InteropServices.LayoutKind.Sequential, CharSet:=System.Runtime.InteropServices.CharSet.Ansi, Pack:=1)> _
   Public Structure BitRec
       <MarshalAs(UnmanagedType.ByValArray, SizeConst:=20)> Public iBit() As Integer
       Public iState As Integer
       Public iTime As Integer
   End Structure

<System.Runtime.InteropServices.StructLayoutAttribute(System.Runtime.InteropServices.LayoutKind.Sequential, CharSet:=System.Runtime.InteropServices.CharSet.[Ansi], Pack:=1)> _
    Public Structure MixCalcRec
        Public dLeistung As Double
        Public dTemp1 As Double
        Public dEinlauf As Double
        Public dAuslauf As Double
        Public dStempelWeg As Double
        Public dDrehzahl As Double
    End Structure

<System.Runtime.InteropServices.DllImportAttribute("DPCALC", EntryPoint:="_CalcMixData@28", CallingConvention:=System.Runtime.InteropServices.CallingConvention.StdCall)> _
   Public Shared Function CalcMixDataDLL(ByRef AnalogData As MixCalcRec, ByVal iArraySize As Integer, ByRef BitArray As BitRec, ByVal iBitSize As Integer, ByVal iMode As Integer, ByVal dbDistance As Double) As Integer
   End Function

Public Function CalcMixData(ByRef AnalogData As MixCalcRec, ByVal iArraySize As Integer, ByRef BitArray As BitRec, ByVal iBitSize As Integer, ByVal iMode As Integer, ByVal dbDistance As Double) As Integer
        Dim ireturn As Integer = 0
        Dim iSizeOfOneStruct1 As Integer = Marshal.SizeOf(GetType(MixCalcRec))
        Dim iTotalSize1 As Integer = iSizeOfOneStruct1 * iArraySize
        Dim pUnmanagedAnalogDaten As IntPtr = Marshal.AllocCoTaskMem(iTotalSize1)
        Marshal.StructureToPtr(AnalogData, pUnmanagedAnalogDaten, False)
        Dim iSizeOfOneStruct2 As Integer = Marshal.SizeOf(GetType(BitRec))
        Dim iTotalSize2 As Integer = iSizeOfOneStruct2 * iBitSize
        Dim pUnmanagedBitDaten As IntPtr = Marshal.AllocCoTaskMem(iTotalSize2)
        Marshal.StructureToPtr(BitArray, pUnmanagedBitDaten, False)
        ireturn = CalcMixDataDLL(pUnmanagedAnalogDaten, iArraySize, pUnmanagedBitDaten, iBitSize, iMode, dbDistance)
        Marshal.FreeCoTaskMem(pUnmanagedAnalogDaten)
        Marshal.FreeCoTaskMem(pUnmanagedBitDaten)
        CalcMixData = ireturn
    End Function

After calling the Function in the DLL wrapper i get an error that I attempted to read or write in protected memory. Can someone help me with that? What am I doing wrong? I think the structures and the DLL declaration are OK. I guess something's wrong in the DLL wrapper.

Thanks for your help.

A code in VB.NET.

hansoctantan8-Feb-12 22:40

hansoctantan

8-Feb-12 22:40

Hi guys, I have a question...
I created an Image TIF Viewer and its working fine (Zooming, Move Up Down Left Right, Rotate, Next and Previous Page).
This image viewer is not that high level app cause I just use Panel and Picturebox in it. The problem is I can't run this program to a lower version of windows so I decided to use Visual Basic 6. The problem is some of the datatypes is new to me, I just found them in the Internet.
This is the part that I don't know how to convert it in VB6

I use this code to view the multi-tiff image

Dim objGuid As Guid = (objImage.FrameDimensionsList(0))
Dim objDimension As System.Drawing.Imaging.FrameDimension = New System.Drawing.Imaging.FrameDimension(objGuid)
imgTotalPage = objImage.GetFrameCount(objDimension)
objImage.SelectActiveFrame(objDimension, imgPage)

the Guid and this System.Drawing.Imaging.FrameDimension, is there a same type of this in VB6?

Any answer/reply/comment is appreciated. Thumbs Up | :thumbsup:

Thanks in advance... Big Grin | :-D

modified 9-Feb-12 5:38am.

JR2129-Feb-12 1:40

JR212

9-Feb-12 1:40

Easy. Don't

VB6 to vb.net ==>logic
vb.net to vb6 ==> very wrong choice

there must be another reason why your program won't work.

Is the framework that you use installed on that other computer.

Jan

Simon_Whale9-Feb-12 1:59

9-Feb-12 1:59

It will be Difficult to impossible to rollback code to previous versions of Visual basic especially from the .net framework to version 6.

If you are adamant on using VB6 then I would look at 3rd party controls to do what you are after.

Sorry but that is my 2 cents on the subject.

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Dave Kreskowiak9-Feb-12 2:10

Dave Kreskowiak

9-Feb-12 2:10

There is no direct conversion for the code you posted. You'd have to write your own libraries to duplicate the functionality provided.

Considering you want (for some very bad reason) to use VB6, I'd suggest using a 3rd party control for this, IF you can even find one any more.

Windows 8 will NOT have VB6 runtime support, so I suggest you rethink what you want to support. in the way of Windows versions.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

hansoctantan9-Feb-12 3:28

hansoctantan

9-Feb-12 3:28

Actually I created the program to remove the use of third party.
The reason is, you must buy the license.
If that's the case, I'll try to find an another way...

Bernhard Hiller9-Feb-12 22:02

Bernhard Hiller

9-Feb-12 22:02

System.Drawing.Imaging.FrameDimension existed already in .NET 1.1 - hence you can use it from Windows 2000. But you will need a very old version of Visual Studio to create a program targeted to framework version 1.1.

Simon_Whale9-Feb-12 22:53

Datagridview not showing my list(of object)

9-Feb-12 22:53

He's after earlier than that! VB6

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Sonhospa8-Feb-12 8:22

Sonhospa

8-Feb-12 8:22

Hi everybody,

I want to populate a datagridview with a generic list(of object), and from different sources I have 2 ways to do so, either

dataGridView1.DataSource = list

or (after binding the datagridview to a bindingsource)

Bindingsource1.Datasource = list

Unfortunately both ways won't work for me, and I wonder why. Either way I tried, I refreshed the datagridview afterwards and also controlled that the list was definitely populated.

Does anyone have an idea what might be wrong in my approach?

Thank you
Mick

Re: Datagridview not showing my list(of object)

Luc Pattyn8-Feb-12 9:30

(Resolved): Datagridview not showing my list(of object)

8-Feb-12 9:30

I know of two ways to get a DGV automatically display a collection of data:

1.
stuff the data in a DataTable, then simply establish a binding between DT and DGV. Once the DT is fully populated, the DGV columns, their HeaderText, Width, etc are all set automatically.

2.
or have a collection of some type (not: object) with a number of public properties, then give the DGV a number of columns and bind each column to a property of the type in the collection, using DataGridViewColumn.DataPropertyName[^]

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

Sonhospa10-Feb-12 0:36

Sonhospa

10-Feb-12 0:36

Hi Luc,

thank you for your hints Cool | :cool:

. I tried both ways, and after a little bit of fiddling I could make either way work. On the way I found an interesting piece of code (how to convert a generic list into a datatable[^]), which might also be interesting for others.

Have a nice weekend, regards
Mick

Re: (Resolved): Datagridview not showing my list(of object)

Luc Pattyn10-Feb-12 1:01

Re: Datagridview not showing my list(of object)

10-Feb-12 1:01

you're welcome.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

Simon_Whale9-Feb-12 22:58

Re: Datagridview not showing my list(of object)

9-Feb-12 22:58

The class that is in the list, is it using public variables i.e.

public class foobar
 public id as integer = 0
 public name as string = string.empty
end class

if so I dont know why it does it but that always leaves the gridview empty until your define properties e.g.

public class foobar
 private _id as integer = 0
 private _name as string = string.empty

 public property ID as integer
  'get set here
 end property

 public property Name as string
 end property
end class

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Luc Pattyn9-Feb-12 23:38