Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Connect to SQL Server Post Reply Post New Topic
Author Message
newtocrystal
Newbie
Newbie


Joined: 26 May 2008
Location: Canada
Online Status: Offline
Posts: 2
Quote newtocrystal Replybullet Topic: Connect to SQL Server
    Posted: 26 May 2008 at 11:03am
I am using Crystal report XI and trying to connect to my sql server residing on server 2003.  Can someone provide instruction
Thanks You
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 27 May 2008 at 12:34pm
Probably the easiest way is to set up an ODBC connection and point it to the database on the server. If you use SQL authentication on the database you can include the login credentials as part of the ODBC setup. You will detailed information in the CR help file under "ODBC data sources".

Similarly you can use an ADO connection which will set up and OLEDB type data connection. You will find detailed information in CR help under "OLE DB (ADO) dialog box"
 
Hope this will get you started.
 
Regards,
 
John W.
IP IP Logged
newtocrystal
Newbie
Newbie


Joined: 26 May 2008
Location: Canada
Online Status: Offline
Posts: 2
Quote newtocrystal Replybullet Posted: 27 May 2008 at 12:40pm
Thanks
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.