cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal connecting to a Local ServiceBased database

Former Member
0 Kudos

I am switching a project from a normal SQL Database to Local Database that will be packaged and deployed with the project.. first I can't seem to figure out in the "Set data location" which connection type I should be using.. It is not the normal ADO.  Something did seem to be created when I added the Database.. Looks like  ProjectName.Database.DatabaseName.. Property says it is ADO.net(XML)...  But when you open it to look for tables & stored procedures it just says "No Items Found"..  I see nothing I can do to point to the "items"..

However I connect, I do need the path not to be hardcoded, (whether I need to change the path in C# code programically doesn't matter).. But if the path is hardcoded, I need some advice on how to redirect the path.. That's because once packaged & deployed, I don't have total authority on where people will install it..

Just hoping to find some of you having navigated these waters before who can help me..

thanks.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Wendy,

What kind of a SQL DB is it and what is it based on? MS SQL Server or ???? And what kind of local database are you using?

Most DB's will use and have an ODBC Driver available, easiest way to manage this, users simply need to create the System DSN or your install scripts can do it for them.

Don

Answers (0)