Connecting to SQL Server

[PM2000]

Hi -- I am doing a simple insert to a SQL server 2000 DB. I only have one text field and a submit button.

When I click on the submit button, the data does not get entered into the DB and the typical IE error screen comes up with the message "Internet Explorer returns an error on the address you just entered or clicked."

The connection that I have set up seems fine -- when I click to test it in Dreamweaver Ultradev, all the records in the table display properly in the test screen. Also, when I am in the ODBC screen - I test the DSN connection and it tests successfully. So, I must assume that the connection to the DB is fine.

Any ideas?

Thanks in advance,
Peter

 

[Cheech]

Are you testing the DSN locally, has it been set up on your remote server? The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[PM2000]

It's a local DSN. Eventually, I will be putting it on a remote server.

I was trying something else last night and it may be more of a SQL server/odbc issue. I had my DSN conifguration set to use windows authentication (I am on an XP machine) -- this seems to have allowed me to retrieve the recordset when I tested the connection, but I believe it does not allow me to add/update records to the database. Does that sound right?

I then tried to set up a DSN connection using strictly SQL Server authentication -- I used the 'sa' username, which is still the default on this SQL Server and I now get the error:

"Connection Failed, SQL State: 28000, SQL Server Error: 18452, [Microsoft][ODBC SQL Server Driver][SQLServer] Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection"

This I find strange because I know that the 'sa' username is valid and I have used it in a VB app I developed to access the SQL Server.

Do you think I am barking up the wrong tree or getting closer to the solution?

Thanks,
Peter

 

[Cheech]

Dunno mate I will have a word with out sql admin see if he can help The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[ScottNeth]

I had this problem a couple of times but it was because I forgot to set up a DNS for both development and production (only had a development DNS). The other thing - you're using SQL...you sure you're putting the ID and password in? I guess you'd have to to see data in the test. One last thing - make sure you're pushing your connections folder when you push the site. I think the DNS stuff is in there and I know I've forgotten to push the connections before and the site didn't know where to look. Scott Neth
Web Designer/Cyberpunk