Search results for query: *

I can't figure this out. I have a VB6 application writing to an SQL Server 2005 database. At one point in the application, I delete an invoice. This function touches multiple tables using select, update and delete commands. The code is surrounded by BeginTrans and CommitTrans. I don't...

I'm using VB6 with CRXI and an SQL Server database. I pass the OLEDB DSN and database name dynamically through the VB code. This has worked fine. I've recently added a dynamic parameter to an existing report. When I try to run the report from my VB app and pass the new DSN and database, I...

I've installed my VB6 compiled application on Windows Vista (it actually installed without errors) but am receiving a runtime error "login failed for user 'sa'" when trying to access any recordsets using the Microsoft ADODC recordset component. I am accessing an SQL Server database. The...

I am using VB6 and CR11. I have about 500 standard reports that I've converted from CR8 to CR11 and updated the VB6 code to work with cR11. All of these reports work fine. I then created a new report in CR11. It uses the same VB6 code as the reports above. This report works when I view it...

I am using SQL Server 2000 with Crystal Reports XI. I have a datetime formatted field in the SQL Server database. However, when I browse the data in the Crystal Report the data only shows as a date. The time is stored in the database, but is not showing and cannot be formatted in the Crystal...

I am new to CR11 and am updating VB6 code that used the CR8 OCX control. Using the OCX, I passed the sort field with the following code: CR.sortfields(0)="+{orders.CUSTOMER}" In CR11 I understand that you would use the following code: dim crxDBField as craxdrt.databasefielddefinition set...

I have a very frustrating situation. I have a VB app using Crystal Reports 8.5. Within Crystal reports I select a default printer, which is a printer installed on the citrix server. When this printer is selected, local users cannot print to their default printers or specify a new printer...

I have a very frustrating situation. I have a VB app using Crystal Reports 8.5. Within Crystal reports I select a default printer, which is a printer installed on the citrix server. When this printer is selected, local users cannot print to their default printers or specify a new printer...

I have a customer with an SQL Server 2000 database using Mixed Mode authentication and a password on the sa account. The users can access the database from a VB6 application without a problem for a few days. However, every few days they receive a "login failed for user sa" error. I reset the...

I can import customers into PT through my VB6 app successfully in PT versions 2002, 2003 and 2004 using DDE. However when I try to run the same code with PT 2005 (importing customers from VB app to PT) I receive the following error message: "Cannot open 'C:\import path' for importing" Has...