Ok. Would I also remove that include file that I was getting the error with?
rrnml -> RE: ODBC error (6/14/2005 13:07:45)
Ok I need a little schooling from you. I have the form up and running. My question is how do I write it so the information entered on this form will post to a db on sql? Have I gone about it the wrong way?
rrnml -> RE: ODBC error (6/14/2005 14:02:39)
Nevermind. I searched your site and found the info about sending form info to a db. Thanks! I am getting NULLS for the Name, Division, and Dates, however. So if anyone has a suggestion about that, please let me know. Thanks again!
rrnml -> RE: ODBC error (6/15/2005 11:29:34)
Trying to pass some parameters from a form to an sql db. When I do, some of these parameters show up as NULLS in my sql table. Any ideas why? I would appreciate any help with this. Thanks.
Spooky -> RE: ODBC error (6/15/2005 17:05:27)
They may show up as nulls if you are using the wrong form names? Could you perhaps clarify with a new post and some code?
rrnml -> RE: ODBC error (6/15/2005 18:31:14)
Thanks for replying Spooky. I figured most of it out. The administrator the created the tables messed up on the lengths on a couple of the tables so they didn't match up. Also one table was screwy so I just created a new one and deleted the old one. The only thing I'm trying to fix now is the Date field. I have it's data type as char right now. I see the only options I have are datetime and smalldatetime. We are asking users to enter it in the form of yyyymmdd. Would either of those data types work? Or do I need to ask them to enter it in a different format? Thanks.
rrnml -> RE: ODBC error (6/20/2005 11:55:03)
Ok I have another question. I have a form that will submit entries to an SQL db. On that form I have a link that says... Click here if you want to update an existing entry. If clicked that takes you to another page where you can enter an auto number to retrieve an existing entry. My question is how do I direct that to retrieve the entry and bring up the original form with that existing data on it? Thanks
for this u have to do this, Click on Client Configuration ->change Network libraries from Named Pipes to TCP/IP, then click OK. I think thats's how that issue is resolved. Hope it helps.