Database

Richard Deeming wrote: That sounds very similar to Entity Framework Code First Migrations Maybe they got it from me? :laugh: I've been using this approach since about Y2K. :) You do have some good points regarding principle of least privilege, and I wholeheartedly agree with that philosophy/architecture for some applications...most of the ones I deal with demand simplicity and the ability for an end user to install a module without help from IT, hence dbo. :) "Go forth into the source" - Neal Morse

Ok Got it my friend thank you, I put an another sql task that just updates that Column value, so I think we are good now my friend. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

First crate a query that selects the link records (t_cars_feature) you expect to see. Select * from t_cars_feature where (FeatureID = 1 and value = 'CMC') and (FeatureID = 2 and value in (3,5)) ... Then change the query to only get the CarID Select CarID from t_cars_feature where (FeatureID = 1 and value = 'CMC') and (FeatureID = 2 and value in (3,5)) ... Once you are happy with the results wrap the first query to select the cars Select * from Cars where CarID in (insert query 1) What you are missing is the heavy use of brackets. It is still an ugly database design. Never underestimate the power of human stupidity RAH

indian143 wrote: with Admin rights Ace drivers are also Working, So rephrasing to make it very clear what the problem is. 1. When you run the application ON the target machine with admin privileges it both drivers work. 2. When you run the application ON the target machine with non-admin privileges, doing exactly the same as above for 1, then only one driver works. The other fails. If so your problem is with the non-admin user and/or the access rights for the driver that does not work.

Databases, these days, have their own GUID process. I figure there is very likely optimizations in the database based on that specific data type. Something an external value as text isn't going to have. So it means the attributes of the native type are what I end up with.

See sql - Retrieve column names and types of a stored procedure? - Stack Overflow[^], first answer. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Here's another post on the same issue: OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error". – Tips and tricks from a Developer Support perspective.[^] It definitely sounds like a permissions issue on the "temp" directory used by the SQL service account. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

indian143 wrote: is there anything that I can do to eliminate those " and implement Data conversion without any problems Based on the following - no. Connect to a Flat File Data Source (SQL Server Import and Export Wizard) | Microsoft Docs[^] You might want to review the actual input spec yourself in the hope the docs are wrong. Presuming there is no option, and you cannot get the source adjusted, then you must 1. Take all of the values as strings 2. Add a post process step to convert to correct values (remove quotes and convert to numeric as needed.)

Did you get any success with your project??? I'm developing a c# application to pull out data from the Alerton Envision Bactalk system, but there is no much information how to establish a connection between my interface and Alerton database, any help will be very appreciate.

--- Solution 1 Use a Virtual Machine (VM). One OS in VM 'A' would have one version and the other VM would have the other. If you actually need both on a single machine in the delivery (production) then you could. 1. Create a service that encapsulates one service and exposes one, not both of the drivers. Call this driver 'A' 2. It doesn't do anything but allow you to run the driver. 3. Run that in a VM 4. On the regular machine (not VM) install the other driver 'B', then you app uses 'B' directly and makes rest calls to the service, via the VM, to run 'A'. --- Solution 1 This might or might not work. And it would take a lot of experimentation. And you MUST check the license agreement to validate this usage. 1. Neither driver should be installed. 2. Install one driver, probably 32 bit one 3. Determine exactly what files were installed. 4. Copy those files somewhere. 5. Uninstall the driver. 6. Install the other driver. 7. Create a library that encapsulates the first driver in the executable itself. So not as an installed driver but rather as a library. Your library exposes the functionality you need. 8. Use your library to get to the first driver and the regular idiom to get to the second. Note that if you can get this to work then it might best to do it with both drivers rather than relying on different access methodologies.

As soon as I get the data from the database I move it into a model/object so I never work with the dataset/table object. In future I will move the datatable to a Json string on the server and let the client move it into a model/object. Never underestimate the power of human stupidity RAH

Hi, Thank you, I did implement it in my Application, I found that both 32 bit Jet 4.0 and 64 bit Ace 12.0 drivers are not registered on Production Server. But there are 32 bit and 64 bit Ace 14.0 drivers are there, then why Package is not able to execute? Are Ace 14.0 64 bit and Ace 12.0 64 bit drivers not compatible to each other? Another thing is, even though I have Ace 14.0 drivers on my local machine Data tools 2012 is taking Ace 12.0 64 bit drivers when I Create Data flow task using an xlsx file as data source? Why is it not taking Ace 14.0 drivers instead, I am creating the packages with Visual studio 2012 and .Net 4.0. Why is my Package taking Ace 12.0 drivers by default and expecting it to be registered on the Server. Is there any solution for me? Can anybody please suggest me, so any change I have to make should have solid ground because I am going to make that change on the Production server. Please help I need some guidance or a link anything. By the way I tried both the .xls and .xlsx files and run Package under both 32 bit and 64 bit modes in both cases its failing because 32 bit failing for Jet drivers not registered and 64 bit is failing because Ace 12.0 specifically not registered when Ace 14.0 is registered there. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

What you could do is stop crossposting[^]. Tips are here[^]. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

The steps to normalize a relational database-design are described on the Wikipedia. I'd recommend to normalize at least up to BCNF[^]. The wikipedia holds explanation on each rule, and why it is important. Start here[^]. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

notification_template 'notification' because it applies to email and sms. 'template' because although the are properties the group actual serves as a template for what the notification will be. Underscore to separate the two nouns. Should not be 'templates' plural because by definition a table is already a set. And there are cases where one wants a table to contain more than one row/record as a 'set'. In those cases the table might be better named with the plural.