Viewing 15 posts - 61 through 75 (of 337 total)
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...
March 28, 2011 at 6:53 am
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...
March 4, 2011 at 6:20 am
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...
January 27, 2011 at 1:18 pm
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...
January 26, 2011 at 6:29 am
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...
January 25, 2011 at 5:54 pm
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...
January 25, 2011 at 2:24 pm
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:...
January 25, 2011 at 6:14 am
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...
January 24, 2011 at 9:42 pm
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....
January 24, 2011 at 11:37 am
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...
January 7, 2011 at 7:24 am
Ninja's_RGR'us (1/7/2011)
Also it might be worth it to convert that column to an integer or decimal. Then keep...
January 7, 2011 at 7:17 am
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.
January 7, 2011 at 7:13 am
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...
October 15, 2010 at 7:40 am
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...
September 28, 2010 at 7:08 am
_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.
July 15, 2010 at 7:25 am
Viewing 15 posts - 61 through 75 (of 337 total)