Creating ODBC connection

In my project, I have added a database called aspnetdb.mdf and I store all the required information here. Now I want to write a seperate Cryatl Report for my manager, that accesses this database and display required data. This report is not a part of the asp.net project. This is only for my manager. My database is not attached to any server. I just use the attachdb in the coonection string of my project to attach this database. no I want my crystal report to access this database. If I can create an ODBC connection to this database, it will solve my problem. Dows any body know how to access this database from Crystal with or without ODBC?

Any help is greatly appreciated.

i think crystal supports pretty much any type of data source, eg. odbc, oledb, etc.

Is the database SQL Express running on your own computer? I can find the connection string for you if this is the case.

Creating database from SQL Server set uP Wizard

can i create a table within the aspnetdb.mdf?

I created a database from SQL server set up wizard, and the

database i make copy exactly what a aspnetdb.mdf(from tables to

stored procedure) has..Can i change or add some files,tbles and

stored procedure to it...

I'll using SQL Express Edition...

can i know what is the best way to implement the database i created

if im going to setup ,manually my database (without set up

wizard)can I copy the tables and stored procedure in aspnetdb.mdf

in my database??

thanks for the answer...

thanks and more power...

Hi,

In my opinion, you can add some fields or stored procedures in the table in ASPNETDB.mdf. However, I suggest you not change any existing fields created by the wizard. Because this will cause unexpected result.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!