CLUELESS - Help This Panicked Dad!
Mar 27, 2006
HELP!
I am in deep do-do. I was to write a db to help with many functions of our office. I asked the web manager if I could link mty mdb file to the webserver, he said it was possible. Now I am 15 days shy of my deadline and he is now telling me I can no longer link my database due to security issues and that I must use SQL... I am not familiar with a SQL environment..... Please help!!!!
I made many forms in access to make my db really interactive like an software application and are wondering how to use data access pages with SQl to not loose my hard work.
Here is what I am given to complete my task:
1. Set up a new web site (and corresponding test site) independent from my current public site.
2. Got SQL Enterprise Manager
3. Was given db_owner privileges to a blank database using Network account
I will get fired if I can not make this work. I have 3 small children and a wife that will be devestated if that happens. Please help me with any programming that you know that will link my data access pages to SQL and/or any programming you think my benefit me in making this possible.
I really appreciate it. I am a very scared daddy right now and have no where to turn. Please HELP!!!!
Lex
View 20 Replies
Feb 17, 2008
Okay no clue where to start off here, long time ASP (old) coder, familiar with JScript / VBScript / WSF / VB / C# / C++ / C in order of knowledge
I'm going cross eyed trying to figure out ASP.NET's functionalityTrying to Connect to an SQL database using the web.config and ADO.Net, but it seems recordsets are a thing of the past.
Where having an include file with
<!--METADATA TYPE="typelib" UUID="00000205-0000-0010-8000-00AA006D2EA4" NAME="ADODB Type Library" -->
<%
sub openDb()
if varType(connTemp)=0 or varType(connTemp)=1 then
' create the connection
set connTemp= server.createObject("adodb.connection")
connTemp.Open sDatabaseConnectionString
end if
end sub
sub getFromDatabase(mySQL, rstemp, scriptName)
call openDb()
on error resume next
set rstemp = server.createObject("adodb.recordset")
' set locktype
rstemp.lockType = adLockReadOnly
' set the cursor
rstemp.cursorType = adOpenForwardOnly
rstemp.open mySQL, connTemp
Isn't done in the same fashion anymore.No clue why, but writing out lines of code is what I am used to, and the built in features grid / dataview of visual studio/web dev are not what I am looking for. Not to mention the limitations of my webspace provider restricting access to MS SQL Server through VS, makes a lot of the features in VS useless.So far i've been able to manage that I can use App_Code/myclass.cs to allow for a globally called class/include file like i'm used to which is compiled on runtime.No clue how to apply it, or make it dynamic however, where I could call information from the database to populate the variables in return allow me to manipulate data..static void init(){
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString);
SqlDataReader rdr = null;
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * from Customers", conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{ Anyone have any useful information as to where I could look to find examples of my style of programming in ASP converted to ASP.NET in C#?
View 5 Replies
View Related
Aug 14, 2006
I would like to convert these IF statements into a case statement, but I have no clue as to how to achieve this. As you can see im using freetext parameters along with other paramaters, please if you can help it would be greatly appreciated.
IF LEN(@keywords)>=1 AND LEN(@organization)<1 AND LEN(@year)<1
BEGIN
SELECT DISTINCT A.RECIPIENT_STATE, B.FISCAL_YEAR, B.FEDERAL_SHARE, B.NON_FEDERAL_SHARE
FROM Tab_Awards AS A JOIN TAB_Amendments AS B ON A.AWARD_NUMBER = B.AWARD_NUMBER JOIN Tab_Program AS C
ON A.FPO_ID = C.FPO_ID
WHERE (FREETEXT(A.*,@keywords))
END
ELSE IF LEN(@keywords)<1 AND LEN(@fromYear)<1 AND LEN(@toYear)<1 AND LEN(@organization)<1 AND LEN(@year)<1
BEGIN
SELECT DISTINCT A.RECIPIENT_STATE, B.FISCAL_YEAR, B.FEDERAL_SHARE, B.NON_FEDERAL_SHARE
FROM Tab_Awards AS A JOIN TAB_Amendments AS B ON A.AWARD_NUMBER = B.AWARD_NUMBER JOIN Tab_Program AS C
ON A.FPO_ID = C.FPO_ID
WHERE A.RECIPIENT_STATE IN (@states) AND C.PROGRAM IN (@program)
END
ELSE IF LEN(@keywords)<1 AND LEN(@organization)<1 and LEN(@year)<1
BEGIN
SELECT DISTINCT A.RECIPIENT_STATE, B.FISCAL_YEAR, B.FEDERAL_SHARE, B.NON_FEDERAL_SHARE
FROM Tab_Awards AS A JOIN TAB_Amendments AS B ON A.AWARD_NUMBER = B.AWARD_NUMBER JOIN Tab_Program AS C
ON A.FPO_ID = C.FPO_ID
WHERE C.PROGRAM IN (@program) AND B.FISCAL_YEAR BETWEEN @fromYear AND @toYear
END
ELSE IF LEN(@keywords)<1 AND LEN(@organization)<1 AND LEN(@year)<1 AND LEN(@toYear)<1
BEGIN
SELECT DISTINCT A.RECIPIENT_STATE, B.FISCAL_YEAR, B.FEDERAL_SHARE, B.NON_FEDERAL_SHARE
FROM Tab_Awards AS A JOIN TAB_Amendments AS B ON A.AWARD_NUMBER = B.AWARD_NUMBER JOIN Tab_Program AS C
ON A.FPO_ID = C.FPO_ID
WHERE A.RECIPIENT_STATE IN (@states) AND C.PROGRAM IN (@program) AND B.FISCAL_YEAR = @fromYear
END
ELSE
BEGIN
SELECT DISTINCT A.RECIPIENT_STATE
FROM Tab_Awards AS A JOIN TAB_Amendments AS B ON A.AWARD_NUMBER = B.AWARD_NUMBER JOIN Tab_Program AS C
ON A.FPO_ID = C.FPO_ID
WHERE (FREETEXT(A.*,@keywords)) AND A.RECIPIENT_STATE IN (@states) AND C.PROGRAM IN (@program) AND B.FISCAL_YEAR BETWEEN @fromYear AND @toYear AND LEN(@organization)<1 AND LEN(@year)<1
END
View 2 Replies
View Related
Nov 13, 2007
I want to select the below info from a sql 2005 db, to use it in a dynamic datadriven menu. Only problem, I don't know how to formulate my select statement. So here's the data
ID, TEXT HREF DESCR PARENTID
1
hMenu1
link1.htm
desc text
0
2
hMenu2
link2.html
desc text
0
3
sMenuM1
link3.htm
desc text
1
4
sMenuTSMenu3
link4.htm
desc text
3
I want the data structured so that below the row with id 1, would come it's subitems, subitems for the subitems and so on. So the recordset I'd like to return would in this case be:hMenu1
sMenuM1
sMenuTSMenu3
hMenu2
I've indented the data just to make things clearer. And finally, I want the substructure to be infinite at least in theory.I also do not want to use recursive logic to do this, if possible. I can change the structure of my table if neeed.Cheers!/Eskil
View 7 Replies
View Related
Mar 19, 2004
Hello all,
I have a database that supports two different applications.
For arguments sake I'll call them "intelligent app" and "clueless app"
The client that provided me the schema for the clueless app used reserved words as field names.
The words used are:
value, state, and time
I explained to the client that modifying them could prevent current/future issues.
The client is an "oracle" db (and in my mind should know better but .....) and responded back to me with the following:
BEGIN QUOTE
They are not currently reserved and there is no guarantee they will ever be reserved. In fact, the SQL server line eliminates as many words from the reserved list as they add with new releases. There are other words on the
possible future reserved keyword list that I do not wish to avoid either unless forced to some day, like depth, size, class, zone, level and others.
END QUOTE
Now for the assistance request, where can I find the documented ramifications of using reserved words?
I want to have my documentation (and my ducks lined up) when this clients portion of the app fails.
Any and all assistance is greatly appreciated.
T. Mullins
View 4 Replies
View Related
