ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Programming Languages - More > ASP Programming
Reload this Page

MySQL bombing out with ASP on IIS

Discuss MySQL bombing out with ASP on IIS in the ASP Programming forum on Dev Shed.
MySQL bombing out with ASP on IIS ASP Programming forum discussing Active Server Pages coding techniques and problem solving methods. Use VBScript or Jscript to make dynamic web applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old February 9th, 2003, 03:20 PM
dlo001 dlo001 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2003
Posts: 5 dlo001 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
MySQL bombing out with ASP on IIS
I checked out my DSNs and it looks like I have the drivers installed for myODBC.

When I go to configure the DSN, it gives me an error:

"The setup routines for the MySQL ODBC driver could not be loaded due to system error code 126" [Click OK]

"Could not load the setup or translator library" [Click Ok]

ASP error page:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Specified driver could not be loaded due to system error 126 (MySQL).
/test_scripts/test_adodb.asp, line 15

Code:
<%@ LANGUAGE="VBSCRIPT" %>
<%
strConnection = "driver={MySQL};server=127.0.0.1:3306;uid=root;pwd=;database=test"
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open strConnection

strQuery = "SELECT * FROM test;"
Set RS = adoDataConn.Execute(strQuery)
%>




Did the MyODBC driver not load properly?????

Need help asap. Cant develop unless get passed this

Thanks
Reply With Quote
  #2  
Old February 11th, 2003, 04:11 PM
victorpendleton victorpendleton is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
  
Join Date: Jan 2003
Location: No es importante
Posts: 2,065 victorpendleton User rank is Private First Class (20 - 50 Reputation Level)victorpendleton User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 6 h 44 m 30 sec
Reputation Power: 8
What OS are you using? What version of the MyODBC are you installing?
__________________
El éxito consiste en una serie de pequeñas victorias día a día

MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html
Reply With Quote
  #3  
Old May 6th, 2003, 03:03 PM
Battle Angel's Avatar
Battle Angel Battle Angel is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2003
Posts: 4 Battle Angel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I'm having the same problem installing the mySQL ODBC drivers.

mdac: 2.6
mySQL: 4.0
Server 2000 SP3
Reply With Quote
  #4  
Old November 1st, 2003, 10:42 AM
Panhandler Panhandler is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: Gig Harbor, WA
Posts: 1 Panhandler User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
MySQL can't find database
Greetings,
I recognized your server address and its the same as mine!
The host and I are currently trying to figure out why the MySQL won't hook up with the database. Would you mind contacting me regarding this problem? URL
Thanks,
Reply With Quote
  #5  
Old November 2nd, 2003, 06:10 PM
INF INF is offline
Standards User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2003
Posts: 146 INF User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 4 sec
Reputation Power: 6
Hey my server adress is 127.0.0.1 too!...
Reply With Quote
  #6  
Old November 2nd, 2003, 11:30 PM
Doug G Doug G is offline
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
  
Join Date: Jun 2003
Posts: 10,982 Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 1 Day 18 h 42 m 27 sec
Reputation Power: 814
The IP address 127.0.0.1 is a special addresses reserved for the "loopback" address. This means 127.0.0.1 is the same as the name "localhost" which is your own computer. You must provide an external IP address if the tcp service you want is not running on your own computer.

Another way to put it, anything sent to 127.0.0.1 never leaves your computer.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > MySQL bombing out with ASP on IIS

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway. 
Stay green...Green IT