Error when trying to create "datasources"

Brand new at this !

I'm running VB 2005 express edition installed from full MS download which included the SQL2005 express server V9.00.1116

Have used the Video tutorial (video 8 & 9) to create a database and have followed instructiions faithfully

Problem.

From the Data / Add New Datasource menu everything proceeds ok - that is a "dataset.xsd" file is created but then I get an error message

" Could not get type information for .........myfilename dataset "

and so the process is not completed properly and a datasource is not created.

I'm unsure what the type information is and have been unsuccesful turning up anything from the help files or forum so hoping someone can maybe tell me whats happening and how to fix this.

Thanks

I also ran into this problem and got it solved by removing the connection strings in 'My Project - Settings'. I hope this also works for you.

Harmen.|||

Thanks for that idea

For the record had trouble removing strings however -

My problems have been solved by accident when I created a new windows user account and ran VB express from there. I believe the problem was to do with the connection address because my system name has an " & " in the name(stupid me when I set up Windows XP ) the ampersand maybe an illegal character in a path name.

Here's the full path i used

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\TB&MA\My Documents\Visual Studio 2005\Projects\MyDataBase\MyDataBase\Database1.mdf";Integrated Security=True;User Instance=True

I think this why running it from a new user account worked ok as the connection string would have new directory path name

Thanks again

sql

Error when trying to create "datasources"

Brand new at this !

I'm running VB 2005 express edition installed from full MS download which included the SQL2005 express server V9.00.1116

Have used the Video tutorial (video 8 & 9) to create a database and have followed instructiions faithfully

Problem.

From the Data / Add New Datasource menu everything proceeds ok - that is a "dataset.xsd" file is created but then I get an error message

" Could not get type information for .........myfilename dataset "

and so the process is not completed properly and a datasource is not created.

I'm unsure what the type information is and have been unsuccesful turning up anything from the help files or forum so hoping someone can maybe tell me whats happening and how to fix this.

Thanks

I also ran into this problem and got it solved by removing the connection strings in 'My Project - Settings'. I hope this also works for you.

Harmen.
|||

Thanks for that idea

For the record had trouble removing strings however -

My problems have been solved by accident when I created a new windows user account and ran VB express from there. I believe the problem was to do with the connection address because my system name has an " & " in the name(stupid me when I set up Windows XP ) the ampersand maybe an illegal character in a path name.

Here's the full path i used

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\TB&MA\My Documents\Visual Studio 2005\Projects\MyDataBase\MyDataBase\Database1.mdf";Integrated Security=True;User Instance=True

I think this why running it from a new user account worked ok as the connection string would have new directory path name

Thanks again

Error when executing a distributed query on a linked server

Hi,
It's a repost of an old thread with more information included
I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits. I've
been trying to link a sql server 2000 SP4 to this but I'm having some
troubles. When creating the linked server from the Sql Server Management
Studio/New Linked Server I choosed Server type to be "SQL Server" for the 2K
linked server. The linked server was created. Then I go to
Properties/Security and configure the linked server to be accesed as sa. But
when I run a distributed query like
Select * from linkedserver.database.dbo.table I get the error:
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 2
Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
server "sqlservhpold". A four-part name was supplied, but the provider does
not expose the necessary interfaces to use a catalog or schema.
I tested the link by using sp_testlinkedserver and it returns no failure.
I also created a linked server in the reverse. I mean let server A be the
Sql Server 2005 64 bits Enterprise, and server B be a Sql Server 2000
Standard. I'm in A making B as linked server and trying to make a
distributed query from A to B (Select * from B.database.dbo.table) and this
fails. I tryed in B create A as a linked server. Then I made a distributed
query from B to A (Select * from A.database.dbo.table) and it works as
expected.
The most frustrating is the message that error 7399 returns: "The provider
did not give any information about the error." I cn not find nothing about
such an error message...
Any hint is welcomed
Thanks in advance
SammySammyBar (sammybar@.gmail.com) writes:
> I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits.
> I've been trying to link a sql server 2000 SP4 to this but I'm having
> some troubles. When creating the linked server from the Sql Server
> Management Studio/New Linked Server I choosed Server type to be "SQL
> Server" for the 2K linked server. The linked server was created. Then I
> go to Properties/Security and configure the linked server to be accesed
> as sa. But when I run a distributed query like
> Select * from linkedserver.database.dbo.table I get the error:
> Msg 7399, Level 16, State 1, Line 2
> The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
> error. The provider did not give any information about the error.
> Msg 7312, Level 16, State 1, Line 2
> Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
> server "sqlservhpold". A four-part name was supplied, but the provider
> does not expose the necessary interfaces to use a catalog or schema.
Can you double check the SQL 2000 instance, by doing SELECT @.@.version?
I seem to recall that to run linked queries from SQL 2005 to SQL 2000,
the latter needs some catalog procedures that comes with SP4, or possbly
SP2.
Also the exact command you use to create the linked server could be of
interest.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error running the Distribution Wizard

I have a very strange error (included at the end of message) and it seems to indicate that I have not installed the SQL Server correctly - perhaps the wrong version. I have re-run the configuration a couple of times with no effect. I have not removed the server and re-installed yet. I have Here is my version info:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

TITLE: Microsoft SQL Server Management Studio

Could not start the wizard.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ConfigureDistWizard, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)You did not install replication support.|||When I run setup and attempt to change installed components the Microsoft SQL Server 2005 Setup dialog shows under Database Services the Replication option as already installed on the drive - I have uninstalled it and re-installed it with no effect. Are you talking about a different option that appears if I start from a fresh install? I am hesitating to uninstall SQL completely and re-install it as the database is being used and I would prefer to update it if possible.

Thanks for the answer.|||

Hi Brian,

If you check directory D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE, could you find configuredistwizard.dll? And is this directory in your PATH environment variables?

Peng

|||Hi Peng,

No I don't have configuredistwizard.dll in my P:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE directory, but I do have the CreatePubWizard.dll in there. That directory is in the path.

Brian
|||

It is very strange. What is your upgrade sequence? 2005 RTM->SP2 or 2005 RTM->SP1->SP2? Does your machine use AMD64 processor?

One way to help troubleshoot the problem is to search in files under directory C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files and look for ConfigureDistwizard.dll. See if there are any error messages.

Also post your question in the SQL setup forum. There might be some experts that can give you better advice.

Peng

|||Hi Peng,

I'm not sure about the installation sequence because I did not install it myself. I eventually uninstalled the SQL Server Database Engine completely and re-installed fully and now the wizard appears.

Thanks again,
Brian

Error running the Distribution Wizard

I have a very strange error (included at the end of message) and it seems to indicate that I have not installed the SQL Server correctly - perhaps the wrong version. I have re-run the configuration a couple of times with no effect. I have not removed the server and re-installed yet. I have Here is my version info:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

TITLE: Microsoft SQL Server Management Studio

Could not start the wizard.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ConfigureDistWizard, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

You did not install replication support.|||When I run setup and attempt to change installed components the Microsoft SQL Server 2005 Setup dialog shows under Database Services the Replication option as already installed on the drive - I have uninstalled it and re-installed it with no effect. Are you talking about a different option that appears if I start from a fresh install? I am hesitating to uninstall SQL completely and re-install it as the database is being used and I would prefer to update it if possible.

Thanks for the answer.
|||

Hi Brian,

If you check directory D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE, could you find configuredistwizard.dll? And is this directory in your PATH environment variables?

Peng

|||Hi Peng,

No I don't haveconfiguredistwizard.dll in my P:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE directory, but I do have the CreatePubWizard.dll in there. That directory is in the path.

Brian
|||

It is very strange. What is your upgrade sequence? 2005 RTM->SP2 or 2005 RTM->SP1->SP2? Does your machine use AMD64 processor?

One way to help troubleshoot the problem is to search in files under directory C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files and look for ConfigureDistwizard.dll. See if there are any error messages.

Also post your question in the SQL setup forum. There might be some experts that can give you better advice.

Peng

|||Hi Peng,

I'm not sure about the installation sequence because I did not install it myself. I eventually uninstalled the SQL Server Database Engine completely and re-installed fully and now the wizard appears.

Thanks again,
Brian