Home > Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.
PhpMyAdmin to import a text file to a table
Hi, I am trying to import data to SQLServer DB using PhpMyAdmin. The data is in Microsoft Access. I figured out how to export data from Access table to .csv file. My question is how do i import this data to SQLServer DB? I tried usin...
Hi, I am trying to import data to SQLServer DB using PhpMyAdmin. The data is in Microsoft Access. I figured out how to export data from Access table to .csv file. My question is how do i import this data to SQLServer DB? I tried usin...
answer(3) view(112) status(
)
)
Server: Msg 3701
Hallo! I have a problem with my sql server. I create a temporary table, like so: Code: create table #tempTable ( userId int ) This works just fine But when I try to drop the same table: Code: drop table ...
Hallo! I have a problem with my sql server. I create a temporary table, like so: Code: create table #tempTable ( userId int ) This works just fine But when I try to drop the same table: Code: drop table ...
answer(4) view(550) status(
)
)
Web Config
What is the purpose of Web.Config File. Is it act as an intermediate between the application and database.
What is the purpose of Web.Config File. Is it act as an intermediate between the application and database.
answer(1) view(947) status()
)
syntax error in id query HELP!!!!!!
i have 1 page which gives the results of a data base search. the title of each result is hypertext so clicking on it will open a second page which will contain the other fields of the same database record.I have used the ?id? field for this...
i have 1 page which gives the results of a data base search. the title of each result is hypertext so clicking on it will open a second page which will contain the other fields of the same database record.I have used the ?id? field for this...
answer(1) view(781) status()
)
Insert , Delete ,Update Data Using SQL Connection
I have come across the script in ASP.net With Vb.net for undating, inserting and deleting data in an application.But then when I run it in my PC it could not cater the application to run as normal.What I feel hear is, do we need some interm...
I have come across the script in ASP.net With Vb.net for undating, inserting and deleting data in an application.But then when I run it in my PC it could not cater the application to run as normal.What I feel hear is, do we need some interm...
answer(3) view(1,000) status()
)
How to simulate a 1rst,previous,next,last form
I wanted to simulate a form like this<br><br>Name:<br>Adress:<br>Country:<br><br>[FIRST][PREVIOUS][NEXT][LAST] [NEW] [UPDATE] -> This are buttons!<br><br>with ASP.NET (VB.NET), can you guys...
I wanted to simulate a form like this<br><br>Name:<br>Adress:<br>Country:<br><br>[FIRST][PREVIOUS][NEXT][LAST] [NEW] [UPDATE] -> This are buttons!<br><br>with ASP.NET (VB.NET), can you guys...
answer(1) view(181) status()
)
Error msg: Operation must use an updateable query
I'm trying to insert data into a database with a web form and I get the message "Operation must use an updateable query" when I try the page using my own web server. When I upload the pages to a ASP.Net hosting service the page w...
I'm trying to insert data into a database with a web form and I get the message "Operation must use an updateable query" when I try the page using my own web server. When I upload the pages to a ASP.Net hosting service the page w...
answer(5) view(372) status()
)
Welcome
The first post in a new forum.
The first post in a new forum.
answer(0) view(1,022) status()
)
ASP Database Problem
I hope there's a genius ASP programmer out there somewhere. I'm having a real problem with a client's ASP website that I just cannot understand or solve.<br><br>Ten points to the anyone that can help!!<br><br>The si...
I hope there's a genius ASP programmer out there somewhere. I'm having a real problem with a client's ASP website that I just cannot understand or solve.<br><br>Ten points to the anyone that can help!!<br><br>The si...
answer(5) view(849) status()
)
Recordset loops and javascript......
Im trying to perform a Javascript function for each iteration of a retrieved recordset. However as expected, I found the two don't always like working in tandom together. Basically my function needs data from the record set, does some calcu...
Im trying to perform a Javascript function for each iteration of a retrieved recordset. However as expected, I found the two don't always like working in tandom together. Basically my function needs data from the record set, does some calcu...
answer(0) view(483) status()
)
database and asp
Hi Guys, <br>I've never done asp programmin in my entire life hehe but as part of a uni project I need to create a database for a real estate company. (never created a database before either!)<br><br>I need to create somet...
Hi Guys, <br>I've never done asp programmin in my entire life hehe but as part of a uni project I need to create a database for a real estate company. (never created a database before either!)<br><br>I need to create somet...
answer(2) view(519) status()
)
insrtng, dltng, updatng, viewing data f accss/sql
I am a begginer in ASP. I have been developing a web site with ASP. I 'd like to register users, let them view data from the database, and update database information as web master. As well as send e-mail to the visitors.<br><br>...
I am a begginer in ASP. I have been developing a web site with ASP. I 'd like to register users, let them view data from the database, and update database information as web master. As well as send e-mail to the visitors.<br><br>...
answer(1) view(199) status()
)
Beginning
Where can I get the full idea of creating a web form for beginners developers.<br><br>Thank You Very Much....
Where can I get the full idea of creating a web form for beginners developers.<br><br>Thank You Very Much....
answer(1) view(296) status()
)
filling textbox
I am looking for a code example that when a hyperlinked record is clicked a new page is called and text boxes on that page are filled from an access database using that hyperlink in asp.
I am looking for a code example that when a hyperlinked record is clicked a new page is called and text boxes on that page are filled from an access database using that hyperlink in asp.
answer(1) view(457) status()
)
Updating DataSet from an edited DataGrid
I have a DataGrid that allows editing of records. I have taken over the OnUpdateCommand event and I wish to move the edited values back into the proper DataRow of a persisted dataset. Basically, I want to let the user modify one or more r...
I have a DataGrid that allows editing of records. I have taken over the OnUpdateCommand event and I wish to move the edited values back into the proper DataRow of a persisted dataset. Basically, I want to let the user modify one or more r...
answer(2) view(254) status()
)
how to preserve a userid and password information
Hello Everyone,<br><br> Using ASP I'm trying to logon to a "*.mdw" database. I'm successful there and once the connection is established I'm directing the user to another asp page to select the options they want. ...
Hello Everyone,<br><br> Using ASP I'm trying to logon to a "*.mdw" database. I'm successful there and once the connection is established I'm directing the user to another asp page to select the options they want. ...
answer(2) view(196) status()
)
ASP.NET COUNT
I'm new to ASP.NET and think I've missed something. In JSP and PHP it's normally pretty easy to get the result from a bog standard SQL COUNT statement. In ASP.NET it seems as though you have to bring back the whole data set, then count up...
I'm new to ASP.NET and think I've missed something. In JSP and PHP it's normally pretty easy to get the result from a bog standard SQL COUNT statement. In ASP.NET it seems as though you have to bring back the whole data set, then count up...
answer(1) view(763) status()
)
So what do you do if you have NO IDEA
I created our website but now I need to setup a service for our customers to submit data into our website to create an educational resorce.<br><br>I can use any method available.<br><br>They would need to register a...
I created our website but now I need to setup a service for our customers to submit data into our website to create an educational resorce.<br><br>I can use any method available.<br><br>They would need to register a...
answer(0) view(822) status()
)
adovbs.inc constants
Hi i Hope you can help me, This is my first attempt at accessing a database from a asp page. I have included adovbs.inc in the top of my page, but when i run the file i recive the error listed below. I do not think i have redifined any cons...
Hi i Hope you can help me, This is my first attempt at accessing a database from a asp page. I have included adovbs.inc in the top of my page, but when i run the file i recive the error listed below. I do not think i have redifined any cons...
answer(1) view(367) status()
)
T-SQL 'PRINT' Statement / Multiple Recordsets
I've got a SP which returns information back in the following format (when viewed as Text in SQL7' Query Analyzer) ...<br><br><font style="color:000099;">PIN = xxxyyy OWNER = Paul blaaar ...
I've got a SP which returns information back in the following format (when viewed as Text in SQL7' Query Analyzer) ...<br><br><font style="color:000099;">PIN = xxxyyy OWNER = Paul blaaar ...
answer(0) view(500) status()
)
Hyperlinks on Intranet
I have been successful with the creation of a database and a search results page. My need is for the following:<br><br>From the records returned in the results page I need to open another page (popup) with more detailed inform...
I have been successful with the creation of a database and a search results page. My need is for the following:<br><br>From the records returned in the results page I need to open another page (popup) with more detailed inform...
answer(2) view(363) status()
)
Problem with dropdownlist and stored procecedure
I managed to pass values to the stored procedure by entering the values into the parameters collection successfully using a webform generated code below:<br><br>Me.OleDbCommand1.Parameters.Add(New System.Data.OleDb.OleDbParamete...
I managed to pass values to the stored procedure by entering the values into the parameters collection successfully using a webform generated code below:<br><br>Me.OleDbCommand1.Parameters.Add(New System.Data.OleDb.OleDbParamete...
answer(0) view(184) status()
)
stored proc problem
I have a stored proc on a sql 6.5 svr. that run fines from the SQL anlizer, and in VB6 code.<br><br>However when I run it from asp it blows up. saying that cant <br>ADODB.Recordset error '800a0e78' <br><br>Op...
I have a stored proc on a sql 6.5 svr. that run fines from the SQL anlizer, and in VB6 code.<br><br>However when I run it from asp it blows up. saying that cant <br>ADODB.Recordset error '800a0e78' <br><br>Op...
answer(1) view(544) status()
)
Accessing Database Information
I am trying to pull data from an Access database. The results of this data will be displayed in a table. I am guessing that it should be done with If/Then statements but can't seem to get the results I want. <br><br>As an exampl...
I am trying to pull data from an Access database. The results of this data will be displayed in a table. I am guessing that it should be done with If/Then statements but can't seem to get the results I want. <br><br>As an exampl...
answer(0) view(535) status()
)
Error Openning database.
Hello everybody...<br><br>My web application works fine, but when some different people try to open the databse, I get the following error...<br><br>Microsoft JET Database Engine error '80004005' <br>Cannot op...
Hello everybody...<br><br>My web application works fine, but when some different people try to open the databse, I get the following error...<br><br>Microsoft JET Database Engine error '80004005' <br>Cannot op...
answer(2) view(551) status()
)
Updating ORACLE BLOB using ASP 3.0/IIS5.0
<u>Updating ORACLE BLOB using ASP 3.0/IIS5.0</u><br><br>Dear All, <br> <br>I have an ORACLE database server (8.1.6) with database and a WEB Server that using IIS5.0/ASP 3.0. <br><br>I am tryin...
<u>Updating ORACLE BLOB using ASP 3.0/IIS5.0</u><br><br>Dear All, <br> <br>I have an ORACLE database server (8.1.6) with database and a WEB Server that using IIS5.0/ASP 3.0. <br><br>I am tryin...
answer(0) view(958) status()
)
how to change from OLE object to image
i want to know how to input the image to sql database <br> <img border="0" src="/forum/emoticons/jumpin.gif" height="31" width="31" alt="jumpin" /> <img border="0" ...
i want to know how to input the image to sql database <br> <img border="0" src="/forum/emoticons/jumpin.gif" height="31" width="31" alt="jumpin" /> <img border="0" ...
answer(4) view(1,036) status()
)
Need Help on .NET and ORACLE DB Connection
TESTED CONNECTION-WORKS FINE BUT RUNNING OF APPLICATION GIVE THE FOLLOWING ERROR: DATA FROM DB NOT DISPLAYED IN MY APPLICATION PLS HELP THNX.<br><br><br><br>Server Error in '/ORACLE_PDAFRS' Application.<br>----...
TESTED CONNECTION-WORKS FINE BUT RUNNING OF APPLICATION GIVE THE FOLLOWING ERROR: DATA FROM DB NOT DISPLAYED IN MY APPLICATION PLS HELP THNX.<br><br><br><br>Server Error in '/ORACLE_PDAFRS' Application.<br>----...
answer(1) view(922) status()
)
Implementing ODBC in ASP .NET
<b>The Problem</b><br><br>Anybody who has ever connected a web page to a simple database is probably familiar with Microsoftæ¯ Open Database Connectivity (ODBC) interface. This is the interface that enables a develope...
<b>The Problem</b><br><br>Anybody who has ever connected a web page to a simple database is probably familiar with Microsoftæ¯ Open Database Connectivity (ODBC) interface. This is the interface that enables a develope...
answer(0) view(391) status()
)
What prevents me from reading the msysobjects tbl?
Hello,<br><br>I've created an asp page that connects to an MS Access database. I want to read the contents of the msysobjects table and display it on the screen.<br>Problem is, I can connect to user tables just fine, but A...
Hello,<br><br>I've created an asp page that connects to an MS Access database. I want to read the contents of the msysobjects table and display it on the screen.<br>Problem is, I can connect to user tables just fine, but A...
answer(2) view(462) status()
)
Programming
Related Pages
- Passing a value into a variable in a Stored Procedure
- text and ntext
- SQL Server Dates
- How can I check if SQL Server 2005 listens on port 1433?
- Visual Studio .NET, ASP.NET DataSet Fill Question...
- Update 1 table feild with 3 values
- Please help! Sql tables & USerID
- SQL 2000 & ASP
- Database Maintanance
- MS SQL Server Query
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2010 by Infoqu. All rights reserved
Copyright 2007-2010 by Infoqu. All rights reserved