Hi guys, so I was given an assignment on vb.net to make an ID Validator, and since being done with that, I've been unable to generate reports with it.
I've basically scoured the internet in search of a solution, downloaded all the 'connectors' specified, but nothing seems to be working.

While trying to connect the CR to database, I get the below error everytime...
.

Failed to open the connection.
Details: ADO Error code: 0x80004005
Source: MICROSOFT OLE DB Provider for SQL server
Description: [DBNETLIB][ConnectionOpen (Connect().)SQL server does not exist or access denied.
Sql state: 08001
Native error: 17....

.
I've also tried using click events(manual pulling of data into CrystalReport) like I do on VB6 but nothing is working.
.
I'll appreciate if anyone can assist me with this.
TIA.

Any form of help will be very much appreciated guys... Abeg, no just view and leave if you can help out o.

Using VB6 technique in .NET? The versions are so so different. You did not even state the version of .NET you are using - the different versions have slightly different approaches to doing stuffs.
I am quite rusty in VB.NET at the moment, but i know we have active VB.NET programmers on the board sha.

Thanks for the reply brov... Though, I didn't mean I used VB.6 codes or techniques, I meant like you easily call a report in vb6 at runtime, I decided to explore the options for VB.Net.
.
And it's VB10.net - 2013 (Professional) to be precise.... Thanks again "dhtml18"

What measures have you taken to ensure that you resolve all those errors?
Do you have mssql server installed and configured properly?
Are you sure your connection credentials are okay?

Because this looks like the problem rather than crystal reports per say.

I have practically downloaded all the connectors in Microsoft's store... I actually downloaded 'MySQL Workbench 6.3 CE' since I make use of MySQL specifically (and wampserver) and not SQL OLEDb.
I've equally downloaded some "Source codes", but seems everyone's making use of 'Datasets', tried that and was met with yet more errors.

That MySQL with VB things, last time i did that was VB 6. And I remember using ODBC before I could link it. I remember the details no more however except that I used ODBC at some point.

There is another way too that has to do with MySQL connection, let me search a bit, got it


http://stackoverflow.com/questions/6190599/vb-net-mysql-connection

Once you have got that connector, it practically makes your VB app a MySQL client, somewhat similar to MySQL workbench.

Can't thank you enough sire, I really appreciate the effort... I'll be back to update on how it goes.
Thanks.

Seems I've installed the referenced connector already... Though from what I got just now, "Installing an unsupported .Net Connector does more harm than good", So, I'll try uninstalling all the other connectors to see how it goes.
Thanks for your time ->
Dim dhtml18 As String = "Thanks for Your time"
MsgBox(dhtml18, MsgBoxStyle.Exclamation)

great, except that you need to use MsgBoxStyle.Troll (if they dont have that, we need to tell microsoft to create a TROLL ICON).

dhtml18:
great, except that you need to use MsgBoxStyle.Troll (if they dont have that, we need to tell microsoft to create a TROLL ICON).

I got that

dhtml18:
great, except that you need to use MsgBoxStyle.Troll (if they dont have that, we need to tell microsoft to create a TROLL ICON).

Wow, never knew that!, Boss you are... Gracias

Wow, so I finally got a way out after weeks of rigorous search and 'Trial & Errors'... Finally got a way out!...overjoyed!.
Used DataSets instead of the traditional 'OLEDB sql' parameters and with the assistance of a video from Youtube, was able to make it work!.

For anyone having same issues, you can search Youtube using this string - "Create report in vb.net with mysql using crystal report".

As per the error I made mention of(Missing DLL), found a solution here -> http://scn.sap.com/thread/3606863

'dhtml', thanks for the replies.

You are an excellent person, many of our brothers will not share how they solved the problem, they will just waka way.
Congrats, you need to kill a TURKEY to celebrate this.

dhtml18:
You are an excellent person, many of our brothers will not share how they solved the problem, they will just waka way.
Congrats, you need to kill a TURKEY to celebrate this.

Lol, I tell you... its so worth it.