Search results

That's awesome, that might help me troubleshoot to see if that is what's going on. So how does the checking of the number work? If the current record + 1 equals the users record + 1?

I'm working with an Access program and a portal site that both make updates in an SQL database. If a user in the Access program is changing records in a table, and someone submits a record on the site, the site update will go through and reset whatever changes the user was making in the Access...

I believe it was a problem with the connection trying to open again and it already being open? I changed the source of the page to a view in the SQL Server and it works, but now my checkboxes that I have on the data grid are disabled. Trying to work that out now.

Haven't tried that but I know the network guys have opened the ports necessary for them to communicate.

SQL 2012. I will double check but I'm pretty sure I checked the other day and it was enabled.

Not sure if this will help but here is a link to the error page I receive. http://i.imgur.com/fXsp9.png

Changed the format and added providerName, still get the error.

Join the club! I think we've tried to put in the server name and it didn't work. I will try that again.

We are indeed using AD.

What is AD? Yes, I responded a few posts ago that I had created an ODBC connection without a problem.

I just found that thread as well. I checked and the web server user has that enabled.

I just looked up some stuff on that part, but no one ever mentions which user this needs to be set as. The user on the Web Server or the one on the SQL Server? Do you know? EDIT: I just checked and it is set for the user on the web server. I'm at a complete loss here as to why the site...

Do you know what they mean by that last part? Login as a Service permissions?

Looks like we're running V7.

When testing the ODBC, I did use the credentials I'm using for the site. We have IIS installed on the server and it's being run from that. I click browse to test it. That last part about the internet guest, can you expand on that? I've never heard that before. What would that entail for...

Just created a manual ODBC connection and connected to the server no problem. Tested Data Source and it took like a split second to confirm.

How do I go about setting up a manual ODBC connection? Also, I remote into the SQL and Web servers from my laptop. I will check the authentication. I'm not sure on that. I know when I open the SQL Server Management Studio it defaults to Windows Authentication. EDIT: It is set up for mixed...

After checking the last two checks from that article I still get the same error.

I just checked on the Server Browser, on my laptop (where the site works) it is not on either. I will turn it on and check.

Yes, I believe that my co worker who is more on the SQL side of things has verified that all that is enabled/running and what not. The only thing I haven't seen is the last step about sqlbrowser.exe creating an exception for the Firewall. I will investigate this now.