• Database Connection Error

    When I opened a crystal report from design mode to Preview mode It thrown this error:’’Database Connection Error:’Cannot obtain Error message from server’ and, ODBC Error(Merant) ODBC Oracle 8 Driver ORA-06550:Line1,Column8,PLS-00201:identifier’xxx.PRC_RI_REPORT’Must be Declared...

    Sandeepk6660 pointsBadges:
  • How to install the MySQL JDBC connector?

    Can anybody tell me how to install the MYSQL JDBC connector. I am getting error "java.sql.SQLException: No suitable driver ". I placed the driver in the java-jre\lib\ folder also in the shared folder of tomcat 5.0. Even in the lib folder of WEB-INF. But I am getting the same error.

    Advancedjava25 pointsBadges:
  • MS Access 2007 Author credit

    I'm designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?

    Lwbadgr5 pointsBadges:
  • Looping Queries in Oracle using data from SQL Server

    I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = '0' CONNECT BY PRIOR a.parentid = a.sid' Where I have '0' in the query above, should take all the values from PID. Is there a easy way to write this? or...

    Sreedhar775 pointsBadges:
  • Microsoft Access Drop Down List

    Hi, I have combo boxes in Microsoft Access where if the user starts typing the drop down list expands. Now if they use the keyboard to select the item, Access moves to the next control and the list is brought back up, but if they use the mouse then the list stays down. I was wondering if there was...

    RoadDust390 pointsBadges:
  • access 03 sending emails

    I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can't get it to work. Please help

    Bent4lf5 pointsBadges:
  • Dynamic/Data-driven page creation and content

    Hello! Sort of a "newbie", so please forgive the ignorance. I want to be able to build a page (and edit screen) dynamically, based on some mechanism of persistable per-control screen location/formatting/field masking information - storeable/retrievable as a "unit", representing a particular "view"...

    Galaxis5 pointsBadges:
  • Macromedia Dreamweaver Dataset problem

    Hi, I'm new to web development and I'm working my way through the Dreamweaver manual (also in the PDF). It was going well well until I hit the wall in "Chapter 5 Developing a Web Application" (Page 69-82). My problem.... I can't seem to get "Live Data View" to work (bottom of P.66 in the PDF) When...

    Thomas12345 pointsBadges:
  • Word and Excel

    In MS Access you can create a form so when its all filled out the data is automatically put into an Excel spreadsheet under the correct headlines. Is this possible to do this with a form made in word?

    AerospacePJ5 pointsBadges:
  • Converting data to SQL Server data with the DTS wizard

    I need to convert my Sybase data to SQL Server data. I tried using several methods for a single table that contains 1357 records. When I used the DTS wizard, the tranfer completed sucessfully but the data in the column with data type "money" was not correctly transferred. For an example, the value...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Viewing the guts of a Microsoft Access form, query and report, programmatically

    I have over 1000 MDB's which need to be checked to make sure they don't reference any external sources. So, I'm searching for 'A:', 'B:'... 'Z:', '\', etc. I need to search the guts of each form, query definitions, and reports to find any references to something external. The data is done. Is there...

    DMoseley5 pointsBadges:
  • Microsoft Access linking

    Hi, I have a database in access which has a main table and a products table. They are linked by a customer I.D. field (Primary Key). I have 2 forms one is the customer form and one a products form there is a button to open the products form from the customer form. I would like to be able to open...

    Donb5225 pointsBadges:
  • Find out what is in dbms_sql cursor

    I am trying to put in a 5500 character query into dynamic sql, and then use the Oracle dbms_sql function to execute the sql. However, there is an error in the sql statement that is being generated, but the error message doesn't help me identify where the error is, as it pertains to the dynamic sql...

    Darryn765 pointsBadges:
  • MySQL and JSP connection

    I hosted my site and I got the mysql server. Now, I want to connect it with the jsp pages . I am not understanding how to use ip address in connection string and while creating DSN i used my local server that is tomcat. But my website is in linux server. Will it create a problem.

    Advancedjava25 pointsBadges:
  • Can I link items between Outlook, Word, Excel, and Access, through the Calender view?

    Can links be set in Outlook Calender '07 to docs in Word, Excel, Access? I want to be able to go to a set date and access from that view all items pertinent without having to go looking for each item separately. Is possible?

    Notumbo15 pointsBadges:
  • How can I print all picture attachmens attached to a record on an access report

    I have a number of records that each have multiple attachments (pictures)> I have created a report and only the 1st attachment of each record prints on the report. Is the a way to have all the attachments print on the report for each record?

    FBDave5 pointsBadges:
  • Microsoft Access AutoNumber

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to be of 8...

    Ansh12320 pointsBadges:
  • Switch between two options in Microsoft Access 2000 text field

    I am an access programmer, not much used to with the VB codes. I am using the wizards instead. I have a new project where in I want the secondary level users to check the data fed by the primary users. The findings of the primary user will be available in the new screen for the secondary level user...

    SRCA5 pointsBadges:
  • SQL Server 2005 query to get the average

    Hi, I'm using MSSql 2005 on Windows 2003 Server. I need some assistance to write a query to get the average of two columns and write the value to a third coulmn. All the transactions is in one table. Basically it is column 1 + column 2 devide by two = column 3 Thank you, George

    GPNel200675 pointsBadges:
  • How can I compare fields on two databases

    I want to list all fields on a database and use a forall loop to check list of fields on two forms in two seperate databases...can this be done

    Star0810 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following