Logon failed, Crystal Reports 9, VB6 , sql server, sqlncli

i'm trying to build a setup package for a legacy vb6 software. the software itself connects to a sql server via sqlncli (native client). i've packaged all the dependencies and deploy them to a new...

Using Semantic MediaWiki for tabular data

Am I completely off-track to think about using Semantic MediaWiki to store (and organise, report on, etc.) 'tabular' data such as financial transactions or weather readings that would usually live...

SQL mapping between multiple tables

This is a SQL design question. First, the setup. I have three tables: A, which is automatically populated based on a query against a linked server. The data in this table cannot be changed; B,...

Can I set ignore_dup_key on for a primary key?

I have a two-column primary key on a table. I have attempted to alter it to set the ignore_dup_key to on with this command: ALTER INDEX PK_mypk on MyTable SET (IGNORE_DUP_KEY = ON); But I get...

How to store a list in a column of a database table

So, per Mehrdad's answer to a related question, I get it that a "proper" database table column doesn't store a list. Rather, you should create another table that effectively holds the elements of...

Can an Option in a Select tag carry multiple values?

I got a select tag with some options in a HTML form: (the data will be collected and processed using PHP) Testing: <select name="Testing"> <option value="1"> One <option value="2"> Two ...

Database design - primary key naming conventions

I am interested to know what people think about (AND WHY) the following 3 different conventions for naming database table primary keys in MySQL? -Example 1- Table name: User, Primary key column...

When to Denormalize a Database Design

I know that normalization has been extensively discussed on Stack Overflow. I've read many of the previous discussions. I've got some additional questions though. I'm working on a legacy system...

ID Best Practices for Databases

I was wondering what the best practices were for building and storing IDs. A few years ago, a professor told me about the dangers of a poorly constructed ID system, using the Social Security...

Storing a List into Python Sqlite3

I am trying to scrape form field IDs using Beautiful Soup like this for link in BeautifulSoup(content, parseOnlyThese=SoupStrainer('input')): if link.has_key('id'): print link['id'] Lets us...

Soccer database design

I've a problem with my database design. I want to do an app to mantein a soccer league, so I have tables to record associations, teams, players, coachs and so on and now I have a problem with...

How many records can I store in 5 MB of PostgreSQL on Heroku?

I'm going to store records in a single table with 2 fields: id -> 4 characters password_hash -> 64 characters How many records like the one above will I be able to store in a 5mb PostgreSQL on...

PostgreSQL: Which Datatype should be used for Currency?

Seems like Money type is discouraged as described here My application needs to store currency, which datatype shall I be using? Numeric, Money or FLOAT?

Postgres constraint for unique datetime range

My table has two columns: startsAt endsAt Both hold date and time. I want to make following constraint: IF both columns are NOT NULL then range between startsAt and endsAt must not overlap with...

Laravel: how to get average on nested hasMany relationships (hasManyThrough)

I have three tables: products: id|name|description|slug|category_id|... reviews: id|product_id|review_text|name|email|... review_rows id|review_id|criteria|rating the review table stores...

Create a login application with local database in visual studio

Please I am really having trouble creating a simple login application in C#. I just want to create a login form and whenever I enter the username and password it checks from the database if it...

"polymorphism" for FOREIGN KEY constraints

There is this field in a table: room_id INT NOT NULL CONSTRAINT room_id_ref_room REFERENCES room I have three 2 tables for two kinds of rooms: standard_room and family_room How to do something...

How can I create categories with different options of it in mysql tables

I want to design a database in MySQL about categories with options for categories. Example : Script classified .. When you want to add ads into the "cars category" you must add some options for...

Unable to update EntityFramework models from MySQL database in Visual Studio 2015 RC

My organization upgraded from Visual Studio 2013 to Visual Studio 2015 RC a couple months ago, and we only just now attempted to update some of our existing "db-first" EntityFramework models from...

How is Cosmos DB data supposed to be structured

I am currently working with a team of developers that is implementing CosmosDB as a backend store, and I have some questions about how it is really supposed to be used. I get that the documents...

In RESTful API, Are Resources need to be directly in relation to domain models?

Consider I have a User resource on database and it contains a list of Addresses with in it. GET /users -> Returns list of users [ { "name":"Rick", "email":"[email protected], ...

Structuring database relationships for tracking different variations of app settings

An app I'm currently designing allows users to create custom competitive leagues (think of it kind of like fantasy sports) and each user can join different leagues and each league consists of...

Power BI - Filters on all pages no honored

Just starting with Power BI... Using Power BI with a DirectQuery connection to a SQL Server database. (I doubt SQL Server is relevant to the question, but if it is I'll add it to the tags. Just...

Design in jFrame form in netbeans not loading

the design part in netbeans jframe form is just loading, not allowing me to edit anything or create any new jFrame form. i tried to uninstall netbeans and reinstall it, but nothing changed. i...

Authenticating With Azure Directory and Fetch the Valid User Roles From Database

I have to design a application for an organization where Authentication need to be happen Using SSO with Azure Directory using spring boot. All the employee Information is stored in the AD. My...

Can´t save data into Firebase

I'm trying to save into my Firebase database but I unable to do it. Right after the app intitialize the serive is disconected, but the app don't crash. I able to switch between the pages, but...

How to reduce the gap/spacing between two bullet-point lines in Overleaf LaTeX?

In this image I have shown the bullet points in Overleaf LaTeX when I was creating my resume. How do I reduce the gap between these bullet point lines? My current code looks like...

Unable to resolve service for type Microsoft.EntityFrameworkCore.Diagnostics.IDiagnosticsLogger

I am having difficulties to scaffold an existing MySQL database using EF core. I have added the required dependencies as mentioned in the oracle doc: <PackageReference...

Acceptable way to get around a UNIQUE w NULL constraint?

I have a table as follows: I would like to add a UNIQUE KEY on (connection_id, parent_container_id, name). However, parent_container_id and connection_id are a disjoin union -- the record must...

Storing NULL vs not storing NULL in the following table design

This is a question about storing nulls (or not), and two answers that do a very good job answering the use of nulls...