Search results for query: *

I found the problem. When I ran the code through SQL Server directly, I received an error message on a select statement. VB did not throw an error when it was run through VB.

I tested another database and the code doesn't work on an SQL Server 2000 database either. So, I still don't understand why the transactions won't commit...

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

Thanks for the links! That's a good start. I don't think it's an SQL issue because I can log in to the database and the program. The error occurs when I try to open the ADODC (ADO Data Control) component. It's an MS component so I was hoping it would work.

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 found that in the reports that work, the tables do not have specified catalogs or owners. These properties are not available. In the reports that don't work, the catalogs and owners are specified for each table. How do I reset these properties so they can be passed in the code?

I forgot to tell the error message. The message I receive is "Failed to retrieve data from Database. Details: [Database vendor code 208]

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 found it for a second - but now the option is gone again. It was under Report Options - something like "Read Date-Time format as" (Date, Time or Date-Time). I was able to switch it once for this report, but now I can't find the menu option again for another report. Where can I turn this...

I did check that. All of the options (Date, Time, Date and Time) are set to the system Default. I even tried changing them to a custom format to force the time on the datetime option. Still when I browse the data, the fields are only dates. However, both dates and times are stored in the...

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

Thank you for your response. It is captured in VB. However, I don't understand what you mean by "If it's captured in VB, then substitute your variable in VB for crxDBField."

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 received this message from my customer. She provided more information this time. Any ideas? The server restarted and I had to reset the SQL password again. This time, after looking in the System Event Viewer, I found out that “winlog.exe initiated the restart because the Remote Procedure...

The SQL Server is only housing the one database. It was purchased for our program and there are only two of us that have access to the SQL Server. Neither of us is changing the password. Are you saying if a hacker is trying to get in to the database, that could change the sa password...

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