Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Add OLE DB or ODBC Data Source for clients

Author  Topic  vpoko Starting Member 22 Posts Posted - 2006-02-01 : 10:05:47 Good morning, I'm developing a SQL Server 2000 application using an Access 2000 Project file as the front-end. In order to distribute this file to other users, I presume they will need to add either an ODBC data source or an OLE DB link. Is there a script I can create to do this automatically? I know I can create an OLE DB link by creating a file with a udl extention, but it is my (possibly incorrect) understanding that most users do not have OLE DB installed (unless they've installed SQL Server client-side software) and I will need to use ODBC. Can anyone help untangle my understanding?