Sparkalyn.com

Comments (12)

An invalid schema or catalog was specified for the provider “MSDASQL” for linked server

Make sure “level zero only” is checked on the MSDASQL provider.
Now to the question!
SQL Server’s linked server feature lets you link to a remote server through an ODBC connection. Once the server is linked, you are supposed to be able to reference it using four-part notation like so:
SELECT * FROM linkedserver…tablename
If you’re like me that [...]

Rage and technology

This is an exercise in taking two different concepts and bringing them into togetherness and love. Please keep your divs inside the allotted browser window. No malformed code allowed, not even in the comment box. Today’s post is brought to you by the letters “ooooooooh” and the word “lovely”. Lets now commence with the sense [...]

Where in Hell did that space come from?

A few months ago I spent a long weekend cursing margins and padding and css layout and computers and also Google (*gasp*). The reason I was practicing my invective was about 12 pixels of innocent space that decided to take up residence between my header and my content. It was definently NOT supposed to be [...]

Im-Press-ive

Well. I switched to Wordpress. It’s a lovely bit of application and so far I’m happy with it. The infamous five minute install left me feeling excited and full of a newfound respect for server-side installs and open source code. 1 week, several hacks and hundreds of search results later…. the feeling isn’t as [...]

surprise inside

I like to think that I’m a very practical, level headed person. I’m not prone to swooning, fanatical adoration of anyone unless you count Michael Jackson late 80s and early 90s. (ok i admit… I still love him) But hell may have just experienced a cold front. You see I’ve developed a fascination for [...]