#connection string

Attach a storage account by using a Shared Access Signature (SAS) – Microsoft Azure Storage Explorer

A Shared Access Signature, or SAS, lets the admin of an Azure subscription grant temporary access to a storage account without having to provide Azure subscription credentials.

To illustrate this scenario, let’s say that UserA is an admin of an Azure subscription, and UserA wants to allow UserB to access a storage account for a limited time with certain permissions:

UserA generates a SAS…

The target principal name is incorrect. Cannot generate SSPI context

由於最近公司有Product go Live, 所以有很多時候有些urgent 的問題要解決

又不幸的。。。我的電腦剛剛安裝好。。還安裝了Visual Studio 2017. 當我嘗試執行公司的Project時。。出現了以下的錯誤信息。。 “The target principal name is incorrect. Cannot generate SSPI context”

起初還以為是Visual Studio或SQL Server版本問題。。 當我仔細看了這個Error message和 connection string 之後。。 便發現問題是來自 Connection string… 因為有了兩隻不同的Login方法 而我們的電腦在Server上沒有Login的Permission

原本的connection string

Connection String Romance Continued

Continuing from the latest blog post, I finally made some breakthrough in my knowledge. It is true that the best teacher is your own experience. (more…)

ASP Classic Connection String Romance

New job and brand new works is giving me new things to learn. Currently I am staying with ASP again! This time it is not ASP.net but ASP classic. (more…)

Cloud SQL - Connection refused

Finally, I’m in that phase that I would like to use a database (currently I read the data from a file). I choose the Cloud SQL, MySQL combination. I registered an instance and it automatically added my project to the access table. After I copied the example java code into my DAO. Here I’m. When I run the app then I always get the Connection Refused error message. I haven’t found the solution yet.

Based on the description, it should be enough that the application id is in the access table. I think it is enough, because the GAE instance is in the same infrastructure than the database in PROD. Therefore, the connection string in java should be like a localhost connection. And the example code also contains a ‘jdbc:mysql://localhost/database?user=root’ connections string. I think it is approved. So, no more action is necessary.

‘These must be located in the same region.’ The AppEngine instance and the SQL instance are in the same region.

Excel Geeking: Using VBA And ADO To Pull Data From SharePoint Lists

I’ve been developing a SharePoint team site for my area which will house all kinds of information about the process and tools that I and my team support. I’ve been tinkering with the team site now for about two weeks. I’ll say this about SharePoint: moving around it is definitely not intuitive, and you can build some unbelievably ugly sites if you don’t know what you’re doing. But once you get…

I devided Phonebook aplication in four parts:

Part 1: Creating simple database and adding connection string.

Part 2: Building an application - doing everything that's related with persons (list of persons, insert/edit/delete person and see persons phone numbers).

Part 3: Building an application - we'll do the same thing as in Part 2 but with phone numbers.

Part 4: Adding styles.

PART 1: creating simple database and adding connection string

For building this application I used Visual Studio 2013 and SQL Server Express 2012 with SQL Server Management Studio.

Goal is to have the list of persons with links to their phone numbers. You can edit/add/delete person or phone number. Each person can have several phone numbers.

In Visual Studio create Empty Web Application - Phonebook. Then in SQL Server Management Studio create new Database with two tables - Persons and PhoneNumbers. Add the primary and foreign keys and some data.

After creating and editing tables go to the Visual Studio/Sever explorer and add connection, also in this point you need to copy the connection string which you can find under Advanced Properties/DataSource.

Add connection string to Web.config.