×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Reading an SQL database

Reading an SQL database

Reading an SQL database

(OP)
After many happy years with Visual FoxPro, I have been given a new school database program (SIMS.net), based on MS SQL Server 2005. I have set up an ODBC(RDO) connection through Windows XP Pro to the data, so I can read it via Crystal Report Designer 9. Everything appears to work fine, except Crystal is not picking up data changes made to the SQL database. I presume this is because the ODBC connection is only reading the database's MDF file and not the LDF file (with all the latest changes to data).

Is this probable? Is there an ODBC setting I am missing, which if implemented would allow me to see the LDF data also? Or is it an SQL issue and I just have to update the MDF file more often?

RE: Reading an SQL database

Quote:


 I have set up an ODBC(RDO) connection
RDO? I didn't think SQL Server supported that since SQL7.
Why not ADO?

Depression is merely anger without enthusiasm.

RE: Reading an SQL database

(OP)
I followed the steps in, for example, http://iis.asu.edu/ceslab/kb/odbc_sqlserver.htm. Once the System DSN was set up, then Crystal Reports 9 shows it under what it calls ODBC(RDO).

Why not ADO? Mainly because I know nothing about it! If you could point me in the right direction, I'd be willing to give it a go ... .

RE: Reading an SQL database

Sorry, I misunderstood. I thought you were using a connection object/string thru code to get at the data. The steps outlined in the link above are correct. Pretty weird about the (RDO) naming convention though.
Getting back to your original problem:
When I use the DataReport designer (not Crystal) in VB with an Access database, I have to stop/start my connection object to see changes. Don't know if this helps or not, but good luck!

Depression is merely anger without enthusiasm.

RE: Reading an SQL database

Hi:
Could you explain the difference between the MDF and LDF files? I use Crystal and SQL and I haven't heard of this. It must be something in the structure of your database. You said "file" but are these maybe actually tables? Either way I think you may need to adjust your data source in Crystal. I'm not sure that this is an ODBC issue.

Barb

RE: Reading an SQL database

The LDF file should just be a log file.  Once your transaction is complete the MDF file should have the data.  In Crystal there is an option to save the data with the report (under the file menu).  Uncheck this so that every time you refresh your data Crystal makes a call to the database.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close