Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fxdigital
Starting Member
1 Post |
 Posted - 2011-05-02 : 20:58:57
|
| Have just moved from windows 2000 to windows 2003... and one of my sites which uses ASp / MySQL will not work. It works locally using the online database, it works locally using the local database... and it worked previously on the old server... but not this one. It appears as if the SQL at the start of the index.asp file is not being executed... this takes data from the database (mySQL) and generates the data required for this... however it isn't working.... the sctipt at the top of every page see index.asp is: <%Dim rsCSSMenu1Dim rsCSSMenu1_cmdDim rsCSSMenu1_numRowsSet rsCSSMenu1_cmd = Server.CreateObject ("ADODB.Command")rsCSSMenu1_cmd.ActiveConnection = MM_swan_mysql_STRINGrsCSSMenu1_cmd.CommandText = "SELECT *, CONCAT(swan_link,'?ID=',id_mnu) AS NewURL FROM menu_mnu WHERE visible_mnu = 1 ORDER BY order_mnu ASC" rsCSSMenu1_cmd.Prepared = trueSet rsCSSMenu1 = rsCSSMenu1_cmd.ExecutersCSSMenu1_numRows = 0%>................I have changed the /MX_Menu2.inc.asp file to write what it finds ... and when excecuted onling it shows ??????? ... when run locally it shows:standard.asp?ID=37standard.asp?ID=38board.asp?ID=39standard.asp?ID=42standard.asp?ID=43standard.asp?ID=44news.asp?ID=47events_all.asp?ID=49calendar.asp?ID=50swan_event.asp?ID=51network_2000.asp?ID=52standard.asp?ID=53standard.asp?ID=56business.asp?ID=62business.asp?ID=63links.asp?ID=64standard.asp?ID=80login.asp?ID=69standard.asp?ID=73standard.asp?ID=74standard.asp?ID=79standard.asp?ID=58standard.asp?ID=66standard.asp?ID=71standard.asp?ID=75standard.asp?ID=59standard.asp?ID=72standard.asp?ID=76standard.asp?ID=77standard.asp?ID=60members_profile.asp?ID=68standard.asp?ID=78standard.asp?ID=61standard.asp?ID=70standard.asp?ID=40Swan ChamberThis data for some reason is not being generated on the server...Anyone got any ideasthank youSteve |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQl runs locally but not online