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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASP form error 0
linking to SQL Server db table 6
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
import txt file to SQL Server DB table using ASP file. . . 2
update table using asp 0
Visio 2019 crashes when attempting to open drawing. 0
Q.) Jet DB error: Multiple Users able to write to MS Access DBsimutaneously? 3
ASP/VBScript/Access SQL 0

Top