Can't view SQL Server 2000 tables in VB6 Data Environment

Can't view SQL Server 2000 tables in VB6 Data Environment

Post by MiniM » Sat, 14 Jul 2001 11:39:49



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
it work?

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
 IIS 5.0
Windows 2000 Hot fixes
Visual InterDev 6 Enterprise SP 5
Visual Basic 6
     Add-In Manager
          Component Services Add-In for VB 5.0/6.0
          VB 6 Data Object Wizard
          Visual Component Manager 6.0
     References
          Visual Basic for Applications
          Visual Basic runtime objects and procedures
          Visual Basic objects and procedures
          OLE Automation
          Microsoft Data Environment Instance 1.0 (SP4)
          Microsoft ActiveX Data Objects 2.5 Library

SQL Server 2000 - Standard Edition
         Mixed Mode Authentication
        MDAC 2.6
Commerce Server 2000
IE 5.5

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 :>).

Best regards,


Just erase the GETRIDOF in my e-mail address to reach me.

 
 
 

Can't view SQL Server 2000 tables in VB6 Data Environment

Post by Richard Allsebroo » Sat, 14 Jul 2001 17:24:08


Make sure you have MDAC 2.6 installed.


> 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
> it work?

> 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
>  IIS 5.0
> Windows 2000 Hot fixes
> Visual InterDev 6 Enterprise SP 5
> Visual Basic 6
>      Add-In Manager
>           Component Services Add-In for VB 5.0/6.0
>           VB 6 Data Object Wizard
>           Visual Component Manager 6.0
>      References
>           Visual Basic for Applications
>           Visual Basic runtime objects and procedures
>           Visual Basic objects and procedures
>           OLE Automation
>           Microsoft Data Environment Instance 1.0 (SP4)
>           Microsoft ActiveX Data Objects 2.5 Library

> SQL Server 2000 - Standard Edition
>          Mixed Mode Authentication
>         MDAC 2.6
> Commerce Server 2000
> IE 5.5

> 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 :>).

> Best regards,


> Just erase the GETRIDOF in my e-mail address to reach me.


 
 
 

Can't view SQL Server 2000 tables in VB6 Data Environment

Post by Mike Rollin » Sun, 22 Jul 2001 14:56:50


I've experienced the same problem.  We found that when a query was written as:

"Select * from SomeTable"

the client computer froze when the table had a lot of fields, but when we named
every field explicitly instead of using '*' it was OK.  We applied Service Pack
1 to SQL2000 and upgraded the clients to MDAC 2.6 and everything works now.

Mike R


> 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
> it work?

> 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
>  IIS 5.0
> Windows 2000 Hot fixes
> Visual InterDev 6 Enterprise SP 5
> Visual Basic 6
>      Add-In Manager
>           Component Services Add-In for VB 5.0/6.0
>           VB 6 Data Object Wizard
>           Visual Component Manager 6.0
>      References
>           Visual Basic for Applications
>           Visual Basic runtime objects and procedures
>           Visual Basic objects and procedures
>           OLE Automation
>           Microsoft Data Environment Instance 1.0 (SP4)
>           Microsoft ActiveX Data Objects 2.5 Library

> SQL Server 2000 - Standard Edition
>          Mixed Mode Authentication
>         MDAC 2.6
> Commerce Server 2000
> IE 5.5

> 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 :>).

> Best regards,


> Just erase the GETRIDOF in my e-mail address to reach me.

 
 
 

1. Can't view SQL Server 2000 tables in VB6 Data Environment

Hello,

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
it work?

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
     IIS 5.0
Windows 2000 Hot fixes
Visual InterDev 6 Enterprise SP 5
    Visual Basic 6
         Add-In Manager
              Component Services Add-In for VB 5.0/6.0
              VB 6 Data Object Wizard
              Visual Component Manager 6.0
         References
              Visual Basic for Applications
              Visual Basic runtime objects and procedures
              Visual Basic objects and procedures
              OLE Automation
              Microsoft Data Environment Instance 1.0 (SP4)
              Microsoft ActiveX Data Objects 2.5 Library

SQL Server 2000 - Standard Edition
     Mixed Mode Authentication
    MDAC 2.6
Commerce Server 2000
IE 5.5

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 :>).

Best regards,


Just erase the GETRIDOF in my e-mail address to reach me.

2. Problems with RegisterDatabase Method

3. Installing IngresII error

4. ODBC SQL Error 8525 on rdoQuery after VB6 Install

5. VB6 Data Environment problems w/ SQL 2000

6. Data Warehouse software

7. VB6: Data Environment & SQL Server 6.5

8. DATA ENVIRONMENT in VB6 with SQL SERVER

9. SQL Server connection VB6 Data Environment

10. VB6/SQL Server 7 problem - VB Data Environment