Tag Info

New answers tagged

1

It isn't possible as SQL Server Native Client is a client library for SQL Server, not for MySQL. If you want to access a MySQL server through ODBC, then you need the MySQL ODBC driver (Connector/ODBC).


0

I was able to figure this out by just using multiple CTE's, then selecting what I needed to combine.


0

Based on what I understand of your goals, SQL Server 2014 Standard Edition may well support your needs for some time to come. Especially since you only anticipate a small handful of people using the server. Regarding hardware, I have no real basis for a comment since I know nothing about the anticipated load and amount of processing needed. So, shooting ...


0

Try using; Server: 127.0.0.1 Port: 27017 That should work.


0

The short answer is that we eventually literally pulled the plug on the SQL server and got away with it, (although I wouldn't necessarily recommend the approach). If you're in a situation like we were with this though, here's the full scenario: We couldn't log onto the box at all, and all services dependant on the database were running very slowly. The OS ...


0

> We've tried everything we can think of. As stated in all the site guides for StackExchange you should include what you have tried already in your question. Also include the results of what you tried - i.e. any error messages that resulted. Otherwise we are probably missing vital clues that would help us help you, and we may waste time suggesting things ...


1

I am a SQL Server DBA - I am biased towards SQL Server. However if the budget is limited, I would suggest trying a mature open source database, perhaps MySQL, PostGreSQL or MariaDB. Performance isn't your real issue here. The security of your data and the safety of strong ACID transactions are what you should really prioritise. How are you going to backup ...


1

SQL Server Compact is mostly used for building standalone and occasionally connected applications for mobile devices, desktops, and Web clients. There are lots of features not supported in SQL Server Compact check differences and with lack of these features hosting provider with exceptional bandwidth, up-time, etc will not help in terms of performance and ...


1

I have not used SQL Server Compact, but because of its design, there are warnings in the SQL Server 2012 documentation about concurrency issues. See: http://technet.microsoft.com/en-us/library/ms171845(v=sql.110).aspx for warnings on: Lost updates. Inconsistent analysis (nonrepeatable reads). Phantom reads. If you need a free and much more functional ...


0

Your code does not reveal any specific issue. I would say that the problem lies on the database server: your query may be blocked due to some on-going operation happening on the server, or the query is taking too much time for some other reasons. Without knowing which is the state of the server and which queries are running at the same time (or other ...


1

There is no other way to enable service broker except taking that database out of AlwaysON Availability group, enabling service broker and then joining it back. If you know that your source database has service broker enabled, then when you restore the database, use RESTORE .. with ENABLE_BROKER, so that you dont have to go with such trouble again. If you ...



Top 50 recent answers are included