VBasic 6.0 and SQL 6.5

VBasic 6.0 and SQL 6.5

Post by Javier Campo » Wed, 12 Jan 2000 04:00:00

I'm developing apps for VB6.0 accessing to SQL6.5. When I run my apps in the
server (where SQL6.5 is) it runs fine... But when I run my apps from a
client with W95, it doesn't access to the server. I've created the link to
the server and it runs with MS-Access, but not with VB... Does anybody know
what it the problem?

Thanks in advence.



VBasic 6.0 and SQL 6.5

Post by Bob Pfeif » Fri, 14 Jan 2000 04:00:00

What does your connection string(s) look like in the VB application?


1. User connections with SQL Server 6.5 and VBasic 6.0

Hi everyone!

We are working with Visual Basic 6.0 and SQL Server 6.5, and each time we
run a project in VBasic, we get a lot of idle
connections with SQL Server. In most of our forms there are some Data
Controls and Ado Data Controls and we think these controls are causing the

We use the ODBC providers for OLE DB, and we have tried to enable the
connection pooling in the ODBC but it hasn't worked at all.

We think  there has to be a way to close these connections, either from
Visual Basic code or from SQL Server.

Does anyone know how to solve it?

Thank you

2. Update with an aggregate.

3. SQL Server 6.5 - Client Upgrade from SQL 6.0 to 6.5

4. Multiple DB Connections in ABF (6.4/04)

5. VBasic 4.0 SQL Server 6.5 insert error, table is read only

6. SQL Access final report?

7. SQL 6.5 Enterprise Manager with 6.5 and 6.0 Servers

8. Btrieve 96

9. Connecting Access 2000 and VBasic 6.0 sp3

10. Trouble with SQL 6.5 Enterprise Manager Access SQL 6.0

11. sa users lost privileges from SQL 6.0 to SQL 6.5

12. Problem connecting to both SQL 6.0 and SQL 6.5