FlyBoy Posted November 5, 2004 Posted November 5, 2004 i want to upload to a free hosting site,my sql database which is 2 files...transaction log and the mdf file. will it be possible to retrieve and modify data on it???? and what will be the connection string (the Data Source),the http\ftp link? if its not possilbe,will it be possilbe with a MDB \Access DB? Quote
Administrators PlausiblyDamp Posted November 5, 2004 Administrators Posted November 5, 2004 The hosting site will need to support SQL server for that to work, which is unlikely for a free service. It should however be possible using an access database as that won't require any server side configuration. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
FlyBoy Posted November 5, 2004 Author Posted November 5, 2004 The hosting site will need to support SQL server for that to work, which is unlikely for a free service. It should however be possible using an access database as that won't require any server side configuration. i see...so concering to the Access MDB...i just need to upload it..and in the connection string for ex: "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = HERE!!!!" where the HERE i need to enter the link to the DB? (ftp\or http)??? i dont think it needs any server config....i load an access db from my local computer only with a path .... Quote
Administrators PlausiblyDamp Posted November 5, 2004 Administrators Posted November 5, 2004 I don't believe you can use a data source that is a HTTP / FTP connection - you would need to access the file directly. Are you also hosting a web application of the server or just the database? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
FlyBoy Posted November 5, 2004 Author Posted November 5, 2004 I don't believe you can use a data source that is a HTTP / FTP connection - you would need to access the file directly. Are you also hosting a web application of the server or just the database? just database.... :o Quote
Administrators PlausiblyDamp Posted November 5, 2004 Administrators Posted November 5, 2004 In that case you probably will not be able to access the file directly, you may want to consider creating a Web Service that runs on the server and access the DB and then calling this service from other applications. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
FlyBoy Posted November 5, 2004 Author Posted November 5, 2004 In that case you probably will not be able to access the file directly' date=' you may want to consider creating a Web Service that runs on the server and access the DB and then calling this service from other applications.[/quote'] and making the webservice runing on a free hoster wouldnt be possible right?? (i have no idea... :-\ ) Quote
Administrators PlausiblyDamp Posted November 5, 2004 Administrators Posted November 5, 2004 If the host supports .Net then it's perfectly possible to do with .Net. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.