nonethefewer: (Default)
[personal profile] nonethefewer
Two useful geeky tools:

* ConnectionStrings.com

* Angry IP Scanner

In other news, can someone explain to me why it is that SSIS in SQL Server 2005 can't see MySQL, but DTS in SQL Server 2000 absolutely can?

(no subject)

Date: 2007-10-30 12:21 am (UTC)
macthud: (Default)
From: [personal profile] macthud
why it is that SSIS in SQL Server 2005 can't see MySQL, but DTS in SQL Server 2000 absolutely can

because this is how to torment you...

more seriously, well, SSIS does *many* things differently than DTS, mostly subtly so. OLE DB Provider settings are the most likely cause. Linked Server configuration next.

presuming both SSIS and DTS are running on the same PC, that is, so your MySQL permissions aren't coming into play (because MySQL uses the troika of UID, PWD, *and* client IP)...

hopefully that helps

February 2022

S M T W T F S
  12345
6789101112
13141516171819
20212223242526
2728     

Page Summary

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 25th, 2025 10:39 am
Powered by Dreamwidth Studios