How can i connect other machine DSN with my pc without sharing using Visual Basic.....
Krunalexpert 0 Newbie Poster
vb5prgrmr 143 Posting Virtuoso
An ODBC DSN (Open DataBase Connectivity Data Source Name) must be created on each computer that will use the end result of the Visual Basic 6.0 design process. Meaning you create the exe and the installable package and install the program on the machine and then create the ODBC DSN...
Good Luck
Krunalexpert 0 Newbie Poster
But i have told DSN reside on one machine at Server only...
vb5prgrmr 143 Posting Virtuoso
Wrong, each computer that connects to a server/service like SQL, Oracle, etc, needs an ODBC DSN if you are not using ADO's DSN Less capability. Having a ODBC DSN on just the server will not work...
Good Luck
vbboy 0 Newbie Poster
I agree with vb5prgrmr you must create a ODBC
here's the site on how to create ODBC
http://visualbasicnetcode.blogspot.com/2010/04/training-how-to-connect-database-using.html
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.