Write to Table Failure

[JayKusch]

can anyone tell me what this error is caused by and if not, where i may go to look it up. seems like alott of folks are getting it, but i have found no explaination?

Thanks

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()).

Data Source = "TRENDS"

 

[Niv3k]

Silly question, do the users have the ability to write to the database?

 

[JayKusch]

yes, this error message is related to an ADD to a table in our Trends DB. our front end is a Cold Fusion app/screen that they enter their data into and then submit.

Thanks

 

[Niv3k]

I don't know if this will help, but alot of times, it seems our DNS is screwed up, and in the DSN, I have to specify the server's IP address, for example, insteard of saying 1Peter, I have to put 170.36.233.35

The only other thing I could think of is if they have INSERT permission on the SQL server, maybe there is some CF protection against db inserts?