Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

DSN connection via IP addresss

I have  a access database thats on windwos server
I want to have users enter and update information via the internet
my ISP is using a unix based server so access wont work.


is there a 3rd party tool out there that lets me set up a DSN connection so that i can pull data from my server from my ISP server via IP address?
my ISP wont let do a link from her server to my server.
thanks
0
neojapanese
Asked:
neojapanese
  • 2
1 Solution
 
ap_sajithCommented:
Not possible AFAIK.

Try moving your database to Mysql and modify your code accordingly or change your hosting provider.. there are thounds of cheap windows hosting providers available.

BTW.. how did you get asp to work on unix server in the first place?. sunone asp?

Cheers!!
0
 
neojapaneseAuthor Commented:
ok so i just learn that they have my sql. it will be too much work to convert the access database to mysql. can i link to my sql with access and then i can upload data onthe fly that way?
0
 
ap_sajithCommented:
I am not quite sure.. maybe there is an export wizard in access that would allow you to do that. you might have to do some recoding though.

Cheers!!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now