Hi,
The problem started because the client's hardware malfunctioned and he
needed to move things to a new computer. So, we installed SQL 2000 on the
new computer, ran the SP3 updates, and installed the specific initial
database using our installer.
After that, we restored the database to the data that they had backed up
a while ago. Everything looked good and they ran without full-text searches
for a while. They then decided that they were ready to do the full-text
index populations, so we ran a script designed to get that all squared away.
The problem apparently started when this script attempted to drop the
full-text indexes and relocate them in the appropriate place. I thought I
could work through this, but couldn't find appropriate information for quite
a while. Later, I decided to attempt a manual removal of the full-text
indexes from the sysfulltextindex (sp?) table. There were two rows, with
the first columns having the values of 5 and 6. I removed them, and tried
to clean things up. In that process, I disabled the full-text indexing, and
now it simply will not re-enable.
Reading this newsgroup, I noticed the existence of a script that could
possibly help by manually deleting the traces of the full-text catalogs.
My question is: What is the best next step?
1) Try to make use of the script I just mentioned.
2) Restore the database, copy in the previous full-text data files
to the appropriate directory, and then try to run our script that moves and
re-populates the catalogs?
3) Something else entirely?
Thanks for your help.
John
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.744 / Virus Database: 496 - Release Date: 8/24/2004
John,
I've emailed you charter account directly as resolving this type of a
situation is better handled via direct email. I don't publicly post these
scripts because they require SysAdmin permission level of access and modify
both Registry keys & values as well as SQL Server system tables.
Regards,
John
"John" <jsfishr@.charter.net> wrote in message
news:eMb$LO6jEHA.704@.TK2MSFTNGP09.phx.gbl...
> Hi,
> The problem started because the client's hardware malfunctioned and he
> needed to move things to a new computer. So, we installed SQL 2000 on the
> new computer, ran the SP3 updates, and installed the specific initial
> database using our installer.
> After that, we restored the database to the data that they had backed
up
> a while ago. Everything looked good and they ran without full-text
searches
> for a while. They then decided that they were ready to do the full-text
> index populations, so we ran a script designed to get that all squared
away.
> The problem apparently started when this script attempted to drop the
> full-text indexes and relocate them in the appropriate place. I thought I
> could work through this, but couldn't find appropriate information for
quite
> a while. Later, I decided to attempt a manual removal of the full-text
> indexes from the sysfulltextindex (sp?) table. There were two rows, with
> the first columns having the values of 5 and 6. I removed them, and
tried
> to clean things up. In that process, I disabled the full-text indexing,
and
> now it simply will not re-enable.
> Reading this newsgroup, I noticed the existence of a script that could
> possibly help by manually deleting the traces of the full-text catalogs.
> My question is: What is the best next step?
> 1) Try to make use of the script I just mentioned.
> 2) Restore the database, copy in the previous full-text data files
> to the appropriate directory, and then try to run our script that moves
and
> re-populates the catalogs?
> 3) Something else entirely?
> Thanks for your help.
> John
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.744 / Virus Database: 496 - Release Date: 8/24/2004
>
Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts
Tuesday, March 27, 2012
Advice on a good strategy
I have a general question and a specific question.
1.) I'm doing some reporting using the Crystal Reports software my company has installed; however, I see threads of people using all kinds of more powerful software (VB, C, etc) to work with Crystal (web development, etc). Crystal Reports is on a terminal server here, and my audience will use that software to view the reports. Am I then limited to the Crystal (or Basic) syntax found in the software, or can I somehow use something like Perl or C to do my programming? I'm not sure how all of this goes together.
2.) More specifically, I'm trying to build a parts list tree (parent/child). The database is organized such that it makes this correlation difficult. In one Table (Part Master), is a list of all unique parts. In another table is a list of all unique jobs (times we've made the parts) (Jobs) that would show the part being made (one part shown) (link to Part Master). In the third table (Materials), the Jobs are listed with all of the sub components used for the main part for that job. Here, I'd want to capture the sub-components, but then loop back through the original Part Master to capture THEIR subcomponets, and so on. There could be up to 5 levels of this.
Basically, I want a user to enter a top-level assembly number, then I want to show every part used for that assembly, all the way down. My problem is that I really need to loop through the original list of returned records (I think). If I find the first part, and the first level of sub-parts, I may have passed those records already, so I need to re-read the list. I attempted build an array of the entire list of parts and do the logic at the end, but there are 82,000 of them (limit is 1000 and I don't plan to do Case with 82 levels). I'm inclined to believe that Crystal Reports (v.10) does not support multi-dimensional arrays, making this even tricker.
Can someone help me on a strategy to attack this one?Well, first you probably need to realize, that even if they are using VB or C-whatever or anything else in conjunction with Crystal, that Crystal is still a data-analysis/reporting engine. All it does is spit out the data in whatever format you design the report to do so. You can connect directly to your database (I am guessing it is a relatively standard engine, although you don't mention it), and then use crystal to select certain sets of data, group that data, and summarize that data, no matter what the general GUI interface to your data is. So just use crystal, point it to your database through ODBC or OLEDB (or whichever method you want), and go. Now, how you allow your users to view those reports is another matter, you might put shortcuts on the desktop (if the full version of CR is accessible through the terminal server), or use or develop a CR viewer for them to open the reports in. For that, you would need another tool, such as VB or C-whatever.
It does sound as if you have several layers of one-to many relationships to account for in the description of your project. My presonal experience leads me to usually start for the smallest partion, and work up. If you want a jobs report, that will show the detail down to the smallest sub-part, you would probably know that you need to start from an AssembyID, display each individual part, and below each part, a list of sub-parts. So you would add each of those tables to your report and link them by their primary keys (I usually use a left join if there is any possibility of missing links, i.e., a sub-part entry that is not in the table, otherwise an inner join would be more efficient). Then group by jobid, partid, and sub-part id. Add all the fields you want for each job (be sure to keep the field boxes in the correct group).
Obviously, this is hugely simplified and requires a lot more, but that is a basic approach. More detail could be given, if you give me a list of tables and their relationships.
ScottJ
1.) I'm doing some reporting using the Crystal Reports software my company has installed; however, I see threads of people using all kinds of more powerful software (VB, C, etc) to work with Crystal (web development, etc). Crystal Reports is on a terminal server here, and my audience will use that software to view the reports. Am I then limited to the Crystal (or Basic) syntax found in the software, or can I somehow use something like Perl or C to do my programming? I'm not sure how all of this goes together.
2.) More specifically, I'm trying to build a parts list tree (parent/child). The database is organized such that it makes this correlation difficult. In one Table (Part Master), is a list of all unique parts. In another table is a list of all unique jobs (times we've made the parts) (Jobs) that would show the part being made (one part shown) (link to Part Master). In the third table (Materials), the Jobs are listed with all of the sub components used for the main part for that job. Here, I'd want to capture the sub-components, but then loop back through the original Part Master to capture THEIR subcomponets, and so on. There could be up to 5 levels of this.
Basically, I want a user to enter a top-level assembly number, then I want to show every part used for that assembly, all the way down. My problem is that I really need to loop through the original list of returned records (I think). If I find the first part, and the first level of sub-parts, I may have passed those records already, so I need to re-read the list. I attempted build an array of the entire list of parts and do the logic at the end, but there are 82,000 of them (limit is 1000 and I don't plan to do Case with 82 levels). I'm inclined to believe that Crystal Reports (v.10) does not support multi-dimensional arrays, making this even tricker.
Can someone help me on a strategy to attack this one?Well, first you probably need to realize, that even if they are using VB or C-whatever or anything else in conjunction with Crystal, that Crystal is still a data-analysis/reporting engine. All it does is spit out the data in whatever format you design the report to do so. You can connect directly to your database (I am guessing it is a relatively standard engine, although you don't mention it), and then use crystal to select certain sets of data, group that data, and summarize that data, no matter what the general GUI interface to your data is. So just use crystal, point it to your database through ODBC or OLEDB (or whichever method you want), and go. Now, how you allow your users to view those reports is another matter, you might put shortcuts on the desktop (if the full version of CR is accessible through the terminal server), or use or develop a CR viewer for them to open the reports in. For that, you would need another tool, such as VB or C-whatever.
It does sound as if you have several layers of one-to many relationships to account for in the description of your project. My presonal experience leads me to usually start for the smallest partion, and work up. If you want a jobs report, that will show the detail down to the smallest sub-part, you would probably know that you need to start from an AssembyID, display each individual part, and below each part, a list of sub-parts. So you would add each of those tables to your report and link them by their primary keys (I usually use a left join if there is any possibility of missing links, i.e., a sub-part entry that is not in the table, otherwise an inner join would be more efficient). Then group by jobid, partid, and sub-part id. Add all the fields you want for each job (be sure to keep the field boxes in the correct group).
Obviously, this is hugely simplified and requires a lot more, but that is a basic approach. More detail could be given, if you give me a list of tables and their relationships.
ScottJ
Thursday, March 22, 2012
Adventureworks version 631 error
I installed Sql Server 2005 Express Edition on an XP system thismorning and tried to attach Adventureworks, but got an error messagestating:
The database 'Adventureworks' cannot be opend because itis version 631. This server supports version 612 andearlier. A downgrade path is not supported.
Since both SqlServer 2005 Express Edition, Management Studio, and the Adventureworksdatabase have all be downloaded within the past three days, I amastonished that there is a compatibility issue. I have runAdventureworks on other systems without problems. Any suggestionson how to proceed?
Hi Moonshadow,
Where did you download that "Adventureworks" ?
Please make sure you are downloading the correct AdventureWorks database for SQL Server 2005. The CodePlex website contains two versions of the database, one for SQL Server 2008 and one for SQL Server 2005. If you are viewing the AdventureWorks database download release for SQL Server 2008 you must click "SQL Server 2005 SP2a" in the Releases box on the right hand side. You can also use the following link to download the SQL Server 2005 version directly at:http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004.
Detailed information, see:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1966875&SiteID=1
thanks
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
|||Hi B.C. When I originally searched for the DB I was redirected tothe Codeplex site where the current default download version is for SqlServer 2008, hence version incompatibility. I tracked down andinstalled the 2005 version at Codeplex and all is well.
AdventureWorks Samples Not working
I've installed and deployed the AdventureWorks Sample reports to Report
Manager in RS 2005. When I click on any of the reports, the report just
spins away and never returns the report information. I eventually (10
minutes later) just stop the browser. I made sure I have permissions to all
the data sources as well. Has anyone else had this problem or know where I
can look to see where the report(s) are hanging?
System Information:
Windows XP Pro
IIS 5.x
SQL Server 2005 Std.
VS 2005 Pro
Reporting Services 2005Verify that the dataset(s) in a report are actually working.
"Michael" wrote:
> I've installed and deployed the AdventureWorks Sample reports to Report
> Manager in RS 2005. When I click on any of the reports, the report just
> spins away and never returns the report information. I eventually (10
> minutes later) just stop the browser. I made sure I have permissions to all
> the data sources as well. Has anyone else had this problem or know where I
> can look to see where the report(s) are hanging?
> System Information:
> Windows XP Pro
> IIS 5.x
> SQL Server 2005 Std.
> VS 2005 Pro
> Reporting Services 2005
>|||I'm pretty sure the dataset is working since when I preview in VS2005 I can
get the sample to work with no problem. Strangely also, when I use VS2005 to
deploy and open the Samples folder, I can click on a sample report and it
works as expected. Only when I go to http://localhost/reports/home.aspx ->
AdventureWorks Samples -> Sample report does it just spin away.
"Bing Bing Yu" wrote:
> Verify that the dataset(s) in a report are actually working.
>
> "Michael" wrote:
> > I've installed and deployed the AdventureWorks Sample reports to Report
> > Manager in RS 2005. When I click on any of the reports, the report just
> > spins away and never returns the report information. I eventually (10
> > minutes later) just stop the browser. I made sure I have permissions to all
> > the data sources as well. Has anyone else had this problem or know where I
> > can look to see where the report(s) are hanging?
> >
> > System Information:
> > Windows XP Pro
> > IIS 5.x
> > SQL Server 2005 Std.
> > VS 2005 Pro
> > Reporting Services 2005
> >
> >
Manager in RS 2005. When I click on any of the reports, the report just
spins away and never returns the report information. I eventually (10
minutes later) just stop the browser. I made sure I have permissions to all
the data sources as well. Has anyone else had this problem or know where I
can look to see where the report(s) are hanging?
System Information:
Windows XP Pro
IIS 5.x
SQL Server 2005 Std.
VS 2005 Pro
Reporting Services 2005Verify that the dataset(s) in a report are actually working.
"Michael" wrote:
> I've installed and deployed the AdventureWorks Sample reports to Report
> Manager in RS 2005. When I click on any of the reports, the report just
> spins away and never returns the report information. I eventually (10
> minutes later) just stop the browser. I made sure I have permissions to all
> the data sources as well. Has anyone else had this problem or know where I
> can look to see where the report(s) are hanging?
> System Information:
> Windows XP Pro
> IIS 5.x
> SQL Server 2005 Std.
> VS 2005 Pro
> Reporting Services 2005
>|||I'm pretty sure the dataset is working since when I preview in VS2005 I can
get the sample to work with no problem. Strangely also, when I use VS2005 to
deploy and open the Samples folder, I can click on a sample report and it
works as expected. Only when I go to http://localhost/reports/home.aspx ->
AdventureWorks Samples -> Sample report does it just spin away.
"Bing Bing Yu" wrote:
> Verify that the dataset(s) in a report are actually working.
>
> "Michael" wrote:
> > I've installed and deployed the AdventureWorks Sample reports to Report
> > Manager in RS 2005. When I click on any of the reports, the report just
> > spins away and never returns the report information. I eventually (10
> > minutes later) just stop the browser. I made sure I have permissions to all
> > the data sources as well. Has anyone else had this problem or know where I
> > can look to see where the report(s) are hanging?
> >
> > System Information:
> > Windows XP Pro
> > IIS 5.x
> > SQL Server 2005 Std.
> > VS 2005 Pro
> > Reporting Services 2005
> >
> >
AdventureWorks Owner
Hi,
I've installed AdventureWorks, attached it to SQL Express and wanted to see its Database Diagrams. When I click on the Database Diagrams, I get this error message:
TITLE: Microsoft SQL Server Management Studio Express
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
--
I really see that in properties for this database there's no owner, while if I do
sp_helpdb 'AdventureWorks'
It shows that the owner is 'IDB-SERV\Michael' , which is my user.
I further tried to set this user as an owner in AdventureWorks properties-files window (where it showed no owner), but it says :
TITLE: Microsoft SQL Server Management Studio Express
Set owner failed for Database 'AdventureWorks'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Set+owner+Database&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred in SMO. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
The login 'IDB-SERV\Michael' does not exist on this server.
Are all these bugs, or did I miss something?
Please, help
Thanx a lot !!!!
Moisha, here are a few threads hitting the same error.http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112297&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=228352&SiteID=1
They both seem to be solving the problem using sp_dbcmptlevel.
Take a look at the threads and see if it applies to your environment.
Thanks,
Sam Lester (MSFT)
|||
Moisha,
The quick solution for me - which I distilled from the links posted here - was to execute the sp_dbcmptlevel procedure. I did not need to do anything else.
EXEC sp_dbcmptlevel 'nameOfDatabase', '90';
Sunshine is my life. Clean air is my right.
adventureworks installation
I downloaded and installed the .msi from codeplex. After installation I open SQL Server Management Studio but don't see AdventureWorksDB in the list of databases. How is this possible? Should I not be seeing this new database? Do I have to do something else?
From within the sql server studio, right click on the databases entry. The task you are looking for is "attach database".
Grab the .mdf file for the adventure works db. ( It may try to grab a .log file that is in the wrong directory, if so, delete the reference to it on the screen. It will create another log file in the same directory as the .mdf file.)
sqlAdventureWorks Install
I am using sqlserver 2005 express edition and have downloaded the
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
no tables appear under system tables. Is there something I am missing here?
No, it's normal in SQL Server 2005. System tables are hidden and you can't
see or modify them directly.
Regards
Pawel Potasinski
Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using sqlserver 2005 express edition and have downloaded the
> AdventureWorksDB.msi. I have installed it and it created 3 files:
> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
> AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
> no tables appear under system tables. Is there something I am missing
> here?
>
>
|||I have another DB (storeDB) on the server and I am able to see all the
tables under Databases > System Databases > storeDB > Tables > System
Tables, but I am unable to see the System Tables under AdventureWorks. I am
going through the tutorial and it's asking me to create the following query:
SELECT * FROM Production.Product;
GO
and I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Production.Product'.
I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
2005.
Any help would be appreciated.
Regards, Richard
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
> No, it's normal in SQL Server 2005. System tables are hidden and you can't
> see or modify them directly.
> --
> Regards
> Pawel Potasinski
>
> Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
[vbcol=seagreen]
> I have another DB (storeDB) on the server and I am able to see all the
> tables under Databases > System Databases > storeDB > Tables > System
> Tables, but I am unable to see the System Tables under AdventureWorks. I am
> going through the tutorial and it's asking me to create the following query:
> SELECT * FROM Production.Product;
> GO
> and I receive this error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Production.Product'.
> I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
> 2005.
> Any help would be appreciated.
> Regards, Richard
> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
Looks like a permissions issue. If you are just testing, make your account
you log in as a Server Role of Sysadmin (God-level rights).
Chuck Lathrope
www.sqlwebpedia.com
|||Thanks, I changed permissions, but I still can't see the tables. The strange
thing is that there are 3 files in the Data folder under the MSSQL folder
for AdventureWorks: AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~
164MB) and AdventureWorks_log.idf (~1MB). The other DB's on the server only
have 2 files (.mdf and .idf) for each database. There are no _Data.mdf
files.
Regards, Richard
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:rugaxfto4xox$.1xm17ldm6wy7j$.dlg@.40tude.net.. .
> On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
>
> Looks like a permissions issue. If you are just testing, make your account
> you log in as a Server Role of Sysadmin (God-level rights).
> Chuck Lathrope
> www.sqlwebpedia.com
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
no tables appear under system tables. Is there something I am missing here?
No, it's normal in SQL Server 2005. System tables are hidden and you can't
see or modify them directly.
Regards
Pawel Potasinski
Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using sqlserver 2005 express edition and have downloaded the
> AdventureWorksDB.msi. I have installed it and it created 3 files:
> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
> AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
> no tables appear under system tables. Is there something I am missing
> here?
>
>
|||I have another DB (storeDB) on the server and I am able to see all the
tables under Databases > System Databases > storeDB > Tables > System
Tables, but I am unable to see the System Tables under AdventureWorks. I am
going through the tutorial and it's asking me to create the following query:
SELECT * FROM Production.Product;
GO
and I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Production.Product'.
I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
2005.
Any help would be appreciated.
Regards, Richard
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
> No, it's normal in SQL Server 2005. System tables are hidden and you can't
> see or modify them directly.
> --
> Regards
> Pawel Potasinski
>
> Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
[vbcol=seagreen]
> I have another DB (storeDB) on the server and I am able to see all the
> tables under Databases > System Databases > storeDB > Tables > System
> Tables, but I am unable to see the System Tables under AdventureWorks. I am
> going through the tutorial and it's asking me to create the following query:
> SELECT * FROM Production.Product;
> GO
> and I receive this error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Production.Product'.
> I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
> 2005.
> Any help would be appreciated.
> Regards, Richard
> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
Looks like a permissions issue. If you are just testing, make your account
you log in as a Server Role of Sysadmin (God-level rights).
Chuck Lathrope
www.sqlwebpedia.com
|||Thanks, I changed permissions, but I still can't see the tables. The strange
thing is that there are 3 files in the Data folder under the MSSQL folder
for AdventureWorks: AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~
164MB) and AdventureWorks_log.idf (~1MB). The other DB's on the server only
have 2 files (.mdf and .idf) for each database. There are no _Data.mdf
files.
Regards, Richard
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:rugaxfto4xox$.1xm17ldm6wy7j$.dlg@.40tude.net.. .
> On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
>
> Looks like a permissions issue. If you are just testing, make your account
> you log in as a Server Role of Sysadmin (God-level rights).
> Chuck Lathrope
> www.sqlwebpedia.com
AdventureWorks Install
I am using sqlserver 2005 express edition and have downloaded the
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
no tables appear under system tables. Is there something I am missing here?No, it's normal in SQL Server 2005. System tables are hidden and you can't
see or modify them directly.
--
Regards
Pawel Potasinski
U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using sqlserver 2005 express edition and have downloaded the
> AdventureWorksDB.msi. I have installed it and it created 3 files:
> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
> AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
> no tables appear under system tables. Is there something I am missing
> here?
>
>|||I have another DB (storeDB) on the server and I am able to see all the
tables under Databases > System Databases > storeDB > Tables > System
Tables, but I am unable to see the System Tables under AdventureWorks. I am
going through the tutorial and it's asking me to create the following query:
SELECT * FROM Production.Product;
GO
and I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Production.Product'.
I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
2005.
Any help would be appreciated.
Regards, Richard
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
> No, it's normal in SQL Server 2005. System tables are hidden and you can't
> see or modify them directly.
> --
> Regards
> Pawel Potasinski
>
> U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>>I am using sqlserver 2005 express edition and have downloaded the
>> AdventureWorksDB.msi. I have installed it and it created 3 files:
>> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
>> AdventureWorks_log.idf (~1MB). When I added the database to the
>> sqlserver,
>> no tables appear under system tables. Is there something I am missing
>> here?
>>
>|||On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
> I have another DB (storeDB) on the server and I am able to see all the
> tables under Databases > System Databases > storeDB > Tables > System
> Tables, but I am unable to see the System Tables under AdventureWorks. I am
> going through the tutorial and it's asking me to create the following query:
> SELECT * FROM Production.Product;
> GO
> and I receive this error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Production.Product'.
> I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
> 2005.
> Any help would be appreciated.
> Regards, Richard
> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
>> No, it's normal in SQL Server 2005. System tables are hidden and you can't
>> see or modify them directly.
>> --
>> Regards
>> Pawel Potasinski
>>
>> U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
>> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>>I am using sqlserver 2005 express edition and have downloaded the
>> AdventureWorksDB.msi. I have installed it and it created 3 files:
>> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
>> AdventureWorks_log.idf (~1MB). When I added the database to the
>> sqlserver,
>> no tables appear under system tables. Is there something I am missing
>> here?
>>
>>
Looks like a permissions issue. If you are just testing, make your account
you log in as a Server Role of Sysadmin (God-level rights).
Chuck Lathrope
www.sqlwebpedia.com|||Thanks, I changed permissions, but I still can't see the tables. The strange
thing is that there are 3 files in the Data folder under the MSSQL folder
for AdventureWorks: AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~
164MB) and AdventureWorks_log.idf (~1MB). The other DB's on the server only
have 2 files (.mdf and .idf) for each database. There are no _Data.mdf
files.
Regards, Richard
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:rugaxfto4xox$.1xm17ldm6wy7j$.dlg@.40tude.net...
> On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
>> I have another DB (storeDB) on the server and I am able to see all the
>> tables under Databases > System Databases > storeDB > Tables > System
>> Tables, but I am unable to see the System Tables under AdventureWorks. I
>> am
>> going through the tutorial and it's asking me to create the following
>> query:
>> SELECT * FROM Production.Product;
>> GO
>> and I receive this error message:
>> Msg 208, Level 16, State 1, Line 1
>> Invalid object name 'Production.Product'.
>> I have a connection the AdventureWorks DB. I'm obviously new to SQL
>> Server
>> 2005.
>> Any help would be appreciated.
>> Regards, Richard
>> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
>> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
>> No, it's normal in SQL Server 2005. System tables are hidden and you
>> can't
>> see or modify them directly.
>> --
>> Regards
>> Pawel Potasinski
>>
>> U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
>> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>>I am using sqlserver 2005 express edition and have downloaded the
>> AdventureWorksDB.msi. I have installed it and it created 3 files:
>> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
>> AdventureWorks_log.idf (~1MB). When I added the database to the
>> sqlserver,
>> no tables appear under system tables. Is there something I am missing
>> here?
>>
>>
> Looks like a permissions issue. If you are just testing, make your account
> you log in as a Server Role of Sysadmin (God-level rights).
> Chuck Lathrope
> www.sqlwebpedia.com
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
no tables appear under system tables. Is there something I am missing here?No, it's normal in SQL Server 2005. System tables are hidden and you can't
see or modify them directly.
--
Regards
Pawel Potasinski
U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using sqlserver 2005 express edition and have downloaded the
> AdventureWorksDB.msi. I have installed it and it created 3 files:
> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
> AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
> no tables appear under system tables. Is there something I am missing
> here?
>
>|||I have another DB (storeDB) on the server and I am able to see all the
tables under Databases > System Databases > storeDB > Tables > System
Tables, but I am unable to see the System Tables under AdventureWorks. I am
going through the tutorial and it's asking me to create the following query:
SELECT * FROM Production.Product;
GO
and I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Production.Product'.
I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
2005.
Any help would be appreciated.
Regards, Richard
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
> No, it's normal in SQL Server 2005. System tables are hidden and you can't
> see or modify them directly.
> --
> Regards
> Pawel Potasinski
>
> U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>>I am using sqlserver 2005 express edition and have downloaded the
>> AdventureWorksDB.msi. I have installed it and it created 3 files:
>> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
>> AdventureWorks_log.idf (~1MB). When I added the database to the
>> sqlserver,
>> no tables appear under system tables. Is there something I am missing
>> here?
>>
>|||On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
> I have another DB (storeDB) on the server and I am able to see all the
> tables under Databases > System Databases > storeDB > Tables > System
> Tables, but I am unable to see the System Tables under AdventureWorks. I am
> going through the tutorial and it's asking me to create the following query:
> SELECT * FROM Production.Product;
> GO
> and I receive this error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Production.Product'.
> I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
> 2005.
> Any help would be appreciated.
> Regards, Richard
> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
>> No, it's normal in SQL Server 2005. System tables are hidden and you can't
>> see or modify them directly.
>> --
>> Regards
>> Pawel Potasinski
>>
>> U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
>> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>>I am using sqlserver 2005 express edition and have downloaded the
>> AdventureWorksDB.msi. I have installed it and it created 3 files:
>> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
>> AdventureWorks_log.idf (~1MB). When I added the database to the
>> sqlserver,
>> no tables appear under system tables. Is there something I am missing
>> here?
>>
>>
Looks like a permissions issue. If you are just testing, make your account
you log in as a Server Role of Sysadmin (God-level rights).
Chuck Lathrope
www.sqlwebpedia.com|||Thanks, I changed permissions, but I still can't see the tables. The strange
thing is that there are 3 files in the Data folder under the MSSQL folder
for AdventureWorks: AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~
164MB) and AdventureWorks_log.idf (~1MB). The other DB's on the server only
have 2 files (.mdf and .idf) for each database. There are no _Data.mdf
files.
Regards, Richard
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:rugaxfto4xox$.1xm17ldm6wy7j$.dlg@.40tude.net...
> On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
>> I have another DB (storeDB) on the server and I am able to see all the
>> tables under Databases > System Databases > storeDB > Tables > System
>> Tables, but I am unable to see the System Tables under AdventureWorks. I
>> am
>> going through the tutorial and it's asking me to create the following
>> query:
>> SELECT * FROM Production.Product;
>> GO
>> and I receive this error message:
>> Msg 208, Level 16, State 1, Line 1
>> Invalid object name 'Production.Product'.
>> I have a connection the AdventureWorks DB. I'm obviously new to SQL
>> Server
>> 2005.
>> Any help would be appreciated.
>> Regards, Richard
>> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
>> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
>> No, it's normal in SQL Server 2005. System tables are hidden and you
>> can't
>> see or modify them directly.
>> --
>> Regards
>> Pawel Potasinski
>>
>> U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
>> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>>I am using sqlserver 2005 express edition and have downloaded the
>> AdventureWorksDB.msi. I have installed it and it created 3 files:
>> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
>> AdventureWorks_log.idf (~1MB). When I added the database to the
>> sqlserver,
>> no tables appear under system tables. Is there something I am missing
>> here?
>>
>>
> Looks like a permissions issue. If you are just testing, make your account
> you log in as a Server Role of Sysadmin (God-level rights).
> Chuck Lathrope
> www.sqlwebpedia.com
AdventureWorks Install
I am using sqlserver 2005 express edition and have downloaded the
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
no tables appear under system tables. Is there something I am missing here?No, it's normal in SQL Server 2005. System tables are hidden and you can't
see or modify them directly.
Regards
Pawel Potasinski
Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using sqlserver 2005 express edition and have downloaded the
> AdventureWorksDB.msi. I have installed it and it created 3 files:
> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
> AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
> no tables appear under system tables. Is there something I am missing
> here?
>
>|||I have another DB (storeDB) on the server and I am able to see all the
tables under Databases > System Databases > storeDB > Tables > System
Tables, but I am unable to see the System Tables under AdventureWorks. I am
going through the tutorial and it's asking me to create the following query:
SELECT * FROM Production.Product;
GO
and I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Production.Product'.
I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
2005.
Any help would be appreciated.
Regards, Richard
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
> No, it's normal in SQL Server 2005. System tables are hidden and you can't
> see or modify them directly.
> --
> Regards
> Pawel Potasinski
>
> Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>|||On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
[vbcol=seagreen]
> I have another DB (storeDB) on the server and I am able to see all the
> tables under Databases > System Databases > storeDB > Tables > System
> Tables, but I am unable to see the System Tables under AdventureWorks. I a
m
> going through the tutorial and it's asking me to create the following quer
y:
> SELECT * FROM Production.Product;
> GO
> and I receive this error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Production.Product'.
> I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
> 2005.
> Any help would be appreciated.
> Regards, Richard
> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
>
Looks like a permissions issue. If you are just testing, make your account
you log in as a Server Role of Sysadmin (God-level rights).
Chuck Lathrope
www.sqlwebpedia.com|||Thanks, I changed permissions, but I still can't see the tables. The strange
thing is that there are 3 files in the Data folder under the MSSQL folder
for AdventureWorks: AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~
164MB) and AdventureWorks_log.idf (~1MB). The other DB's on the server only
have 2 files (.mdf and .idf) for each database. There are no _Data.mdf
files.
Regards, Richard
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:rugaxfto4xox$.1xm17ldm6wy7j$.dlg@.40tude.net...
> On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
>
> Looks like a permissions issue. If you are just testing, make your account
> you log in as a Server Role of Sysadmin (God-level rights).
> Chuck Lathrope
> www.sqlwebpedia.com
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
no tables appear under system tables. Is there something I am missing here?No, it's normal in SQL Server 2005. System tables are hidden and you can't
see or modify them directly.
Regards
Pawel Potasinski
Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using sqlserver 2005 express edition and have downloaded the
> AdventureWorksDB.msi. I have installed it and it created 3 files:
> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
> AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
> no tables appear under system tables. Is there something I am missing
> here?
>
>|||I have another DB (storeDB) on the server and I am able to see all the
tables under Databases > System Databases > storeDB > Tables > System
Tables, but I am unable to see the System Tables under AdventureWorks. I am
going through the tutorial and it's asking me to create the following query:
SELECT * FROM Production.Product;
GO
and I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Production.Product'.
I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
2005.
Any help would be appreciated.
Regards, Richard
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
> No, it's normal in SQL Server 2005. System tables are hidden and you can't
> see or modify them directly.
> --
> Regards
> Pawel Potasinski
>
> Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>|||On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
[vbcol=seagreen]
> I have another DB (storeDB) on the server and I am able to see all the
> tables under Databases > System Databases > storeDB > Tables > System
> Tables, but I am unable to see the System Tables under AdventureWorks. I a
m
> going through the tutorial and it's asking me to create the following quer
y:
> SELECT * FROM Production.Product;
> GO
> and I receive this error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Production.Product'.
> I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
> 2005.
> Any help would be appreciated.
> Regards, Richard
> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
>
Looks like a permissions issue. If you are just testing, make your account
you log in as a Server Role of Sysadmin (God-level rights).
Chuck Lathrope
www.sqlwebpedia.com|||Thanks, I changed permissions, but I still can't see the tables. The strange
thing is that there are 3 files in the Data folder under the MSSQL folder
for AdventureWorks: AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~
164MB) and AdventureWorks_log.idf (~1MB). The other DB's on the server only
have 2 files (.mdf and .idf) for each database. There are no _Data.mdf
files.
Regards, Richard
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:rugaxfto4xox$.1xm17ldm6wy7j$.dlg@.40tude.net...
> On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
>
> Looks like a permissions issue. If you are just testing, make your account
> you log in as a Server Role of Sysadmin (God-level rights).
> Chuck Lathrope
> www.sqlwebpedia.com
AdventureWorks DB sample
OK, I've installed SQL 2k5, and I'm sure I selected Advanced>Samples
however I cannot see the AdventureWorks database attached.
I have tried opening SQL Server manager>right click on databases>Attach>Add but this only brings up a Folder explorer, not a file explorer.
I can navigate to where the AdventureWorks samples are but SQL Server manager is not able to attach them because it is a Folder explore. also, I have the samples in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data but I am only able to browse to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\
How then can I attach the database?
(later on...) Ok I still cant browse to the Data directory, but I copied the contents of this directory into its parent directory which I can browse to. I still could not see the files in the directory because it is a tree view with no way to see files, so I typed in the name of the AdventureWorks database that I wanted to attach.
Then I got a permissions error - I wasnt able to attach the DB even though I had connected using windows permissions.
This is really starting to frustrate me - I have wasted many hours on something that should be straight forward.
You should find the sample Db under the following directory.
C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP
|||See the book online section:
It contains detailed steps to get the AdventureWorks DB samples installed.
|||The sample db is in 90\Tools location ok but I seem not to get the step 9. in the Setup post installation procedure which says
"To install and attach the sample databases, from Sample Databases Setup, select Install and attach sample databases, and then click Next.
The database files are created and stored in the folder <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data. The database is attached and ready for use."
(there's just a cert in MSSQL.1\MSSQL\Data)AdventureWorks DB sample
OK, I've installed SQL 2k5, and I'm sure I selected Advanced>Samples
however I cannot see the AdventureWorks database attached.
I have tried opening SQL Server manager>right click on databases>Attach>Add but this only brings up a Folder explorer, not a file explorer.
I can navigate to where the AdventureWorks samples are but SQL Server manager is not able to attach them because it is a Folder explore. also, I have the samples in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data but I am only able to browse to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\
How then can I attach the database?
(later on...) Ok I still cant browse to the Data directory, but I copied the contents of this directory into its parent directory which I can browse to. I still could not see the files in the directory because it is a tree view with no way to see files, so I typed in the name of the AdventureWorks database that I wanted to attach.
Then I got a permissions error - I wasnt able to attach the DB even though I had connected using windows permissions.
This is really starting to frustrate me - I have wasted many hours on something that should be straight forward.
You should find the sample Db under the following directory.
C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP
|||See the book online section:
It contains detailed steps to get the AdventureWorks DB samples installed.
|||The sample db is in 90\Tools location ok but I seem not to get the step 9. in the Setup post installation procedure which says
"To install and attach the sample databases, from Sample Databases Setup, select Install and attach sample databases, and then click Next.
The database files are created and stored in the folder <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data. The database is attached and ready for use."
(there's just a cert in MSSQL.1\MSSQL\Data)adventureworks db and dw not showing up in management studio database list
I've installed both the AW db and dw off the MS download. I see the db in the directory I use for other databases, the dw doesnt seem to want to go where I tell it. Anyway, when I connect to my instance of sql (developer's) I dont see the AW db.used attach and all is ok
Adventureworks db
I installed adventureworks db onto sqlExpress. It does not show up althought it is in the:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
I look up the database in the Microsoft SQL Server Management Studio Express, But it's not visible. I've turned the service off andon, but it still is not available. Any ideas what has happened.
john welte
The installation of the sample database does not mean that you attached it for use in SQL Server. You will need to use the sp_attach procedure or the command which can be found in Management Studio under Right click the Server > Attach Database > specify the location and the name of the database file > Done :-)HTH; Jens Suessmeyer.
http://www.sqlserver2005.de
AdventureWorks database
It is not automatically installed. You must specifically select it during a
custom install.
You might be able to get it now by just reinstalling the tools and making
sure you choose the sample databases. Otherwise you can download it from
here
http://www.microsoft.com/downloads/details.aspx?FamilyID=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:ucBHEhvLHHA.780@.TK2MSFTNGP03.phx.gbl...
> Is this database 'AdventureWorks' comes with SQL 2005?
> I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
> comes with SQL Server 2005. But I cannot find that in the Management
> Studio.
>
Alan T wrote:
> Thanks.
> I downloaded the 'SqlServerSamples.msi' and installed it.
> However, I looked thro' the Samples folder cannot find the AdventureWorks
> database.
You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
Razvan
|||Yes, the SqlServerSamples.msi is code samples. There are separate downloads
for the sample databases, which you can see in the link I gave you are
larger files than the Samples download. You can choose to download AW in
either a case-sensitive collation or case-INsensitive.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1167832817.697717.13790@.48g2000cwx.googlegrou ps.com...
> Alan T wrote:
> You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
> Razvan
>
custom install.
You might be able to get it now by just reinstalling the tools and making
sure you choose the sample databases. Otherwise you can download it from
here
http://www.microsoft.com/downloads/details.aspx?FamilyID=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:ucBHEhvLHHA.780@.TK2MSFTNGP03.phx.gbl...
> Is this database 'AdventureWorks' comes with SQL 2005?
> I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
> comes with SQL Server 2005. But I cannot find that in the Management
> Studio.
>
Alan T wrote:
> Thanks.
> I downloaded the 'SqlServerSamples.msi' and installed it.
> However, I looked thro' the Samples folder cannot find the AdventureWorks
> database.
You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
Razvan
|||Yes, the SqlServerSamples.msi is code samples. There are separate downloads
for the sample databases, which you can see in the link I gave you are
larger files than the Samples download. You can choose to download AW in
either a case-sensitive collation or case-INsensitive.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1167832817.697717.13790@.48g2000cwx.googlegrou ps.com...
> Alan T wrote:
> You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
> Razvan
>
AdventureWorks
I've download and installed the sample database but the Server can't see it .. it doesn't appear in the User databases. I installed using the defaults. Anyone ha d the same problem and solved it?
Downloadable user database or not installed upon installation. the datafiles /scripts are just copied to the specified directory. if you want to see them as server attached databases, you will have to either go through the GUI and attach them right-clicking on the Databases node and Select attach database, fo through the GUI and specify the path and file name of the database you want to attach. Another option would be to use the sp_attachdb command from TSQL (see more information about that in the BOL)
Jens K. Suessmeyer
http://www.sqlserver2005.de
Tuesday, March 6, 2012
ADOMD and XML/A
Hi,
I got the following from a Microsoft Technet Chat - "The advantage of XML/A over ADOMD is the thin client. ADOMD requires PTS and ADOMD installed on all client machines while XML/A would only require an XML parser."
Now say, I develop an asp.net application which would use adomd.net to get cube data, and will also run mdx queries. I host the asp.net page on my server, and allow it to be accessed by remote users. My server itself contains all the necessary cubes, and other components like adomd.net, etc.
My question is, if you want to run the asp.net page hosted on my server, (via HTTP), will it be necessary for you to install the adomd.net components on your local (remote) machine also?
(Actually I dont like coding with XML/A and find execution of mdx queries via Adomd.Net much easier! Any links showing xml/a coding for MDX in VB.Net from scratch?)
Thanx and Regards!
As in typical ASP.NET apps, you only need data access components on the ASP.NET server - maybe the 2nd figure on this page will help you:
http://msdn2.microsoft.com/en-us/library/ms174518.aspx
>>
SQL Server 2005 Books Online
Client Architecture (SSAS)
...
Analysis Services provides broad middle tier support for Web services. ASP applications are supported by OLE DB for OLAP and ADO MD, ASP.NET applications are supported by ADOMD.NET. The middle tier, illustrated in the following figure..
>>
ADOMD
Hello:
I've installed ADOMD.NET and I've tried to connect Analysis Service with
ASP.NET (using VB.NET). I receive errors but I don't know how I must use
ADOMD.NET. Can somebody help me and show me how I begin?
Thanks.
Regards.
look at this:
http://www.sqlserveranalysisservices...tGridIntro.htm
"Gema Snchez" <gema.sanchez@.grupo-episteme.com> wrote in message
news:OaL%23V8qYFHA.980@.TK2MSFTNGP12.phx.gbl...
> Hello:
> I've installed ADOMD.NET and I've tried to connect Analysis Service with
> ASP.NET (using VB.NET). I receive errors but I don't know how I must use
> ADOMD.NET. Can somebody help me and show me how I begin?
> Thanks.
> Regards.
>
I've installed ADOMD.NET and I've tried to connect Analysis Service with
ASP.NET (using VB.NET). I receive errors but I don't know how I must use
ADOMD.NET. Can somebody help me and show me how I begin?
Thanks.
Regards.
look at this:
http://www.sqlserveranalysisservices...tGridIntro.htm
"Gema Snchez" <gema.sanchez@.grupo-episteme.com> wrote in message
news:OaL%23V8qYFHA.980@.TK2MSFTNGP12.phx.gbl...
> Hello:
> I've installed ADOMD.NET and I've tried to connect Analysis Service with
> ASP.NET (using VB.NET). I receive errors but I don't know how I must use
> ADOMD.NET. Can somebody help me and show me how I begin?
> Thanks.
> Regards.
>
ADOMD
Hello:
I've installed ADOMD.NET and I've tried to connect Analysis Service with
ASP.NET (using VB.NET). I receive errors but I don't know how I must use
ADOMD.NET. Can somebody help me and show me how I begin?
Thanks.
Regards.look at this:
http://www.sqlserveranalysisservice...etGridIntro.htm
"Gema Snchez" <gema.sanchez@.grupo-episteme.com> wrote in message
news:OaL%23V8qYFHA.980@.TK2MSFTNGP12.phx.gbl...
> Hello:
> I've installed ADOMD.NET and I've tried to connect Analysis Service with
> ASP.NET (using VB.NET). I receive errors but I don't know how I must use
> ADOMD.NET. Can somebody help me and show me how I begin?
> Thanks.
> Regards.
>
I've installed ADOMD.NET and I've tried to connect Analysis Service with
ASP.NET (using VB.NET). I receive errors but I don't know how I must use
ADOMD.NET. Can somebody help me and show me how I begin?
Thanks.
Regards.look at this:
http://www.sqlserveranalysisservice...etGridIntro.htm
"Gema Snchez" <gema.sanchez@.grupo-episteme.com> wrote in message
news:OaL%23V8qYFHA.980@.TK2MSFTNGP12.phx.gbl...
> Hello:
> I've installed ADOMD.NET and I've tried to connect Analysis Service with
> ASP.NET (using VB.NET). I receive errors but I don't know how I must use
> ADOMD.NET. Can somebody help me and show me how I begin?
> Thanks.
> Regards.
>
Saturday, February 25, 2012
ADODB Connection Error.
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/visastatus/NewEmpVisaDetails.asp, line 35
Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
it...
The Enterprise Manager is giving an error " Provider cannot be found. It may
not be properly installed."
Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
the system support people is to reformat my system.
Arun
"Knowledge grows when Shared"
- Anonymous
What does your connection string look like? It will probably have the word
provider in it.
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
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> Error Type:
> ADODB.Connection (0x800A0E7A)
> Provider cannot be found. It may not be properly installed.
> /visastatus/NewEmpVisaDetails.asp, line 35
> Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> it...
> The Enterprise Manager is giving an error " Provider cannot be found. It
> may
> not be properly installed."
> Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> the system support people is to reformat my system.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
|||Hi
You may want to check MDAC is installed correctly see the component checker
http://www.microsoft.com/downloads/d...DisplayLang=en
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> Error Type:
> ADODB.Connection (0x800A0E7A)
> Provider cannot be found. It may not be properly installed.
> /visastatus/NewEmpVisaDetails.asp, line 35
> Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> it...
> The Enterprise Manager is giving an error " Provider cannot be found. It
> may
> not be properly installed."
> Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> the system support people is to reformat my system.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
|||Cotter
Yep ur right it does house the word Provider in the connection, but i was
able to establish the connection previously.
Would that affect my enterprise manager too, even when i right click on a
table and when i choose return all rows it is giving me a "Provider...not
installed".
Rather it is a problem with the SQL(Enterprise manager) rather than the
connection string...(Guess so!), if not let me know how do i modify the
connection string.
Here is how my connection string looks
set objConn=Server.CreateObject("ADODB.CONNECTION")
objConn.Open "Provider=SQLOLEDB;data Source=<my server>;Initial Catalog=<my
database>;User Id= <id> ;Password= pwd"
"Knowledge grows when Shared"
- Anonymous
"Hilary Cotter" wrote:
> What does your connection string look like? It will probably have the word
> provider in it.
> --
> 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
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>
>
|||John
I have already installed Component Checker, do let me know where do i find
the error, educate me how to use it for trouble shooting.
Arun
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> You may want to check MDAC is installed correctly see the component checker
> http://www.microsoft.com/downloads/d...DisplayLang=en
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>
>
|||Hi
If you run the component checker it will show you the dlls installed and
what version they are at. If you are at a version less than 2.8 SP1 then you
may want to consider trying an upgrade.
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...[vbcol=seagreen]
> John
> I have already installed Component Checker, do let me know where do i find
> the error, educate me how to use it for trouble shooting.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
|||I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
What else could be the problem...!!!
Arun
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> If you run the component checker it will show you the dlls installed and
> what version they are at. If you are at a version less than 2.8 SP1 then you
> may want to consider trying an upgrade.
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>
>
|||The component checker will usually detect problems with installed
components. You might try reinstalling the MDAC 2.8 SP1.
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...[vbcol=seagreen]
> I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
> What else could be the problem...!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
|||Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing is
happening.
I wouldn't want to c my system getting formatted for this system...some1
HELP!!!!
Arun
"Knowledge grows when Shared"
- Anonymous
"Dan Guzman" wrote:
> The component checker will usually detect problems with installed
> components. You might try reinstalling the MDAC 2.8 SP1.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
>
>
|||It's strange that the component checker didn't detect an error so server
that both ODBC and SQLOLEDB providers are not found. Do all components
match? Did you reboot after the MDAC reinstall?
Just to be clear, if SQL Server and your application are running on a
different machines, you should be focusing on the client box rather than the
database server.
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...[vbcol=seagreen]
> Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing
> is
> happening.
> I wouldn't want to c my system getting formatted for this system...some1
> HELP!!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "Dan Guzman" wrote:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/visastatus/NewEmpVisaDetails.asp, line 35
Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
it...
The Enterprise Manager is giving an error " Provider cannot be found. It may
not be properly installed."
Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
the system support people is to reformat my system.
Arun
"Knowledge grows when Shared"
- Anonymous
What does your connection string look like? It will probably have the word
provider in it.
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
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> Error Type:
> ADODB.Connection (0x800A0E7A)
> Provider cannot be found. It may not be properly installed.
> /visastatus/NewEmpVisaDetails.asp, line 35
> Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> it...
> The Enterprise Manager is giving an error " Provider cannot be found. It
> may
> not be properly installed."
> Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> the system support people is to reformat my system.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
|||Hi
You may want to check MDAC is installed correctly see the component checker
http://www.microsoft.com/downloads/d...DisplayLang=en
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> Error Type:
> ADODB.Connection (0x800A0E7A)
> Provider cannot be found. It may not be properly installed.
> /visastatus/NewEmpVisaDetails.asp, line 35
> Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> it...
> The Enterprise Manager is giving an error " Provider cannot be found. It
> may
> not be properly installed."
> Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> the system support people is to reformat my system.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
|||Cotter
Yep ur right it does house the word Provider in the connection, but i was
able to establish the connection previously.
Would that affect my enterprise manager too, even when i right click on a
table and when i choose return all rows it is giving me a "Provider...not
installed".
Rather it is a problem with the SQL(Enterprise manager) rather than the
connection string...(Guess so!), if not let me know how do i modify the
connection string.
Here is how my connection string looks
set objConn=Server.CreateObject("ADODB.CONNECTION")
objConn.Open "Provider=SQLOLEDB;data Source=<my server>;Initial Catalog=<my
database>;User Id= <id> ;Password= pwd"
"Knowledge grows when Shared"
- Anonymous
"Hilary Cotter" wrote:
> What does your connection string look like? It will probably have the word
> provider in it.
> --
> 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
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>
>
|||John
I have already installed Component Checker, do let me know where do i find
the error, educate me how to use it for trouble shooting.
Arun
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> You may want to check MDAC is installed correctly see the component checker
> http://www.microsoft.com/downloads/d...DisplayLang=en
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>
>
|||Hi
If you run the component checker it will show you the dlls installed and
what version they are at. If you are at a version less than 2.8 SP1 then you
may want to consider trying an upgrade.
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...[vbcol=seagreen]
> John
> I have already installed Component Checker, do let me know where do i find
> the error, educate me how to use it for trouble shooting.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
|||I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
What else could be the problem...!!!
Arun
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> If you run the component checker it will show you the dlls installed and
> what version they are at. If you are at a version less than 2.8 SP1 then you
> may want to consider trying an upgrade.
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>
>
|||The component checker will usually detect problems with installed
components. You might try reinstalling the MDAC 2.8 SP1.
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...[vbcol=seagreen]
> I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
> What else could be the problem...!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
|||Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing is
happening.
I wouldn't want to c my system getting formatted for this system...some1
HELP!!!!
Arun
"Knowledge grows when Shared"
- Anonymous
"Dan Guzman" wrote:
> The component checker will usually detect problems with installed
> components. You might try reinstalling the MDAC 2.8 SP1.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
>
>
|||It's strange that the component checker didn't detect an error so server
that both ODBC and SQLOLEDB providers are not found. Do all components
match? Did you reboot after the MDAC reinstall?
Just to be clear, if SQL Server and your application are running on a
different machines, you should be focusing on the client box rather than the
database server.
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...[vbcol=seagreen]
> Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing
> is
> happening.
> I wouldn't want to c my system getting formatted for this system...some1
> HELP!!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "Dan Guzman" wrote:
ADODB Connection Error.
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/visastatus/NewEmpVisaDetails.asp, line 35
Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
it...
The Enterprise Manager is giving an error " Provider cannot be found. It may
not be properly installed."
Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
the system support people is to reformat my system.
Arun
--
"Knowledge grows when Shared"
- AnonymousWhat does your connection string look like? It will probably have the word
provider in it.
--
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
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> Error Type:
> ADODB.Connection (0x800A0E7A)
> Provider cannot be found. It may not be properly installed.
> /visastatus/NewEmpVisaDetails.asp, line 35
> Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> it...
> The Enterprise Manager is giving an error " Provider cannot be found. It
> may
> not be properly installed."
> Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> the system support people is to reformat my system.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous|||Hi
You may want to check MDAC is installed correctly see the component checker
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> Error Type:
> ADODB.Connection (0x800A0E7A)
> Provider cannot be found. It may not be properly installed.
> /visastatus/NewEmpVisaDetails.asp, line 35
> Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> it...
> The Enterprise Manager is giving an error " Provider cannot be found. It
> may
> not be properly installed."
> Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> the system support people is to reformat my system.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous|||Cotter
Yep ur right it does house the word Provider in the connection, but i was
able to establish the connection previously.
Would that affect my enterprise manager too, even when i right click on a
table and when i choose return all rows it is giving me a "Provider...not
installed".
Rather it is a problem with the SQL(Enterprise manager) rather than the
connection string...(Guess so!), if not let me know how do i modify the
connection string.
Here is how my connection string looks
set objConn=Server.CreateObject("ADODB.CONNECTION")
objConn.Open "Provider=SQLOLEDB;data Source=<my server>;Initial Catalog=<my
database>;User Id= <id> ;Password= pwd"
"Knowledge grows when Shared"
- Anonymous
"Hilary Cotter" wrote:
> What does your connection string look like? It will probably have the word
> provider in it.
> --
> 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
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> > Error Type:
> > ADODB.Connection (0x800A0E7A)
> > Provider cannot be found. It may not be properly installed.
> > /visastatus/NewEmpVisaDetails.asp, line 35
> >
> > Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> > it...
> >
> > The Enterprise Manager is giving an error " Provider cannot be found. It
> > may
> > not be properly installed."
> >
> > Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> > the system support people is to reformat my system.
> >
> > Arun
> >
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
>
>|||John
I have already installed Component Checker, do let me know where do i find
the error, educate me how to use it for trouble shooting.
Arun
--
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> You may want to check MDAC is installed correctly see the component checker
> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> > Error Type:
> > ADODB.Connection (0x800A0E7A)
> > Provider cannot be found. It may not be properly installed.
> > /visastatus/NewEmpVisaDetails.asp, line 35
> >
> > Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> > it...
> >
> > The Enterprise Manager is giving an error " Provider cannot be found. It
> > may
> > not be properly installed."
> >
> > Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> > the system support people is to reformat my system.
> >
> > Arun
> >
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
>
>|||Hi
If you run the component checker it will show you the dlls installed and
what version they are at. If you are at a version less than 2.8 SP1 then you
may want to consider trying an upgrade.
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
> John
> I have already installed Component Checker, do let me know where do i find
> the error, educate me how to use it for trouble shooting.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
>> Hi
>> You may want to check MDAC is installed correctly see the component
>> checker
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> John
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> > Error Type:
>> > ADODB.Connection (0x800A0E7A)
>> > Provider cannot be found. It may not be properly installed.
>> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >
>> > Even registering the dll "sqloledb.dll" didn't fix the problem. Added
>> > to
>> > it...
>> >
>> > The Enterprise Manager is giving an error " Provider cannot be found.
>> > It
>> > may
>> > not be properly installed."
>> >
>> > Do let me know the fix, i have reinstalled the SQL 2000, the fix given
>> > by
>> > the system support people is to reformat my system.
>> >
>> > Arun
>> >
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>>|||I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
What else could be the problem...!!!
Arun
--
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> If you run the component checker it will show you the dlls installed and
> what version they are at. If you are at a version less than 2.8 SP1 then you
> may want to consider trying an upgrade.
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
> > John
> >
> > I have already installed Component Checker, do let me know where do i find
> > the error, educate me how to use it for trouble shooting.
> >
> > Arun
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
> >
> >
> > "John Bell" wrote:
> >
> >> Hi
> >>
> >> You may want to check MDAC is installed correctly see the component
> >> checker
> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
> >>
> >> John
> >>
> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> >> > Error Type:
> >> > ADODB.Connection (0x800A0E7A)
> >> > Provider cannot be found. It may not be properly installed.
> >> > /visastatus/NewEmpVisaDetails.asp, line 35
> >> >
> >> > Even registering the dll "sqloledb.dll" didn't fix the problem. Added
> >> > to
> >> > it...
> >> >
> >> > The Enterprise Manager is giving an error " Provider cannot be found.
> >> > It
> >> > may
> >> > not be properly installed."
> >> >
> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix given
> >> > by
> >> > the system support people is to reformat my system.
> >> >
> >> > Arun
> >> >
> >> > --
> >> > "Knowledge grows when Shared"
> >> > - Anonymous
> >>
> >>
> >>
>
>|||The component checker will usually detect problems with installed
components. You might try reinstalling the MDAC 2.8 SP1.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
> I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
> What else could be the problem...!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
>> Hi
>> If you run the component checker it will show you the dlls installed and
>> what version they are at. If you are at a version less than 2.8 SP1 then
>> you
>> may want to consider trying an upgrade.
>> John
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>> > John
>> >
>> > I have already installed Component Checker, do let me know where do i
>> > find
>> > the error, educate me how to use it for trouble shooting.
>> >
>> > Arun
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>> >
>> >
>> > "John Bell" wrote:
>> >
>> >> Hi
>> >>
>> >> You may want to check MDAC is installed correctly see the component
>> >> checker
>> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> >>
>> >> John
>> >>
>> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> >> > Error Type:
>> >> > ADODB.Connection (0x800A0E7A)
>> >> > Provider cannot be found. It may not be properly installed.
>> >> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >> >
>> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
>> >> > Added
>> >> > to
>> >> > it...
>> >> >
>> >> > The Enterprise Manager is giving an error " Provider cannot be
>> >> > found.
>> >> > It
>> >> > may
>> >> > not be properly installed."
>> >> >
>> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
>> >> > given
>> >> > by
>> >> > the system support people is to reformat my system.
>> >> >
>> >> > Arun
>> >> >
>> >> > --
>> >> > "Knowledge grows when Shared"
>> >> > - Anonymous
>> >>
>> >>
>> >>
>>|||Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing is
happening.
I wouldn't want to c my system getting formatted for this system...some1
HELP!!!!
Arun
--
"Knowledge grows when Shared"
- Anonymous
"Dan Guzman" wrote:
> The component checker will usually detect problems with installed
> components. You might try reinstalling the MDAC 2.8 SP1.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
> > I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
> >
> > What else could be the problem...!!!
> >
> > Arun
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
> >
> >
> > "John Bell" wrote:
> >
> >> Hi
> >>
> >> If you run the component checker it will show you the dlls installed and
> >> what version they are at. If you are at a version less than 2.8 SP1 then
> >> you
> >> may want to consider trying an upgrade.
> >>
> >> John
> >>
> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
> >> > John
> >> >
> >> > I have already installed Component Checker, do let me know where do i
> >> > find
> >> > the error, educate me how to use it for trouble shooting.
> >> >
> >> > Arun
> >> > --
> >> > "Knowledge grows when Shared"
> >> > - Anonymous
> >> >
> >> >
> >> > "John Bell" wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> You may want to check MDAC is installed correctly see the component
> >> >> checker
> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
> >> >>
> >> >> John
> >> >>
> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> >> >> > Error Type:
> >> >> > ADODB.Connection (0x800A0E7A)
> >> >> > Provider cannot be found. It may not be properly installed.
> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
> >> >> >
> >> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
> >> >> > Added
> >> >> > to
> >> >> > it...
> >> >> >
> >> >> > The Enterprise Manager is giving an error " Provider cannot be
> >> >> > found.
> >> >> > It
> >> >> > may
> >> >> > not be properly installed."
> >> >> >
> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
> >> >> > given
> >> >> > by
> >> >> > the system support people is to reformat my system.
> >> >> >
> >> >> > Arun
> >> >> >
> >> >> > --
> >> >> > "Knowledge grows when Shared"
> >> >> > - Anonymous
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||It's strange that the component checker didn't detect an error so server
that both ODBC and SQLOLEDB providers are not found. Do all components
match? Did you reboot after the MDAC reinstall?
Just to be clear, if SQL Server and your application are running on a
different machines, you should be focusing on the client box rather than the
database server.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...
> Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing
> is
> happening.
> I wouldn't want to c my system getting formatted for this system...some1
> HELP!!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "Dan Guzman" wrote:
>> The component checker will usually detect problems with installed
>> components. You might try reinstalling the MDAC 2.8 SP1.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
>> > I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
>> >
>> > What else could be the problem...!!!
>> >
>> > Arun
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>> >
>> >
>> > "John Bell" wrote:
>> >
>> >> Hi
>> >>
>> >> If you run the component checker it will show you the dlls installed
>> >> and
>> >> what version they are at. If you are at a version less than 2.8 SP1
>> >> then
>> >> you
>> >> may want to consider trying an upgrade.
>> >>
>> >> John
>> >>
>> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>> >> > John
>> >> >
>> >> > I have already installed Component Checker, do let me know where do
>> >> > i
>> >> > find
>> >> > the error, educate me how to use it for trouble shooting.
>> >> >
>> >> > Arun
>> >> > --
>> >> > "Knowledge grows when Shared"
>> >> > - Anonymous
>> >> >
>> >> >
>> >> > "John Bell" wrote:
>> >> >
>> >> >> Hi
>> >> >>
>> >> >> You may want to check MDAC is installed correctly see the component
>> >> >> checker
>> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> >> >>
>> >> >> John
>> >> >>
>> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> >> >> > Error Type:
>> >> >> > ADODB.Connection (0x800A0E7A)
>> >> >> > Provider cannot be found. It may not be properly installed.
>> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >> >> >
>> >> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
>> >> >> > Added
>> >> >> > to
>> >> >> > it...
>> >> >> >
>> >> >> > The Enterprise Manager is giving an error " Provider cannot be
>> >> >> > found.
>> >> >> > It
>> >> >> > may
>> >> >> > not be properly installed."
>> >> >> >
>> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
>> >> >> > given
>> >> >> > by
>> >> >> > the system support people is to reformat my system.
>> >> >> >
>> >> >> > Arun
>> >> >> >
>> >> >> > --
>> >> >> > "Knowledge grows when Shared"
>> >> >> > - Anonymous
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Hi
Can you confirm that other workstations are working ok?
You may want to try re-installing the client tools.
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...
> Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing
> is
> happening.
> I wouldn't want to c my system getting formatted for this system...some1
> HELP!!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "Dan Guzman" wrote:
>> The component checker will usually detect problems with installed
>> components. You might try reinstalling the MDAC 2.8 SP1.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
>> > I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
>> >
>> > What else could be the problem...!!!
>> >
>> > Arun
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>> >
>> >
>> > "John Bell" wrote:
>> >
>> >> Hi
>> >>
>> >> If you run the component checker it will show you the dlls installed
>> >> and
>> >> what version they are at. If you are at a version less than 2.8 SP1
>> >> then
>> >> you
>> >> may want to consider trying an upgrade.
>> >>
>> >> John
>> >>
>> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>> >> > John
>> >> >
>> >> > I have already installed Component Checker, do let me know where do
>> >> > i
>> >> > find
>> >> > the error, educate me how to use it for trouble shooting.
>> >> >
>> >> > Arun
>> >> > --
>> >> > "Knowledge grows when Shared"
>> >> > - Anonymous
>> >> >
>> >> >
>> >> > "John Bell" wrote:
>> >> >
>> >> >> Hi
>> >> >>
>> >> >> You may want to check MDAC is installed correctly see the component
>> >> >> checker
>> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> >> >>
>> >> >> John
>> >> >>
>> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> >> >> > Error Type:
>> >> >> > ADODB.Connection (0x800A0E7A)
>> >> >> > Provider cannot be found. It may not be properly installed.
>> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >> >> >
>> >> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
>> >> >> > Added
>> >> >> > to
>> >> >> > it...
>> >> >> >
>> >> >> > The Enterprise Manager is giving an error " Provider cannot be
>> >> >> > found.
>> >> >> > It
>> >> >> > may
>> >> >> > not be properly installed."
>> >> >> >
>> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
>> >> >> > given
>> >> >> > by
>> >> >> > the system support people is to reformat my system.
>> >> >> >
>> >> >> > Arun
>> >> >> >
>> >> >> > --
>> >> >> > "Knowledge grows when Shared"
>> >> >> > - Anonymous
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Tried with my neighbours system, found to be working fine. But the error is
ONLY
with my system.
The application is in my system and the database is in different workstation
- DAN this is FYI
Arun
--
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> Can you confirm that other workstations are working ok?
> You may want to try re-installing the client tools.
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...
> > Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing
> > is
> > happening.
> >
> > I wouldn't want to c my system getting formatted for this system...some1
> > HELP!!!!
> >
> > Arun
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
> >
> >
> > "Dan Guzman" wrote:
> >
> >> The component checker will usually detect problems with installed
> >> components. You might try reinstalling the MDAC 2.8 SP1.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
> >> > I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
> >> >
> >> > What else could be the problem...!!!
> >> >
> >> > Arun
> >> > --
> >> > "Knowledge grows when Shared"
> >> > - Anonymous
> >> >
> >> >
> >> > "John Bell" wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> If you run the component checker it will show you the dlls installed
> >> >> and
> >> >> what version they are at. If you are at a version less than 2.8 SP1
> >> >> then
> >> >> you
> >> >> may want to consider trying an upgrade.
> >> >>
> >> >> John
> >> >>
> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
> >> >> > John
> >> >> >
> >> >> > I have already installed Component Checker, do let me know where do
> >> >> > i
> >> >> > find
> >> >> > the error, educate me how to use it for trouble shooting.
> >> >> >
> >> >> > Arun
> >> >> > --
> >> >> > "Knowledge grows when Shared"
> >> >> > - Anonymous
> >> >> >
> >> >> >
> >> >> > "John Bell" wrote:
> >> >> >
> >> >> >> Hi
> >> >> >>
> >> >> >> You may want to check MDAC is installed correctly see the component
> >> >> >> checker
> >> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
> >> >> >>
> >> >> >> John
> >> >> >>
> >> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> >> >> >> > Error Type:
> >> >> >> > ADODB.Connection (0x800A0E7A)
> >> >> >> > Provider cannot be found. It may not be properly installed.
> >> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
> >> >> >> >
> >> >> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
> >> >> >> > Added
> >> >> >> > to
> >> >> >> > it...
> >> >> >> >
> >> >> >> > The Enterprise Manager is giving an error " Provider cannot be
> >> >> >> > found.
> >> >> >> > It
> >> >> >> > may
> >> >> >> > not be properly installed."
> >> >> >> >
> >> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
> >> >> >> > given
> >> >> >> > by
> >> >> >> > the system support people is to reformat my system.
> >> >> >> >
> >> >> >> > Arun
> >> >> >> >
> >> >> >> > --
> >> >> >> > "Knowledge grows when Shared"
> >> >> >> > - Anonymous
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||> The application is in my system and the database is in different
> workstation
> - DAN this is FYI
I just wanted to make sure that you are doing this the client rather than
the server.
I've never run into a situation where an errant MDAC installation wasn't
identified by the component checker. I don't have any other suggestions
other than those already provided.
Unless someone else chimes in, you might take the advise of the system
support people and repave. As painful as that is, it might be the most
expedient solution.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:09442D27-7968-42F8-ABC2-D98E9F860374@.microsoft.com...
> Tried with my neighbours system, found to be working fine. But the error
> is
> ONLY
> with my system.
> The application is in my system and the database is in different
> workstation
> - DAN this is FYI
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
>> Hi
>> Can you confirm that other workstations are working ok?
>> You may want to try re-installing the client tools.
>> John
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...
>> > Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but
>> > nothing
>> > is
>> > happening.
>> >
>> > I wouldn't want to c my system getting formatted for this
>> > system...some1
>> > HELP!!!!
>> >
>> > Arun
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>> >
>> >
>> > "Dan Guzman" wrote:
>> >
>> >> The component checker will usually detect problems with installed
>> >> components. You might try reinstalling the MDAC 2.8 SP1.
>> >>
>> >> --
>> >> Hope this helps.
>> >>
>> >> Dan Guzman
>> >> SQL Server MVP
>> >>
>> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
>> >> > I'm having MDAC 2.8 SP1...It is giving me the Product Release
>> >> > matches.
>> >> >
>> >> > What else could be the problem...!!!
>> >> >
>> >> > Arun
>> >> > --
>> >> > "Knowledge grows when Shared"
>> >> > - Anonymous
>> >> >
>> >> >
>> >> > "John Bell" wrote:
>> >> >
>> >> >> Hi
>> >> >>
>> >> >> If you run the component checker it will show you the dlls
>> >> >> installed
>> >> >> and
>> >> >> what version they are at. If you are at a version less than 2.8 SP1
>> >> >> then
>> >> >> you
>> >> >> may want to consider trying an upgrade.
>> >> >>
>> >> >> John
>> >> >>
>> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>> >> >> > John
>> >> >> >
>> >> >> > I have already installed Component Checker, do let me know where
>> >> >> > do
>> >> >> > i
>> >> >> > find
>> >> >> > the error, educate me how to use it for trouble shooting.
>> >> >> >
>> >> >> > Arun
>> >> >> > --
>> >> >> > "Knowledge grows when Shared"
>> >> >> > - Anonymous
>> >> >> >
>> >> >> >
>> >> >> > "John Bell" wrote:
>> >> >> >
>> >> >> >> Hi
>> >> >> >>
>> >> >> >> You may want to check MDAC is installed correctly see the
>> >> >> >> component
>> >> >> >> checker
>> >> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> >> >> >>
>> >> >> >> John
>> >> >> >>
>> >> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> >> >> >> > Error Type:
>> >> >> >> > ADODB.Connection (0x800A0E7A)
>> >> >> >> > Provider cannot be found. It may not be properly installed.
>> >> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >> >> >> >
>> >> >> >> > Even registering the dll "sqloledb.dll" didn't fix the
>> >> >> >> > problem.
>> >> >> >> > Added
>> >> >> >> > to
>> >> >> >> > it...
>> >> >> >> >
>> >> >> >> > The Enterprise Manager is giving an error " Provider cannot be
>> >> >> >> > found.
>> >> >> >> > It
>> >> >> >> > may
>> >> >> >> > not be properly installed."
>> >> >> >> >
>> >> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the
>> >> >> >> > fix
>> >> >> >> > given
>> >> >> >> > by
>> >> >> >> > the system support people is to reformat my system.
>> >> >> >> >
>> >> >> >> > Arun
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> > "Knowledge grows when Shared"
>> >> >> >> > - Anonymous
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/visastatus/NewEmpVisaDetails.asp, line 35
Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
it...
The Enterprise Manager is giving an error " Provider cannot be found. It may
not be properly installed."
Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
the system support people is to reformat my system.
Arun
--
"Knowledge grows when Shared"
- AnonymousWhat does your connection string look like? It will probably have the word
provider in it.
--
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
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> Error Type:
> ADODB.Connection (0x800A0E7A)
> Provider cannot be found. It may not be properly installed.
> /visastatus/NewEmpVisaDetails.asp, line 35
> Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> it...
> The Enterprise Manager is giving an error " Provider cannot be found. It
> may
> not be properly installed."
> Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> the system support people is to reformat my system.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous|||Hi
You may want to check MDAC is installed correctly see the component checker
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> Error Type:
> ADODB.Connection (0x800A0E7A)
> Provider cannot be found. It may not be properly installed.
> /visastatus/NewEmpVisaDetails.asp, line 35
> Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> it...
> The Enterprise Manager is giving an error " Provider cannot be found. It
> may
> not be properly installed."
> Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> the system support people is to reformat my system.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous|||Cotter
Yep ur right it does house the word Provider in the connection, but i was
able to establish the connection previously.
Would that affect my enterprise manager too, even when i right click on a
table and when i choose return all rows it is giving me a "Provider...not
installed".
Rather it is a problem with the SQL(Enterprise manager) rather than the
connection string...(Guess so!), if not let me know how do i modify the
connection string.
Here is how my connection string looks
set objConn=Server.CreateObject("ADODB.CONNECTION")
objConn.Open "Provider=SQLOLEDB;data Source=<my server>;Initial Catalog=<my
database>;User Id= <id> ;Password= pwd"
"Knowledge grows when Shared"
- Anonymous
"Hilary Cotter" wrote:
> What does your connection string look like? It will probably have the word
> provider in it.
> --
> 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
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> > Error Type:
> > ADODB.Connection (0x800A0E7A)
> > Provider cannot be found. It may not be properly installed.
> > /visastatus/NewEmpVisaDetails.asp, line 35
> >
> > Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> > it...
> >
> > The Enterprise Manager is giving an error " Provider cannot be found. It
> > may
> > not be properly installed."
> >
> > Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> > the system support people is to reformat my system.
> >
> > Arun
> >
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
>
>|||John
I have already installed Component Checker, do let me know where do i find
the error, educate me how to use it for trouble shooting.
Arun
--
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> You may want to check MDAC is installed correctly see the component checker
> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> > Error Type:
> > ADODB.Connection (0x800A0E7A)
> > Provider cannot be found. It may not be properly installed.
> > /visastatus/NewEmpVisaDetails.asp, line 35
> >
> > Even registering the dll "sqloledb.dll" didn't fix the problem. Added to
> > it...
> >
> > The Enterprise Manager is giving an error " Provider cannot be found. It
> > may
> > not be properly installed."
> >
> > Do let me know the fix, i have reinstalled the SQL 2000, the fix given by
> > the system support people is to reformat my system.
> >
> > Arun
> >
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
>
>|||Hi
If you run the component checker it will show you the dlls installed and
what version they are at. If you are at a version less than 2.8 SP1 then you
may want to consider trying an upgrade.
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
> John
> I have already installed Component Checker, do let me know where do i find
> the error, educate me how to use it for trouble shooting.
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
>> Hi
>> You may want to check MDAC is installed correctly see the component
>> checker
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> John
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> > Error Type:
>> > ADODB.Connection (0x800A0E7A)
>> > Provider cannot be found. It may not be properly installed.
>> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >
>> > Even registering the dll "sqloledb.dll" didn't fix the problem. Added
>> > to
>> > it...
>> >
>> > The Enterprise Manager is giving an error " Provider cannot be found.
>> > It
>> > may
>> > not be properly installed."
>> >
>> > Do let me know the fix, i have reinstalled the SQL 2000, the fix given
>> > by
>> > the system support people is to reformat my system.
>> >
>> > Arun
>> >
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>>|||I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
What else could be the problem...!!!
Arun
--
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> If you run the component checker it will show you the dlls installed and
> what version they are at. If you are at a version less than 2.8 SP1 then you
> may want to consider trying an upgrade.
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
> > John
> >
> > I have already installed Component Checker, do let me know where do i find
> > the error, educate me how to use it for trouble shooting.
> >
> > Arun
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
> >
> >
> > "John Bell" wrote:
> >
> >> Hi
> >>
> >> You may want to check MDAC is installed correctly see the component
> >> checker
> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
> >>
> >> John
> >>
> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> >> > Error Type:
> >> > ADODB.Connection (0x800A0E7A)
> >> > Provider cannot be found. It may not be properly installed.
> >> > /visastatus/NewEmpVisaDetails.asp, line 35
> >> >
> >> > Even registering the dll "sqloledb.dll" didn't fix the problem. Added
> >> > to
> >> > it...
> >> >
> >> > The Enterprise Manager is giving an error " Provider cannot be found.
> >> > It
> >> > may
> >> > not be properly installed."
> >> >
> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix given
> >> > by
> >> > the system support people is to reformat my system.
> >> >
> >> > Arun
> >> >
> >> > --
> >> > "Knowledge grows when Shared"
> >> > - Anonymous
> >>
> >>
> >>
>
>|||The component checker will usually detect problems with installed
components. You might try reinstalling the MDAC 2.8 SP1.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
> I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
> What else could be the problem...!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
>> Hi
>> If you run the component checker it will show you the dlls installed and
>> what version they are at. If you are at a version less than 2.8 SP1 then
>> you
>> may want to consider trying an upgrade.
>> John
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>> > John
>> >
>> > I have already installed Component Checker, do let me know where do i
>> > find
>> > the error, educate me how to use it for trouble shooting.
>> >
>> > Arun
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>> >
>> >
>> > "John Bell" wrote:
>> >
>> >> Hi
>> >>
>> >> You may want to check MDAC is installed correctly see the component
>> >> checker
>> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> >>
>> >> John
>> >>
>> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> >> > Error Type:
>> >> > ADODB.Connection (0x800A0E7A)
>> >> > Provider cannot be found. It may not be properly installed.
>> >> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >> >
>> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
>> >> > Added
>> >> > to
>> >> > it...
>> >> >
>> >> > The Enterprise Manager is giving an error " Provider cannot be
>> >> > found.
>> >> > It
>> >> > may
>> >> > not be properly installed."
>> >> >
>> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
>> >> > given
>> >> > by
>> >> > the system support people is to reformat my system.
>> >> >
>> >> > Arun
>> >> >
>> >> > --
>> >> > "Knowledge grows when Shared"
>> >> > - Anonymous
>> >>
>> >>
>> >>
>>|||Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing is
happening.
I wouldn't want to c my system getting formatted for this system...some1
HELP!!!!
Arun
--
"Knowledge grows when Shared"
- Anonymous
"Dan Guzman" wrote:
> The component checker will usually detect problems with installed
> components. You might try reinstalling the MDAC 2.8 SP1.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
> > I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
> >
> > What else could be the problem...!!!
> >
> > Arun
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
> >
> >
> > "John Bell" wrote:
> >
> >> Hi
> >>
> >> If you run the component checker it will show you the dlls installed and
> >> what version they are at. If you are at a version less than 2.8 SP1 then
> >> you
> >> may want to consider trying an upgrade.
> >>
> >> John
> >>
> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
> >> > John
> >> >
> >> > I have already installed Component Checker, do let me know where do i
> >> > find
> >> > the error, educate me how to use it for trouble shooting.
> >> >
> >> > Arun
> >> > --
> >> > "Knowledge grows when Shared"
> >> > - Anonymous
> >> >
> >> >
> >> > "John Bell" wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> You may want to check MDAC is installed correctly see the component
> >> >> checker
> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
> >> >>
> >> >> John
> >> >>
> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> >> >> > Error Type:
> >> >> > ADODB.Connection (0x800A0E7A)
> >> >> > Provider cannot be found. It may not be properly installed.
> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
> >> >> >
> >> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
> >> >> > Added
> >> >> > to
> >> >> > it...
> >> >> >
> >> >> > The Enterprise Manager is giving an error " Provider cannot be
> >> >> > found.
> >> >> > It
> >> >> > may
> >> >> > not be properly installed."
> >> >> >
> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
> >> >> > given
> >> >> > by
> >> >> > the system support people is to reformat my system.
> >> >> >
> >> >> > Arun
> >> >> >
> >> >> > --
> >> >> > "Knowledge grows when Shared"
> >> >> > - Anonymous
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||It's strange that the component checker didn't detect an error so server
that both ODBC and SQLOLEDB providers are not found. Do all components
match? Did you reboot after the MDAC reinstall?
Just to be clear, if SQL Server and your application are running on a
different machines, you should be focusing on the client box rather than the
database server.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...
> Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing
> is
> happening.
> I wouldn't want to c my system getting formatted for this system...some1
> HELP!!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "Dan Guzman" wrote:
>> The component checker will usually detect problems with installed
>> components. You might try reinstalling the MDAC 2.8 SP1.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
>> > I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
>> >
>> > What else could be the problem...!!!
>> >
>> > Arun
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>> >
>> >
>> > "John Bell" wrote:
>> >
>> >> Hi
>> >>
>> >> If you run the component checker it will show you the dlls installed
>> >> and
>> >> what version they are at. If you are at a version less than 2.8 SP1
>> >> then
>> >> you
>> >> may want to consider trying an upgrade.
>> >>
>> >> John
>> >>
>> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>> >> > John
>> >> >
>> >> > I have already installed Component Checker, do let me know where do
>> >> > i
>> >> > find
>> >> > the error, educate me how to use it for trouble shooting.
>> >> >
>> >> > Arun
>> >> > --
>> >> > "Knowledge grows when Shared"
>> >> > - Anonymous
>> >> >
>> >> >
>> >> > "John Bell" wrote:
>> >> >
>> >> >> Hi
>> >> >>
>> >> >> You may want to check MDAC is installed correctly see the component
>> >> >> checker
>> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> >> >>
>> >> >> John
>> >> >>
>> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> >> >> > Error Type:
>> >> >> > ADODB.Connection (0x800A0E7A)
>> >> >> > Provider cannot be found. It may not be properly installed.
>> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >> >> >
>> >> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
>> >> >> > Added
>> >> >> > to
>> >> >> > it...
>> >> >> >
>> >> >> > The Enterprise Manager is giving an error " Provider cannot be
>> >> >> > found.
>> >> >> > It
>> >> >> > may
>> >> >> > not be properly installed."
>> >> >> >
>> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
>> >> >> > given
>> >> >> > by
>> >> >> > the system support people is to reformat my system.
>> >> >> >
>> >> >> > Arun
>> >> >> >
>> >> >> > --
>> >> >> > "Knowledge grows when Shared"
>> >> >> > - Anonymous
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Hi
Can you confirm that other workstations are working ok?
You may want to try re-installing the client tools.
John
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...
> Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing
> is
> happening.
> I wouldn't want to c my system getting formatted for this system...some1
> HELP!!!!
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "Dan Guzman" wrote:
>> The component checker will usually detect problems with installed
>> components. You might try reinstalling the MDAC 2.8 SP1.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
>> > I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
>> >
>> > What else could be the problem...!!!
>> >
>> > Arun
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>> >
>> >
>> > "John Bell" wrote:
>> >
>> >> Hi
>> >>
>> >> If you run the component checker it will show you the dlls installed
>> >> and
>> >> what version they are at. If you are at a version less than 2.8 SP1
>> >> then
>> >> you
>> >> may want to consider trying an upgrade.
>> >>
>> >> John
>> >>
>> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>> >> > John
>> >> >
>> >> > I have already installed Component Checker, do let me know where do
>> >> > i
>> >> > find
>> >> > the error, educate me how to use it for trouble shooting.
>> >> >
>> >> > Arun
>> >> > --
>> >> > "Knowledge grows when Shared"
>> >> > - Anonymous
>> >> >
>> >> >
>> >> > "John Bell" wrote:
>> >> >
>> >> >> Hi
>> >> >>
>> >> >> You may want to check MDAC is installed correctly see the component
>> >> >> checker
>> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> >> >>
>> >> >> John
>> >> >>
>> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> >> >> > Error Type:
>> >> >> > ADODB.Connection (0x800A0E7A)
>> >> >> > Provider cannot be found. It may not be properly installed.
>> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >> >> >
>> >> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
>> >> >> > Added
>> >> >> > to
>> >> >> > it...
>> >> >> >
>> >> >> > The Enterprise Manager is giving an error " Provider cannot be
>> >> >> > found.
>> >> >> > It
>> >> >> > may
>> >> >> > not be properly installed."
>> >> >> >
>> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
>> >> >> > given
>> >> >> > by
>> >> >> > the system support people is to reformat my system.
>> >> >> >
>> >> >> > Arun
>> >> >> >
>> >> >> > --
>> >> >> > "Knowledge grows when Shared"
>> >> >> > - Anonymous
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Tried with my neighbours system, found to be working fine. But the error is
ONLY
with my system.
The application is in my system and the database is in different workstation
- DAN this is FYI
Arun
--
"Knowledge grows when Shared"
- Anonymous
"John Bell" wrote:
> Hi
> Can you confirm that other workstations are working ok?
> You may want to try re-installing the client tools.
> John
> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...
> > Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but nothing
> > is
> > happening.
> >
> > I wouldn't want to c my system getting formatted for this system...some1
> > HELP!!!!
> >
> > Arun
> > --
> > "Knowledge grows when Shared"
> > - Anonymous
> >
> >
> > "Dan Guzman" wrote:
> >
> >> The component checker will usually detect problems with installed
> >> components. You might try reinstalling the MDAC 2.8 SP1.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
> >> > I'm having MDAC 2.8 SP1...It is giving me the Product Release matches.
> >> >
> >> > What else could be the problem...!!!
> >> >
> >> > Arun
> >> > --
> >> > "Knowledge grows when Shared"
> >> > - Anonymous
> >> >
> >> >
> >> > "John Bell" wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> If you run the component checker it will show you the dlls installed
> >> >> and
> >> >> what version they are at. If you are at a version less than 2.8 SP1
> >> >> then
> >> >> you
> >> >> may want to consider trying an upgrade.
> >> >>
> >> >> John
> >> >>
> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
> >> >> > John
> >> >> >
> >> >> > I have already installed Component Checker, do let me know where do
> >> >> > i
> >> >> > find
> >> >> > the error, educate me how to use it for trouble shooting.
> >> >> >
> >> >> > Arun
> >> >> > --
> >> >> > "Knowledge grows when Shared"
> >> >> > - Anonymous
> >> >> >
> >> >> >
> >> >> > "John Bell" wrote:
> >> >> >
> >> >> >> Hi
> >> >> >>
> >> >> >> You may want to check MDAC is installed correctly see the component
> >> >> >> checker
> >> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
> >> >> >>
> >> >> >> John
> >> >> >>
> >> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
> >> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
> >> >> >> > Error Type:
> >> >> >> > ADODB.Connection (0x800A0E7A)
> >> >> >> > Provider cannot be found. It may not be properly installed.
> >> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
> >> >> >> >
> >> >> >> > Even registering the dll "sqloledb.dll" didn't fix the problem.
> >> >> >> > Added
> >> >> >> > to
> >> >> >> > it...
> >> >> >> >
> >> >> >> > The Enterprise Manager is giving an error " Provider cannot be
> >> >> >> > found.
> >> >> >> > It
> >> >> >> > may
> >> >> >> > not be properly installed."
> >> >> >> >
> >> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the fix
> >> >> >> > given
> >> >> >> > by
> >> >> >> > the system support people is to reformat my system.
> >> >> >> >
> >> >> >> > Arun
> >> >> >> >
> >> >> >> > --
> >> >> >> > "Knowledge grows when Shared"
> >> >> >> > - Anonymous
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||> The application is in my system and the database is in different
> workstation
> - DAN this is FYI
I just wanted to make sure that you are doing this the client rather than
the server.
I've never run into a situation where an errant MDAC installation wasn't
identified by the component checker. I don't have any other suggestions
other than those already provided.
Unless someone else chimes in, you might take the advise of the system
support people and repave. As painful as that is, it might be the most
expedient solution.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
news:09442D27-7968-42F8-ABC2-D98E9F860374@.microsoft.com...
> Tried with my neighbours system, found to be working fine. But the error
> is
> ONLY
> with my system.
> The application is in my system and the database is in different
> workstation
> - DAN this is FYI
> Arun
> --
> "Knowledge grows when Shared"
> - Anonymous
>
> "John Bell" wrote:
>> Hi
>> Can you confirm that other workstations are working ok?
>> You may want to try re-installing the client tools.
>> John
>> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> news:C4D95659-D871-4939-9BE3-45631F8AA1B7@.microsoft.com...
>> > Forgive me i have done that 2...reinstalled the SQL, MDAC 2.8, but
>> > nothing
>> > is
>> > happening.
>> >
>> > I wouldn't want to c my system getting formatted for this
>> > system...some1
>> > HELP!!!!
>> >
>> > Arun
>> > --
>> > "Knowledge grows when Shared"
>> > - Anonymous
>> >
>> >
>> > "Dan Guzman" wrote:
>> >
>> >> The component checker will usually detect problems with installed
>> >> components. You might try reinstalling the MDAC 2.8 SP1.
>> >>
>> >> --
>> >> Hope this helps.
>> >>
>> >> Dan Guzman
>> >> SQL Server MVP
>> >>
>> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> news:A7F3B556-4CDC-49F9-AAB9-3842A02E1AAF@.microsoft.com...
>> >> > I'm having MDAC 2.8 SP1...It is giving me the Product Release
>> >> > matches.
>> >> >
>> >> > What else could be the problem...!!!
>> >> >
>> >> > Arun
>> >> > --
>> >> > "Knowledge grows when Shared"
>> >> > - Anonymous
>> >> >
>> >> >
>> >> > "John Bell" wrote:
>> >> >
>> >> >> Hi
>> >> >>
>> >> >> If you run the component checker it will show you the dlls
>> >> >> installed
>> >> >> and
>> >> >> what version they are at. If you are at a version less than 2.8 SP1
>> >> >> then
>> >> >> you
>> >> >> may want to consider trying an upgrade.
>> >> >>
>> >> >> John
>> >> >>
>> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in message
>> >> >> news:689B1660-DB62-4B85-B63B-7B8CD27F8C94@.microsoft.com...
>> >> >> > John
>> >> >> >
>> >> >> > I have already installed Component Checker, do let me know where
>> >> >> > do
>> >> >> > i
>> >> >> > find
>> >> >> > the error, educate me how to use it for trouble shooting.
>> >> >> >
>> >> >> > Arun
>> >> >> > --
>> >> >> > "Knowledge grows when Shared"
>> >> >> > - Anonymous
>> >> >> >
>> >> >> >
>> >> >> > "John Bell" wrote:
>> >> >> >
>> >> >> >> Hi
>> >> >> >>
>> >> >> >> You may want to check MDAC is installed correctly see the
>> >> >> >> component
>> >> >> >> checker
>> >> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en
>> >> >> >>
>> >> >> >> John
>> >> >> >>
>> >> >> >> "Arunkumar" <Arunkumar@.discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:41DF7DCA-0843-4635-B61C-3E133B760223@.microsoft.com...
>> >> >> >> > Error Type:
>> >> >> >> > ADODB.Connection (0x800A0E7A)
>> >> >> >> > Provider cannot be found. It may not be properly installed.
>> >> >> >> > /visastatus/NewEmpVisaDetails.asp, line 35
>> >> >> >> >
>> >> >> >> > Even registering the dll "sqloledb.dll" didn't fix the
>> >> >> >> > problem.
>> >> >> >> > Added
>> >> >> >> > to
>> >> >> >> > it...
>> >> >> >> >
>> >> >> >> > The Enterprise Manager is giving an error " Provider cannot be
>> >> >> >> > found.
>> >> >> >> > It
>> >> >> >> > may
>> >> >> >> > not be properly installed."
>> >> >> >> >
>> >> >> >> > Do let me know the fix, i have reinstalled the SQL 2000, the
>> >> >> >> > fix
>> >> >> >> > given
>> >> >> >> > by
>> >> >> >> > the system support people is to reformat my system.
>> >> >> >> >
>> >> >> >> > Arun
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> > "Knowledge grows when Shared"
>> >> >> >> > - Anonymous
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
Subscribe to:
Posts (Atom)