Click here to Skip to main content
11,702,119 members (64,841 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-Server VB.NET
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
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:\\\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
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.

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

  Print Answers RSS
0 Maciej Los 420
1 Sergey Alexandrovich Kryukov 355
2 OriginalGriff 314
3 Mika Wendelius 119
4 CHill60 105
0 OriginalGriff 8,344
1 Sergey Alexandrovich Kryukov 7,507
2 CPallini 4,922
3 Maciej Los 4,371
4 Mika Wendelius 3,556

Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2015
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