Search results for query: *

Server: Msg 3624, Level 20, State 1, Line 1 Location : recovery.c:2657 Expression : seenCkptEnd SPID : 9 Process ID : 900 Connection Broken When attaching the database to the sql server 7.0 it gives this error and hence unable to attach.

Server: Msg 3624, Level 20, State 1, Line 1 Location: recovery.c:2657 Expression: seenCkptEnd SPID: 9 Process ID: 900 Connection Broken When attaching the database to the sql server 7.0 it gives this error and hence unable to attach.

Well iam into a new realm of programming wherein i am required to get the input from a Bar Code reader and feed it in the database. Can anybody give me a detailed process as to how can i acomplish the same.

We have developed an application in VB 6.0 which uses Crystal reports 7.5.But in some cases, when the report opens and the user cliks on the Export Button of the viewer to extract the report in different formats,nothing happens after clicking the button. This happens only on few of the machines...

We have developed an application in VB 6.0 which uses Crystal reports 7.5.But in some cases, when the report opens and the user cliks on the Export Button of the viewer to extract the report in different formats,nothing happens after clicking the button. This happens only on few of the machines...

Well I am executing a dynamically build query.This query when executed generates a couple of insert queries.How can i execute these insert queries. Is there a way out to execute the result of an execute command.

When i install my system at the client-end i would like to change his regional settings of Currency and Date to suit Indian standards. (Rs. and "dd/MM/yyyy"). How can i acomplish this . . .either through VB code or through the Setup program. . please assist.

Hi All, I am facing an unusual error. I am using command object for accessing Store Procedure in some of my forms in my project. For that I am using active connection as "cn". Now For some other forms I am using the same connection "cn" For saving purpose. and in those forms...

Hi , I have made a report in crystal report , to which i pass a connnection string from my vb application.Now if i pass a string of a different database, the report should should show the data in that database, but it doesn't happens. how to accomplish this. table struct in both the database...

In a Vb application how can i come to know that how many instances of the same application are open on one machine and also on different machines in the network

Well In one application i am using Sql server. The server can be accessed from many machines. But all the machines uses single user login ie default login "sa". How can i come to know that how many machines are accessing the server and also if on some machine more than one instance of...

Hello, I am getting a very erratic error in crystal report. When I run the report from VB form with a perticular selection fornmula , the report before fetching any data says "Automation Error". After that it cannot be closed untill u end the process thru task manager.The same...

I have a csv file and wish to to load the data into sql server table selectively. I don't want to use the Data transformation service of SQL Server. Iam using the following code to open the csv file Dim db As Database Set db = OpenDatabase("C:\PartUpdate.csv") but it says unrecognised...

I need to extract data from a csv file and show it in a grid and then update it in a MSSql server table.I was trying the same with data control + data grid. But no success. It is working for excel file but not for CSV.What should be the connect option be set to in case of CSV, which i set...

I have made a report on a query based on a table. But when i open the report and the table has no records, the reports shows the messages "Unable to Access First Record" and report doesn't opens up. How can i make the report to still open up with blank details even if the table has no...

In crystal report how can I supress the message "Unable to access First Record" , if a subreport doesn't fetches any record.The subreport is linked with the primary report on a Primary key field. The rest of the report is okay , but it doesn't opens up if the query on which the...

In crystal report how can I supress the message "Unable to access First Record" , if a subreport doesn't fetches any record.The subreport is linked with the primary report on a Primary key field. The rest of the report is okay , but it doesn't opens up if the query on which the...

Well I am calling a stored procedure written in Sql Server from VB.I take the result in a recordset. But the recordset doesn't allow Move previous/Recordcount/Movefirst , and find methods. Also the recordcount returned is always -1. Can anybody let me know how to overcome this.

Well I want to use the system procedure Sp_processmail. But iam stuck up. I give all the parameters , but it always return with an error message that parameter @set_user expects varchar. Can anybody let me know that how can i overcome this and how to set this variable.By the way I tried sa and...

Well I have a specific dynamic sql statement , which is made at run time. Now i execute this statement and want to catch the result of this dynamic sql inside a procedure and want this procedure to return that value to my form in VB. How can i move about ?