[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: MyODBC and .NET (C#)
From:       "Fredrick Bartlett" <palmtreefrb () earthlink ! net>
Date:       2002-03-12 16:04:37
[Download RAW message or body]

Hmmm...
Well I have two PC's that I have yet to get 3.51.xx to work with "ASP.NET".
Can I have both driver's installed at the same time?

This works...
   string mySQLConnStr = "driver={MySQL};";
   mySQLConnStr = mySQLConnStr + "server=127.0.0.1;";
   mySQLConnStr = mySQLConnStr + "uid=BARTLETR;";
   mySQLConnStr = mySQLConnStr + "pwd=74590000;";
   mySQLConnStr = mySQLConnStr + "database=myStore;";
   mySQLConnStr = mySQLConnStr + "OPTION=17923";

This does not work and I get the following error which makes no sence since
I have it installed and can use 3.51 from other applications. Just not from
ASP.NET
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified
  string mySQLConnStr = "driver={MySQL ODBC 3.51 Driver};";
   mySQLConnStr = mySQLConnStr + "server=127.0.0.1;";
   mySQLConnStr = mySQLConnStr + "uid=BARTLETR;";
   mySQLConnStr = mySQLConnStr + "pwd=74590000;";
   mySQLConnStr = mySQLConnStr + "database=myStore;";
   mySQLConnStr = mySQLConnStr + "OPTION=17923";

If you look at my previous post.  MDAC 2.7 reports that 3.51 is installed.
I'm wondering if the name of the drivers are in conflict. Maybe rename MySQL
ODBC to MySQLODBC with out the space.  Can I do this manually if I change
some .ini files?



---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread5125@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]