Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Professionals
|
ASP.NET 3.5 Professionals If you are an experienced ASP.NET programmer, this is the forum for your 3.5 questions. Please also see the Visual Web Developer 2008 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 3.5 Professionals section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 26th, 2009, 07:15 AM
Authorized User
 
Join Date: Apr 2007
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP.NET with MySql, connection not being established

Hello Friends,

I'm establishing a connection between ASP.NET and MySql. But i'm getting following error

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Here i'm also providing my ConnectionString below

<connectionStrings>
<
addname="ConnectionString"connectionString="Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=totalbhakti_new; uid=root;pwd=; />
</
connectionStrings>

Actually MySql which is installed on my system is with PHP(using Wamp Server). Is that the reason behind throwing the error
 
Old March 25th, 2009, 07:39 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 166
Thanks: 2
Thanked 33 Times in 33 Posts
Default

I haven't got .NET 3.5 here at the moment, but I installed connector 3.51 and ran it fine with ASP.NET 2.0. I don't see having MySQL bundled with PHP as being an issue.
There are two things you could try.

A post here suggests that you may not need the Driver={MySQL ODBC 3.51 Driver}; part, but I'm not sure if that will fix it.

A better idea would be to download the new MySQL driver written specifically for .NET 3.5. You can download it here and see the docs here.

Phil





Similar Threads
Thread Thread Starter Forum Replies Last Post
Asp and Mysql Connection surendran Classic ASP Basics 3 September 15th, 2005 05:22 AM
Connection coudn't be established to the local hos rraguraman JSP Basics 1 February 13th, 2005 01:42 PM
ASP Connection to MySQL fs22 Classic ASP Databases 1 August 18th, 2004 11:35 PM
Runtime error 40006 - After connection established mynameisbill2 Beginning VB 6 1 November 29th, 2003 05:05 AM
ASP.NET database connection MySQL socoolbrewster ASP.NET 1.0 and 1.1 Basics 3 November 21st, 2003 07:12 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.