BearRiver
asked on
Filemaker Server Advanced 11 odbc driver & .asp problem with sql query - not showing results
Hi All,
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:
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")
oConn.Open Application("strConnect")
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")
rsInfo.MoveNext
End If
rsInfo.Close
oConn.Close
ASKER
Any ideas why just the text field values would not be written to the screen?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER