Search results for query: *

Hi everyone, It's been a while. Hope everyone is doing well. My company has been maintaining VB6 software for several years now and it's about time for us to re-imagine/re-write our software. Other companies with less experience but slicker-looking (translation: more modern) software have...

SQL Server 2005, Windows XP A little background: My company does NOT have the server maintenance contract for this particular client. We do however provide all client software. Recently, the server was upgraded to Win2003 server and the SQL was upgraded from SQL Server 2000 to SQL Server...

Hello everyone, it's been a while. My problem is this: I'm adding textboxes to a form at runtime. Using the following code: Private Sub AddBoxesForTaxes() Dim intNumTaxes As Integer Dim intLoopit As Integer Let intNumTaxes = 10 Dim intTop As Integer Dim intLeft As...

Hi Everyone, I'm using VB6 SP6, sql2000, windows XP. My application needs to make a copy of an existing database and place the copy under a new name. I'm using sqldmo and my backup procedure is working great. THe problem comes in when I attempt to restore the database to a new name...

Hi everyone, VB6 SP6 WinXP I've been hitting an UnSpecified System Error at the time the compile has completed and it has begun writing the .exe. We have two development systems. One in our office, and one on site. If we make changes to any classes, bas, or forms at the site, we bring...

VB6 WIndows XP SP2 This one has me stumped. I recently acquired a new computer at my office. I installed VB6. Installed the VBSP5 (I thought). Installed all outside source dll's, ocx's, etc... Then moved my projects to the new machine. The app loads fine into vb6. It runs fine. However...

Hi everyone. I'm looking for some input as to the best way to create a copy of an entire database. Basically, I need to take an entire database and copy it to a NEW name, while retaining all permissions, stored procedures, etc... The reason for this is the user needs to be able to perform a...

This may be the wrong forum for this question, if so I apologize. I have a VB6 application, connecting to a SQL2000 server database. My app needs to be able to CREATE a database. This databse needs to be a duplicate of an existing database. All tables, permissions, etc... need to be...

Windows XP SQLServer2000 Hello again, We currently have new software written in VB6, Server OS is Windows 2000 server, Database SQLSERVER2000, individual PCs are running XP. The software has been installed on-site and is running very well, however I need a way to limit access to certain...

Hi All, Is there any method to determine the Registration point of a dll/ocx? Specifically, if you have several copies of a dll/ocx on your Win2k machine, is there any way to determine WHICH dll/ocx is registered? I'm having difficulty installing some software, and after going through all...

VB6-SP5 Win2000, SQL2000, Crystal 8.0.1.0 Hi all, Judging from the number of times this question has been asked, this isn't an uncommon problem, but I have been through all the threads, tried most of the solutions, and still no luck. I'm trying to create a software package deployment. In...

Hi all, I have researched this problem through the FAQ's and Keyword Searches and while I've found some pertinent information, I'm hoping someone can provide a little more detail: I have a project using VB6, WIN2000, CR8.5, sql2000 I'm attempting to distribute this project to a clean Win2k...

Win2K, VB6, SQL2000 Hi all, I'm attempting to deploy a VB package to a 'new' Win2k machine ('new' meaning that it only has the OS, no other software has been installed). I've created a setup package using Inno and the installation proceeds without any problems. However, I'm having a problem...

Hi all, I have just begun the process of packaging my application and being a complete novice at this part of the game, I'm looking for advice. Most of the process is fairly self-explanatory, however when I get to the Install Locations portion I see that most of my dll's and OCX's will be...

Hi gang, My company is about ready to begin the process of packaging and deployment of our software. The software uses many types of graphics: .bmps, .cur, .ico, .avi, etc... Currently all of these graphics are stored in separate folders below app.path. Meaning, the avi files are in app.path...

Hi all, Is there a Transact SQL function that will return the database NAME that a Stored Procedure is currently running in? My situation is this: On one server there will be several databases that contain identically defined tables. The database names are based on a fiscal year, ie, there...

Hi all, This question may more suited to the SQL forum, please pardon me if it is. I'm looking for a way, through VB6, to give the users limited query capability on an SQL2000 database. Ideally, I would simply like for them to be able to query tables in whatever manner they choose with no...

Hi all, SQL200, VB6, Win2000. The application I'm currently working on requires (government specs) that I create a log for every table modification in the database. Specifically: UserName, MachineName, DateTime, Table modified, Type of modification (Insert, Delete, Update) and what was...

Hi all, I'm relatively new to Stored Procedures and have a question. I have 2 stored procedures. One replaces some data in all rows that match the criteria: IF @NewSched > '' BEGIN IF @All > '' Begin UPDATE Acreage SET Schedule = @NewSched WHERE Parcel = @ParcelNo End...

Hi all. We are almost ready to begin deployment of our VB6 application to a beta site and one of the final hurdles is this: All of our clients are offsite. We are trying to determine the best way to handle our program updates/fixes. Currently, each client PC at the site will have a copy of...