Missing Subscriber tab in EM Replication Configure wizard

Hi All,
On a server I configured publication of a database and push subcriptions
successfully using Enterprise Manager. But later when I select the
"Configure Publishing, Subsribers and Distribution" option again by either
right clicking on Replication folder or Menu, I find Subscribers tab is
missing, I see only Distributor and Publishers tabs.
Can anyone please tell me what I am missing anything here?
Thanks a lot,
VM
The server is not configured as a publisher. Enable it as a publisher and
click apply and ok. Reopen this dialog.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"VM" <VM@.discussions.microsoft.com> wrote in message
news:8C3C9EA9-B273-4CA6-99BF-CA51B6E25294@.microsoft.com...
> Hi All,
> On a server I configured publication of a database and push subcriptions
> successfully using Enterprise Manager. But later when I select the
> "Configure Publishing, Subsribers and Distribution" option again by
> either
> right clicking on Replication folder or Menu, I find Subscribers tab is
> missing, I see only Distributor and Publishers tabs.
> Can anyone please tell me what I am missing anything here?
> Thanks a lot,
> VM

Missing ODBC drivers - please help!!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Might try http://www.datadirect.com/download/index.ssp here to download.

HTH

|||

Hi Satya

In the hope of NOT making things worse, I don't want to install third party stuff just yet. I will give it a go if no other advice is submitted. Thanks

Regan

|||Are there any recent chanages such as rollout of hotfix or service pack on this installation, as you say previously it used to be there.|||

It was definitely working on the 13Nov. That was the last time I did an import into a sql db.

Automatic updates has been running and yes there have been a few. Tried a system restore, but for some reason the wizard only goes back to the 20th. Not sure why THAT is.

Anyway, did a restore to the 20th and the problem ist still there. My question is HOW does the import wizard enumerate the list for the data source drop down box. I am leading towards the following strategy:

1. A XP repair attempt which I am assuming will restore everything to installation default, but still keep my program files ...I hope!?

2. If no luck there then a complete re-install. This is an absolute last resort as it will involve installing and setting up my development environment, all vpn access connections and everything else and will be a complete pain not to mention the 1 to 2 days downtime (which I REALLY can't afford).

Maybe using the data direct driver is still an option. but that still doesn't fix my machine.

So ANY help would be greatly appreciated.

Thanks

Regan

|||Appreciate your feedback in this case to understand the problem and workaround .

I believe it looks like some sort of MDAC tools mismatch causing this issue and relevant ODBC drivers .DLL might be missing, may try with DataDirect and they can be trusted as no issues it works me always.

I suggest you may try opening a case with MS PSS if this is causing a major downgrade to your production system, if not live with third party tool until you can get another machine to fix the problem.

Sorry, nothing much help but few options you might try out.

Good luck.|||

Did you ever get this fixed? I have a staff member that has the same problem and is running XP SP2 with no ODBC Drivers at all.

|||Have you referred to the link above to get the relevant drivers?

Missing ODBC Drivers - please help!!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Replied to one of similar posts in other section.

Missing ODBC drivers - please help!!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Might try http://www.datadirect.com/download/index.ssp here to download.

HTH

|||

Hi Satya

In the hope of NOT making things worse, I don't want to install third party stuff just yet. I will give it a go if no other advice is submitted. Thanks

Regan

|||Are there any recent chanages such as rollout of hotfix or service pack on this installation, as you say previously it used to be there.|||

It was definitely working on the 13Nov. That was the last time I did an import into a sql db.

Automatic updates has been running and yes there have been a few. Tried a system restore, but for some reason the wizard only goes back to the 20th. Not sure why THAT is.

Anyway, did a restore to the 20th and the problem ist still there. My question is HOW does the import wizard enumerate the list for the data source drop down box. I am leading towards the following strategy:

1. A XP repair attempt which I am assuming will restore everything to installation default, but still keep my program files ...I hope!?

2. If no luck there then a complete re-install. This is an absolute last resort as it will involve installing and setting up my development environment, all vpn access connections and everything else and will be a complete pain not to mention the 1 to 2 days downtime (which I REALLY can't afford).

Maybe using the data direct driver is still an option. but that still doesn't fix my machine.

So ANY help would be greatly appreciated.

Thanks

Regan

|||Appreciate your feedback in this case to understand the problem and workaround .

I believe it looks like some sort of MDAC tools mismatch causing this issue and relevant ODBC drivers .DLL might be missing, may try with DataDirect and they can be trusted as no issues it works me always.

I suggest you may try opening a case with MS PSS if this is causing a major downgrade to your production system, if not live with third party tool until you can get another machine to fix the problem.

Sorry, nothing much help but few options you might try out.

Good luck.|||

Did you ever get this fixed? I have a staff member that has the same problem and is running XP SP2 with no ODBC Drivers at all.

|||Have you referred to the link above to get the relevant drivers?

Missing ODBC drivers - please help!!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Might try http://www.datadirect.com/download/index.ssp here to download.

HTH

|||

Hi Satya

In the hope of NOT making things worse, I don't want to install third party stuff just yet. I will give it a go if no other advice is submitted. Thanks

Regan

|||Are there any recent chanages such as rollout of hotfix or service pack on this installation, as you say previously it used to be there.|||

It was definitely working on the 13Nov. That was the last time I did an import into a sql db.

Automatic updates has been running and yes there have been a few. Tried a system restore, but for some reason the wizard only goes back to the 20th. Not sure why THAT is.

Anyway, did a restore to the 20th and the problem ist still there. My question is HOW does the import wizard enumerate the list for the data source drop down box. I am leading towards the following strategy:

1. A XP repair attempt which I am assuming will restore everything to installation default, but still keep my program files ...I hope!?

2. If no luck there then a complete re-install. This is an absolute last resort as it will involve installing and setting up my development environment, all vpn access connections and everything else and will be a complete pain not to mention the 1 to 2 days downtime (which I REALLY can't afford).

Maybe using the data direct driver is still an option. but that still doesn't fix my machine.

So ANY help would be greatly appreciated.

Thanks

Regan

|||Appreciate your feedback in this case to understand the problem and workaround .

I believe it looks like some sort of MDAC tools mismatch causing this issue and relevant ODBC drivers .DLL might be missing, may try with DataDirect and they can be trusted as no issues it works me always.

I suggest you may try opening a case with MS PSS if this is causing a major downgrade to your production system, if not live with third party tool until you can get another machine to fix the problem.

Sorry, nothing much help but few options you might try out.

Good luck.

Missing ODBC drivers - please help!

Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

Might try http://www.datadirect.com/download/index.ssp here to download.

HTH

|||

Hi Satya

In the hope of NOT making things worse, I don't want to install third party stuff just yet. I will give it a go if no other advice is submitted. Thanks

Regan

|||Are there any recent chanages such as rollout of hotfix or service pack on this installation, as you say previously it used to be there.|||

It was definitely working on the 13Nov. That was the last time I did an import into a sql db.

Automatic updates has been running and yes there have been a few. Tried a system restore, but for some reason the wizard only goes back to the 20th. Not sure why THAT is.

Anyway, did a restore to the 20th and the problem ist still there. My question is HOW does the import wizard enumerate the list for the data source drop down box. I am leading towards the following strategy:

1. A XP repair attempt which I am assuming will restore everything to installation default, but still keep my program files ...I hope!?

2. If no luck there then a complete re-install. This is an absolute last resort as it will involve installing and setting up my development environment, all vpn access connections and everything else and will be a complete pain not to mention the 1 to 2 days downtime (which I REALLY can't afford).

Maybe using the data direct driver is still an option. but that still doesn't fix my machine.

So ANY help would be greatly appreciated.

Thanks

Regan

|||Appreciate your feedback in this case to understand the problem and workaround .

I believe it looks like some sort of MDAC tools mismatch causing this issue and relevant ODBC drivers .DLL might be missing, may try with DataDirect and they can be trusted as no issues it works me always.

I suggest you may try opening a case with MS PSS if this is causing a major downgrade to your production system, if not live with third party tool until you can get another machine to fix the problem.

Sorry, nothing much help but few options you might try out.

Good luck.

missing error message? "no description found"

Anyone know what causes this?

When trying to deploy a package using the deploy wizard, following error is received:

===================================

Could not save the package "H:\SSIS\RSlog\RSExecutionLog_Update\bin\Deployment\RSExecutionLog_Update.dtsx" to SQL Server "xxxxxxxxxxx\xxxxxxxxxx". (Package Installation Wizard)

===================================

No description found


Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)the server in question does not have ssis installed

thanks for the useful error message .....