mysql problems

Author Message
xingxang

  • Total Posts : 1
  • Scores: 0
  • Reward points : 0
  • Joined: 10/17/2008
  • Status: offline
mysql problems Friday, October 17, 2008 10:35 AM (permalink)
0
I'm migrating a website to a Chili!Soft server running mysql. I've been working out issues with database connectivity, and I think that's all set now. However, when I access the website, I'm getting: Error Type: ADODB.Recordset.1 (0x80004005) SQLState: S Native Error Code: 1146 [TCX][MyODBC]Table 'pvcspor1_pvcspor1.pvcspor1_pvcspor1' doesn't exist /index.asp, line 23.

The code as follows:
 
 <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
 <!--#include virtual="/Connections/pvcsports.asp" -->
 <%
  
  
 Dim rsMetaTags
 Dim rsMetaTags_numRows
 Dim dsn
  
 dsn = "Driver={Mysql}; Server=localhost; Port=3306; Database=pvcspor1_pvcspor1; UID=*; PWD=*"
 response.write dsn
 dim dbConn
 set dbConn = server.createObject ("ADODB.connection")
 dbconn.open dsn
 response.write "connection successful"
  
 Set rsMetaTags = Server.CreateObject("ADODB.Recordset")
 rsMetaTags.ActiveConnection = dbconn
 rsMetaTags.Source = "SELECT * FROM pvcspor1_pvcspor1"
 rsMetaTags.CursorType = 0
 rsMetaTags.CursorLocation = 2
 rsMetaTags.LockType = 1
 rsMetaTags.Open()
 


Where is it pulling the table "pvcspor1_pvcspor1.pvcspor1_pvcspor1" from?
<message edited by xingxang on Friday, October 17, 2008 10:39 AM>
 
#1
    TNO

    • Total Posts : 2094
    • Scores: 36
    • Reward points : 0
    • Joined: 12/18/2004
    • Location: Earth
    • Status: offline
    RE: mysql problems Monday, October 20, 2008 4:00 AM (permalink)
    0
    I would have to venture a guess and say that the connection string is wrong and the database isn't called
    pvcspor1_pvcspor1
    To iterate is human, to recurse divine. -- L. Peter Deutsch
     
    #2

      Online Bookmarks Sharing: Share/Bookmark

      Jump to:

      Current active users

      There are 0 members and 1 guests.

      Icon Legend and Permission

      • New Messages
      • No New Messages
      • Hot Topic w/ New Messages
      • Hot Topic w/o New Messages
      • Locked w/ New Messages
      • Locked w/o New Messages
      • Read Message
      • Post New Thread
      • Reply to message
      • Post New Poll
      • Submit Vote
      • Post reward post
      • Delete my own posts
      • Delete my own threads
      • Rate post

      2000-2012 ASPPlayground.NET Forum Version 3.9