Connect To A MSsql Server
how do i connect to the server using asp?
View Complete Forum Thread with Replies
Related Forum Messages:
Connect To MSSQL
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 !
MSSQL SERVER 2000 Connections
i just want to ask how many online connections can mssql server 2000 accomodate at the same time? can it handle 250 to 400 simultaneous connections? the specs of my pc is pentium4, 2gb ram, 80gb hd..is this enough?
View Replies !
Compactability Of Mssql With Linux Server
i want to know the possible activities in mssql configured with Linux server. Because i can't able to execute some of the queries in this Configuration. Like, the query is executed in all display the outputs in windows envirnment, but it shows empty data's in linux Environment. ( also i am using the mssql connectivity in PHP) That is Why?
View Replies !
Connect 2 Server?
i have 2 database server........... i have a pages that need to get data from 2 server....... so, i open connection when want to get data..... but this page, i need to get data from 4 table in server1 and 3 table from server2...... table in server1 have relationship with table server2..... so, i always open connection to server1 and get data..then close.....then open connection to server2 and close........
View Replies !
How To Connect Ftp Server From ASP
I want to connect my ftp server using ASP,how can i connect? Is there any method to do this. If any one knows the solution please let me know. I know how to connect database on ftp server,but now i want to connect to ftp server only. If any related solution urls for this problem please let me know.
View Replies !
How Do I Connect To The Server?
I am about to do the first step of this ASP stuff - have created the file.asp and thankyou.asp and want them into the right folder. But I dont understand how to use IIS to connect to the server, I am renting webspace from somewhere else.
View Replies !
Can't Connect To MySQL Server
I recently got an error message from the Java release: j2rel.4.2_05 regarding c:program filesjavaj2rel.4.2_05injpiexp32.dll This message came in a .log file to my desktop, and since then, every once in a while I get this following error while trying access my pages in which I am creating. Code:
View Replies !
The Transport Failed To Connect To The Server
I tried setting up formmail ASP based on Matt's cgi script but only got these errors when submitting this page: http://www.a2zli.com/surveycl56.htm Formmail v1.3 detected the following errors: error no.: -2147220973 description: The transport failed to connect to the server.
View Replies !
Can't Connect To SQL Server 2005 Db With Asp But Access 2k3 Is Ok.
I am about to migrate my asp web pages from a previous well functioning connection with Access 2003 to SQL Server 2005 Express Edition instead. I have created a database in SQL Server called "test_db". As far as I know I have not set any particular user id or password for the database. In this microscopic database I have onnly a single table called "name" and in this table I have two columns called "fname" and "lname". I have two records stored in the name table. What I want to achieve is simply to display these two records in my asp-page. How can I achieve this and what am I missing here?
View Replies !
Cannot Connect To SQL Server From Application Running On IIS
My website connects to a remote sql server. Application works fine when I run from Visual Studio. But when I run the site from IIS, it shows an error. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
View Replies !
Connect To A Database On A Remote Server
I have my access database on a xp workstation setup as a web server using IIS. I am trying to access the mdb from another web server, but when I run my code below I keep getting : Microsoft ADO/RDS error '800a20ff' Internet Server Error. Code:
View Replies !
How Do I Connect To SQL Server 2005 From Within My Asp Webpage?
I have had a web server up an running for a while based on Access 2003 and asp code. Now I have decided to upgrade the database to SQL Server 2005 (not the express edition). The problem is that I just can't get it to work properly. During the installation I was prompted for an instance name (I chose the default radio button). I am using windows authentication on a Windows 2003 Server OS. I have created a database called "testDB". This database has only 1 table called "testtable" and this table consists of a single column called "name" with just 4 records. I want to display these records in my webpage. The code below works fine with Access 2003 but how should it be changed to work with SQL 2005 too? Code:
View Replies !
Error: The Transport Failed To Connect To The Server
I'm using this coding but get some error. i can't understand this line .Item(sch & "smtpserver") = "<enter_mail.server_here>" mail server means which server im used help me error:Error Type: CDO.Message.1 (0x80040213) The transport failed to connect to the server. <% sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(sch & "sendusing") = 2 ' cdoSendUsingPort .Item(sch & "smtpserver") = "<enter_mail.server_here>" .update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = "basvbas@yahoo.com" .To = "basvbas22@yahoo.com" .Subject = "Sample CDO Message" .TextBody = "This is a test for CDO.message" .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing %>
View Replies !
Error: The Transport Failed To Connect To The Server.
I have a form in my website and keep getting this error I was wondering if anyone could help out with this error message I keep getting <!--#include file="email_validation.asp"--> <% Dim strMailFrom Dim strMailTo Dim strMailServer Dim strMailSubject ' ------------------------------------------------------- ' Stuff you need to change ' ------------------------------------------------------- ..........
View Replies !
Can Connect To A Database On A Remote Server But With An Error
I eventually managed to create a connection between my IIS LocalHost ASP WebPages and my database located on a website on the net. Here is the solution: Dim conn, connect set conn=server.CreateObject ("adodb.connection") connect = "Provider=MS Remote; Remote Server=http://www.example.com; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.mappath("database_filedatabase.mdb") & ";" conn.Open connect When I point my connection to my database on the net like in the code above I get the following error: Error Type: Microsoft ADO/RDS (0x800A2011) Internet Server Error: Object/module not found. Any Suggestions?
View Replies !
Unable To Connect To Live Communication Server Through My Own UI
I am facing a problem that i am unable to connect to Live Communication Server using my own UI. Actually i want to access the API's in LCS through my own UI(which is a messenger UI),which i am using to implement chatting messenger in my project. The main reson is that i dont know the code to connect to this LCS and what namespace shld i use so that i can access all the functionality of my LCS 2005. The coding is to be done in c#. I could have used the MS OFFICE Communicator direcltly but i have to use my oen UI and thus i need to connect to this LCS...
View Replies !
Connect To A Remote Server To Grab Data
I am wondering if it is possible to have an asp script, called script1.asp sitting on a server called server1. when this asp script runs, i want it to connect too a different server (called server2) somewhere else in the world and grab data, maybe an xml file. Is this possible? and if so what is the process called (and/or function names etc) that can help me do this, so i can look them up in google and get cracking on the code.
View Replies !
Mssql
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 !
ASP And MSSQL
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 !
ASP (Javascript) And MSSQL XML
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 !
Stable ASP/MSSQL CMS Out There
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 !
ASP/MSSQL Version
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 !
ASP/VERY COMPLEX MSSQL
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 !
Update Mssql Using Csv Or Xml
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 !
Connecting To MSSQL Db From Web
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 !
Access Vs. MSSQL In ASP
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 !
Stored In MSSQL
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 !
Can Run MSSQL DB In Linux
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 !
MSSQL Connection
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 !
ASP Connection To MSSQL
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 !
ASP/MSSQL To ASP/MySql
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 !
Access VS MSSQL
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 !
MSSQL Select
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 !
Connecting To Mssql
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 !
ASP/MSSQL/Cookie Problem
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 !
MSSQL Date Query
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 !
MSSQL Date Format
I’m new to MSSQL and I’m having a problem with an ASP3 JS website that I’m upgrading from Access. I’m trying to format the date from mm/dd/yyyy as held in the db by GETDATE to display as dd/mm/yyyy on a web page. Previously with the Access db I used: "SELECT format(addate, 'dd/mm/yyyy') as addate1 FROM...” What do you use with MS-SQL?
View Replies !
ASP+IIS4+MSSQL: Unicode Problem
I need to make an ASP page which needs to insert and display multilingual contents like Korean, Chinese, Japanese from a MSSQL DB. After googling, I know that by the using server-side directive "Session.Codepage=65001" and charset UTF-8 in HTML,I can do it in IIS 5.0. But IIS 4.0 seems doesnt support this Codepage. Is there any solution for IIS 4.0?
View Replies !
Extracting Data From MSSQL To Excel
Is it possible to extract data from SQL server to MS Excel ? Say if I have 2 tables (Membership and Profile) and extract some certain datas from those 2 tables; MemberID, Member Name, Birthday, Interest; could it be possible to extract them automatically everyday at 1 AM without me doing it manually? Perhaps its possible to do it with Stored Procedure? or some other means?
View Replies !
Problem With Inserting Date Value Into MSSQL
I'm trying to insert a date value into MSSQL, the type of the sql filed is: "smalldatetime" and i'm trying to insert a text Variable that looks like this: "19/02/2006". .... SET update_date='" & Update_Date & "' ... i get the message: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value
View Replies !
|
TRACKER
