Create A Brand New MSSQL DB Programmatically
I am a ASP Developer w/ Access Backend. I am new to MS SQL But i knew that MSSQL has a big upper hand against MsAccess I am currently running my website w/ MsAccess DB for Members. If i wanted to transfer all the data from Access to MSSQL. I use Virtual Hosting. So i have less access for installing a converter.
Can anyone help me for coding to create a brand new MSSQL database and transfer the Contents. Get me the basic coding. I wanted everything to be programmatically. Atleast help me Create a New DB in MSSQL I have an Idea for Transfering if it works.
My idea is to create DSN for both of them (My Control Panel Allows DSN Creation for both Access and MSSQL) and transfer through two recordsets and connections. That Part is almost OK.
View Replies
ADVERTISEMENT
I have this ASP page that checks if a certain DLL is registered on a client machine. If it ain't registered, then it should be registered.
Here is the part of my code that supposedly registers the dll: Code:
View Replies
View Related
I would like to programmatically scrape and generate .MHT files for archival purposes. Is this possible. Has anyone dealt with a need like this.
View Replies
View Related
Using ASP, is there an easy way in code to "visit a URL", without opening a
browser session?
Explanation: I have a page caching class. The page caching class's behavior
can effectively be "programmed" via instructions that are sent through the
querystring. When members of our staff update articles using a CMS I
programmed, I would like the cache to be flushed. The cache can be rebuilt
by issuing an instruction via a URL querystring.
I would like the machine to programmatically "visit" two different URLs
without actually showing those pages to the user.
View Replies
View Related
I have web page that I use for add/delete/modify records from a database. Depending on what the user desires on previous web page this particular web page allows users to add, modify, or delete the record from a database. Each has different directions and labels on buttons are change with in code.
My users also want the background color for add web page to be one color, modify web page to be different color, and delete web page third color. In VB this was form.background color, but can not seem to find solution in MSDN for this one.
View Replies
View Related
I need to load a load a web page and save the whole page to a file.
I tried ADODB.Stream.Open
"URL=http://www.someurl.com/default.asp?parameter=somevalue"
this fails when you append querystring parameters to the URL. Otherwise it
would have been fine.
View Replies
View Related
In my code to send email from VBScript, I use standard CDOSYS code similar to
the following:
With oMsg
Set .Configuration = oCon
.To = """Admin"" <admin@mycompany.com>"
.From = """Joe Admin"" <jadmin@mycompany.com>"
.Subject = "Hey You!"
.TextBody = "Service(s) have failed!"
.Send
End With
I understand the use of the .HTMLBody property, as well as the
..CreateMHTMLBody method. So I know I can create an ASP or HTML page, and
pass it to the .CreateMHTMLBody method, to get the images truly embedded, so
the email source contains the cid:blahblahblah references to the images,
which is key to getting the email to display properly in web-based mail
clients.
My question is... how do I achieve the same thing (embed the images) that
the .CreateMHTMLBody method does automatically, manually, so I can also
inject values passed from a form postback into the email?
It seems that I shouldn't use the .CreateMHTMLBody method. It seems that I
need to manually accomplish what it accomplishes automatically, so I have
more granular control. But I have found no thorough online resources that
explain exactly how. I have thoroughly looked at all of the SDK information
pertaining to CDOSYS, and I am still in dire need of an example for
VBScript...
It seems that the .AddRelatedBodyPart method is part of the answer, but when
I use it to embed the images and fill .HTMLBody, rather than using the
..CreateMHTMLBody method, I do not see cid:blahblahblah in the email source,
and the images do not display properly in web-based mail clients such as
Outlook Web Access.
I really need some help on this. It would also appear that I am not alone.
I find plenty of questions on this, but no answers. Can anyone help with a
working VBScript example that embeds images into an email in a fashion that
yields the cid:blahblahblah in the email source, for the image references,
that does not use the .CreateMHTMLBody method to do the work automatically?
View Replies
View Related
I persist the login info using cookies so that a user doesn't have to login every time they come to our website, unless they previously logged out. Everything works OK on W98 SE, and Windows XP Pro machines.
On a W2K machine, IE6.0.2800.1106 SP1, the following function won't delete cookies, or deletes them but they're mysterioulsy re-created when the web page is subsequently referenced. Therefore, a web user can't logout.
// ============================================
// remove login cookies
// ============================================
function KillLoginCookies ( )
{
Response.Cookies ( sCookieCustomerID ) = '';
Response.Cookies ( sCookieCustomerID ).Expires = '01/01/1980';
Response.Cookies ( sCookiePassword ) = '';
Response.Cookies ( sCookiePassword ).Expires = '01/01/1980';
}
What am I missing here?
View Replies
View Related
Here's what my code looks like...
View Replies
View Related
I have imported a list of links to MSSQL database with enterprise manager. I use ASP to show the list of links and it's description. Originally I had 8600 links in the database and I have imported 700 new one.
I have checked in table and all the links exist and the table is indexed on field linkID. My asp script has worked before and there is no problem with it.
I can still show all the links including the new links and it's descriptions but if I click on an old link, it goes to that site while with new imports, it just opens another example of my site (404 page set to open my index page).
The link is correct since if I copy it from screen and paste in browser, it opens the page correctly.I have removed the index from table and made it again but no difference. There is also an edit function in my script, if I click on it, I will get a message that filed linkID does not exits but it clearly exists in the table and the rest of script is using it.
View Replies
View Related
If I creat a ASP page, what do I need or how do I connect to a MSSQL database? Is it possible to connect to MySQL with an ASP page, or is it better to stick with MSSQL when creating an ASP page?
View Replies
View Related
Does anyone try before using ASP to execute JOB in MSSQL?
View Replies
View Related
I was wondering if anyone could give me some pointers as to using ASP (Javascript, not VB) to get XML out of SQL.
I have my storedProc with the FOR XML AUTO on the end, and that is returning a recordset with XML fine in query analyzer.
I am lost as to how to output this as XML from an ASP page so I can transform it with XSL.
My transform would be something like: Code:
View Replies
View Related
Looking for suggestions on any stable asp/MS SQL server content management systems in the market place. Any suggestions, or even places where I can look? I have quickly seen Rainbow and would like any comments from users of this CMS.
View Replies
View Related
I am currently learning ASP but have a small PHP background,
With PHP I used PHPMYADMIN to work with MYSQL
Is there a web based Alternative for
ASP and MSSQL that provides similair functionality?
View Replies
View Related
I have a query to one table but one of the values in the table is referencing a record from another table... here is the sql Code:
strSql = "SELECT streetdate, barcode, itemname, descrip, vendor, sku, catlog, config, retail_cost, cost FROM blah WHERE (STREETDATE >='"& GSTARTDATE &"') AND (STREETDATE <='"& GENDDATE &"') ORDER BY STREETDATE, CATLOG DESC"
now I have 2 things going on here...
1. vendor is just a number... there is a tblvendor that matches the number with a name (that i need.. i coudl nest another db query but figured that would be more resource intensive as this returns 1000s of records)
2. itemname is also a number that references another tblItem the sam way, I woul dlike to sort alphabetical off this somehow (is it even possable)
View Replies
View Related
Can't seem to find anything relating so forgive me if i've missed it.
I'm after a way to open either a csv or xml file, then cycle through each line to see if it's in mssql, if it is update it... otherwise add it and then if it's in mssql and not the csv, remove it.Is it possable?
Still learning and haven't dug into opening files, let alone this so any help would be grateful... oh and the fields are exactly the same in both
View Replies
View Related
Anyone know of a free advanced mssql hit counter?
View Replies
View Related
In our office we use RMS (Residential Management System) and they use an MSSQL database to store all the data. we can access this database using access and have made several...several queries to pull out info, save it to another access database, then upload it to the web and pull data from it.
the server that houses the MSSQL database is online and i was wondering if it is possible to connect to it and pull out information. we wouldnt want to change anything, just view.
so to connect to it, what all do i need to do?
View Replies
View Related
I'm just deciding whether to use Access or MS-SQL for a web-application
I'm predicting that my application will grow large enough to warrant use of MS-SQL, but I'm wondering how extensive the changes to my code that would make
...Specificially in ASP.Net, if I use ADO.Net, would I just need to modify my connection string or would it involve more extensive modifications?
View Replies
View Related
I am new to programming and I managed to store images in MSSQL.
The problem I have is that when I retrieve the image from the database
and display it in my browser it opens a new window. I would like to use
the image control, but it requires a url. Is there anyway of viewing that image
in the image control or keeping it in the same page where my information is
but displaying it where and when I want it
View Replies
View Related
I want an answer by tomorrow with examples and reference URLS if we can do this.There is a program written in ASP and the databse is MSSQL (Microsoft) hosted in Windows platform.
But they want this databse and ASP Program host on a UNLIX/LINUX server and use the same ASP program. Can thy do it/ and how?
View Replies
View Related
I had used ASP about a year ago, I had connected to a *.MDB database but not MSSQL,can someone please throw me the just of it
View Replies
View Related
I am using a Windows 2000 Server and when i tried creating a simple asp application this error always appear everytime I access the database. Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'MYSERVERIUSR_MYSERVER'.
/o/faculty_evaluation/add_dean_db.asp, line 22
what kind of error is this?
is there something wrong with my connection string -> conn.Open "Provider=sqloledb;Data Source=MYSERVER;Initial Catalog=dog_evaluation;Integrated Security=SSPI;"
View Replies
View Related
any one have the connection string and included query on how to connect to the mssql server?
View Replies
View Related
If I create an ASP page, what do I need or how do I connect to a MSSQL database. And, is it possible to connect to a MySQL with ASP, or is it better to use MSSQL when developing a ASP page?
View Replies
View Related
I am planning to convert an ASP/MS SQL based site into ASP/MySQL to save on monthly recurring fees. MSSQL costs additional $40 a month while MySQL is free. Are there any major technical issues?
View Replies
View Related
If you have a large traffic site, say over 30 current users accessing the database at once, can Access handle this. I know MSSQL can. Is there any other databases that can be used with asp other than Access and MSSQL and what would there benifits be?
View Replies
View Related
I'm writing a script to show a bithday list. I select the data from a MSSQL db. I want to only show the next seven days's birthdays in the result. Something's wrong with my script below and would appreciate it if somebody could just have a quick look and let me know. Everything works well, but at the end of the month the order by doesn't work 100%
Below is the code:
<%
Function formStr(s)
if not isNull(s) then
formStr = UCase(Left(s,1)) & lCase(right(s, len(s)-1))
else
formStr = ""
end if
End Function
View Replies
View Related
i have a website on fast hosts and i have a mssql data base, i have set up the data base using enterprise manager. and i am now trying connect to it it via asp page but i am getting this message. is this wrong?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login ' lstudents'. Login fails.
/default.asp, line 14
here is the line of my code that connects to the database.
<%conn.open "DRIVER={SQL Server};SERVER=213.171.218.235;UID=xxxxxx;PWD=xxxx xx;DATABASE= mytable"%>
View Replies
View Related
I have taken over a e-commerce site that uses, ASP, MSSQL, stored procedures and cookies. For the most part it works fine. However for some reason when the user comes to the site for the first time (and therefore has not cookies for the site) there order does not go through properly. I have been discussing this issue on experts exchange and the situation is probably clear if you have a quick read of URL....
View Replies
View Related
what are some simple fuctions, like how do i get the date using mssql. also wheres a good tutorial on mssql
View Replies
View Related
How can I do a query like below on a MSSQL server? The format of the date in the db is 10/9/2004 8:38:01 PM
onlinedate = now()
strTimeout = 5
StrOnlineTimedout = dateadd("n",-strtimeout*3,onlinedate)
StrSql = "DELETE FROM active_users WHERE Last_Seen < " & StrOnlineTimedout &""
View Replies
View Related
