named instance after install?

can I change my SQL2k desktop server to a named instance after install?
--== Posted via mcse.ms - Unlimited-Uncensored-Secure Usenet News==-
--
http://www.mcse.ms The #1 Newsgroup Service in the World! 120,000+ New
sgroups
--= East and West-Coast Server Farms - Total Privacy via Encryption =--I believe that will require a new installation.
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"David J Rose" <david.rose@.newsgroup.reply.only.com> wrote in message
news:426662c7$1_2@.127.0.0.1...
> can I change my SQL2k desktop server to a named instance after install?|||Each instance is it's own installation, with own binaries and files. You nee
d
to do a full un-install and re-install.
Regards
Mike
"David J Rose" wrote:

> can I change my SQL2k desktop server to a named instance after install?
>
> --== Posted via mcse.ms - Unlimited-Uncensored-Secure Usenet News=
=--
> http://www.mcse.ms The #1 Newsgroup Service in the World! 120,000+ N
ewsgroups
> --= East and West-Coast Server Farms - Total Privacy via Encryption =--
-
>

Name and Description property of OLEDB Source components

I am adding two OLE DB Source components to my pipeline and giving them different names

(via the Sourcename variable) but like they are assuming default name and description i.e. OLE DB Source which is causing the following error message on opening the package that was generated.

The package contains two objects with the duplicate name of "component "OLE DB Source" (37)" and "component "OLE DB Source" (1)"

Here is how I am doing it, in the debugger the names in both instances seem to have set correctly based on the variable but when saved they are lost. What am I doing wrong here?

IDTSComponentMetaData90 source = dataFlowTask.ComponentMetaDataCollection.New();

source.Name = Sourcename;

source.ComponentClassID = "DTSAdapter.OleDbSource.1";

source.Description = Sourcename;

Thanks

Just figured it out. So if anyone else is running into this you need to be aware of the fact that the name you provide to the IDTSComponentMetaData90 is reinitialized after you get the design time instance of the component.

So the Name and other properties have to be assigned after the design time instance is created.

MySQL

Hello,
When I try to connect to my MySQL server (on my webserver) via my ODBC
connector, I receive a "general network error". Does anyone know what this
is or what is causing this so I can get around it?
Thanks,
Evan M.
evan AT radiologyonesource DOT com
Evan,
This is a Microsoft SQL Server group, you probably won't get a reply to
your MySQL question here. Try http://dev.mysql.com/support/
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Evan McCutchen wrote:
> Hello,
> When I try to connect to my MySQL server (on my webserver) via my ODBC
> connector, I receive a "general network error". Does anyone know what this
> is or what is causing this so I can get around it?
> Thanks,
> Evan M.
> evan AT radiologyonesource DOT com
>
|||Mark,
Thanks for the direction! It helped alot!!
Evan McCutchen
Evan AT radiologyonesource. DOT com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u6FYV57UEHA.2320@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Evan,
> This is a Microsoft SQL Server group, you probably won't get a reply to
> your MySQL question here. Try http://dev.mysql.com/support/
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Evan McCutchen wrote:
this[vbcol=seagreen]

MySQL

Hello,
When I try to connect to my mysql server (on my webserver) via my ODBC
connector, I receive a "general network error". Does anyone know what this
is or what is causing this so I can get around it?
Thanks,
Evan M.
evan AT radiologyonesource DOT comEvan,
This is a Microsoft SQL Server group, you probably won't get a reply to
your mysql question here. Try http://dev.mysql.com/support/
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Evan McCutchen wrote:
> Hello,
> When I try to connect to my mysql server (on my webserver) via my ODBC
> connector, I receive a "general network error". Does anyone know what this
> is or what is causing this so I can get around it?
> Thanks,
> Evan M.
> evan AT radiologyonesource DOT com
>|||Mark,
Thanks for the direction! It helped alot!!
Evan McCutchen
Evan AT radiologyonesource. DOT com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u6FYV57UEHA.2320@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Evan,
> This is a Microsoft SQL Server group, you probably won't get a reply to
> your mysql question here. Try http://dev.mysql.com/support/
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Evan McCutchen wrote:
this[vbcol=seagreen]

MySQL

Hello,
When I try to connect to my MySQL server (on my webserver) via my ODBC
connector, I receive a "general network error". Does anyone know what this
is or what is causing this so I can get around it?
Thanks,
Evan M.
evan AT radiologyonesource DOT comEvan,
This is a Microsoft SQL Server group, you probably won't get a reply to
your MySQL question here. Try http://dev.mysql.com/support/
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Evan McCutchen wrote:
> Hello,
> When I try to connect to my MySQL server (on my webserver) via my ODBC
> connector, I receive a "general network error". Does anyone know what this
> is or what is causing this so I can get around it?
> Thanks,
> Evan M.
> evan AT radiologyonesource DOT com
>|||Mark,
Thanks for the direction! It helped alot!! :)
Evan McCutchen
Evan AT radiologyonesource. DOT com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u6FYV57UEHA.2320@.TK2MSFTNGP10.phx.gbl...
> Evan,
> This is a Microsoft SQL Server group, you probably won't get a reply to
> your MySQL question here. Try http://dev.mysql.com/support/
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Evan McCutchen wrote:
> > Hello,
> >
> > When I try to connect to my MySQL server (on my webserver) via my ODBC
> > connector, I receive a "general network error". Does anyone know what
this
> > is or what is causing this so I can get around it?
> >
> > Thanks,
> > Evan M.
> > evan AT radiologyonesource DOT com
> >
> >

MySAP Business Suite ERROR: Table class INTTAB is not supported.

Hi there,

we collect data from SAP via the Data Provider for MySAP Business Suite.
Everything works fine for Standard objects like KNA1 etc. but if we try to read data from a custom table we get the following error:

Code Snippet

Fehler bei Get ZZEUSGRP_WA [SAP ZZEUSGRP_WA [1]]: Microsoft.Adapter.SAP.SAPManagedProviderException: Table class INTTAB is not supported.
bei Microsoft.Adapter.SAP.SAPSelectHandler.CheckResult(SAPTable returnTab)
bei Microsoft.Adapter.SAP.SAPSelectHandler.ExecuteSelect(SAPTable tabFields, SAPTable tabStruct_Tab....

The error message tells me not to use a specific table type. So far so good.
The question is: What would be the workaround? What should I tell the SAP team who cares for the data structures?

Thank you for your advice in advance
Fridtjof

OK, the reason for this problem is: The referenced SAP object is a view which is currently not supported by the connector.
(That doesn't really anser my question but nevertheless it is not a bug)

Fridtjof