>I keep getting this error in my asp pages that I create with the Interdev data form wizard. The error occurs at the first numeric field in the table. The first three fields are chr and they are shown on the asp page, but the fourth field is numeric and generates the error '00000000'. I'm working with NT4ws, Peer Web, Service Pack 3. I've d/l the new VFP ODBC. I've installed several ASP examples and they all work. I've even used a Access mdb included in a tutorial and it worked fine. Thanks to anyone that can help
>
>Michael Lim
>mlim@dalton.net
I am accessing VFP free tables and dbc's via ODBC in ASP. I'm not sure what your problem is nut here's a few things to look out for and try. Can you access your data set without the numeric field? (I don't think you'll be able to.) Where is your ODBC pointing to? You need read access thru the iusr_machineName account to that location. Here's some minimum code and
<%
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "TCMS"
Dim RS
Set RS = Conn.Execute("SELECT key, caseno FROM Transact") %>
<% Do While Not RS.EOF %>
<% = RS("Key") %>
<% = RS("caseno") %>
<%
RS.MoveNext
Loop %>
And here's the result......by the way Key is an integer, caseno is char 15
150622 97-12345
150624 97-12345
Stick with it. The initial config can be quite messy....at least it was for us. But it is really quite easy to use once your up.
Hope this helps!
Brent
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only