| View previous topic :: View next topic |
| Author |
Message |
mubashir
Joined: 10 Jul 2005
Posts: 2
|
 Posted: Sun Jul 10, 2005 1:10 am Post subject: need help connecting to mysql server in asp |
 |
|
im using the following code:
| Code: |
Dim objConn
Dim objRS
Dim STRING
STRING = "Driver={MySQL ODBC 3.51 Driver}; Server=66.226.64.4; Database=dbname; UID=root; PWD=password; Option=3; Port=3306;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open(STRING)
Set objRS = objConn.Execute("SELECT * FROM categories_description")
While Not objRS.EOF
Response.Write objRS.Fields("categories_name") & ", " & objRS.Fields("categories_id") & "<br>"
Response.Write & " "
objRS.MoveNext
Wend
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
|
but i keep getting following error:
| Quote: |
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/index1.asp, line 14
|
please help, any help would be much appreciated. thanks |
|
| Back to top |
|
 |
administrator
Site Admin
Joined: 01 Oct 2004
Posts: 183
|
|
| Back to top |
|
|
mubashir
Joined: 10 Jul 2005
Posts: 2
|
| Posted: Sun Jul 10, 2005 5:53 pm Post subject: |
|
|
| thanks, i'll give that a try, ill let u knw if it works. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
