by 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 crap 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.computerbytesman.com/privacy/wmp8dvd.htm
No kidding !!!
<VERY SERIOUS FACE>
My format and re-install happens every 12 or less months, Well I wine just
like you about it.
But don't let Linux fool you, I'm looking @ that route and I'll tell you I
have crashed Linux more
in 2 months with re-installs that I have done with M$ in 3 years of NT+Win@k
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.
> 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.
> "Maartin" <dinam...@ibi.co.za> wrote in message
> news:emqagzBBCHA.992@tkmsftngp02...
> 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.
> --------------------
> "Mike Edgewood" <mrlmz.nos...@earthlink.net> wrote in message
> news:uPenjbnACHA.1916@tkmsftngp04...
> > 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!
> > "Maartin" <dinam...@ibi.co.za> wrote in message
> > news:uh5HiacACHA.2196@tkmsftngp04...
> > 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.
> > "Mike Edgewood" <mrlmz.nos...@earthlink.net> wrote in message
> > news:u$nXdRcACHA.1880@tkmsftngp04...
> > > Sorry if this is a stupid question, but should I install 2.7 on the
> server
> > > as well as the client?
> > > "Maartin" <dinam...@ibi.co.za> wrote in message
> > > news:OGVusrPACHA.1208@tkmsftngp02...
> > > > If I recall correctly you need MDAC .7 for SQL2000, there was some
> > > > undocumented features with 2.6 and SQL2000.
> > > > Cheers,
> > > > Maartin.
> > > > "Mike Edgewood" <mrlmz.nos...@earthlink.net> wrote in message
> > > > news:eeW3lVBACHA.1692@tkmsftngp05...
> > > > > 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.