VB 6 Application with MS Access 2000 backend for Windows 2003 Server

Visual Basic

    Next

  • 1. Case sensitive combobox.
    Hi, Any idea how to make a combobox case - sensitive in VB. Let us assume i have a range object in Excel with 2 strings which are the same but the case is different. Eg: ABC and abc. Now i set the row source of the combo to this range object. Now when i set the text property of the combo as abc the value property of the combo must be 2 and not 1 (as it is set incorrectly) The reason is because a combo cannot differentiate between upper and lower case.. any idea how to make a combo as case sensitive? -Thanks in advance Veena.
  • 2. Shell Command Security
    Hi, I want to use the Shell command to run one executable program from another. I need to send password information as an argument to the second program. Are the arguments passed on a shell command secure, or do I need to encrypt the information? Thanks Heather
  • 3. flexgrid and activeX server
    Hi I'm thinking about loading a grid in background, (so I can present the initial data more quickly to the user) and am thinking of using an ActiveX server to do it 1) Is it a good idea? Is it possible? 2) Are there any complications to be aware of? 3) Is an ActiveX server the best way to do it or should I look at some other multi-threading technique? 4) I was looking to pass the usercontrol containing the grid via a secondary interface ... will that work? 5) Would it is better to do caching in-project rather than farming it out to an activeX server? (BTW the grid is a vsflexgrid) Thanks Simon
  • 4. How do I make Package and Deployment Wizard install for everyone
    Hello! I have created a program in VB 6.0 and am trying to use the Package and Deployment Wizard to create an installation. I work but for one thing. The program will be installed 'Just for me', i.e. Only the user that is logged on when installing will get the menu under Start - Program How do I tell Package and Deployment Wizard that I wan the program to be installed for 'Everyone'? // Anders

VB 6 Application with MS Access 2000 backend for Windows 2003 Server

Postby CoolerThenZero » Wed, 19 Sep 2007 05:29:43 GMT

HELP!!! everyone,

I have a VB 6 application that uses Microsoft Access 2000 as the
backend database. They say it requires MDAC 2.6 Sp2.  This application
is currently running fine on a Citrix server running Windows 2000
server. I have to migrate my citrix farm and so am upgrading to
windows 2003 server and a newer version of citrix.  However, when
trying to install this one application that 30-40 users use, I recieve
the following error.

<----------Beginning of Error-------------->
MDAC 2.6 Sp2 cannot be installed on this machine. MDAC 2.6 Sp2
requires any one of the following configurations:

Microsoft Windows 95 or 98 with Y2K update 2 and Internet Explorer
4.01 SP2 or later
Microsoft Windows Millenium
Microsoft NT 4 SP5 (or greater) and IE 4.01 SP2 or later
Microsoft Windows 2000

Setup will exit now. Please restart setup after installing the
necessay updates to this machine.
<------End of Error----->

I spoke with the vendor and they said that other IT departments might
have gotten it too work on Windows 2003 with some minor tweaks. They
said that it was developed in VB 6 with Access 2000 as the backend and
that MDAC 2.6 Sp2 was a requirement.

I installed Access 2000 on the new Windows 2003 Terminal Server and
have tried both MDAC 6 SP2 and MDAC 7 before trying to load the app
but still get the same error message without any luck.

Is there anyone out there that might might have some ideas on how to
get this app to work with some tweaks?   I would appreciate your
input.

Thanks!


Re: VB 6 Application with MS Access 2000 backend for Windows 2003 Server

Postby Ralph » Wed, 19 Sep 2007 06:40:39 GMT






Well, this one sounds a little strange. The "MDAC" packages are labelled by
the highest version of the ADO they support. They also have slightly
different versions based on the OLE suite and O/S it is to run on. (the SPs
and RCs). In other words MDACs are tied to the O/S not to an application.

The vendor's insistance on "MDAC 2.6 Sp2" as a *Requirement* without regard
to the OS, and that their clients have got it to work on Win2003 with
"tweaks", suggest to me they haven't a clue what they are talking about. In
other words, I can see that ADO 2.6 may be a *requirement* but not that
"MDAC 2.6" is. Unless they have somehow made the application dependant on a
particular OLE component, in which case, IMHO they are idiots. <g>

Go ahead and install the "MDAC" appropriate for your O/S (or actually in
this case use the one already there) and give it a shot.

-ralph



Re: VB 6 Application with MS Access 2000 backend for Windows 2003 Server

Postby Michael C » Wed, 19 Sep 2007 10:01:02 GMT





Have you just tried running the application? I suspect mdac2.6 will be 
installed by default.

Michael 



Similar Threads:

1.migrating from Windows server 2000 to Windows server 2003

Hello friends,

I have an application written mostly in VB6.0. It has server based component 
and client based component and running on windows 2000. It is a GUI generator 
application that launch many windows forms. Would there be any problems if i 
migrated my VB6.0 application or run it under Windows server 2003?

Actually, we have binding terms with Microsoft that our application should 
be using some COM add-in that calls office component 2003 and also be running 
under windows 2003. Can I add COM to it written in VB6.0 or VC++ that calls 
Office 2003 component and run the whole application under Windows 2003? OR 
VB6.0 is not compatible with Windows 2003?

2.Converting MS Access 2000 application to a VB / VB.NET application

Hello All

I am trying to convert a MS Access 2000 application to a VB application
(Just Started Yesterday)

I am using Visual Studio .NET 2003 utilizing Visual Basic .NET

I think I have a good feel to what I have to do, but does anyone know of a 
GOOD white paper on what is involved, pitfalls, etc?

So far I have run into one problem that I have not been able to figure away 
around.
That is how to access the tables.  In access you have Database objects, 
Recordset objects and all if the associated methods.  I cant seem to find out 
how to convert this to VB.  I have been reading through postings in this 
Discussion Group, but I am still a little bit confused.

Is there a SIMPLE way to access the existing .MDB database tables, and the 
individual fields within the tables.  Any help would be greatly appreciated, 
or a pointer to a good white paper describing the procedure.

Thanks in advance     

-- 
George H. Slamowitz
(602) 765-8111
(602) 765-8222 (FAX)

3.Opening MS Access 2000 or 2003 using VB 6

I have a VB6 application that works opening MS Access 97 (.mdb) files, but
does not recognize MS Access 2000.  I have Office 2000 (including MS Access)
installed on my machine, so the drivers should be up to date.

I am using:
 Set dbImpExp = g_ws.OpenDatabase(filename, False, False)

The result I am getting is this:
?err
 3343
?err.Description
Unrecognized database format 'C:\onetouch\Manage\exp2000.mdb'.

Any advice?

-- 
-Richard M. Hartman
 XXXX@XXXXX.COM 

186,000 mi/sec: not just a good idea, it's the LAW!


4.registry access in windows 2000/XP/2003

Some code in my application reads and writes to the registry. Everything 
works fine in windows98 but it doesn't work in 2000/XP. 
How can i write this functions in 2000/XP? 
Here's two of the functions i use in the program: 




Public Sub SaveOpcaoIva(strUserName As String, bolIvaTotal As Boolean) 
Dim keyValue As String, keyName As String 
Dim retValue As Long, keyID As Long 

retValue = RegCreateKey(HKEY_LOCAL_MACHINE, STOCKS_OPCOES_REG_KEY, keyID) 
keyName = strUserName & "IvaTotal" 
If bolIvaTotal = True Then 
keyValue = "Total" 
Else 
keyValue = "Linha" 
End If 
retValue = RegSetValueEx(keyID, keyName, 0, REG_SZ, ByVal keyValue, 
Len(keyValue) + 1) 
End Sub 

Public Function GetOpcaoIVA(strUserName As String) As String 
Dim keyID As Long, bufSize As Long, retValue As Long 
Dim subKey As String, keyValue As String, strReturnValue As String 

strReturnValue = "" 
retValue = RegCreateKey(HKEY_LOCAL_MACHINE, STOCKS_OPCOES_REG_KEY, keyID) 
subKey = strUserName & "IvaTotal" 
retValue = RegQueryValueEx(keyID, subKey, 0&, REG_SZ, 0&, bufSize) 
If bufSize >= 2 Then 
keyValue = String(bufSize + 1, " ") 
retValue = RegQueryValueEx(keyID, subKey, 0&, REG_SZ, ByVal keyValue, 
bufSize) 
keyValue = Left$(keyValue, bufSize - 1) 
strReturnValue = keyValue 
End If 
GetOpcaoIVA = strReturnValue 
End Function 

5.vb.net app not finding application configuration file on Windows 2003 Server Standard

6. update code vba (sql server 2000 and access 2003)

7. Access 97/2000/2003 comparisons - VB6 application

8. Running MS Access Application From VB.net 2003



Return to Visual Basic

 

Who is online

Users browsing this forum: No registered users and 20 guest