ansaurus

Question

Is it possible to ceate a DSn to my FTP Account

Answer 1

A:

Unfortunately, no. FTP is a protocol for transferring files, not for random access on files, which would be required for a database with reasonable performance.

Heinzi 2009-11-27 12:53:07

it working some thing like ms access?

Alex 2009-11-27 13:00:25

The MS Access driver uses a Windows file path ("C:\..." or "\\Server\Share\...") to locate the database. As far as I know, it's not possible to access FTP with a Windows file path.

Heinzi 2009-11-27 13:39:26

Answer 2

A:

Since you're using SSME, that implies SQL Express.

If SQL Express is running on the same machine as your FTP folder, and if the SQL Server identity has access to that folder, then you can either use SSME to attach to an MDF file in the FTP folder, or use the AttachDbFilename property in your connection string to do it automatically.

However, keep in mind that SQL Express only supports a database size up to 4GB maximum -- so you still wouldn't be able to use the full 300GB, even in the best of circumstances.

RickNZ 2009-11-27 13:15:02

i use my all database field types are varchar(8000), its affect my space

Alex 2009-11-27 13:28:12

varchar fields only take up as much space as the data needs; the size you declare is just a maximum, so 1 character in a varchar(1) takes up just as much space on disk as 1 character in a varchar(8000).

RickNZ 2009-11-27 13:33:57

based on ur above answe "If SQL Express is running on the same machine as your FTP folder, and if the SQL Server identity has access to that folder, then you can either use SSME to attach to an MDF file in the FTP folder, or use the AttachDbFilename property in your connection string to do it automatically." i not get this point, can u describe this?

Alex 2009-11-27 13:39:57

Both SQL Express and the FTP server read and write to disks the Windows filesystem. Both programs run as certain users that have certain permissions. To be able to share files between them, the programs must run on the same server and run as users with compatible permissions.

RickNZ 2009-11-27 13:51:30

ansaurus

tags:

views:

answers:

Is it possible to ceate a DSn to my FTP Account

related questions