Search results for query: *

I am having the same issue. Did you ever find out any shortcuts? Thanks

Has anyone come accross this. Running a cfquery through CFMX and getting one set of data and then running the exact same query (from the debugging information) in SQL Query Analyzer and getting different results? The query uses multiple CASE statements.

Yes.

Were you ever able to figure out what the problem was. I am currently having the same situation. Thanks

I have set up a system DSN for a database connection for MSQL and am accessing it with ASP (Yes the driver has been installed). If I test the DSN, it connects fine but if I run the web page, I get a page not found error. If I take out the connection code, the page loads fine. It works with no...

The connection works on my local machine but not on our Intranet server. The DSN is set up correctly and it tests fine but when I try to run a page with the connection DSN, it just tells me that the page cannot be found and no mention of a problem with the database. If I commect the connection...

I have a form in which I click on a button and a Calendar pops up. When a date is chosen, I want to place it in a field on the first form. It seems simple but can not seem to find the answer. Help. Thanx

I recently used the Data Transformation Services / Import Wizard to import my Access 2000 database to an SQL 2000 database. The problem is that now some of the queries that worked fine in Access are giving me a host of errors is SQL. It is connecting fine to the SQL database. Does anyone know...

Use this to set up the database connection: <% 'connection.inc create connection to inventory.mdb dim cnnDataACCESS 'ActiveX Data Object-Connection Object dim strConnectACCESS 'Connection String 'create instance of ActiveX Connection Object set cnnDataACCESS =...

I ran into this same problem and Crystal has a problem with the dependancy files for the OCX. Take a look at this from the Crystal Knowledge base http://support.crystaldecisions.com/library/kbase/articles/c2009452.asp

The following is the code that is being used to run the report. Public Sub Do_Print() On Error GoTo StopPrinting Crystal1.Connect = &quot;DSN=M:\Public\Accounting\New Commissions Application\Commissions.mdb&quot; Crystal1.ReportFileName = &quot;M:\Public\Accounting\New...

Yes I am using a DSN and the application works fine with the database but the when the report is called on, it says that it can not find the database.

I have created an application in VB which uses the Crystal OCX to run and show the reports but for some reason, it will run fine on my machine which has CR8.5 installed on it but when I package the application and install it on another computer, an error message shows up to say that it is unable...

In order to run reports from an ASP application which will be dependant on parameters entered from the ASP page, does Crystal Reports, Crystal Enterprise, or both have to be installed on the server that our intranet is running on ?

Can someone tell me what dlls are necessary to be packaged with a VB6 application in order to run CR8.5. I am getting errors when packaging the application. Thanks

When attempting to package the application I get the following Error: Unexpected error number 80010108 has occurred: Automation error. The object involved has disconnected from its clients. The application runs fine with the dll for the classes. I am also using Crystal Reports for reporting...