2
Answers

assign different SQL server name to crystal report

Doudy

Doudy

10y
853
1
I'm working on a WPF.Net application (.Net 2010) with Crystal Reports and sql server 2012,and want to connect to my Sql Server instance in the Crystal Reports designer on my machine. and send this data to crystal by code:
 
    
my Server Name: MSSQLSERVER     Authentication: SQL server Authentication User Name: my username     Password: my password      myCrystalReport.SetDatabaseLogon("myUsername", "myPassword", ".", "myDatabaseName");



also add this data in app.config and it works fine, but on my client machine when I deployed this application , crystal reports asks me for password, and I my client machine didi't accept (.) for the server name, 

   
 my client machine server name is : ADMIN-PC\SQLEXPRESS



so how can I solve this please 
Answers (2)
0
Abhimanyu K Vatsa

Abhimanyu K Vatsa

NA 50.9k 12.4m 13y
Look at the Sam's Post to learn basics of ADO etc.

Read this post, it will full-fil your ask. here you will find a working example too.

http://www.c-sharpcorner.com/UploadFile/abhikumarvatsa/1605/
0
Sam Hobbs

Sam Hobbs

NA 28.7k 1.3m 13y

Look at the following. I know that the Forms section is quite large, but you will see the abundance of useful material.