Using the native driver to connect to MS SQL Server 7.0

Thread View: borland.public.cppbuilder.database.multi-tier

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by John Graham Wed, 04 Aug 1999 00:00

#1695

Author: John Graham
Date: Wed, 04 Aug 1999 00:00

18 lines
1344 bytes

Heyo!

I have read that the MSSQL native driver, as supplied with BCB 4 can be
used with both MSSQL Server 6.5 and 7.0 databases.  We have the same
database running under both versions.  My application runs well with the
6.5 version, but bombs when attempting to connect to the 7.0 version of
the DBMS.  In fact, I get an error message stating that the server can't
be found or does not exist.  Has anyone out there attempted this, and
were you successful?  At this point I don't know if something isn't set
up correctly or if the driver is at fault.

This is a 3 tier application, and I have had limited success running the
app. using the MS SQL ODBC driver against the 7.0 version of MS SQL
Server, but I'm afraid that things will be slower than tolerable with
ODBC.

Thanks,
John

Re: Using the native driver to connect to MS SQL Server 7.0

#1696

Author: Kent Reisdorph (TeamB)
Date: Wed, 04 Aug 1999 00:00

12 lines
1082 bytes

>>when attempting to connect to the 7.0 version of
the DBMS.  In fact, I get an error message stating that the server can't
be found or does not exist.  Has anyone out there attempted this, and
were you successful?

Yep, I'm doing it. I don't recall any connection problems. I think BCB 4
shipped with the latest version of the BDE, but you might want to check (I'm
using 5.01).

--
Kent (TeamB and TurboPower Software)
C++Builder Developer's Journal (http://www.reisdorph.com)

Re: Using the native driver to connect to MS SQL Server 7.0

#1698

Author: John Graham
Date: Thu, 05 Aug 1999 00:00

23 lines
1404 bytes

Kent,

Thanks.  It helps to know that the native driver works with MS SQL 7.0.  My
problem most likely involves an account setup problem.  I have ver. 5.01 of the
BDE also, so we're cooking on the same burner.

Regards,
John

"Kent Reisdorph (TeamB)" wrote:

> >>when attempting to connect to the 7.0 version of
> the DBMS.  In fact, I get an error message stating that the server can't
> be found or does not exist.  Has anyone out there attempted this, and
> were you successful?
>
> Yep, I'm doing it. I don't recall any connection problems. I think BCB 4
> shipped with the latest version of the BDE, but you might want to check (I'm
> using 5.01).
>
> --
> Kent (TeamB and TurboPower Software)
> C++Builder Developer's Journal (http://www.reisdorph.com)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads