How to apply Connection string on my ftp server Databases from My wndow application

Question

1.00/5 (2 votes)

See more:

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

sencsk

Add a Solution

Comments

ZurdoDev 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""

[no name] 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

Add a Solution

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

Dave Kreskowiak · Answer 1 · 2013-02-25T10:35:00

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.

Posted 25-Feb-13 10:35am

Dave Kreskowiak

How to apply Connection string on my ftp server Databases from My wndow application

1 solution

Solution 1

Add your solution here

Preview 0

How to apply Connection string on my ftp server Databases from My wndow application

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us