Connection options from *nix to SQL Server 2000

Hi All,
There is a possibility that we may need to move our existing W2K servers and
our custom application over to *nix.
I am interested to know what are the options available to us if we stick
with SQL Server 2000 Enterprise as the database on a W2K or W2003 OS.
Is JDBC the way to go? Is there a better option? Likewise we currently use
ATL to access SQL from our application, would an alternative solution offer
the same level of performance and stability?
Any help would be very much appreciated.
Thanks in advance.
Phil
Phil:
I think you have to basic options for a Java app on UNIX to SQL Server
2000 -- stick w/ JDBC or use a ODBC driver for UNIX, like the one Data
Direct sells.
-shelby
Shelby Goerlitz
Microsoft SQL Server
"philwhite3" <philwhite3@.supanet.com> wrote in message
news:eFNVmSchEHA.3320@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> There is a possibility that we may need to move our existing W2K servers
and
> our custom application over to *nix.
> I am interested to know what are the options available to us if we stick
> with SQL Server 2000 Enterprise as the database on a W2K or W2003 OS.
> Is JDBC the way to go? Is there a better option? Likewise we currently use
> ATL to access SQL from our application, would an alternative solution
offer
> the same level of performance and stability?
> Any help would be very much appreciated.
> Thanks in advance.
> Phil
>

Connection manager validation within UI

Hi all,

I need to validate a custom connection manager within its custom user interface, like the FlatFileConnectionManager does it, by showing errors and warnings at the bottom of the window.

How can I do that since SSIS provides only a ConnectionManager object with the IDtsConnectionManagerUI::Initialize method, and this object doesn't contain any Validate method?

Note that for a custom data flow component, SSIS provides a ComponentMetaData object which supports a Validate method.

Thanks.

Pascal

The UI class is just the stub that allows SSIS to find your UI implementation. You need to add a form that displays controls for setting properties and such like. Within that form you can call the Validate method on your connection class, capture the messages and display them as you wish. There is a connection manager sample with UI in the updated samples available from the MS site, Downloads area. For more samples, look at a task, as this follows exactly the same pattern as for a connection. Components are quite a bit different.

|||I can't call the Validate method of my custom connection manager because SSIS doesn't give me my object but a ConnectionManager which is not a ConnectionManagerBase type...

Connection in transformation component

Hi,

I'm on writing a custom data flow component (transformation). For this I need access to an external datasource. As best practice, it seems that you should use a connectionmanager in the package.

But I don't really know how to access them.

I've overwritten the AquireConnections() to lookup in the RuntimeConnectionCollection for the connection managers. But It seems it doesnt get called. If I call it my own, for example in validate (just for debugging purposes) the collection is empty, although there are two connectionmanagers in the package.

What am I doing wrong or has someone a code snippet for me.

Thanks T.

To make the package connections available within the AcquireConnection or ReleaseConnection method, (make sure you use the latter to close any connection resources), you first have define the component as having one or more connections. You do this in the ProvideComponentProperties method, so just add it and give it a name, description if you feel like it.

IDTSRuntimeConnection90 runtimeConnection = ComponentMetaData.RuntimeConnectionCollection.New();

runtimeConnection.Name = "Reference Data";

This acts as a placeholder, so that if you were to now look at the built-in Advanced UI Editor, on the first page you will see the connection listed, ready for you to choose one of the existing package connections.

Connection Error

Hi all
When i try to access sqlserver from a custom developed assembnly i get the
following error
"
Request for the permission of type
System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
"
can any one please suggest me how to go about this
Thanks
Srujan.NDid you configure a Code Access Security group for your assembly?
Search the newsgroup and you'll find several posts on custom assembly
and Code Access Security.
Andy Potter

Connection designer in RS 2005?

I have upgraded our Custom Data Extension from SQL 2000 Reporting Services
to 2005. I see that the Report Wizard will now launch my Query Designer for
editing command strings (thank you!) but I still can not see a way to get RS
to launch my "Connection Designer" dialog. When running Report Wizard or
Add New Data Source dialog, the "Edit" button becomes greyed out when I
change the Data Source Type to my Provider. How can I plug my Connection
String editor user interface at this point?
Thanks!Hello Stephen,
This is a quick note that I am consulting in the internal discussion group
to discuss this issue. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Any update on this issue?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:an29mv$yGHA.3392@.TK2MSFTNGXA01.phx.gbl...
> Hello Stephen,
> This is a quick note that I am consulting in the internal discussion group
> to discuss this issue. I appreciate your patience.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>|||Hello Stephen,
Sorry Stephen, I did not get update from the discussion group, I am still
performing research now. Thank you for your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello Stephen,
How are you doing on this issue? I'm posting to inform you that we're still
focus on this issue, since Wei is absent due to some urgent issue, he'll
udpate you when he get any update from product team later.
Meanwhile, if you have any further questions or concerns, please feel free
to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||I look forward to the resolution of this importan issue. Thansk for staying
on top of it.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:ArAs09k1GHA.4464@.TK2MSFTNGXA01.phx.gbl...
> Hello Stephen,
> How are you doing on this issue? I'm posting to inform you that we're
> still
> focus on this issue, since Wei is absent due to some urgent issue, he'll
> udpate you when he get any update from product team later.
> Meanwhile, if you have any further questions or concerns, please feel free
> to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Stephen,
Unfortunately, I got the response from the product team that Report
Designer does not support customer-written connection string editors at
this time.
I also contact to them that whether this feature is under consideration. So
far, I do not get the feedback on this.
If I get any information, I will update you ASAP.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello,
From the feedback of product team, they will add this to their list of
potential considerations.
For now, if you have any concerns, please feel free to send your feedback
to product team:
http://connect.microsoft.com/SQLServer.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Connecting to Webservice from DTS

I created a custom DTS object that does its work by calling a
webservice. When you create the object in DTS, it lets you set the
user/pw you want to use to authenticate to the webservice. The problem
I am having is that once I authenticate to the webservice within DTS,
it always uses the same authentication when contacting the service.

So, for example, I drop a new instance of my object into a package. It
connects to the webservice as me. I set up the parameters of the task,
including telling it to connect as User="test". If I run it, my code
sets the credentials correctly on the webservice, but the webservice
still gets called as me.

If I exit out of SQL Server and go back in, and run it, it correctly
connects as User="test". But then if I try to edit the task, and give
my own user and password, it still always tries to connect as "test".

It seems whoever I initially connect to the webservice as, that is the
information that DTS will use for the entire session.

Is there any way to do what I want to do?

thanks"Backslider" <backslider@.mail.com> wrote in message
news:1108159058.882465.266100@.f14g2000cwb.googlegr oups.com...
> I created a custom DTS object that does its work by calling a
> webservice. When you create the object in DTS, it lets you set the
> user/pw you want to use to authenticate to the webservice. The problem
> I am having is that once I authenticate to the webservice within DTS,
> it always uses the same authentication when contacting the service.
> So, for example, I drop a new instance of my object into a package. It
> connects to the webservice as me. I set up the parameters of the task,
> including telling it to connect as User="test". If I run it, my code
> sets the credentials correctly on the webservice, but the webservice
> still gets called as me.
> If I exit out of SQL Server and go back in, and run it, it correctly
> connects as User="test". But then if I try to edit the task, and give
> my own user and password, it still always tries to connect as "test".
> It seems whoever I initially connect to the webservice as, that is the
> information that DTS will use for the entire session.
> Is there any way to do what I want to do?
> thanks

I have no idea - you might want to ask in microsoft.public.sqlserver.dts, to
see if someone there knows about DTS caching properties inappropriately.
Since you seem to be saying that your own custom task is not behaving
correctly, you'll probably have to give more details about exactly how
you've implemented it, to make it clear why you believe the problem lies
with DTS and not your task.

Simon