Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MySQL ODBS DNS global.asa not working correctly

Posted on 2013-01-06
3
447 Views
Last Modified: 2013-01-15
Hi, i am moving websites from one server to another and they all use the mysql 3.51 odbc driver. the server ti is from is 2003 x86, the destination is 2008 R2 Ent x64

i am having difficulty with one website that says:

80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified

the dsn string i am using (which only differs by the DB, user, passsword to other websites:

Session("DSN") = "DRIVER={MySQL ODBC 3.51 Driver};Server=10.5.74.4;Port=3309;Database=<db>;Uid=<user>;Pwd=<password>"

i have verified that the credentials i am using work by using the ODBC manager and also sqlyog.

so i know the credentials work and the driver specified is all ok as other websites are using it without any issue.

i have the 3.51 driver installed for both 32 and 64 bit operation (both show up correctly in the 32 and 64 bit odbc managers. (in fact i have both 3.51 and 5.1 versions of the mysql odbc connector installed for both 32bit and 64bit but changing the driver in the global.asa file does not work.)
0
Comment
Question by:d00s7w
  • 2
3 Comments
 
LVL 51

Expert Comment

by:ahoffmann
ID: 38749356
dos this help
   /Web_Development/Web_Languages-Standards/ASP/Q_25190790.html
0
 

Accepted Solution

by:
d00s7w earned 0 total points
ID: 38764174
well i dont know what i have done but its working now!
0
 

Author Closing Comment

by:d00s7w
ID: 38777577
self fixed
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question