Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




VB4, Windows 2003 && SQL 2000


I have an old VB4 application that sits on an NT machine and connects to a SQL Server 6.5. Microsoft is de-supporting NT so I want to move the application to Windows Server 2003 and connect to SQL Server 2000. The application works fine on 2000 (connecting to SQL2000) but when I try it on 2003 it will not connect to the database.

The application is written in VB4 using WinCGI - I'm creating an .exe. IIS does not support the WinCGI interface natively so in order to make the application run the IS2WCGI.dll library is used to translate the WinCGI app to something compatible with IIS. This *should* not be the problem but just thought I should include it to be complete, I can run a WinCGI app it's just the database connection that's giving me the problem.

Where I am at right now is just forgetting the whole application and just writing a simple test that will connect to the database.

The error I get is:
"Object required (error #424)"

And yes, we could upgrade from VB4 but that is not an option at this time, we may just run it on 2000 but I'd really like to solve this problem or at least confirm that it just will not run on 2003.

Code that I have tried (all get the same error):

____________________________________
Dim rdoSuperann As rdoConnection
Set rdoSuperann = rdoEnvironments(0).OpenConnection("My_DSN", rdDriverNoPrompt, True, "DSN=My_DSN;UID=username;PWD=password;DATABASE=database")
____________________________________
Dim my_Conn As Object
Set my_Conn = Server.CreateObject("ADODB.Connection")

____________________________________
Dim db As Database
Dim connect As String
connect$ = "ODBC;DSN=My_DSN;UID=username;PWD=password;DATABASE=database;"
Set db = OpenDatabase("", False, False, connect$)
____________________________________

I have an ODBC data source defined (it connects fine).

Now this may just be my inexperience with VB4 but any suggestions would be great If you need anymore info please let me know. Thanks.




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Component Not Working In Windows 2003 Server But Working In Windows 2000 Server
hi,

I have a VB upload component which woeks weel with the Windows 2000 server but when i have the same component installed in the Windows 2003 server it is not working. It is displaying the following error. error '800706be' . Searching the microsoft support site i cannot get any relevant information. If anyone has solution for this.

Bye

Sridharan

Problem Running VB6 Application In Windows XP && Windows 2003 Server
I have installed a program written in VB6 and Crystal Reports 8.

When I run the program in Windows XP Professional, once a while I encounter "Illegal Operation" for SslstBar.ocx, Ssdw3a32.ocx and Ssdw3b32.ocx.

When I run the program in Windows 2003 server (program and database in the server), frequently my program seems like hang and I can only close my program using "Endtask".

I need to your help to resolve the above problem soonest possible.

Thank you very much.

Have a nice day.

Please Help Me To Implement RunAs In Windows Service On Windows 2003 Server ...
Hello to all Forum Members;

Currently I'm working on a Monitoring Service which is intended to monitor the status of configured Applications and other Windows Services and restart if any of those are found not running. It works smooth with Windows Services; however I'm facing some problems while making the Service to start the third party Applications that have Database backend via ODBC or ADO.

I register my Windows Service as "Interactive with Desktop" under "LocalSystem" account on Windows 2003 Server. If I configure an Application such as Notepad or similar then there is no problem; but if there any application that has Database backend then the problem starts! These applications are not getting started properly. One of such applications is VoIPSwitch which says that it failed to connect to Database as either database drivers are not found or database does not exists! Both reasons are wrong as I can start the same application with the double click on same Executable file; it's just my Windows Service that's not able to start the application.

I received a suggestion to implement the RunAs for starting such applications with User Name and Password passed to it. So, for my quick testing I quickly searched for RunAs code module and found two examples on Planet Source Code, one of which I'm currently implementing in my code, too. You can download it for your reference from following URL:

http://www.orbitfiles.com/download/id1291685973

When I implemented it in my Monitoring Service and checked my Service Log (which I have coded to be written to ServiceLog.log file; this is not Windows Event Log), I got to see the error as returned by RunAs code: Access Denied!

I specified the same User Name and Password that I give while logging to my Windows 2003 Server (on which this Service is running) for RunAs and still I'm getting this error! The interesting thing is ... when I executed the RunAs VB code (the link above points to the same code) on the same Server by double-click it's icon and then with same User Name and Password, then it started the specified application without any problem! I feel there is no problem in the RunAs code; but it's the Windows Service (which is under Local System account) is not getting permission from Windows 2003 Server!

Am I missing something here? What's going wrong? Why Access Denied error is giving by Windows 2003 when Service attempts to start the application? I'm absolutely clueless right now; please give me some suggestion/solution to resolve this error!

Waiting for your valuable reply ...

Regards,

Ruturaaj.

Please Help Me To Implement RunAs In Windows Service On Windows 2003 Server ...
Hello to all Forum Members;

Currently I'm working on a Monitoring Service which is intended to monitor the status of configured Applications and other Windows Services and restart if any of those are found not running. It works smooth with Windows Services; however I'm facing some problems while making the Service to start the third party Applications that have Database backend via ODBC or ADO.

I register my Windows Service as "Interactive with Desktop" under "LocalSystem" account on Windows 2003 Server. If I configure an Application such as Notepad or similar then there is no problem; but if there any application that has Database backend then the problem starts! These applications are not getting started properly. One of such applications is VoIPSwitch which says that it failed to connect to Database as either database drivers are not found or database does not exists! Both reasons are wrong as I can start the same application with the double click on same Executable file; it's just my Windows Service that's not able to start the application.

I received a suggestion to implement the RunAs for starting such applications with User Name and Password passed to it. So, for my quick testing I quickly searched for RunAs code module and found two examples on Planet Source Code, one of which I'm currently implementing in my code, too. You can download it for your reference from following URL:

http://www.orbitfiles.com/download/id1291685973

When I implemented it in my Monitoring Service and checked my Service Log (which I have coded to be written to ServiceLog.log file; this is not Windows Event Log), I got to see the error as returned by RunAs code: Access Denied!

I specified the same User Name and Password that I give while logging to my Windows 2003 Server (on which this Service is running) for RunAs and still I'm getting this error! The interesting thing is ... when I executed the RunAs VB code (the link above points to the same code) on the same Server by double-click it's icon and then with same User Name and Password, then it started the specified application without any problem! I feel there is no problem in the RunAs code; but it's the Windows Service (which is under Local System account) is not getting permission from Windows 2003 Server!

Am I missing something here? What's going wrong? Why Access Denied error is giving by Windows 2003 when Service attempts to start the application? I'm absolutely clueless right now; please give me some suggestion/solution to resolve this error!

Waiting for your valuable reply ...

Regards,

Ruturaaj.

Windows Service On Windows Server 2003
Hi,

I need to run my application with UI as interactive windows
service (with "Allow service to interact with desktop" and "Local
System Account" checked in service's properties)
Works expectedly on Windows 2000, but not on Windows Server 2003 - UI is
invisible.

Need help.

References In 2000/2003
Hi. Still kind of a newbie here, but developing a rather large application in VBA/Excel that will be used throughout my county and may go on to the entire state. *Most* of the workstations have Windows XP and Office 2003. Some, mine, for example, have Windows 2000 and Office 2000. There might be some with Office 2002, but I'm not sure.

Here's the problem: I wanted to take advantage of Herilane's method of showing a chart in a userform, and it works beautifully on my machine. But because it requires a reference to Office Web Components, the version I wrote on my machine doesn't work w/2003 (OWC is in a different file in 2003). I tried to write the program so it would check the version number and make the appropriate reference, but in 2003 I get an error saying that programmatic changes to references aren't allowed (for security reasons, I guess). Is there any way around this? (Is this question at all clear?)

Server 2000 Vs 2003 - Please Help???
Hi Folks,

We are thinking about installing server software at our office and I would like your thoughts on both Microsoft Server 2000 and 2003. Any advice would be greatly appreciated.

Thanks in advance,

Dave

Win Server 2000 - 2003
I am upgrading my Windows server from 2000 to 2003.

I have configured IIS 6.0 and copied my files into the wwwroot folder just like it was on my previous server. The settings are the same ... as far as I know and the DSN connection is the same, the ODBC setup is the same. For some reason my asp pages that connect to the database just refuse to work!!!

Does anyone else have this problem??? Please help me!!

Excel 2000 V. 2003
I have recently received a new version of software we run in-house; the developer has upgraded from Office 2000 to Office 2003. The app is written in VB6 and generates an Excel spreadsheet. It is crashing at some point in the process-- I do not have access to the source code, but I suspect it is at the time of saving the workbook. The developer no longer has access to Office 2000.

I've decuded that the object libraries are not backwards compatible, but the 9.0 library is no longer available to the developer.

Is there any way to work around this without us upgrading all our machines to Office 2003?

How To Default To Access 2000 Instead Of 2003?
Hi,

how do you default a file to open in Access 2000 instead of Access 2003? I can't do it using the "Open With > Brouse" cause, whenever I choose MS Access 2000, it just reverts back to Access 2003 !!!

this is driving me crazy!!!

also, how can you include Access 2000 in the open with appliations? i can only see 2003!!

thanks.

Connecting To Access 2000 And 2003
Witch reference must i set to connect to access 2000 and 2003

Im Using VB 6 Enterprise Edition SP 6

VB 5 And Access 2000/2003 Compatibility
I've read a similar subject on VB5 and Access XP/2000 compatibility. My problem relates. I use VB5 and I am trying to connect to Access 2003 files. What are my options? VB.net, I understand, is too different and time consuming to convert, and in Access I would not like to convert to and from 97<>2000/2003, whatever... Would VB6 do the trick, and is it still commercially available ?

Thanks.
igr

Differences Between Outlook 2000, Xp && 2003
Hi all,

I've been thinking hard on how to frame this question.

I've got a project that I am working on that involves setting and removing appointments in MS Outlook from a VB6 platform.

My problem arises because of the eventual public nature of the final distribution - I can't disctate what release of MS Outlook users will have loaded on their computers. So the logic was to code for MS outlook 2000 onward (whatever MS is supporting these days).

In any case what I would like to find out is from a coding point of view, are their any critical differences between the Outlook versions? For example, has microsoft decided to use new properties or methods to activate/describe Outlook components in the latter releases? My guess is no - akin to shooting themselves in the foot... but you never really know...

Can anyone help or point me in the right direction to figure this out?

Thanks in advance

Merging In Word 2000/2003
I just tested my merging code. When merging 4,000 labels with a word datasource in word 2000 it only takes 20 seconds while running the same code in word 2003 takes 50 seconds. Is there anything i need to do different in 2003?

Microsoft Access 2000 To 2003
I`m Using Microsoft Access 2000 at this stage as a database for my database programs. I want to convert it to Microsoft Access 2003.

VB6 Service On Windows 2000, Sending/recieving Mail Via Outlook 2000
I have a service running, when I try to connect to a MAPI Session it gives me an "-2147221231 Collaboration Data Objects - [MAPI_E_LOGON_FAILED] (80040111)" error.

If I run it as just a regular Executable and NOT a service it connects fine...

Any Ideas?

VB6 Service On Windows 2000, Sending/recieving Mail Via Outlook 2000
I have a service running, when I try to connect to a MAPI Session it gives me an "-2147221231 Collaboration Data Objects - [MAPI_E_LOGON_FAILED] (80040111)" error.

If I run it as just a regular Executable and NOT a service it connects fine...

I pass the profile on the .login line....

Any Ideas?

Excel 2003 Vs 2000 Library Compatibility
Hi, some of the users of the report I've written are moving over to XP, and Excel 2003. the report was written in VBA in Excel 2000, and now there seems to be a problem with the macro.

an error is thrown on this line:

sheet.Shapes.Item(oldName).name = newName

But this line works fine when I run it on 2000.

Does anyone know about what changes there were to the libraries between 2000 and 2003? I noticed in the references, that the Excel Objecy library refers to EXCEL.EXE in 2003, whereas it refers to EXCEK9.OLB in 2000.

Outlook '97, 2000, 2002, 2003 Compatibility
hello all,

this is the code i've written to input into an Access DB the contacts of Outlook 2002 (i've left the recordset code out). it uses no references, so that the program will start even on computers without outlook installed.

my question is: is this completely compatible with all other versions of outlook?

thank you in advance,

wc.

here is the code:


VB Code:
Dim objOutlook As ObjectDim objNameSpace As ObjectDim objContactsFolder As ObjectDim objContacts As Object On Error Resume NextSet objOutlook = GetObject(, "Outlook.Application")If Err.Number Then    Err.Clear    'no open outlook, open one    Set objOutlook = CreateObject("Outlook.Application")    If Err Then        MsgBox "Could not open outlook."        If Not objOutlook Is Nothing Then Set objOutlook = Nothing        Exit Sub    End IfEnd IfOn Error GoTo 0 'ok now outlook is working Set objNameSpace = objOutlook.GetNamespace("MAPI")'10 is the olFolderContacts constant which you can't use since there's no direct referenceSet objContactsFolder = objNameSpace.GetDefaultFolder(10)Set objContacts = objContactsFolder.Items 'loopFor Each objContact In objContacts    Rs("First Name") = objContact.FirstName    Rs("Last Name") = objContact.LastName    Rs("Company") = objContact.CompanyName    Rs("Email") = objContact.Email1Address                    Rs("BusinessTelephoneNumber") = "" & objContact.BusinessTelephoneNumber        Rs("HomeTelephoneNumber") = "" & objContact.HomeTelephoneNumber        Rs("MobileTelephoneNumber") = "" & objContact.MobileTelephoneNumber                    Rs("BusinessFaxNumber") = "" & objContact.BusinessFaxNumber        Rs("HomeFaxNumber") = "" & objContact.HomeFaxNumber                    Rs("Address") = objContact.BusinessAddressStreet        Rs("Post Code") = "" & objContact.BusinessAddressPostalCode        Rs("Town") = "" & objContact.BusinessAddressCity        Rs("State") = objContact.BusinessAddressState        Rs("Country") = objContact.BusinessAddressCountry         Rs("HomeAddress") = "" & objContact.HomeAddressStreet        Rs("Home Post Code") = "" & objContact.HomeAddressPostalCode        Rs("HomeTown") = "" & objContact.HomeAddressCity        Rs("HomeState") = objContact.HomeAddressState        Rs("HomeCountry") = objContact.HomeAddressCountry     Rs.UpdateNext  Set objNameSpace = NothingSet objContactsFolder = NothingSet objContacts = NothingSet objOutlook = Nothing

Access 2000/XP/2003..Whats The Difference?
Hey,

I was sitting at my desk today thinking. I currently use Access 2000 and was just wondering if anyone knew what the difference was between the three other than the GUI?

Thanks!

Converting Excel With VB Macros From 95 To 2000/2003
Hi, everyone,

I have these Excel files written as template, in 95 format. It containsmacros which are likely to be written in VB 4. The templates were calledin an VB 4 application and everything worked.

If I open the file in Excel 2000 or 2003 and save them in the newformat, it seems the macros will not work. When I call these templatesin my VB 6 application, which is also converted from the original VB4, Iget the errors like subscript out of range, etc. I wonder if I havemissed something here
in this conversion. Can anyone provide me with some clue? Thanks!

Jonathan

Pushing Data FROM Outlook 2000/2003
Good evening all

I need to write some kind of application which retrieves all emails and attachments from outlook and stores this in an external database. If I try and do it outside of outlook I get given that pain in the backside message about somebody trying to access the mail. Is there any way that I can enhance the functionality of Outlook so that it automatically "pushes" the information out?

I dont want to use the Rules and Alerts facility and forward mail to a particular address since I need the owner of the mail to be able to remove sensitive documents before the transfer takes place.

Any ideas?

Thanks
Steve

Create An New User In Windows 2000/Whistler, Or 2000 Server
I need some informations about how to create an new user account in Windows 2000/Whistler, or 2000 Server.

This is necessary because I have to create some accounts automaticaly.

E.g. I have to create accounts from 01 to 36.
On each account there stands a string before the number.

This should look like [string][number] (e.g. 2ben01).

Any suggestions?

thx, vbzero

Access 2003 Works, 2000 Crashes And Burns
I have some basic functionality for adding and deleting rows in a A2000 database (SQL Server) created using 2003. On machines using 2003 everything is fine, but the same app run on 2000 machines crashes Access.

This isn't the first time I've seen problems like this. Access generally seems very fragile when it comes to updating the me.form.recordset. Ive managed to avoid some of these, but it seems every new case or machine and the problems come back.

Any pointers here? Are there some general rules I should be applying to avoid this? I have a 2000 app that won't run on 2000 through no fault of my own - that's sucky.

Diffrence Between Excel 2000 To 2003 Dealing With Multiline Text
Hello,
I`ve wrote a program thats export the data from a multiline textbox (in VB6) to an Excel cell.
It works good on my computer using Excel 2000 but in other computers using office 2003 the result in excel is that between every line there is a blank line.
When I change the multiline property (to false) in the excel cell it becomes a long line.
Seems like on excel 2003 every "Enter" affects twice.
Does anyone noticed this problem and is there a way to make the program work on both excel versions?
Thank you,
Erel

ADO, SQL SVR, Windows 2003 R1 And R2
Has anyone come across the following bug before:-

we have 2 servers, one running Windows 2003 release 1, and the other running Windows 2003 release 2. Using VB6 and ADO to connect to SQL Server 2000.

This VB code only works on Release 1:-

frm.AdodcTemp.Refresh
frm.AdodcTemp.RecordSet.Update

Where as the above code only works on Release 2 when put like this:-

frm.AdodcTemp.RecordSet.Update
frm.AdodcTemp.Refresh

Just doesnt make sense. Anyone come across ADO errors (Probably more like lower level problems) of this type before ? We're using MDAC 2.8 on all.


Need Help With VB In Windows 2003
I have a program that we've moved from a windows 2000 server to a new windows 2003 server. But ever since then, any time I get an error like "active X can't create object" It pops up a message box, instead of just doing the "on error goto Error_handler" code. Does anyone know if 2003 has any sort of setting that might be causing this behavior. Its quite irritating.

VB In Windows 2003
I want to load VB in Windows 2003 server.
Is it possible?

is it give any problem while creating the setup of a VB project?

bye

S.Muhilan

Migration To Office 2000 And Windows 2000
I have a general question concerning Access 97 to Access 2000 migration and operating system migration.

I am in the midst of writing a program using VB 6 Professional with Access 97 as storage in the Windows NT 4.0 operating system.

We are about to change over to Office XP and Windows 2000 professional.

Are there any known issues with either change that I can prepare for now?

Installation On Windows 2000 And Outlook 2000
I have a vb application developed on a windows 2000 machine with outlook 98. i used the package and deployment wizard to create the package. The package seems to install fine on a windows 2000 machine with outlook 2000 but when the user ran the application it opened the login form and after entering the user id and password after clicking ok, windows prompts for the outlook 2000 cd. The application worked fine only when the user put the outlook 2000 cd and windows could find the file it was looking for. i assume it is probably looking for some dll but it is kind of strange. Please help. Is there something in the package and deployment wizard?
Thanks

How To Show PC Processes In A Multi Line Text Box ListView ( XP Win 2000 Win 2003 )?
Hi all =)

I'm working on a projet that inc. Client - Server sides...
I want to know how can I get list of all the processes that runng into a text file or ListView, any idea about doin' so?

Thanks in advance, yours Yoni D.


P.S I'll be online for all day long today

Excel 2000 + Word 2003 - How Do I Move The Cursor After I Locate A Range
Excel 2003 VBA generating a Word document.

I'm using Bookmarks to locate a specific position in a document.

That bit is going fine.

Now I want to completely ignore the range and insert a whole heap of text and tables after the range position.

Declared -
Code:Dim oWord As Word.Application
Dim oDoc As Word.Document
Dim oRng As Word.Range
Dim oBkMk As Word.Bookmark
Dim oTbl As Word.Table
Code snippet
Code:Set oRng = oDoc.Bookmarks(oBkMk.Name).Range
oRng.MoveEnd
Set oRng = Nothing
Selection.InsertBreak Type:=wdPageBreak
Selection.MoveDown Unit:=wdLine, Count:=2
' insert a new heading for the current sheet
Selection.Style = ActiveDocument.Styles("Heading 1")
Select Case ws.Name
Case "AC"
    Selection.TypeText "Performance against SLA - " & colTowns(ws.Name) & " Office"
Case Else
    Selection.TypeText "Performance against SLA - " & colTowns(ws.Name)
End Select
Selection.TypeParagraph
Selection.Style = ActiveDocument.Styles("Normal")
' pick up an entry from the clipboard and paste it
oWord.Selection.Paste

My problem is, is that the Selection instructions all get the "Object doesn't support this property or method"

I'm assuming that the Selection is being interpreted as an Excel Selection rather than a Word Selection. How can I code this so that the correct interpretation is used?

VBA Styles Statement Hangs Word 97 But Doesn't 2000/2002/2003
I have vba code that hangs in Word 97. However, it works in Word 2000/2002/2003. Furthermore, I used WD97 to record a macro that pretty much is the same. I ran the Macro. It crashed. Must active Task Manager and end the process.

Here is a code snippet. It crashes when it hits the last line:

With ActiveDocument.Styles("~Part#").ParagraphFormat
        .LeftIndent = InchesToPoints(0)
        .RightIndent = InchesToPoints(0)
        .SpaceBefore = 204
        '.SpaceBeforeAuto = False
        .SpaceAfter = 0
        '.SpaceAfterAuto = False
        .LineSpacingRule = wdLineSpaceDouble
        .Alignment = wdAlignParagraphCenter
        .WidowControl = True
        .KeepWithNext = True
        .KeepTogether = False
        .PageBreakBefore = True
        .NoLineNumber = False
        .Hyphenation = True
        .FirstLineIndent = InchesToPoints(0)
        .OutlineLevel = wdOutlineLevelBodyText
      
    End With
    'ActiveDocument.Styles("~Part#").NoSpaceBetweenParagraphsOfSameStyle = _
        False
    ActiveDocument.Styles("~Part#").ParagraphFormat.TabStops.ClearAll
    With ListGalleries(wdOutlineNumberGallery).ListTemplates(1).ListLevels(1)
        .NumberFormat = "Part %1"
        .TrailingCharacter = wdTrailingNone
        .NumberStyle = wdListNumberStyleArabic
        .NumberPosition = InchesToPoints(0)
        .Alignment = wdListLevelAlignLeft
        .TextPosition = InchesToPoints(0)
        .TabPosition = wdUndefined
        .ResetOnHigher = 0
        .StartAt = 1
        With .Font
            .Bold = False
            .Italic = False
            .StrikeThrough = False
            .Subscript = False
            .Superscript = False
            .Shadow = False
            .Outline = False
            .Emboss = False
            .Engrave = False
            .AllCaps = False
            .Hidden = False
            .Underline = wdUnderlineNone
           ' .Color = wdUndefined
            .size = wdUndefined
            .Animation = wdUndefined
            .DoubleStrikeThrough = False
            .Name = "Times New Roman"
        End With

        .LinkedStyle = "~Part#"
    End With
        ActiveDocument.Styles("~Part#").LinkToListTemplate ListTemplate:= _
            ListGalleries(wdOutlineNumberGallery).ListTemplates(1), ListLevelNumber:= _
            1


Again, the above line (ActiveDocument.Styles....) crashes Word 97, but is fine in Word 2002/2003/2000

I've searched forums, MSDN, etc. Nothing.

Anybody got a clue?

Custom Database Viewer Will Open In Windows XP But Not Windows 2000 Operating System
Hello,

I have a VB 6.0 program that was created in Windows XP that allows people to view microsoft access data in a custom form using ADO technology. In order for this to work I have code that will check the users system folder to see if MSBIND.dll is in there. IF it isn't then it will install it as it is needed to view the data. The program works fine in Windows XP but now I have tested it out in Windows 200 and I get databinding errors.

I use the system function "GetWindowsDirectory" and when I check to see where msbind.dll is being stored it says C:WINNTSystem32MSBind.dll

I guess my question is, is this where I should be putting my msbind.dll? If so and the dll is not my problem, does anyone know of any problems that could be encountered by a Windows 2000 machine but not a Windows XP machine?

Thank you

Windows Socket Problem Between Windows 2000 Server And XP Professional
It used to work between Windows 2000 server and 2000 professional. When windows 2000 was upgraded to XP prof., it didn’t work. It can’t connect to the remote machine.

Is it possible related to XP's config. such as firewall? i turned the firewall off and it didn't work either.

Is it might related to the new WinSock APIs from XP (Mswsock.dll)? BTW, some codes were copied online posted by Mr. Oleg Gdalevich.

Did anyone have this problem or similar problem? Does anyone has an idea what’s the problem and how to fix it? Thank you so much.

Createdirectory In Windows 2003....
Here is an application i create to test createdirectory in windows 2003, because the application using that code dont work anymore.

is there anywhere that says it wont work with windows 2003? or am i doing something wrong?


Code:
Option Explicit

Private Declare Function CreateDirectory Lib "kernel32" Alias "CreateDirectoryA" (ByVal lpPathName As String, lpSecurityAttributes As SECURITY_ATTRIBUTES) As Long
Private Type SECURITY_ATTRIBUTES
nLength As Long
lpSecurityDescriptor As Long
bInheritHandle As Long
End Type

Private Sub Command1_Click()
Dim lngReturn As Long
Dim strRepertoire As String
strRepertoire = "D:logicielsapplications
gp est est"

If Dir(strRepertoire, vbDirectory) = "" Then
'In general section

Dim Security As SECURITY_ATTRIBUTES

lngReturn = CreateDirectory(strRepertoire, Security)

'If CreateDirectory returns 0, the function has failed
If lngReturn = 0 Then
GoTo err_fncCreerRepertoire
End If
End If

MsgBox "ca marche"

err_fin:
Exit Sub

err_fncCreerRepertoire:
MsgBox Err.Description
End Sub

VB && Windows Server 2003
Hi everyone,

Recently I've started running some of my apps on Windows server 2003.
Everything seems fine apart from one slight problem with "File System Object".

If I have a filesystemobject FSO, when ever I try to copy files, It seems to hang on the first time it is called by the user.

anyone encountered this?

Thanks in advance

VB6 + Windows 2003 Server
Hello.

Everytime i try to install visual studio 98 (to use vb6)
and after the reboot on the forced install of the jvm,
all network related stuff stops working and some services fails to start.

Im currentl using Windows 2003 Server Standard, fully updated and are atm forced to run xp in a VM to be able to access vb6 and make changes to previous apps (that isnt needed to be ported to .net)

any suggestions?

VB6 And Windows Server 2003
I have a scheduling program written in VB6 that was moved to windows server 2003 and does not work. Any suggestions on what I need to do to make it work?

Windows Server 2003
I know this is kind of vague, but, would there be an issue with windows server 2003 and VB 6 programs? I have an app that installs and works on all workstations running 2000 and XP. However, when the app is installed on a server running 2003 the app shows to be running but you can't see it. The install app was created using inno setup.

VB6 && Windows Mobile 2003
is it all application compiled with vb6 can be use in pocket pc that running win mobile 2003?

i developed a simple client file database system using vb6 with access database, so, is it any problem if i wish to install it in my client pocket pc?

Windows 2003 Server
My new host runs Windows 2003 server. My old host was Windows 2000.
I am using ASP/ADO and an Access database.

My site is on a shared server, and recently has been experiencing down time. After looking at my scripts, I realized I neglected to explicitly close my Database connections after the scripts are executed. When I asked them, they said that the issue was indicative of a memory leak. In order to keep the site running, they had to set the "recycle" time of the server to every two hours.

I ran on the old server with a lot of spots that were worse about object clean-up, the old server also saw much more traffic than the new one does and the old server never had this issue. My question is, does anyone know if Windows 2003 server has a problem with memory clean-up? Why does this server seem to be more touchy? I understand it really is my fault, and I didn't really follow good coding standards when writing some of those scripts.

I want to know if it will ever change. I went through my scripts AGAIN, and made sure I was cleaning everything up. I asked them to increase the recycle time to 6 hours, just as a test, and the site was brought to it's knees within a few hours. I am going to go through my scripts again, but I am wondering if I should just find a new host.

I know Access is not recommended for heavy traffic sites, but the only database that every page even comes close to accessing is a small database, and I open and close the connection almost immediately. There is not a lot of data transfer between that database and the website.

If anyone can shed some light on this, it would be greatly appreciated.

Thanks for reading this!

Our VB 6 App Running On Windows 2003 SBS
I work for a software house. Our main product is a 2-tier personell
rostering system written in VB6 connecting to a SQL 2000 database.


Many of our customers are now moving to Windows 2003 server from either
Windows NT Server or Windows 2000 Server.


What several of our customers are telling us (and we actually had one
of the machines shipped back to us to re-produce the problem) is that
after a re-boot, the application will run fine for a few hours, but
will then begin to grind to a halt and the application will hang.


This only seems to happen when they use terminal services to run the
app directly on the box, rather than installing our application on
their own desktop PC and connecting to SQL on the W2003 server.


We also have a VB6 Windows service which runs on the server which does various
backgrounds tasks, which also grinds to a halt.


What we notice with the machine that one of our customers has shipped
back to us (windows 2003 Small business server), is that when this VB6
service is running the memory usage and the number of handles increases
at an alarming rate and never returns to "normal".


The average usage of this VB6 service is about 10-20 MB of memory and
about 150 handles.


What we are seeing is the memory usage hitting 140MB and the handle
count hitting up to 100,000 handles!!!


If I run this VB6 service on my development machine (XP Pro), connected
to the database on the customer machine, then the behaviour appears
normal.


We have therefore ruled out any problems with SQL Server on this
machine.


Incidentally, it is SQL Server 2000 SP3. I also installed SP1 for
Windows 2003 yesterday and made sure that all critical updates had been
applied.


The spec of the machine is an IBM 2.8Ghz Pentium CPU (HT technology),
1.5GB of RAM and 100GB SATA drive.


What we have found, having spoken to our customers who are experiencing this problem is that they are ALL using Windows 2003 Small Business Server, rather than "standard" Windows 2003 Server.

What I have tried today is to build a Windows 2003 Server (not small business server), and the applications run without any problems.


There is obviously something different between Windows 2003 server and the small business edition, where memory allocation and handle allocation is concerned, but I cannot find out what this difference is.

Has anyone else had experience of this problem?


I've searched for pretty much every combination of search words on the
net and cannot find anything?


I hope someone out there can help!!


Regards
Guy

Windows Mobile 2003 And EVB
Hello,

it's possible use eVB for programming Windows Mobile 2003 device ?

Thanks

skimans

POP3 On Windows 2003 Using NTLM....
Anyone have any idea how to either connect to the POP3 Service on Windows 2003 using NTLM, or to disalble NTLM for POP3?

I wrote a program to read POP3 messages, but got thrown for a loop with NTLM when we tried to use Microsofts POP3 Service....

VB5 Apps And Windows Server 2003
Hello everybody. I need to develop VB executables which must run under Windows 98, Me, 2000, XP and Windows Server 2003.

Since I'm not allowed to provide the final users with a setup package, (all the machines are protected) I am obliged to use VB5 rather than VB6. This is because the runtime files needed by VB5 progs (MSVB50VM.DLL and OLEAUT32.DLL) are already present in Windows 98 or later versions. On the contrary, the version of OLEAUT32.DLL needed by VB6 progs is newer than the one you find in Win98, so you would need to replace it.

Now, since some of the computers to which I have to deploy my apps are equipped with Windows Server 2003, I need to know if the library MSVB50VM.DLL is still in the operating system or it has been removed by Microsoft (for example, because it is considered obsolete).

Is there anybody out there using Windows Server 2003 who may want to help me? Just open the Windows/System32 folder and check if you can find the incriminated library.

TIA

Pasquale Esposito
Perugia, Italy

VB6 Application On Windows Server 2003
Hi,

I have a problem with running VB6 application on Windows Server 2003. Project has one or more simple forms, and after calling FORM.SHOW application crashes and throw error OUT OF MEMORY.

Does anybody know where is the problem? With compatibility or something else?

Thanks.

VB6 Windows 2003 Porting Checklist
Hello All,

I have a VB 6 application (EXE, compiled in VB6 SP4). This communicates with a VC++ application, and some thrid party objects (COM server), all running on a Win 2k box.

I am looking to upgrade to Windows 2003. Reading on the forum, I see that in general VB 6 applications run on Windows 2003, but I was wondering if there is a list of things to look out for when porting to Windows 2003?
E.g.: specific Service pack installs, any VB6 runtime / DLLs installs etc

Are ther any links to articles discussing porting of VB6 applications to Windows 2003 that you can point me to?

thanks in advance.

Timers On Windows 2003 Server
Hi All,

I'm looking for a little advice if possible.

I'm writing a small program for tech support purposes, I've been testing as I'm going along and have noticed that my timer event doesn't seem to be running on Windows 2003, it's a simple timer that updates a text field with info from strings.

Any ideas?
Cheers,
Michael.

Copyright © 2005-08 www.BigResource.com, All rights reserved