How do you Use Advantage StreamlineSQL ODBC with CR.NET

I've created a VS 2003 ASP.NET application that displays crystal reports.

I've got it set up so that it is able to display any Report that is using a SQL Server ODBC. But just recently I've been asked to have a Report which accesses the database though a Advantage StreamlineSQL ODBC and it's not working.

a SQL ODBC asks for ODBC name, Servername, database, and login information.

StreamineSQL asks for "ODBC name", "table type" (foxpro), and "Database or Data Dictionary Path" (u:\servername\path\)

This report works fine using the Crystal Reports 11 application. But when I try to put it through the ASP.NET application it asks for login information.

What I also noticed is that I grab the servername, and database names from the report, but the new report only has the servername and there isn't a database name (because the database is the server).

anyways, if anyone has ever used this, or anything like these can you please let me know how I can use this report in an ASP.NET app?

if you need to see my code let me know.. thanks

[1055 byte] By [unlikely] at [2007-12-16]
# 1
Hello,

I am not familar with this database/ODBC driver - is it a secured database?

Have you tried setting the connection info at runtime? If you use the connection info object and set only the username and password it will use the values for database and server that are stored in the report.

Or this maybe similar to MS Access and in that case you might want to check out this kbase:

http://support.businessobjects.com/library/kbase/articles/c2014128.asp

I also found that AdvantageDB has a forum:

http://www.advantagedb.com/Forums.htm

It looks like there is a Crystal Reports forum, I haven't looked at it but you might have better luck posting there.

Keith - Business Objects

KeithThomson at 2007-9-9 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...

Visual Studio

Site Classified