Search results for query: *

I have a Report that has been working well for a long time. Two other Reports are still working well using the same table in the SQL 7 DB and exactly the same connection in the Data Environment. The "Offending Report" has started giving "Error 8577 in DataReport - Failed getting Rowset(s) from...

Is it possible to add a column to a production DB using T-SQL? A customer has added a requirement and I need to add 1 or 2 columns to a DB. They are several hours away and I do not have the capability to "Sign on" via the internet and use EM. I have looked at the FAQs and the MS Developers...

A couple of days ago, my projects started giving me "Error -2147467259 in Microsoft OLE DB Provider for ODBC Drivers Reason [Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified", on every Form Load. Usually 2 messages per form. The forms average about six...

I am using Query Analyzer in SQL Server 7 to Create a View that uses fields in a database called SEM5 and also, a couple of "Name" fields in a second database called CoreData ,located on the same (local) server. It appears to me that the UNION staments and the SELECTs following them are not...

For a new version of my program, I have split the DB into two databases. The view of concern now uses 8 fields in a table in one DB and two fields in two tables in the other DB. The view now will not see the latter two fields in the second DB. I am using SQL Server 7 in VS 6. Is there a way...

I am starting a new project and I would like to import some forms, mods, etc from an existing project on another development server on our network. Both servers have their own unique installation of VS6. These projects are both using VB6 with SQL Server 7/MSDE. I haven't found any pertinent...

I have added and tested a view and a couple of small "Name List" tables to a SQL 7 DB in development environment. The existing DB has been in production for a while and contains quite a bit of critical data. Is there a way to add the new definitions to the production DB without damaging the...

I am generating a Report using MS Report designer. I get a message box stating "Login failed for Database XXX". When I select the cancel choice in the box, the report goes ahead and generates properly. I have a Data Environment with three connections. The subject Report uses a Table under...

I am trying to detach a DB using a proven SPROC that has worked fine until now. I keep getting an error message when I execute the SPROC that the DB "cannot be detached because it is in use". I cannot see the reason for this. No Apps are running and I do not see any thing else. Help? TIA...

In a dcSchoolBuilding_Change Sub, I am filtering Course Names that have been sheduled for that building into a table. Then dcCourses is supposed to "see" that table as it's drop down list. I have tried rs.requery and rs.close with rs.open, but the "List" always shows blank. I have checked the...

I recently reinstalled VS 6.0 Now I am getting messages that I am not licensed to use Microsoft Report Designer when I try to do something with existing Designer objects or try to access the Designer. I have examined every thing I can think of and cannot see why this is happening. What am I...

I have a product authored in VB 6 with SQL Server 7 RDBMS. Two of my customers want to load it on a NW Server but it starts to load and then apparently goes into an infinite loop. No indication of what might be wrong. I enquired in the SQL Server forums and the response was "MS does not...

When this first showed up about a week ago, I thought it was only one project and one object affected. NOT SO! As any (every one) of my projects are loading, I get a message box with a banner "Data View" and a message "Method '~' of object '~' failed". Upon trying to compile any of these...

I have been trying to recover a SQL Server 7 DB for days now. I have two copies of the .mdf and .ldf files that I saved about a week apart. My development work was going unusually smoothly during that week with no apparent problems. When I decided I needed to "back off" to a previous copy of...

I have been copying my VB98 (in Visual Studio 6)folder to a CD for backup purposes. After a long string of good luck, not needing to use any of these BU Cds, I now need to use one. The PROBLEM: All the files in VB98 were recorded as "Read Only" on the CD, and they read back in as "Read Only"...

I'm sure that I used a procedure to recover a suspect database , but I cannot find the thread that it was in. Can some one please point me to it as I think I need it again? TIA Ralph D. Meredith www.merecosoftware.com

When I compile my project Public Subs in a Mod give me a message box with a banner of "Data View" and the message is "Compile Error: Object Library not registered". Also, during the project load, I get a message "Method '~' of Object '~' failed". I have checked this site including the FAQs, the...

Using the following code to create a new view, I keep getting "Syntax error near Keyword JOIN, Statement could not be processed". I have tried every thing I can think of, and stared at the thing until I have a head ache. Can some one point me to it? I know I will probably be embarrased by what...

I must have goofed big time! I created a Dataenvironment1 in a new project and now it not only appears in that project, but it is also in my largest, most critical project in place of the Dataenvironment1 that has been there for a year. Can any one clue me in how I might have been able to do...

I have gotten myself very confused, this should be simple I am sure. I have two local packages SEM_DB_Export, and SEM_DB_Import that are working fine when executed in EM. I need to execute them from VB 6 code; eg. XXX_Click Will some one point me to a good example of a simple execution of a...