I hope that someone may shed some light on why I am having difficulties.
Under Visual Basic 6 Enterprise, I opened Visual Basic project and created a
standard EXE project. I added a Data Environment. I chose "Microsoft OLE
DB Provider for SQL Server" as my provider. I selected the Northwind
database. I verified the connection via "Test Connection".
I used Data View to verify that the database was there and it was. The
tables folder was there, however, there were tables to expand. I tried the
same thing with another SQL Database and had the same results.
I repeated the above steps, except this time I chose "Microsoft Jet 4.0 OLE
DB Provider" instead for an Access database. I was able to view the tables.
I could also view the SQL Server 2000 tables via SQL Server Enterprise
Manager, so I know that the SQL Server database and tables exist.
My question is why can't I see the SQL Server 2000 tables using "Microsoft
OLE DB Provider for SQL Server" as my provider? And what can I do to make
Could this be a configuration problem? I was able to view the SQL Server
2000 databases and tables with the "Microsoft OLE DB Provider for SQL
Server" working on another system that was running under Windows NT 4.0 SP
6 but DID NOT have Commerce Server 2000 installed.
This is the configuration for my "problem" machine:
Windows 2000 Server SP 1
Windows 2000 Hot fixes
Visual InterDev 6 Enterprise SP 5
Visual Basic 6
Component Services Add-In for VB 5.0/6.0
VB 6 Data Object Wizard
Visual Component Manager 6.0
Visual Basic for Applications
Visual Basic runtime objects and procedures
Visual Basic objects and procedures
Microsoft Data Environment Instance 1.0 (SP4)
Microsoft ActiveX Data Objects 2.5 Library
SQL Server 2000 - Standard Edition
Mixed Mode Authentication
Commerce Server 2000
For those who are willing to respond to my post via the newsgroup, I would
appreciate it greatly if you could e-mail me as well :>).
Just erase the GETRIDOF in my e-mail address to reach me.