Member Avatar for weeraa

I know to work with VB.net + crystal report + SQL server.
But now i want to work with SQL server compact edition instead of SQL server.
When we creating Crystal report it is asked provider in one moment. If we work with SQL server we select "Microsoft OLE DB provider for SQL server".
I want to know

(Q1) what I should select as provider.

(Q2)After clicking next, it is asked SERVER. what should i typed. (When i use sql server i typed, "MyName-PC\SQLEXPRESS")

Please Help Me.....

  • 3 Contributors
  • 3 Replies
  • 272 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by poojavb

Recommended Answers

All 3 Replies

Member Avatar for weeraa

DATASET?
Will you please elaborate.

Member Avatar for poojavb

I know to work with VB.net + crystal report + SQL server.
But now i want to work with SQL server compact edition instead of SQL server.
When we creating Crystal report it is asked provider in one moment. If we work with SQL server we select "Microsoft OLE DB provider for SQL server".
I want to know

(Q1) what I should select as provider.

(Q2)After clicking next, it is asked SERVER. what should i typed. (When i use sql server i typed, "MyName-PC\SQLEXPRESS")

Please Help Me.....

If its a windows authentication in ur SQL server then u can use as follows

Server Name: MyName-PC\SQLEXPRESS

Integrated Sercurity checkbox as checked

then the username and password gets disabled

click on Database... ur database will come in the drop down....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.