I am looking to try and connect to SQL Server via a DSN-less
connection in a VB application.
Setting up ODBC data sources is a headache for each user workstation.
There has to be an easier way.
Is there a straight forward way to do that or do you know a good
reference source that would have information on this topic?
Thank you.
RLN (rlntemp-newsgroup@yahoo.com) writes:
> I am looking to try and connect to SQL Server via a DSN-less
> connection in a VB application.
> Setting up ODBC data sources is a headache for each user workstation.
> There has to be an easier way.
> Is there a straight forward way to do that or do you know a good
> reference source that would have information on this topic?
What is the problem?
What means of authentication do you use? SQL Server authentication or
Windows authentication? Is the server always the one and the same? What is
the database?
Our application addresses all these problems by prompting the user. Isn't
that feasible for you?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx