runaldo,

Thanks for the reply.

I'm a little confused as to why each user is created with those rights yet they aren't mapped to any database. I also can't login to...

Thanks for the replies.

I was looking in the SQL Server Configuration manager where you can't enable that service so I wasn't sure. I did enable it through Windows Services though.

I've...

MM,

I was able to get the DSN to work with our application locally and remotely. We prompt the user for their username/password and use that to login. It works well...

MM,

Again thanks for the reply.

The application already has one DSN-less connection string that connects to our DB for doing other stuff. That connection string has the username and password supplied...

I've tested the DSN with various settings.

The DSNs use:

SQL Server Driver

For the server I've used Public or Internal IP addresses and FQDNs depending if I'm local or not. All...

I downloaded the Native Client 10.0 and used it but no luck.

I can't connect to our DB using a DSN within our application unless we're on the same...

SQL Server is the only driver available. I see I can download the Native Client and it does work with SQL 7.0, 2000 and 2005... at least this version does:...

mister.magoo,

Thanks for the reply.

If you mean what protocol (provider) I'm using... I am using TCP/IP unless you're referring to ODBC which we are using. Not sure if I'm understanding you...

Rachel,

Did you ever find a solution to this problem? I have an application that uses a User DSN to connect to a remote DB and we get the same error....

yeah It's not clean b/c when I try to do some calculations on it it fails after I try converting it to a decimal or int. I have a function...

Ninja's_RGR'us (1/7/2011)

---

UDPATE T SET Weight1 = '0' from dbo.tTable1 WHERE Weight1 = ''

Also it might be worth it to convert that column to an integer or decimal. Then keep...

steveb,

Thanks for the reply. Well that explains it. My BOL doesn't say anything about that in the Replace String Function command explanation. Go figure.

DR and BCP has been a huge focus for us this year. We started this earlier in the year and our project is still not 100% complete. I think from...

Okay.. so I dug into the Books Online which was pretty useful.... but it doesn't suggest any "best practice" from what I can tell.

It appears RS has it's own...

_taz_

Also it's not always just about failover it's about failback too. Some products take a long time to failback to the primary server which isn't always acceptable.