Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: 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.2K
Comments
ryanb31 at 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 at 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 at 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 at 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 at 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 at 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
0 OriginalGriff 468
1 Sergey Alexandrovich Kryukov 305
2 PhilLenoir 115
3 RajeeshMenoth 110
4 Peter Leow 100
0 Sergey Alexandrovich Kryukov 6,557
1 OriginalGriff 5,966
2 CPallini 2,473
3 Richard MacCutchan 1,687
4 Abhinav S 1,540


Advertise | Privacy | Mobile
Web03 | 2.8.140821.2 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2014
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