I updated a server to FMSA11 today from FMSA10 and my website (ASP) queries (SQL queries via ODBC) no longer work. I have upgraded to the latest version of ODBC drivers from the FMSA11 install files and the ODBC connection tests are successful. Also, I found a post somewhere on the web that mentioned that the connection string format has changed, so I modified the connection string and I can see that my queries now connect and perform the queries (I have tested the INSERT and SELECT queries) - HOWEVER when running a SELECT query the results do not seem to write to the page. It worked correctly as shown below for years before upgrading to FMSA11 - but now no longer works. Any ideas?
Here's what my query looks like:
set oConn = server.createobject ("ADODB.Connection")
strSQL = "SELECT box1_color, box2_color, box1_text, box2_text, box3_color, box3_text, box3_bgcolor, box3_fontcolor, box3_showhide FROM Graphix WHERE recid = 1"
Set rsInfo = oConn.execute(strSQL)
If NOT rsInfo.EOF Then
box1_color = rsInfo("box1_color")
box2_color = rsInfo("box2_color")
box1_text = rsInfo("box1_text")
box2_text = rsInfo("box2_text")
box3_showhide = rsInfo("box3_showhide")
box3_color = rsInfo("box3_color")
box3_text = rsInfo("box3_text")
box3_bgcolor = rsInfo("box3_bgcolor")
box3_fontcolor = rsInfo("box3_fontcolor")