Tekk News

Thursday, May 18, 2006

I need a vacation...

Well, apparently I have been working so much on this project that I am missing some of the most obvious things that would make you laugh. I spent nearly 3 days trying to understand why I was unable to programmatically create a stored procedure (SP) in an SQL database. Well, let me rephrase that, in the "proper" SQL database. I ended up creating the SP in the "master" database. I figured that maybe I needed to send a "USE ;" command as the first statement in the batch I was sending via ADO's ExecuteNonQuery() method. Only to realize that CREATE DATABASE has to be the first statement executed in a batch. Well after racking my brain for days, I realized my problem. I was missing the INITIAL CATALOG in my Connection String. The only reason I didn't supply it before was that immediately before the creation of my SP I created the DB itself, so adding in the catalog name of a non-existing DB would cause it to crash. Such a simple little thing and I slaved over it for three whole days...

posted at 8:48 PM by Tekk Guy | Permalink |

0 Comments:

About Me

Name: Tekk Guy
Country: United States




About Me: I'm that tech guy…you know the one. When things are broken, I fix them. When they don't make sense, I explain them. When nothing is getting done, I do it. When a void occurs, I fill it. When there is silence on the call, I state the necessary. I'm that guy in IT that is relied upon by the competent as the nth tier of support, overlooked by management, and despised by the slackers. An InfoTech professional, aficionado of all things technological. I've been getting my geek on full-time since 1993, and have worked with information technology in some capacity since 1997 including VB 4-6, ASP, .Net, SQL, Java, HTML, ColdFusion, VBS, JS, Crystal Reports, COGNOS and more. I've worked on global scale environments for Fortune 500 companies and as a software engineer for local government agencies. My expertise is in Visual Basic currently in the .Net flavor, and focuses on user applications. I am also currently active in the ASP.Net programming arena, specializing in DotNetNuke Module development, site creation, and administration. Stated simply, if you need to get information from a-to-z, I'm the guy you want to see.


See my complete profile

Archives

March 2006
April 2006
May 2006
September 2006
October 2006
January 2007
July 2009
August 2009
November 2009
February 2010
November 2010
April 2013

Recent Entries




Progamming Links

.Net Rocks!
GotDotNet




Get awesome blog templates like this one from BlogSkins.com