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.
HELP I can't insert into a database
Hi, I hope somebody help me. I was try from same ways to insert something into my database and I don't know what I'm doing bad. Here is my Code to insert (is simple):<br><%<br><br> Name=Request.Form("Name")<...
Hi, I hope somebody help me. I was try from same ways to insert something into my database and I don't know what I'm doing bad. Here is my Code to insert (is simple):<br><%<br><br> Name=Request.Form("Name")<...
answer(1) view(919) status(
)
)
DropDown Menu - Stop duplicate values showing
I have got a drop down menu that displays everything in my "topic" field in access database. Does anyone know how I can make the values in the dropdown box single values. <br><br>Eg if you had a car colour field "...
I have got a drop down menu that displays everything in my "topic" field in access database. Does anyone know how I can make the values in the dropdown box single values. <br><br>Eg if you had a car colour field "...
answer(1) view(48) status()
)
unable to insert into the database
hi all,<br><br>i created a table. <br><br>example : test<br><br>fieldnames are : col1 , col2 , col3?<br><br>when i am going to insert into the col3? i am getting error. is beacause of ...
hi all,<br><br>i created a table. <br><br>example : test<br><br>fieldnames are : col1 , col2 , col3?<br><br>when i am going to insert into the col3? i am getting error. is beacause of ...
answer(1) view(243) status()
)
HELPppppppppp. Database MSAccess Connection prob
Hi,<br><br>On a network drive accessed by all users,I have created a directory with all security permissions to everyone. Copied the MSAccess database to this directory and granted full control to Everyone.<br><br>&l...
Hi,<br><br>On a network drive accessed by all users,I have created a directory with all security permissions to everyone. Copied the MSAccess database to this directory and granted full control to Everyone.<br><br>&l...
answer(0) view(527) status()
)
Links from database not displaying properly in ASP
In my Access 2000 database, I have several tables in which I am storing information about various countries. One is a lookup table with countryID and countryName. In a related table, I am storing hyperlinks that are relevant for each countr...
In my Access 2000 database, I have several tables in which I am storing information about various countries. One is a lookup table with countryID and countryName. In a related table, I am storing hyperlinks that are relevant for each countr...
answer(3) view(128) status()
)
website triggered by a database
dear everybody,<br>i have a project about a website that is triggered by a database. it has a log-in page using SQL server. mynstructor also required that there be a "session" so that it does no goes directly to the HTML. i ...
dear everybody,<br>i have a project about a website that is triggered by a database. it has a log-in page using SQL server. mynstructor also required that there be a "session" so that it does no goes directly to the HTML. i ...
answer(0) view(687) status()
)
help, I am confused and dazzled
Microsoft OLE DB Provider for SQL Server error '80040e14' <br><br>Line 1: Incorrect syntax near ','. <br><br>/layerdata.asp, line 211 <br><br>I get this error from my hosted website. But when i run the sa...
Microsoft OLE DB Provider for SQL Server error '80040e14' <br><br>Line 1: Incorrect syntax near ','. <br><br>/layerdata.asp, line 211 <br><br>I get this error from my hosted website. But when i run the sa...
answer(1) view(752) status()
)
Dataset in ADO.NET
I am trying to execute the code below but it did not work.<br><br>I want to write the changes to the database but it did not work<br><br>Dim myConn As New SqlClient.SqlConnection("server=ns1;database=dotnet;uid=...
I am trying to execute the code below but it did not work.<br><br>I want to write the changes to the database but it did not work<br><br>Dim myConn As New SqlClient.SqlConnection("server=ns1;database=dotnet;uid=...
answer(2) view(380) status()
)
Getting Oracle to accept username and password
<img border="0" src="/forum/emoticons/jumpin.gif" height="31" width="31" alt="jumpin" /> <br><br> Dim conn = New OracleConnection<br> conn.ConnectionStr...
<img border="0" src="/forum/emoticons/jumpin.gif" height="31" width="31" alt="jumpin" /> <br><br> Dim conn = New OracleConnection<br> conn.ConnectionStr...
answer(0) view(895) status()
)
how do i know which user is entering data?
i am currently working on a cinema website which requires users to book tickets. i have managed to link the website to my database and currently have a robust password and joining page(s) workin with the database.<br><br>howeve...
i am currently working on a cinema website which requires users to book tickets. i have managed to link the website to my database and currently have a robust password and joining page(s) workin with the database.<br><br>howeve...
answer(2) view(929) status()
)
Oracle to Access Migration
Hello Everyone,<br><br>Greetings!<br><br>I am using Oracle 9.2 DB and have a Web Application written in Servlets/JSP.<br><br>Everyday @ 6:00pm I want to convert my Oracle DB to Access DB - what is the Bes...
Hello Everyone,<br><br>Greetings!<br><br>I am using Oracle 9.2 DB and have a Web Application written in Servlets/JSP.<br><br>Everyday @ 6:00pm I want to convert my Oracle DB to Access DB - what is the Bes...
answer(1) view(42) status()
)
Access DB LImits?
Is there a limit to how many people can access my site - or the pages that are delivered from the database. <br><br>Or is there something I need to write into the code so that multiple people can look at it. <br><br>...
Is there a limit to how many people can access my site - or the pages that are delivered from the database. <br><br>Or is there something I need to write into the code so that multiple people can look at it. <br><br>...
answer(3) view(319) status()
)
How to get check boxes for Publisher field
Hi all<br><br>I already have a drop down menu that a user can select a "topic" from, but need some check boxes so the user can run possible queries on the database from whats selected!<br><br>So what I need...
Hi all<br><br>I already have a drop down menu that a user can select a "topic" from, but need some check boxes so the user can run possible queries on the database from whats selected!<br><br>So what I need...
answer(0) view(717) status()
)
Login failed for user NT AUTHORITYNETWORK SERVICE
hi,<br><br>i'm just trying to acces a sql data base wihtin an aspx page... that seem very easy..<br>but i have checked my connectionsrting evrything should be all right, login, pwd...<br><div class="msgQuoteW...
hi,<br><br>i'm just trying to acces a sql data base wihtin an aspx page... that seem very easy..<br>but i have checked my connectionsrting evrything should be all right, login, pwd...<br><div class="msgQuoteW...
answer(2) view(394) status()
)
SQLOLEDB connection error.. help~
I encounter with the problem of connection my data in sql server 2000. I wondering y all the data i retrieve is in this kind of format.. <br>System.Data.Common.DbDataRecord<br>but not the exact value. I am stuck here.. Can somem...
I encounter with the problem of connection my data in sql server 2000. I wondering y all the data i retrieve is in this kind of format.. <br>System.Data.Common.DbDataRecord<br>but not the exact value. I am stuck here.. Can somem...
answer(0) view(629) status()
)
no read permissions?
Hi! <br>I am a asp newbie. I have written a script that is pulling information from a query in an access database, located on an IIS server. I get the following error, and not sure what it means.<br><br>I can connect to ...
Hi! <br>I am a asp newbie. I have written a script that is pulling information from a query in an access database, located on an IIS server. I get the following error, and not sure what it means.<br><br>I can connect to ...
answer(2) view(406) status()
)
add database to server
I am writing an ASP page on my computer running win98 with pws .the connect to the database in acceess its very good (with the ODBC). but how i can put oll my site with database in this server ?with html and js its ok but,with the asp ,d...
I am writing an ASP page on my computer running win98 with pws .the connect to the database in acceess its very good (with the ODBC). but how i can put oll my site with database in this server ?with html and js its ok but,with the asp ,d...
answer(0) view(979) status()
)
add database to server
I am writing an ASP page on my computer running win98 with pws .the connect to the database in acceess its very good (with the ODBC). but how i can put oll my site with database in this server ?with html and js its ok but,with the asp ,d...
I am writing an ASP page on my computer running win98 with pws .the connect to the database in acceess its very good (with the ODBC). but how i can put oll my site with database in this server ?with html and js its ok but,with the asp ,d...
answer(0) view(759) status()
)
Hi,<br><br>If I password protect a folder within my web site, and place an <br>Access database in it, how do I access that database from a web <br>page that resides outside of that folder?<br><br>With a r...
answer(0) view(512) status()
)
MSSQL to DBF import/export
I'm fairly new to MS SQL Server, but I'm looking for someone to point me in the right direction with importing and exporting to a DBF file. Any ideas will be much appreciated. I'm trying to create a site in asp/mssql that will replicate ...
I'm fairly new to MS SQL Server, but I'm looking for someone to point me in the right direction with importing and exporting to a DBF file. Any ideas will be much appreciated. I'm trying to create a site in asp/mssql that will replicate ...
answer(4) view(576) status()
)
MS SQL Installation
Hello everyone. I'm new to MS SQL, I have worked with some DB software before but I'm having trouble with MS SQL installation. I work at a small company and I have decided to start working on Database for a Maintenance Log. I have set ...
Hello everyone. I'm new to MS SQL, I have worked with some DB software before but I'm having trouble with MS SQL installation. I work at a small company and I have decided to start working on Database for a Maintenance Log. I have set ...
answer(2) view(170) status()
)
Where can I get SQL Analyzer or FREE equivalent?
I am trying to install an ASP (Visual Basic) application. It uses a Microsoft SQL database. The installation instructions are: 1. unzip the .zip file to a Web shared (alias or virtual created via IIS) folder 2. create a database ...
I am trying to install an ASP (Visual Basic) application. It uses a Microsoft SQL database. The installation instructions are: 1. unzip the .zip file to a Web shared (alias or virtual created via IIS) folder 2. create a database ...
answer(4) view(207) status()
)
SQL converts ' to " in content output
Hi I am trying to find the easiest way to make sure that all reserved chars are output correctly when rendering content to the web. Characters like ' and bullets etc. are either changed or removed completely. e.g content is enter...
Hi I am trying to find the easiest way to make sure that all reserved chars are output correctly when rendering content to the web. Characters like ' and bullets etc. are either changed or removed completely. e.g content is enter...
answer(1) view(903) status()
)
random display of information from databases
can someone help me... this is my code but whenever i clicked refresh my item seem to become lesser...<br><br> 'make it random<br> Dim x, recordsCount<br> Randomize<br> 'first count how many record...
can someone help me... this is my code but whenever i clicked refresh my item seem to become lesser...<br><br> 'make it random<br> Dim x, recordsCount<br> Randomize<br> 'first count how many record...
answer(1) view(457) status()
)
Access Help using asp scripts
1.table X has 54 records <br>2.inserted 2 more records using asp scripts<br>3.used move.last to read the last record , but for some reasons, it did not read the last record which was the 56th . It just read the 54th record as th...
1.table X has 54 records <br>2.inserted 2 more records using asp scripts<br>3.used move.last to read the last record , but for some reasons, it did not read the last record which was the 56th . It just read the 54th record as th...
answer(2) view(860) status()
)
Urgent! Please help. Can't insert!
Hi, I am running SQL2000 on W2k server. Everything was working fine untill sometime yesterday. All in a sudden, I was not able to insert into my database table. I can do select, and I can even run sp_columns on the table, but when I t...
Hi, I am running SQL2000 on W2k server. Everything was working fine untill sometime yesterday. All in a sudden, I was not able to insert into my database table. I can do select, and I can even run sp_columns on the table, but when I t...
answer(2) view(1,003) status()
)
I/O error (bad page ID) detected during read at offset 0x0000000f3e4000
Hi, Can anyone help me with this error? Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x0000000f3e4000 in file 'C:\Progra...
Hi, Can anyone help me with this error? Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x0000000f3e4000 in file 'C:\Progra...
answer(1) view(17) status()
)
DTS Import File Advice Needed
Hi, Basically I just need some advice. I am using DTS to import a CSV file into my database. This import will take place each day, as a scheduled task. This import will need to totally replace what was in the table before (delete data...
Hi, Basically I just need some advice. I am using DTS to import a CSV file into my database. This import will take place each day, as a scheduled task. This import will need to totally replace what was in the table before (delete data...
answer(0) view(817) status()
)
Complex query
Hi Friends! I have this query which will fetch count of project_ids where proj_CONFIRMED=2 and COUNTRY_ID=6. This is working abs fine. Now I need to add one more to this query. Here is my tables structure. select count(DISTINCT Pd.P...
Hi Friends! I have this query which will fetch count of project_ids where proj_CONFIRMED=2 and COUNTRY_ID=6. This is working abs fine. Now I need to add one more to this query. Here is my tables structure. select count(DISTINCT Pd.P...
answer(1) view(662) status()
)
How do i empty the transaction log in MS SQL 7.0..
How do i empty the transaction log in MS SQL 7.0.. and after the emty.. i offsorse what my stie to still be abel to run.... How do i do that.. Thanks... Reason is my log is getting realy big... Thx BG
How do i empty the transaction log in MS SQL 7.0.. and after the emty.. i offsorse what my stie to still be abel to run.... How do i do that.. Thanks... Reason is my log is getting realy big... Thx BG
answer(1) view(72) status()
)
Programming
Related Pages
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved