Click here to Skip to main content
12,508,185 members (39,936 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB SQL-Server VB.NET
Hi
I'm developing Window application. But i Need to maintain my Database in Ftp. So How Could i Apply Connection String.

By Default
Dim con as New SqlConnection("My Conn String")
Posted 25-Feb-13 6:13am
sencsk1.4K
Comments
ryanb31 25-Feb-13 12:14pm
   
What do you mean you have to maintain your db in ftp? That doesn't make sense to me.
sencsk 25-Feb-13 12:19pm
   
I need to connect my application Database With Ftp. I Run My Application in Multiple Systems. I've Access My DB Through FTP. How to connect my app to FTP
CHill60 25-Feb-13 12:25pm
   
FTP = File TRANSFER Protocol ... I'm not convinced you are CONNECTing to a DB that way. If your database is on another server then you will need the name of the sql instance
sencsk 25-Feb-13 12:26pm
   
is that Right way?
connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=ftp:\\ftp.MyUrl.com\db\MyApplicationDB.accdb;Persist Security Info=True;UName="test";Password="test""
ThePhantomUpvoter 25-Feb-13 12:30pm
   
I have serious doubts that this would work. If it does in fact work, I think you will have problems eventually with it. Why don't you just use SQL Server (as your tag suggests)?
Mike Meinz 25-Feb-13 14:13pm
   
FTP is not a connection protocol that can be used to access any kind of database.

Use SQL Server or SQL Server Express and use the TCP/IP protocol to connect to it.

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

You can't do that. I don't know of a single database provider that will work over FTP, including Access.

You MUST have the Access database on either a local drive OR on a UNC path on a server, NOT an FTP or HTTP path. Those will not work.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160927.1 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100