I only use MSSQL 7 with QARun. It can be difficult to setup however. These are the steps you need to take to set it up.
1. Create the DB in SQL 7.
2. Create an ODBC connection.
3. Create the DB in QARun's Database Maintence based on the odbc DNS that you created in step 2.
4. The owner is "DBO" and the User ID is "sa".
Let me know if you are still having a problem. It is worth the effect.
Thanks, I am not having any problems; I just wanted to know of someone (like you) that was using SQL Server. I am familiar with all aspects of SQL Server, but am curious about how QARun creates tables, manages connections etc..
Question: Have you ever had 2 or more QARun users in the same SQL Server database simultaneously? I may have up to 5.
I too am inyterested in changing over qarun dbs to sql. I am not sure what the benefits are in doing this. My first thought is that performance might be more solid. have a situation where my qarund.mdbs are getting to be quite large. This is slowing down performance (and in some cases causing scripts to stop running because thedatabase is so large). Would converting to SQL server (or another sql version help this?
<BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by Jack: I am familiar with all aspects of SQL Server, but am curious about how QARun creates tables, manages connections etc..
Question: Have you ever had 2 or more QARun users in the same SQL Server database simultaneously? I may have up to 5.<HR></BLOCKQUOTE>
QARun does not allow the RDMS to manage locking of records/scripts. All QARun users are NOT created as a database user. They are created in a QARun table. And locking of scripts is done in QARun NOT the database.
You should have no problem having 5 users on a DB. I have 4 and we haven't had any real problems.
"If your not part of the solution, there's good money to be made in prolonging the problem."