> I can not see tables using VB6 Data View.    I can establish a connection
to
> the Northwind database on the SQL 2k server machine, but under
"Datalink1",
> if I click the plus sign in front of tables, I get nothing.  The plus sign
> disappears.  This is true for 'Database Diagrams', 'Views', etc...

> Test Connection reveals connection succeeded, and connection1 =
(connected)
> is displayed on the bottom bar of the dataview window.

> [ MDAC 2.6 sp1; SQL 2000 sp2; VB 6 sp5; Office SR-1a; SQL Client Tools
> installed on workstation.; MS OLE DB Provider for SQL Server (version
> unknown, but assuming same as server since SQL 2000 Client Tools are
> installed on workstation)  All real-time virus scanning software disabled
on
> workstation and server. ]

> I don't care about loosing SQL 2000 features, I just need this to work
> again.  Am I SOL for upgrading to SQL 2k?  Can I get the DataEnvironment
in
> VB6 to show me the SQL server tables again?

> (also)
> I cannot get this to function correctly in Access 2000 either.
> Performing the following:
>   1)  Launch Access 2000
>   2)  Choose Create a New Database Using Access Database Wizards, Pages
and
> Projects from the opening dialog box.
>   3)  Choose the General tab in New dialog box
>   4)  Choose the icon for Project (Existing Database) and click OK
>   5)  Assign a name to your project and click Create
>        [I save to mydocuments on local drive]
>   6)  Enter you SQL Server name, authentication information, and database
> name in the Data Link Properties dialog box, and click ok.  [I log in as
> 'sa' and use northwind for the database]

> Again, I can see no tables.  Only the new table wizard.

> If I recall correctly you need MDAC .7 for SQL2000, there was some
> undocumented features with 2.6 and SQL2000.

> Cheers,
> Maartin.

> > I can not see tables using VB6 Data View.    I can establish a
connection
> to
> > the Northwind database on the SQL 2k server machine, but under
> "Datalink1",
> > if I click the plus sign in front of tables, I get nothing.  The plus
sign
> > disappears.  This is true for 'Database Diagrams', 'Views', etc...

> > Test Connection reveals connection succeeded, and connection1 =
> (connected)
> > is displayed on the bottom bar of the dataview window.

> > [ MDAC 2.6 sp1; SQL 2000 sp2; VB 6 sp5; Office SR-1a; SQL Client Tools
> > installed on workstation.; MS OLE DB Provider for SQL Server (version
> > unknown, but assuming same as server since SQL 2000 Client Tools are
> > installed on workstation)  All real-time virus scanning software
disabled
> on
> > workstation and server. ]

> > I don't care about loosing SQL 2000 features, I just need this to work
> > again.  Am I SOL for upgrading to SQL 2k?  Can I get the DataEnvironment
> in
> > VB6 to show me the SQL server tables again?

> > (also)
> > I cannot get this to function correctly in Access 2000 either.
> > Performing the following:
> >   1)  Launch Access 2000
> >   2)  Choose Create a New Database Using Access Database Wizards, Pages
> and
> > Projects from the opening dialog box.
> >   3)  Choose the General tab in New dialog box
> >   4)  Choose the icon for Project (Existing Database) and click OK
> >   5)  Assign a name to your project and click Create
> >        [I save to mydocuments on local drive]
> >   6)  Enter you SQL Server name, authentication information, and
database
> > name in the Data Link Properties dialog box, and click ok.  [I log in as
> > 'sa' and use northwind for the database]

> > Again, I can see no tables.  Only the new table wizard.

> Sorry if this is a stupid question, but should I install 2.7 on the server
> as well as the client?

> > If I recall correctly you need MDAC .7 for SQL2000, there was some
> > undocumented features with 2.6 and SQL2000.

> > Cheers,
> > Maartin.

> > > I can not see tables using VB6 Data View.    I can establish a
> connection
> > to
> > > the Northwind database on the SQL 2k server machine, but under
> > "Datalink1",
> > > if I click the plus sign in front of tables, I get nothing.  The plus
> sign
> > > disappears.  This is true for 'Database Diagrams', 'Views', etc...

> > > Test Connection reveals connection succeeded, and connection1 =
> > (connected)
> > > is displayed on the bottom bar of the dataview window.

> > > [ MDAC 2.6 sp1; SQL 2000 sp2; VB 6 sp5; Office SR-1a; SQL Client Tools
> > > installed on workstation.; MS OLE DB Provider for SQL Server (version
> > > unknown, but assuming same as server since SQL 2000 Client Tools are
> > > installed on workstation)  All real-time virus scanning software
> disabled
> > on
> > > workstation and server. ]

> > > I don't care about loosing SQL 2000 features, I just need this to work
> > > again.  Am I SOL for upgrading to SQL 2k?  Can I get the
DataEnvironment
> > in
> > > VB6 to show me the SQL server tables again?

> > > (also)
> > > I cannot get this to function correctly in Access 2000 either.
> > > Performing the following:
> > >   1)  Launch Access 2000
> > >   2)  Choose Create a New Database Using Access Database Wizards,
Pages
> > and
> > > Projects from the opening dialog box.
> > >   3)  Choose the General tab in New dialog box
> > >   4)  Choose the icon for Project (Existing Database) and click OK
> > >   5)  Assign a name to your project and click Create
> > >        [I save to mydocuments on local drive]
> > >   6)  Enter you SQL Server name, authentication information, and
> database
> > > name in the Data Link Properties dialog box, and click ok.  [I log in
as
> > > 'sa' and use northwind for the database]

> > > Again, I can see no tables.  Only the new table wizard.

> Sorry if this is a stupid question, but should I install 2.7 on the server
> as well as the client?

> > If I recall correctly you need MDAC .7 for SQL2000, there was some
> > undocumented features with 2.6 and SQL2000.

> > Cheers,
> > Maartin.

> > > I can not see tables using VB6 Data View.    I can establish a
> connection
> > to
> > > the Northwind database on the SQL 2k server machine, but under
> > "Datalink1",
> > > if I click the plus sign in front of tables, I get nothing.  The plus
> sign
> > > disappears.  This is true for 'Database Diagrams', 'Views', etc...

> > > Test Connection reveals connection succeeded, and connection1 =
> > (connected)
> > > is displayed on the bottom bar of the dataview window.

> > > [ MDAC 2.6 sp1; SQL 2000 sp2; VB 6 sp5; Office SR-1a; SQL Client Tools
> > > installed on workstation.; MS OLE DB Provider for SQL Server (version
> > > unknown, but assuming same as server since SQL 2000 Client Tools are
> > > installed on workstation)  All real-time virus scanning software
> disabled
> > on
> > > workstation and server. ]

> > > I don't care about loosing SQL 2000 features, I just need this to work
> > > again.  Am I SOL for upgrading to SQL 2k?  Can I get the
DataEnvironment
> > in
> > > VB6 to show me the SQL server tables again?

> > > (also)
> > > I cannot get this to function correctly in Access 2000 either.
> > > Performing the following:
> > >   1)  Launch Access 2000
> > >   2)  Choose Create a New Database Using Access Database Wizards,
Pages
> > and
> > > Projects from the opening dialog box.
> > >   3)  Choose the General tab in New dialog box
> > >   4)  Choose the icon for Project (Existing Database) and click OK
> > >   5)  Assign a name to your project and click Create
> > >        [I save to mydocuments on local drive]
> > >   6)  Enter you SQL Server name, authentication information, and
> database
> > > name in the Data Link Properties dialog box, and click ok.  [I log in
as
> > > 'sa' and use northwind for the database]

> > > Again, I can see no tables.  Only the new table wizard.

> Unfortunately, that didn't fix the problem either.  When in the data view
> window, if I right click on tables, I see the following fly out menu:
> (following the steps I mentioned previously)

>     Refresh
>     --------
>     Dockable
>     Hide
>     ---------
>     Show System Objects
>     Filter by owner

> No, New...  etc...

> I'm wondering if I should uninstall and reinstall VS6 altogether.

> One thing I did notice when I created a new project is that, in the Data
> View window, there was a data link from 3 days ago.  I have been exiting
and
> restarting VB every time I start a new project in an effort to clear it
out
> and sever any links which may be persisting.

> I'm stumped!

> no, only the client the server should be fine when you install SQL2K
mdac2.7
> is installed automatically.

> Don't worry are no such a thing as a stupid question. So ask away !!

> Cheers,
> Maartin.

> > Sorry if this is a stupid question, but should I install 2.7 on the
server
> > as well as the client?

> > > If I recall correctly you need MDAC .7 for SQL2000, there was some
> > > undocumented features with 2.6 and SQL2000.

> > > Cheers,
> > > Maartin.

> > > > I can not see tables using VB6 Data View.    I can establish a
> > connection
> > > to
> > > > the Northwind database on the SQL 2k server machine, but under
> > > "Datalink1",
> > > > if I click the plus sign in front of tables, I get nothing.  The
plus
> > sign
> > > > disappears.  This is true for 'Database Diagrams', 'Views', etc...

> > > > Test Connection reveals connection succeeded, and connection1 =
> > > (connected)
> > > > is displayed on the bottom bar of the dataview window.

> > > > [ MDAC 2.6 sp1; SQL 2000 sp2; VB 6 sp5; Office SR-1a; SQL Client
Tools
> > > > installed on workstation.; MS OLE DB Provider for SQL Server
(version
> > > > unknown, but assuming same as server since SQL 2000 Client Tools are
> > > > installed on workstation)  All real-time virus scanning software
> > disabled
> > > on
> > > > workstation and server. ]

> > > > I don't care about loosing SQL 2000 features, I just need this to
work
> > > > again.  Am I SOL for upgrading to SQL 2k?  Can I get the
> DataEnvironment
> > > in
> > > > VB6 to show me the SQL server tables again?

> > > > (also)
> > > > I cannot get this to function correctly in Access 2000 either.
> > > > Performing the following:
> > > >   1)  Launch Access 2000
> > > >   2)  Choose Create a New Database Using Access Database Wizards,
> Pages
> > > and
> > > > Projects from the opening dialog box.
> > > >   3)  Choose the General tab in New dialog box
> > > >   4)  Choose the icon for Project (Existing Database) and click OK
> > > >   5)  Assign a name to your project and click Create
> > > >        [I save to mydocuments on local drive]
> > > >   6)  Enter you SQL Server name, authentication information, and
> > database
> > > > name in the Data Link Properties dialog box, and click ok.  [I log
in
> as
> > > > 'sa' and use northwind for the database]

> > > > Again, I can see no tables.  Only the new table wizard.

> Unfortunately, that didn't fix the problem either.  When in the data view
> window, if I right click on tables, I see the following fly out menu:
> (following the steps I mentioned previously)

>     Refresh
>     --------
>     Dockable
>     Hide
>     ---------
>     Show System Objects
>     Filter by owner

> No, New...  etc...

> I'm wondering if I should uninstall and reinstall VS6 altogether.

> One thing I did notice when I created a new project is that, in the Data
> View window, there was a data link from 3 days ago.  I have been exiting
and
> restarting VB every time I start a new project in an effort to clear it
out
> and sever any links which may be persisting.

> I'm stumped!

> no, only the client the server should be fine when you install SQL2K
mdac2.7
> is installed automatically.

> Don't worry are no such a thing as a stupid question. So ask away !!

> Cheers,
> Maartin.

> > Sorry if this is a stupid question, but should I install 2.7 on the
server
> > as well as the client?

> > > If I recall correctly you need MDAC .7 for SQL2000, there was some
> > > undocumented features with 2.6 and SQL2000.

> > > Cheers,
> > > Maartin.

> > > > I can not see tables using VB6 Data View.    I can establish a
> > connection
> > > to
> > > > the Northwind database on the SQL 2k server machine, but under
> > > "Datalink1",
> > > > if I click the plus sign in front of tables, I get nothing.  The
plus
> > sign
> > > > disappears.  This is true for 'Database Diagrams', 'Views', etc...

> > > > Test Connection reveals connection succeeded, and connection1 =
> > > (connected)
> > > > is displayed on the bottom bar of the dataview window.

> > > > [ MDAC 2.6 sp1; SQL 2000 sp2; VB 6 sp5; Office SR-1a; SQL Client
Tools
> > > > installed on workstation.; MS OLE DB Provider for SQL Server
(version
> > > > unknown, but assuming same as server since SQL 2000 Client Tools are
> > > > installed on workstation)  All real-time virus scanning software
> > disabled
> > > on
> > > > workstation and server. ]

> > > > I don't care about loosing SQL 2000 features, I just need this to
work
> > > > again.  Am I SOL for upgrading to SQL 2k?  Can I get the
> DataEnvironment
> > > in
> > > > VB6 to show me the SQL server tables again?

> > > > (also)
> > > > I cannot get this to function correctly in Access 2000 either.
> > > > Performing the following:
> > > >   1)  Launch Access 2000
> > > >   2)  Choose Create a New Database Using Access Database Wizards,
> Pages
> > > and
> > > > Projects from the opening dialog box.
> > > >   3)  Choose the General tab in New dialog box
> > > >   4)  Choose the icon for Project (Existing Database) and click OK
> > > >   5)  Assign a name to your project and click Create
> > > >        [I save to mydocuments on local drive]
> > > >   6)  Enter you SQL Server name, authentication information, and
> > database
> > > > name in the Data Link Properties dialog box, and click ok.  [I log
in
> as
> > > > 'sa' and use northwind for the database]

> > > > Again, I can see no tables.  Only the new table wizard.

> You've got to be kidding, right?

> I hate to say it, but I do that too.  Thing is, I usually have to buy a
new
> hard drive to do it successfully in the least amount of time.  And I
usually
> wait until there is absolutely no other solution.  [about 9 - 18 mos]

> This is it for me and Microsoft.  I will not be upgrading to XP.  I will
not
> be upgrading to Visual Studio .NET.  Ever! (because it will only run on
> NT/XP)  Period.  I will not upgrade the servers in this office to .NET or
> whatever they are pushing now.  Forget it.

> Looks like it's going to be Mandrake or SuSe Linux as a replacement.  I am
> SO SICK AND TIRED OF MICROSOFT.

> ** Sorry about the soapbox, but does anyone know how to fix this problem?
I
> have seen the problem posted many many times, but no solutions.  Just
cries
> for help, like mine.

> Anybody have any clues at all?  MS KB Article Q266277 doesn't seem to want
> to cure the problem.

> How do,

> Have you installed the latest VS SP ? this might fix the problem.
> From experience in undocumented features in MS products I have learnt it
> does not always help to un-install and install.

> You prob might be fixed with a format c: and re-install all. I know this
is
> the last resort, but if I start to spot funny errors
> that I have never encountered before, I format and re-install all. My
> philosophy there are more serious errors on the way,
> so stop it before it gets worse.

> I as a rule format and re-install all about every 12 months, this also
> clears out all the junk that I forgot about.

> Cheers,
> Maartin.

> --------------------


> > Unfortunately, that didn't fix the problem either.  When in the data
view
> > window, if I right click on tables, I see the following fly out menu:
> > (following the steps I mentioned previously)

> >     Refresh
> >     --------
> >     Dockable
> >     Hide
> >     ---------
> >     Show System Objects
> >     Filter by owner

> > No, New...  etc...

> > I'm wondering if I should uninstall and reinstall VS6 altogether.

> > One thing I did notice when I created a new project is that, in the Data
> > View window, there was a data link from 3 days ago.  I have been exiting
> and
> > restarting VB every time I start a new project in an effort to clear it
> out
> > and sever any links which may be persisting.

> > I'm stumped!

> > no, only the client the server should be fine when you install SQL2K
> mdac2.7
> > is installed automatically.

> > Don't worry are no such a thing as a stupid question. So ask away !!

> > Cheers,
> > Maartin.

> > > Sorry if this is a stupid question, but should I install 2.7 on the
> server
> > > as well as the client?

> > > > If I recall correctly you need MDAC .7 for SQL2000, there was some
> > > > undocumented features with 2.6 and SQL2000.

> > > > Cheers,
> > > > Maartin.

> > > > > I can not see tables using VB6 Data View.    I can establish a
> > > connection
> > > > to
> > > > > the Northwind database on the SQL 2k server machine, but under
> > > > "Datalink1",
> > > > > if I click the plus sign in front of tables, I get nothing.  The
> plus
> > > sign
> > > > > disappears.  This is true for 'Database Diagrams', 'Views', etc...

> > > > > Test Connection reveals connection succeeded, and connection1 =
> > > > (connected)
> > > > > is displayed on the bottom bar of the dataview window.

> > > > > [ MDAC 2.6 sp1; SQL 2000 sp2; VB 6 sp5; Office SR-1a; SQL Client
> Tools
> > > > > installed on workstation.; MS OLE DB Provider for SQL Server
> (version
> > > > > unknown, but assuming same as server since SQL 2000 Client Tools
are
> > > > > installed on workstation)  All real-time virus scanning software
> > > disabled
> > > > on
> > > > > workstation and server. ]

> > > > > I don't care about loosing SQL 2000 features, I just need this to
> work
> > > > > again.  Am I SOL for upgrading to SQL 2k?  Can I get the
> > DataEnvironment
> > > > in
> > > > > VB6 to show me the SQL server tables again?

> > > > > (also)
> > > > > I cannot get this to function correctly in Access 2000 either.
> > > > > Performing the following:
> > > > >   1)  Launch Access 2000
> > > > >   2)  Choose Create a New Database Using Access Database Wizards,
> > Pages
> > > > and
> > > > > Projects from the opening dialog box.
> > > > >   3)  Choose the General tab in New dialog box
> > > > >   4)  Choose the icon for Project (Existing Database) and click OK
> > > > >   5)  Assign a name to your project and click Create
> > > > >        [I save to mydocuments on local drive]
> > > > >   6)  Enter you SQL Server name, authentication information, and
> > > database
> > > > > name in the Data Link Properties dialog box, and click ok.  [I log
> in
> > as
> > > > > 'sa' and use northwind for the database]

> > > > > Again, I can see no tables.  Only the new table wizard.

> You've got to be kidding, right?

> I hate to say it, but I do that too.  Thing is, I usually have to buy a
new
> hard drive to do it successfully in the least amount of time.  And I
usually
> wait until there is absolutely no other solution.  [about 9 - 18 mos]

> This is it for me and Microsoft.  I will not be upgrading to XP.  I will
not
> be upgrading to Visual Studio .NET.  Ever! (because it will only run on
> NT/XP)  Period.  I will not upgrade the servers in this office to .NET or
> whatever they are pushing now.  Forget it.

> Looks like it's going to be Mandrake or SuSe Linux as a replacement.  I am
> SO SICK AND TIRED OF MICROSOFT.

> ** Sorry about the soapbox, but does anyone know how to fix this problem?
I
> have seen the problem posted many many times, but no solutions.  Just
cries
> for help, like mine.

> Anybody have any clues at all?  MS KB Article Q266277 doesn't seem to want
> to cure the problem.

> How do,

> Have you installed the latest VS SP ? this might fix the problem.
> From experience in undocumented features in MS products I have learnt it
> does not always help to un-install and install.

> You prob might be fixed with a format c: and re-install all. I know this
is
> the last resort, but if I start to spot funny errors
> that I have never encountered before, I format and re-install all. My
> philosophy there are more serious errors on the way,
> so stop it before it gets worse.

> I as a rule format and re-install all about every 12 months, this also
> clears out all the junk that I forgot about.

> Cheers,
> Maartin.

> --------------------


> > Unfortunately, that didn't fix the problem either.  When in the data
view
> > window, if I right click on tables, I see the following fly out menu:
> > (following the steps I mentioned previously)

> >     Refresh
> >     --------
> >     Dockable
> >     Hide
> >     ---------
> >     Show System Objects
> >     Filter by owner

> > No, New...  etc...

> > I'm wondering if I should uninstall and reinstall VS6 altogether.

> > One thing I did notice when I created a new project is that, in the Data
> > View window, there was a data link from 3 days ago.  I have been exiting
> and
> > restarting VB every time I start a new project in an effort to clear it
> out
> > and sever any links which may be persisting.

> > I'm stumped!

> > no, only the client the server should be fine when you install SQL2K
> mdac2.7
> > is installed automatically.

> > Don't worry are no such a thing as a stupid question. So ask away !!

> > Cheers,
> > Maartin.

> > > Sorry if this is a stupid question, but should I install 2.7 on the
> server
> > > as well as the client?

> > > > If I recall correctly you need MDAC .7 for SQL2000, there was some
> > > > undocumented features with 2.6 and SQL2000.

> > > > Cheers,
> > > > Maartin.

> > > > > I can not see tables using VB6 Data View.    I can establish a
> > > connection
> > > > to
> > > > > the Northwind database on the SQL 2k server machine, but under
> > > > "Datalink1",
> > > > > if I click the plus sign in front of tables, I get nothing.  The
> plus
> > > sign
> > > > > disappears.  This is true for 'Database Diagrams', 'Views', etc...

> > > > > Test Connection reveals connection succeeded, and connection1 =
> > > > (connected)
> > > > > is displayed on the bottom bar of the dataview window.

> > > > > [ MDAC 2.6 sp1; SQL 2000 sp2; VB 6 sp5; Office SR-1a; SQL Client
> Tools
> > > > > installed on workstation.; MS OLE DB Provider for SQL Server
> (version
> > > > > unknown, but assuming same as server since SQL 2000 Client Tools
are
> > > > > installed on workstation)  All real-time virus scanning software
> > > disabled
> > > > on
> > > > > workstation and server. ]

> > > > > I don't care about loosing SQL 2000 features, I just need this to
> work
> > > > > again.  Am I SOL for upgrading to SQL 2k?  Can I get the
> > DataEnvironment
> > > > in
> > > > > VB6 to show me the SQL server tables again?

> > > > > (also)
> > > > > I cannot get this to function correctly in Access 2000 either.
> > > > > Performing the following:
> > > > >   1)  Launch Access 2000
> > > > >   2)  Choose Create a New Database Using Access Database Wizards,
> > Pages
> > > > and
> > > > > Projects from the opening dialog box.
> > > > >   3)  Choose the General tab in New dialog box
> > > > >   4)  Choose the icon for Project (Existing Database) and click OK
> > > > >   5)  Assign a name to your project and click Create
> > > > >        [I save to mydocuments on local drive]
> > > > >   6)  Enter you SQL Server name, authentication information, and
> > > database
> > > > > name in the Data Link Properties dialog box, and click ok.  [I log
> in
> > as
> > > > > 'sa' and use northwind for the database]

> > > > > Again, I can see no tables.  Only the new table wizard.

> I fixed it!

> On the server, run SQL query analyzer and open the file INSTCAT.SQL from
> C:\WINNT\SYSTEM32\
> .  I had done this once before, [but not after I had installed MDAC 2.6,
> 2.6sp1, 2.6sp2, 2.7RTM] but just ran it now, again, a second time.

> I found a KB Article that mention this problem for ODBC SQL Server v3.6 so
I
> figured I'd give that a try too.  Hell, I tried everything else...

> What do you know.  It worked.

> Don't give up on the Linux, though.  I heard it takes some getting used
to,
> but it is well worth the effort in the end.  Hey, anything to get away
from
> Micro$oft.

> I had a revelation in reviewing my problem.  I was having a problem
> connecting to MS SQL 2000, running on a MS 2k Server, from a MS Win98
> Client, in a MS VB6 Development Environment with MS SQL Drivers.  I feel
> like just another MS lemming.  Oh yeah, Office 2k 5user, too.  Looking
back,
> I've spent almost as much with Microsoft as I have with the IRS.  (Well...
> maybe not that much)

> I was going to upgrade to VS.Net until I read on the side of the box that
it
> required WinXP (or NT flavor) of OS.  Nope.  That's it for me.  No more MS
> OSes.  I heard about that activation {*filter*}and software as a service ain't
> for me.  This is where I draw the line.  Activate on this, MS!  You and my
> wallet will be parting ways...  now, for good!

> http://www.*-*-*.com/

> No kidding !!!
> <VERY SERIOUS FACE>
> My format and re-install happens every 12 or less months, Well I wine just
> like you about it.

> have crashed Linux more
> in 2 months with re-installs that I have done with M$ in 3 years of

> dev.
> </VERY SERIOUS FACE>

> I'm only kidding about with my own tages above, I must agree and linux
might
> have the answer but like I said
> linux is not as stable as they say. BELIVE ME. Linux is also a lot more
work
> than M$ products.

> Best of luck with your prob, please post your fix if you find one here, so
I
> can keep it 'one file' incase in run into it.

> Cheers,
> Maartin.

> > You've got to be kidding, right?

> > I hate to say it, but I do that too.  Thing is, I usually have to buy a
> new
> > hard drive to do it successfully in the least amount of time.  And I
> usually
> > wait until there is absolutely no other solution.  [about 9 - 18 mos]

> > This is it for me and Microsoft.  I will not be upgrading to XP.  I will
> not
> > be upgrading to Visual Studio .NET.  Ever! (because it will only run on
> > NT/XP)  Period.  I will not upgrade the servers in this office to .NET
or
> > whatever they are pushing now.  Forget it.

> > Looks like it's going to be Mandrake or SuSe Linux as a replacement.  I
am
> > SO SICK AND TIRED OF MICROSOFT.

> > ** Sorry about the soapbox, but does anyone know how to fix this
problem?
> I
> > have seen the problem posted many many times, but no solutions.  Just
> cries
> > for help, like mine.

> > Anybody have any clues at all?  MS KB Article Q266277 doesn't seem to
want
> > to cure the problem.

> > How do,

> > Have you installed the latest VS SP ? this might fix the problem.
> > From experience in undocumented features in MS products I have learnt it
> > does not always help to un-install and install.

> > You prob might be fixed with a format c: and re-install all. I know this
> is
> > the last resort, but if I start to spot funny errors
> > that I have never encountered before, I format and re-install all. My
> > philosophy there are more serious errors on the way,
> > so stop it before it gets worse.

> > I as a rule format and re-install all about every 12 months, this also
> > clears out all the junk that I forgot about.

> > Cheers,
> > Maartin.

> > --------------------


> > > Unfortunately, that didn't fix the problem either.  When in the data
> view
> > > window, if I right click on tables, I see the following fly out menu:
> > > (following the steps I mentioned previously)

> > >     Refresh
> > >     --------
> > >     Dockable
> > >     Hide
> > >     ---------
> > >     Show System Objects
> > >     Filter by owner

> > > No, New...  etc...

> > > I'm wondering if I should uninstall and reinstall VS6 altogether.

> > > One thing I did notice when I created a new project is that, in the
Data
> > > View window, there was a data link from 3 days ago.  I have been
exiting
> > and
> > > restarting VB every time I start a new project in an effort to clear
it
> > out
> > > and sever any links which may be persisting.

> > > I'm stumped!

> > > no, only the client the server should be fine when you install SQL2K
> > mdac2.7
> > > is installed automatically.

> > > Don't worry are no such a thing as a stupid question. So ask away !!

> > > Cheers,
> > > Maartin.

> > > > Sorry if this is a stupid question, but should I install 2.7 on the
> > server
> > > > as well as the client?

> > > > > If I recall correctly you need MDAC .7 for SQL2000, there was some
> > > > > undocumented features with 2.6 and SQL2000.

> > > > > Cheers,
> > > > > Maartin.

> > > > > > I can not see tables using VB6 Data View.    I can establish a
> > > > connection
> > > > > to
> > > > > > the Northwind database on the SQL 2k server machine, but under
> > > > > "Datalink1",
> > > > > > if I click the plus sign in front of tables, I get nothing.  The
> > plus
> > > > sign
> > > > > > disappears.  This is true for 'Database Diagrams', 'Views',
etc...

> > > > > > Test Connection reveals connection succeeded, and connection1 =
> > > > > (connected)
> > > > > > is displayed on the bottom bar of the dataview window.

> > > > > > [ MDAC 2.6 sp1; SQL 2000 sp2; VB 6 sp5; Office SR-1a; SQL Client
> > Tools
> > > > > > installed on workstation.; MS OLE DB Provider for SQL Server
> > (version
> > > > > > unknown, but assuming same as server since SQL 2000 Client Tools
> are
> > > > > > installed on workstation)  All real-time virus scanning software
> > > > disabled
> > > > > on
> > > > > > workstation and server. ]

> > > > > > I don't care about loosing SQL 2000 features, I just need this
to
> > work
> > > > > > again.  Am I SOL for upgrading to SQL 2k?  Can I get the
> > > DataEnvironment
> > > > > in
> > > > > > VB6 to show me the SQL server tables again?

> > > > > > (also)
> > > > > > I cannot get this to function correctly in Access 2000 either.
> > > > > > Performing the following:
> > > > > >   1)  Launch Access 2000
> > > > > >   2)  Choose Create a New Database Using Access Database
Wizards,
> > > Pages
> > > > > and
> > > > > > Projects from the opening dialog box.
> > > > > >   3)  Choose the General tab in New dialog box
> > > > > >   4)  Choose the icon for Project (Existing Database) and click
OK
> > > > > >   5)  Assign a name to your project and click Create
> > > > > >        [I save to mydocuments on local drive]
> > > > > >   6)  Enter you SQL Server name, authentication information, and
> > > > database
> > > > > > name in the Data Link Properties dialog box, and click ok.  [I
log
> > in
> > > as
> > > > > > 'sa' and use northwind for the database]

> > > > > > Again, I can see no tables.  Only the new table wizard.