Can I use Visual Studio 2008

Imar · March 1st, 2009, 05:17 PM

Ah, I see. It's been a long time since I used something like MySql, so I can't tell whether it's supposed to work or not.

Are you using a separate connector to connect to MySQL? If not, maybe installing one adds the necessary tools to support this behavior? http://www.mysql.com/products/connector/net/

Just guessing here, but it may work out for you....

Cheers,

Imar

nielseno · March 1st, 2009, 05:59 PM

I think you got it, I used the ODBC connector, not knowing that there was a .NET specific connector.

Here's the latest for .NET:
http://dev.mysql.com/downloads/connector/net/5.2.html

I found it amongst the other connectors here:
http://dev.mysql.com/downloads/

Thanks, I'll give it a try and report back.

nielseno · March 1st, 2009, 07:56 PM

Well, I installed the new connector and the only thing that changes was that I now have a MySQL option immediately available in the Data Dource portion of the Add Connection Dialog box, which effectively simplified the connection creation process but didn't affect the behavior when dragging a table over to the cpMainContent area.

So, I guess that seems to be the expected behavior when using a non-Microsoft database. Would you know if wrox would have a book dealing with DB connections to non-Microsoft databases?

BTW, I have a full version of VS on one PC and the Express version on another. After installing the connector on the Express version, the MySQL database connection option did not show. Not sure if that's a bug or not but I plan on posting to MySQL to see...

Imar · March 2nd, 2009, 02:16 PM

Quote:

Would you know if wrox would have a book dealing with DB connections to non-Microsoft databases?

There's a (generic) ADO.NET book that deals with, among others, MySQL: http://www.wrox.com/WileyCDA/WroxTit...764584375.html

Cheers,

Imar

nielseno · March 2nd, 2009, 02:33 PM

I'll check it out.

Also, I've done some looking around both on the MySQL website and the ASP.net website and it seems like a lot of people are having issues with the MySQL connection. The asp forums seem to have more activity.

http://forums.asp.net/56.aspx

Kevin7777 · March 5th, 2009, 08:46 PM

I'm stumped.

I am able to query the pubs and northwind db's with server name "localhost\sqlexpress" in Visual Studio but I cannot connect with SQL Server Management Studio Express. I have tried every possible combination: (name of computer\SQLEXPRESS), (local)\sqlexpress

Do I need to create a new instance of sql?

Here' the error:

TITLE: Connect to Server
------------------------------
Cannot connect to (localhost)\sqlexpress.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

I do have both VWD 2008 and VS 2008 installed on Vista.

Thanks, Kevin

Imar · March 6th, 2009, 03:47 AM

You shouldn't use (localhost), but only (local) or simply a dot .\SqlExpress

Imar

Kevin7777 · March 6th, 2009, 10:32 AM

Thanks Imar, I really appreciate your help with this, but that didn't work either.

I "Enabled" Remote Connections as described on page 690/Appendix B but that did not work either. Should I enable "Via" I don't know, very frustrated!

This connection string works in VS:

Code:

 
<add name="NorthwindConnectionString" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=Northwind;Integrated Security=True"
providerName="System.Data.SqlClient" />

Kevin

Imar · March 6th, 2009, 10:46 AM

Maybe this helps: http://imar.spaanjaars.com/QuickDocId.aspx?ID=395

Check out the section "Other issues" at end in partcuclar....

Imar

Imar · March 6th, 2009, 10:47 AM

And have you tried:

(local)\SqlExpress

or

.\SqlExpress

instead of

localhost\sqlexpress

Imar