Reading an SQL database

[NickStiven]

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?

 

[genomon]

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.

 

[NickStiven]

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 ... .

 

[genomon]

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.

 

[Barb58]

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

 

[DjangMan]

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.