Question Locked

ODBC DRIVER

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How to add a new ODBC driver to a system. I want to make a project in VB using SQL as database. I have made SQL Database and connected to VB using ODBC driver. Now I need to make a setup. If I make a setup file and if I install it in any other system without SQL server or connection to the network, will it work? How can I run this project in a network without SQL Server installed in the system? If I make file DSN connection, How will I install the same Driver in other PC outside the Domain?

2 replies

by tony hopkinson

I wouldn't recomend exposing a SQL server inside your domain to the outside world anyway.

In short you can't you can't.

You either provide a reachable SQL Server(not recomended outside your domain), put some middle ware in (WEB service), or put a local copy of the database in the foreign domain (with or without synchronisation between local copies)

There are several ways you could go here.

Do you need there to be one database, ie people inside and outside of your domain to access the same data and how up to datae does it have to be?

Last question why are you using ODBC and not ADO?

This discussion is closed to new replies.