Dave's Technophorical Times

A blog about Microsoft's Technologies!
SharePoint :: MVC :: ASP.NET :: IIS :: SQL Server :: Visual Studio :: MS Access
Nov
19

Run As Administrator

by Dave Stuart | Tags:

Everything you need to know about Run as Administrator: http://www.sevenforums.com/tutorials/11841-run-administrator.html

 



I came across a challenge this week. Migrating Blob data from Oracle to SQL Server. I used MS Access for this since I could create an ODBC DSN to each and then have the best of ALL worlds. That is review the data, count the records and write very simple code. The link below is excellent and worked perfectly for what I needed for dealing with the Blobs.  

How To Read and Write BLOBs Using GetChunk and AppendChunk: http://support.microsoft.com/default.aspx?scid=kb;en-us;194975

The process I used for the Blobs was this:
1. Copy the data from Oracle to SQL exluding the Blobs Column.
2. Export the Blobs to File using the ID field as a key like (ID) & FileName. FileName was a column in my Oracle table so that was nice and pretty well needed so you can Identift the MIME (file type like XLS, DOC, PDF).
3. Finally Update the SQL Server table using File to Blob.

I had some other "things" in the code to deal with missing files from the Blob column but that was simple.
 



I had an issue of Web Sites NOT rendering in IE9 for a site that I have running locally in IIS. I could, however, render the page in IE9 on another machine and it worked just fine. My issue was just locally and ONLY when I used the local machine name. i.e. http://localhost WORKED! But http://MachineName DID NOT work. So to fix my issue I just addedhttp://MachineName to the Local Intranet Site list in IE9.

Tools -> Internet Options -> Security -> Local Intranet -> Sites. Then Addhttp://MachineName to the list. Uncheck the https checkbox if just adding http.

Then it all started working locally. I'm not sure why this is as I have other servers that work just fine. I have never come across this issue until now. Good news is that it works now, but I would like someone to explain why I had to do that in the first place.

BTW, this was on a Windows 2008 R2 after installing SQL Server 2012 Reporting Services and SharePoint 2010 Enterprise.

Hope this helps someone!

Dave.



Jan
11

About Me

by Dave Stuart | Tags:

Dave Stuart

Info about Me....The Blogger

So every blog needs this info...

I'm a Developer/BA with 15+ years in the IT industry. I have worked in the UK and Canada as an IT professional and have more years as a contractor than a full-time employee, which is just the way it has turned out. I currently reside in sunny, but frigid, Calgary and moved here from the UK in 2003.

My company Website is http://www.dafran.ca



I made up the word, Technophoric, because it sounded cool and I think anyone reading it will understand that its the opposite to Technophobia (someone who fears Technology).

This is my Second attempt at a Blog using BlogEngine! This time I'm hosting my own site (from the basement! erm home office!) using SQL Server 2008 for the datastore rather than XML files. I've come a long way in the last 12 months with regards to configuring my own data centre and Domain for my home office.

I hope to post some useful Comments on this blog over the course of it's life, which I hope is a long time. I will have some content starting this week sometime.

Happy Blogging
Dave Stuart



The Blogger

Dave Stuart I'm a Developer with a passion for coding. I enjoy the challengers that come with the job! SharePoint is one of my expert areas along with .NET Web Development with MVC and good old MS Access VBA coding. I Blog so that I can remember how I did that way back when; PLUS all this stuff is searchable! I constantly study and run my own business, Dafran Inc. I have passed 22 Microsoft Exams since 1998 when I first jumped on the treadmill of knowledge. I hope that you enjoy this Blog as much as I enjoy updating it. All the very best from Calgary, Alberta, Canada. contact me at linkedin @ dafran.ca

Calendar

<<  September 2017  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

View posts in large calendar

Sign in