Connecting to Access using VB.Net
-
Hi Guys, In VB.Net, how do you make a connection to an access database and use this connnection throughout the application. Also, when making the connection if we fix the path to the database(i.e. drive, folder..), then when the application is deployed on a different machine on a different drive, will this cause an issue. With Best Regards, Mayur
-
Hi Guys, In VB.Net, how do you make a connection to an access database and use this connnection throughout the application. Also, when making the connection if we fix the path to the database(i.e. drive, folder..), then when the application is deployed on a different machine on a different drive, will this cause an issue. With Best Regards, Mayur
hi, To connect to access database use the namespace as OLEDB instead of SQLCLIENT. And then goahead as other connection in >net. Oh Yes dont ever fix the drive or dir for the connection. Rather make a string in your config file (that is provided with vb.net application) and read the path from the config file. Config file gives you the liberty to change the settings and configuration at any time. :) DD Debasish Das(MBA), is a hardcore software solution provider, working in ESSPL (INDIA). Got 5 years of experience on various client server technologies like Visual Basic,.NET framework, Power Builder, Message Queue Server. And also posses sound knowledge in Quality Processes applied to software engineering. Quite often travels overseas to provide solutions to some fortune 100 clients. He can be reached with mr_debasishdas@hotmail.com or debasishd@esspl.com