|
I setup the my WCF service on server machine. The server OS is win 2008 with SQL 2008 express.
I trying to access to my SQL file ( mdf file ) to read data using LINQ to SQL. I see that the DataContext is OK - but when i try to get information that in one of the table i get an exception
"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."
I dont know what i need to define or change in the IIS 7.5 that im using in the server side.
|
|
|
|
|
|
Anyone has managed to use the latest System.Data.SQLite?
The original site http://sqlite.phxsoftware.com/[^]
now redirects to a new site.
The trouble is that the new site is very austere, it describes itself as Fossil, sadly this is a well chosen name.
There is no setup file to download like before, only source.
Building is more complicated that it looks and the documentation is at best hard to follow.
I am starting to wonder now whether it is a good think or not that the project went open source.
Puzzled.
|
|
|
|
|
|
Indeed, this is probably a transition issue.
In the meantime it is frustrating for users that can't, don't have the time or simply don't know how to compile C++.
I was sort of hoping by posting here to find someone that had done it already.
I thought the other site was complete other implementation.
You're right I could go for it, the risk in all of this would be to go for a project that won't be maintained in the future.
Do you think this project is better?
|
|
|
|
|
I'm sorry to say but I haven't used SQLite for ages so my current knowledge is mainly out-of-date. But I guess that if you design the db interface well, changing the library afterwards won't be so big issue. Most likely this means that you would create different kind of wrappers for db operations, such as a common method for executing a command or querying the db etc. This way you won't have so many places to change if the library is changed.
|
|
|
|
|
I have had to give up on the broken official version and I have my own version here:
https://github.com/PaulS/SQLiteDotNetProvider
It has most of the code changes from the official version, but will still build. (There are almost no changes.) Their version has missing files, and won't build an install. It's really about the same as 1.0.66, but compiles with sqlite 3.7.5.
When the official version is working again I would probably go with that.
|
|
|
|
|
Hey friends,
I have serveral usergroups in AD and I want each group to have read / write acces to one or more databases in SQL Server. I know how to set the privileges so that each database is accessable by the correct usergroup and not for all other groups, but I don't know how to set permissions required to query SQL Server which databases are accessable for the user currently logged on.
I'm using integrated security.
Anyone?
|
|
|
|
|
Eduard Keilholz wrote: I'm using integrated security.
IMHO that is where you are going wrong. AD is both too much and too little to meet application security.
We maintain our own user authorisation, especially as we have a 2 day turn around on AD changes. How do you test each group functionality, use different logins for each group 
Users are authenticated via AD and then are given a profile that includes a list of apps they have access to and the functionality they have within the app.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
when connected to SQL Server, executing sp_helpdb[^] without any parameters lists all the databases available to the login.
Best regards,
mika
|
|
|
|
|
|
IMHO they are aimed at 2 different markets, SQL Server works best with smaller environments (non enterprise) while Orable is excellent for truly meaty data with dedicated DBA and hardware support infrastructure.
I am a huge proponent of SQL Server b/c I work mostly with departmental data and limited support infrastructure. Orable requires a LOT more infrastructure support than SQL Server. I know of no small scale developers/departments that use Orable by choice.
As for security, both have more security than I currently need so the finer points at the extreme are moot.
Orable is by far the quickest and out performs SQL Server, this anecdotal as I am currently using both with the same data in both systems.
As with most MS stuff the UI for SQL SErver is dramatically better than Orable - you really need to go to 3rd party tools (TOAD) for Orable and TOAD is a very complex beastie.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I'll second what Mycroft said. And I'll add that the operating system and other infrastructure contributes to security. I've only used Oracle on OpenVMS systems with no Internet connectivity -- you can't get much more secure than that.
On the other hand, Oracle tends to be much more expensive than SQL Server, and Sql Server has a lot of nifty features.
Basically, pick either one, not any of the others. And certainly not Cache .
|
|
|
|
|
PIEBALDconsult wrote: And certainly not Cache .
Cache has a great advantage over both SQL Server and Oracle: you can still write your programs with MUMPS, an advanced programming language with included database. And forget those relational tables, use hierarchical globals instead.
|
|
|
|
|
It has the unacceptable disadvantage of not being SQL92 compliant... otherwise it's just fine. 
|
|
|
|
|
There are lots of Difference are there..
Oracle support varchar2, Sqlserver dont
Oracle support dual , Sqlserver Dont
Oracle Support P/L Sql where as Sqlserver Support TSQL
And many more.. These are the main difference.
|
|
|
|
|
Timothy CIAN wrote: how does the performance compare, generally speaking?
In my experience that all depends on the DBA, some DBAs are good and can make anything sing, others not so much.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
Current we have a database that has two tables "order status" and "lead_free_certs". For each record in "order status" there may be 0 to many records in the "lead_free_certs" table. I'm trying to load a specific record from "order status" and if there is a matching record in "lead_free_certs" (based on project number), the most recent record in "lead_free_certs" based on the certificate number. I'm using VS2008 and I'm connecting to 2005 SQL Server. The SQL statement I have is:
SELECT * FROM [Order Status] LEFT JOIN Lead_Free_Certs ON [Order Status].[Project #] = Lead_Free_Certs.[Project Num] WHERE ([Order Status].[Project #] = " & projectnumber & ") ORDER BY Lead_Free_Certs.[Cert Num] DESC
The "projectnumber" variable is passed as an argument to the function. When I run this command no rows are returned. However if I want to load records only from the "order status" table then the following SQL statement works:
"SELECT * FROM [Order Status] WHERE [Project #] = " & projectnumber
So I know it is a problem with my LEFT JOIN statement. Any help would be greatly appreciated since this is the first time I'm trying to use JOIN statements.
|
|
|
|
|
Just a guess, but is it possible that the two columns of "Project #" and "Project Num" are different types and some implicit cast causes the JOIN to fail. 
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
Didn't think of that; yes they are different types. Project Num is nvarchar(255) and Project # is int. Would it be better to convert them to the same type or is there a way to do the conversion in the SQL statement. There might be a problem with the conversion because some of the records in Lead_Free_Certs table are not strictly numerical. Some of the numbers have hyphens or slashes in them.
|
|
|
|
|
Add an int column called Project # to the Lead_Free_Certs table and figure out how to populate it based upon the value from the Project Num column. But it sounds like you are trying to join two tables that were'nt to be joined together. 
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
The LEFT OUTER JOIN or simply LEFT JOIN return all rows from the first table listed after the FROM clause or left of JOIN keyword , no matter if they have matches in the right table of the JOIN keyword.
Syntax :
FROM table1
LEFT OUTER JOIN table2
ON table1.column_name=table2.column_name ;
Check here lot of examples : http://www.w3resource.com/sql/joins/perform-a-left-join.php
|
|
|
|
|
Okay I tried casting and it worked. The new statement that works is:
SELECT * FROM [Order Status] LEFT JOIN Lead_Free_Certs ON (CAST([Order Status].[Project #] AS nvarchar(255)) = Lead_Free_Certs.[Project Num]) WHERE ([Order Status].[Project #] = " & projectnumber & ") ORDER BY Lead_Free_Certs.[Cert Num] DESC
Thanks for the help!
|
|
|
|
|
You're welcome.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
Hi all.
I have a massive SSIS job that transfers data between databases. Each of these tables has a separate data flow task. When I change the connection string for the source database, SSIS wants to refresh the metadata, so I have to go into each task individually and refresh the metadata, which is pointless and time-consuming.
My question is... Is there any way I can do this more efficiently? Is there a select all/refresh metadata anywhere which I can use?
Thanks in advance for any help.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
