Connect to a database web

Question

User370212504 posted

 Hello,

I want to connect to a web database (access) with a windows application (exe file)

plz help me to find it's code

Answer 1

User1992938117 posted

Hi,

in windows aplication you need to set connection string inside app.config file as

<configuration>
  <appSettings> 
    <add key="connection" value="Data Source=your server ip;Initial Catalog=databasename;Uid=databaseuser;pwd=databasepassword"/>   
  </appSettings>
</configuration>

Thanks...

Answer 2

User370212504 posted

Hello,

but it is a SQL  Server Connection String.

my DataBase in web is Data Access.

Thanks,

 

Answer 3

User1992938117 posted

Hi,

Check here you can find all possible connection strings.

Thanks..

Answer 4

User-1199946673 posted

I want to connect to a web database (access) with a windows application (exe file)

 

The connectionstring in both a web application or a windows application is the same:

http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET

But since these forums are intended for ASP.NET related questions only, please ask your questions somewhere else, like:

http://windowsclient.net/Forums/

Weher you can use the same login as on these forums....

Answer 5

User370212504 posted

Hello,

Unfortunately I can't find it's code on those links above

Answer 6

User1992938117 posted

Hi, check below link

For windows

remote server

http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/how-to-connect-remote-access-database-through-vb-1232152

http://www.astahost.com/info.php/vb-net-ms-access-interaction-tutorial-part_t12054.html

for web:

http://www.c-sharpcorner.com/UploadFile/mimrantaj/Database102102008130743PM/Database1.aspx

http://www.beansoftware.com/ASP.NET-Tutorials/Connecting-Access-Sql-Server.aspx

http://www.w3schools.com/aspnet/aspnet_dbconnection.asp

http://www.c-sharpcorner.com/UploadFile/mimrantaj/Database102102008130743PM/Database1.aspx

still facing problem then use try catch and break point and trace error. also can post your code

Hope it helps...