Link to home
Start Free TrialLog in
Avatar of BearRiver
BearRiverFlag for United States of America

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

Open in new window

Avatar of BearRiver
BearRiver
Flag of United States of America image

ASKER

Update: I ran some more tests and found that the results are writing number and date fields to the results, it's just the text field values that are not getting written
Any ideas why just the text field values would not be written to the screen?
ASKER CERTIFIED SOLUTION
Avatar of BearRiver
BearRiver
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial