The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
What is the mode of transmission of Database: MySql
I am having a very big problem in large-scale transfer of records
strConnString1 ="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=0000000; DATABASE=000000; USER=0000000; PASSWORD= 000000; OPTION=16387;"
strConnString2 ="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=000; PORT=3306; DATABASE=000; USER=000; PASSWORD=000; OPTION=16387;"
set Conn1=server.createObject("ADODB.connection")
Conn1.open strConnString1
strSql1="SELECT TOPIC_ID from forum_topics order by TOPIC_ID LIMIT 11000,1000"
set rs1 = Conn1.Execute (strSql1)
Attempted transfer of subjects and I was there a line in the transfer of records
Is there a way of transfer of each section and pages of members and the responses, voting records, calendar
Thank you for your help in advance
I am having a very big problem in large-scale transfer of records
strConnString1 ="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=0000000; DATABASE=000000; USER=0000000; PASSWORD= 000000; OPTION=16387;"
strConnString2 ="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=000; PORT=3306; DATABASE=000; USER=000; PASSWORD=000; OPTION=16387;"
set Conn1=server.createObject("ADODB.connection")
Conn1.open strConnString1
strSql1="SELECT TOPIC_ID from forum_topics order by TOPIC_ID LIMIT 11000,1000"
set rs1 = Conn1.Execute (strSql1)
Attempted transfer of subjects and I was there a line in the transfer of records
Is there a way of transfer of each section and pages of members and the responses, voting records, calendar
Thank you for your help in advance
Posted
Use a tool such as SQLYog or use phpadmin to export the data as a text dump and then import it to the new database.
Posted
There was an error when importing records text because the markup is there more than 5000 errors in the Register of mis threads forum_a_topics
forum_a_reply
forum_topics
forum_reply
forum_members
forum_a_reply
forum_topics
forum_reply
forum_members
Posted
My advice again is to download and install the free version of SQLYog. Use it to backup the "old" database and then use the backup to restore to the new one. When you backup, select the options to include DROP statements.
Posted
Thank you to apologize for the delay but I know the Egyptian revolution thing for taking all the time in Mrklh election issue has been resolved and I me another question
I'm doing and I Newsflash: there is a mistake
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
line 19
rs.open strSql, conn_active, adOpenForwardOnly, adLockReadOnly, adCmdText
I'm doing and I Newsflash: there is a mistake
Code:
<%
dim strConnString_active
dim conn_active
dim rs
dim topic_cnt,strSql
strConnString_active ="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=0000000; DATABASE=00000000; USER=000000; PASSWORD=000000; OPTION=16387;"
set rs = Server.CreateObject("ADODB.Recordset")
strSql="SELECT FORUM_TOPICS.CAT_ID,FORUM_TOPICS.FORUM_ID,FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT FROM FORUM_TOPICS ORDER BY FORUM_TOPICS.T_LAST_POST DESC LIMIT 20"
' set rs = Conn.Execute (strSql)
rs.cachesize = 20
rs.open strSql, conn_active, adOpenForwardOnly, adLockReadOnly, adCmdText
topic_cnt=1
%><marquee direction="right" scrolldelay="150">
<% do until rs.EOF
Response.Write "<a href='/forum/topic.asp?TOPIC_ID=" & rs("TOPIC_ID") & "' target='_blank' class='linkmid'> " & rs("T_SUBJECT") & "</a>"
%>
<font face=Webdings color=FF0000><</font>
<% rs.MoveNext
topic_cnt=topic_cnt + 1
if topic_cnt = 15 then
exit Do
end if
loop
rs.Close
set rs = nothing
conn_active.close
Set conn_active = Nothing
%>ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
line 19
rs.open strSql, conn_active, adOpenForwardOnly, adLockReadOnly, adCmdText
Posted
Did you set a value to conn_active?