Find Jobs
Hire Freelancers

Create a web configurable dns administrative interface using asp/vb.net, Simple DNS and SQL Server. This is only a prototype.

$500-1100 USD

Completed
Posted about 13 years ago

$500-1100 USD

Paid on delivery
Create a web configurable dns administrative interface using asp/vb.net, Simple DNS and SQL Server. This is only a prototype. 1) Create 2 tables to store DNS info 2) Create a simple asp.net administrative screen 3) Setup Simple DNS Plus in your development environment (<[login to view URL]>) 4) Setup MS SQL Server "Plus" Plugin-in (<[login to view URL]>) in your local environment 5) Demonstrate the ability to create a record in administrative screen and query said record (i.e. from nslookup) ## Deliverables **Summary:** Create a web configurable dns administrative interface using asp/vb.net, Simple DNS and SQL Server. This is only a prototype. See attached details. 1) Create 2 tables to store DNS info 2) Create a simple asp.net administrative screen 3) Setup Simple DNS Plus in your development environment (<[login to view URL]>) 4) Setup MS SQL Server "Plus" Plugin-in (<[login to view URL]>) in your local environment 5) Demonstrate the ability to create a record in administrative screen and query said record (i.e. from nslookup) **Detailed:** *Create 2 tables to store DNS info* I have created two tables to be used for this project called ctm_domains and ctm_domainrecords. The schema is shown below: CREATE TABLE [ctm_domains]( [hMy] [int] IDENTITY(1,1) NOT NULL, [sDomainName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [sDesc] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_ctm_domains] PRIMARY KEY CLUSTERED ( [hMy] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [ctm_domainrecords]( [hMy] [int] IDENTITY(1,1) NOT NULL, [hDomain] [int] NOT NULL, [iRecordType] [int] NOT NULL, [sHost] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [sPointsTo] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [iMXPriority] [int] NULL, [iTTL] [int] NULL, CONSTRAINT [PK_ctm_domainrecords] PRIMARY KEY CLUSTERED ( [hMy] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] ctm_domains = Master table to store main domain (i.e. [login to view URL]) [login to view URL] = ID column [login to view URL] = Domain name (i.e. [login to view URL]) [login to view URL] = Domain description (i.e. Microsoft main domain) ctm_domainrecords = Child table to store actual records [login to view URL] = ID column [login to view URL] = pointer to [login to view URL] [login to view URL] = type of record (a, cname, mx) [login to view URL] = the host that is being queried (i.e. [[login to view URL]][1] or [[login to view URL]][2], or [login to view URL]) [login to view URL] = the IP address of the target (i.e. [login to view URL]) [login to view URL] = for mx type records only (i.e. 10, 20, 30, 40) [login to view URL] = time to live for each record (i.e. 1hr, 1day, 1week) *Create a simple asp.net administrative screen* Create a simple web 2.0/ajax/jquery web interface that writes and reads to the two tables defined above. I've added some screenshots of suitable interfaces. This does not need to be fancy, just needs to work: *Setup Simple DNS Plus in your development environment AND Setup MS SQL Server "Plus" Plugin-in* This is fairly self explanatory. You will need to install and configure both, including defining the sql server to be used by Simple DNS plugin to get records. Create a very simple document (no more than a page or two) with some screenshots and description on how to set this up in our own environment. *Demonstrate the ability to create a record in administrative screen and query said record (i.e. from nslookup* This is self explanatory too.
Project ID: 3075012

About the project

11 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$850 USD in 14 days
4.9 (268 reviews)
6.3
6.3
11 freelancers are bidding on average $724 USD for this job
User Avatar
See private message.
$425 USD in 14 days
5.0 (64 reviews)
7.0
7.0
User Avatar
See private message.
$850 USD in 14 days
4.9 (141 reviews)
7.0
7.0
User Avatar
See private message.
$765 USD in 14 days
5.0 (7 reviews)
5.6
5.6
User Avatar
See private message.
$701.25 USD in 14 days
4.8 (19 reviews)
4.5
4.5
User Avatar
See private message.
$875.50 USD in 14 days
4.6 (5 reviews)
4.0
4.0
User Avatar
See private message.
$637.50 USD in 14 days
5.0 (10 reviews)
3.7
3.7
User Avatar
See private message.
$654.50 USD in 14 days
0.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$850 USD in 14 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$765 USD in 14 days
0.0 (2 reviews)
0.1
0.1
User Avatar
See private message.
$595 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
13
Member since Jun 1, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.