ASP to SQL DB Troubleshooting

T

Tim

I have a Front Page 2003 ASP page that collects mail address information and
is supposed to pass data to a SQL server DB on our network. We are
authenticating in as a SQL user instead of network auth to the DB. I have
the System DNS setup correctly and passed the test connection to the SQL DB.
No error messages at all after ASP data submission but no data is written to
the DB? No errors on the ASP after form submission either? I wrote a small
VB program to be sure I could read/write to the DB (this worked). I have no
clue how to or what troubleshooting tools are available to help me to narrow
this down. Any ideas on how to proceed?
Sorry for the long post..Thanks in Advance
Tim
 
T

Tim

Got it! Had to manually change the SQL connection string to the db in the
Global ASA file. Don't understand why the string generated from the template
did not work or there was no connection error to the db..Maybee that is
supressed for security reasons.
 
Top