Creating Data Sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I go about checking via VB is a data source exists or not? If the
source doesn't exist, can I create one in via VB? Is it necessary to even
have the data sources if I have the server information, can I just use vb to
link to the table without the data source?

If you could point me to any examples, that would also be greatly appreciated.

Thanks

Mark
 
Mark,

If you are connecting to SQL server or any other source and you know (1) the
server name (2) the database (3) a valid username (4) a corresponding valid
password then you can simply use ADO and the connect string to open the
datasource, here is a reference to connection string syntax for various
sources: http://www.able-consulting.com/ADO_Conn.htm

Dan
 
Back
Top