Recent content by Ralph8

The static recordset cursor made it work one time out of three. Adding a .requery at the end of my Report Initialize Section stabilized it and got it to work every time. Thank you very much! TIA Ralph D. Meredith www.merecosoftware.com

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...

Thanks guys. Books on line had a specific example of what I need to do. TIA Ralph D. Meredith www.merecosoftware.com

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...

Still have not figured this out. I have experimented every way that I can think of in WIN XP Pro Control Panel and haven't made any difference. I have confirmed that the connection strings(s) and Record Source(s) are setting up properly as described above. I have found one project that works...

Yes. I have stepped thru every thing that I can think of. Also, I have a routine that loads the connection strings for all the adodcs in the Form_load. I set up a series of msgBoxs just prior to end sub in the form load and all connections are just as they should be. TIA Ralph D. Meredith...

Wish I knew. The problem as described in my first submission shows up during form load. TIA Ralph D. Meredith www.merecosoftware.com

Did that. I am still getting the same results. I compared to the DSN setup on the machine that the "Copied" project came from and I don't see any thing really different. TIA Ralph D. Meredith www.merecosoftware.com

No, but what I did do was copy a project from another machine into a unique folder on this machine, and then copy some individual objects (Forms and Mods) into my development directory (VB98). I then "added" them to the projects that are getting the messages. If this is causing the problem...

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...

The FullName fields are not in the SEM5 database, they are in the CoreData database (See last example above that uses UNION). Does that change the code? TIA Ralph D. Meredith www.merecosoftware.com

Yes TIA Ralph D. Meredith www.merecosoftware.com

I want VIEW dbo.vu_ServicesReport to show all the datafields in SEM5.dbo.tblStdtIEPServicesSum plus the FullName fields from CoreData.dbo.tblStdtPersonal and CoreData.dbo.tblTeacherPersonal. Matching would be on StudentID and TeacherID. Thanks Ralph TIA Ralph D. Meredith www.merecosoftware.com

The following code is working after a fashion. I have a couple of problems with data type conversion, not to mention the cumbersome way that it turned out. I feel quite UNprofessional just looking at it, but I am admittedly a light weight when it comes to SQL. I would prefer to do joins on the...

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...