Recent content by mercurymik

Thanks Kray4660. It was a hint enough to get me to the right place. I had tried it with the single qoutes and it failed. What worked was not using the quotes. mailto:Whomever@someplace.com&Subject=Test&Body=The start of a message. The tags &Subject= and &Body= specify subject line and...

In Crystal Reports Enterprise I have several reports that have a "text field" with the word "email" that is a "hyperlink" to bring up an e-mail with specific data from the record details. For instance one report shows purchase orders a department has made. If there is a question about one of...

chelseatech Thanks, but unfortunately I cannot even install a third party app without going through a week of intense interrogation by IS Management followed by a ROI evaluation and the agreement of 6 co-developers saying they would most likely use the functionality... OK maybe not quite that...

Using crystal reports XI and BOXI Enterprise The dream: I have a Purchase Order report...The vendor happens to have an e-mail address. After creating my report and viewing it for accurracy I want to e-mail the report to this vendor if they have an e-mail address. Not all vendors in my system...

Sometimes when the field of the left outer join is used in the selection criteria I have had to include a statement like: {Joinfield} = {?parameter} or IsNull({Joinfield}) or when trying match the field I have had to use this: ({LeftJoinTableField} = {JoinField} or IsNull({LeftJoinTableField}))

Thanks, that is helpful

I inherited a Novell network. Some of the computers have a Workstation Only option on the Novell Network login screen... some don't. The latest client program we are installing is 4.9. It seems this is the version without the option. Once in awhile a computer may be used for a presentation...

First of all, indexed views are great if you only need straight forward select statements from base tables. If you want to combine data using derived tables, they have some major limitations. The real question is why do you not want your users in the base tables??? If you set your security up...

This problem occurred because the server needed to be rebooted after the installation of the Oracle Client. The reboot was not requested after the client install, like most programs. What is interesting is that I could manually run the DTS package successfully, but, I could not schedule it...

Either way, you can link the SQL server table to the Access database and use Access queries to perform the updates. You just have to be sure a key is defined. When linking the table, if access doesn't pick up the key it will ask you to select fields to create unique records. You can also use...

I would link the SQL Server table to the Access database using an ODBC connection. As long as your ODBC connection is authenticated to a user with the proper authority in the SQL Server, you can use your Access queries to update the data. I suggest you setup a user on the SQL Server that only...

I am using the Oracle specific ODBC that was installed with the Oracle Client. It is the SQORA32.dll version 9.02.00.00. Thanks again

Yes, I can run the DTS Package from the Enterprise manager console on the SQL Server and it works fine. As long as I manually run the DTS Package the data is transferred to the Oracle database. When I schedule the package, the scheduled job fails with the error. What I find interesting is that...

I had the same problem when I used an "Oracle Provider for OLE DB" connection that I defined in the DTS package. What I did to overcome that was create a System DSN using the Oracle ODBC driver that loaded with the Oracle client. In the DTS package I chose the "Other Connection" and pointed...

I figure I should start my own thread on this one. I have a SQL Server 2000 on a Microsoft Server 2003 box. And I have Oracle 9i on a Microsoft 2000 Clustered Server. I am trying to transfer data from a SQL server table to an Oracle table. I have installed an Oracle 9i client on the server...