Connect to online database from Crystal Reports
Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16788
Printed Date: 26 Apr 2024 at 9:28am
Topic: Connect to online database from Crystal Reports
Posted By: trivk96
Subject: Connect to online database from Crystal Reports
Date Posted: 19 Jun 2012 at 2:01am
|
Does anyone know how i can connect to an online database from crystal reports. The database specifically is DevTrack by TechExcel
|
Replies:
Posted By: hilfy
Date Posted: 19 Jun 2012 at 3:35am
|
Can you set up an ODBC connection to it? Or is there a web service available? Some of this also depends on which version of Crystal you're using. -Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: trivk96
Date Posted: 19 Jun 2012 at 3:59am
|
The version i am using is the newest. I didn't know how to do it using the web services. I didn't know what to put for the http(s) schema url. It is not on the internet but on the server. it is a file on the server accessed through a browser
|
Posted By: trivk96
Date Posted: 19 Jun 2012 at 4:16am
Posted By: hilfy
Date Posted: 19 Jun 2012 at 4:19am
|
It sounds like there probably isn't a web service available to get the data. So, you'll have to look into setting up an ODBC connection. -Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: trivk96
Date Posted: 19 Jun 2012 at 10:08pm
|
Just found out a bit more about the db. The db is on the local network. and it is connected to through VPN. Still need help connecting. it is SQL server. Any more hints. Is it ODBC... Web service... or something else. Any help is very much appreciated Thank you
|
|