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)
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>
|
|
|
|
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)
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
|
|
|
|