microsoft.public.inetserver.asp.db
  Home FAQ Contact Sign in
microsoft.public.inetserver.asp.db only
 
Advanced search
January 2008
motuwethfrsasuw
 123456 1
78910111213 2
14151617181920 3
21222324252627 4
28293031    5
2008
 Jan   Feb   Mar   Apr 
 May   Jun   Jul   Aug 
 Sep   Oct   Nov   Dec 
2008 2007 2006  
total
microsoft ... asp.db Profile…
RELATED GROUPS

POPULAR GROUPS

more...

 Up
  Invest smart         


Author: Mr. Buck
Date: Jan 31, 2008 20:11

How much profit can you make with one dollar?

Check out this website www.forbuck.com

Without any obligation, registering or other ties make cash!
no comments
  64 bit Server issue         


Author: Stacky
Date: Jan 30, 2008 01:05

Hi

I hope you can help me here.
The problem I am experiencing on the server is related to an issue
with MDAC and 64 bit version of Windows Server 2003.

There is a connection problem between ASP and ODBC. The ODBC source is
working fine, I can test it and connect to the server running MySQL.
When I run an ASP page there is a data provider error.

I made a search on some search engines, including Google, Msn search
and Altavista, with the error code, and looks like the problem is
common with many 64 bit Windows installation and ASP based web
applications.

Is there any patch to install to fix the problem ?

Thanks again for your help.
Regards.

Stephen Stack

--
Stacky
no comments
  adding an image url to a DB         


Author: stevebushe
Date: Jan 29, 2008 12:56

ive been struggling with this problem for a few days. does anyone
know how to add a url to a sql 2000 database. im trying to
build a web app with asp 3.0 and sql2000. instead of storing images
directly to the DB, id like to store the images on the file system and
then have a url in the DB pointing to the images.

any help is appreciated

thanks
4 Comments
  cannot display chinese         


Author: HK newsgroup
Date: Jan 29, 2008 11:24

I cannot display Chinses at ASP page. All chinese data (whatever is
Traditional or Simply Chinese) are displayed as ????.

My website connect to MS SQL Server 2005 and all the chinese data are
displayed as ????.

I try to fix the problem for several days, but still can't fix it. Please
help me to solve this problem.

here is the detail of my system.
* SQL Server 2005 via TCP/IP
* the connection string is "Provider=SQLOLEDB.1;Persist Security
Info=False;User ID=xx;Initial Catalog=websonic_pos;Data
Source=xx.xx.xx.xx;Password=xx;"
1 Comment
  Duplicate entry inserted in the SQL database while calling an ASP         


Author: Noemi
Date: Jan 22, 2008 22:16

Hi All,

I hope I posted this inquiry under the correct forum.

To start off, I have been working on a bug where duplicate inserts happen
when calling an ASP page that does the DB insert processing. We have a
software where a user is given two options to register...
Show full article (2.37Kb)
4 Comments
  Urgent problem about SQL Server         


Author: HK newsgroup
Date: Jan 22, 2008 11:52

Hi,
I have a problem connecting my SQL Server 2005 from a ASP Webpage.

When I trying to connect using the following connection string:
"Provider=SQLOLEDB; Data Source =2xx.xxx.xxx.xxx; Initial Catalog = xxx;
User Id = xxx; Password=xxx"

The browser returns an error:
"Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied."

If I put the ASP page under the same local machine with the SQL Server, it
works fine.
However it failed to connect if I put the ASP page in another client
machine, which then remote connect to the SQL Server machine.

I am sure I have openned the port 1433 and 80, because I can connect by
using SQL Server Management Studio by using the same IP address, and I can
access the IIS thru a client machine.

Is there anything missing in my Win Server 2003 machine that blocked the
connection from Web? or any setting missing in the SQL Server to accept Web
connection?
Show full article (1.01Kb)
1 Comment
  Sporadic connect failures to Oracle         


Author: Frank Burleigh
Date: Jan 21, 2008 13:33

I thought I knew how to do this. But one, low-use web form occasionally
loses form submissions and I haven't been able to understand why. I
can't even duplicate the behavior.

The form's processor is in a JSCRIPT "class" so I'll pull out the
relevant bits below.

Several users report seeing the "cannot save" message "thrown" when the
test for this.aConnection.State!=1 fails.

No other place in the application presents that error, so I'd guess
that's the problem: either the test itself is invalid, or we're really
having trouble making connections.

Hints would sure be appreciated.

this.aConnection=null;

var sConnect="Provider=OraOLEDB.Oracle;Data Source=<>;User
Id=<>;Password=<>";

this.aConnection=Server.CreateObject( "ADODB.Connection" );
if( !this.aConnection )
throw "The application cannot access information.";
Show full article (1.06Kb)
no comments
  retain user rights         


Author: navin
Date: Jan 21, 2008 09:51

Hi All,

i have created a login page for my intranet website. when user logs
in, it also check for the rights which the user has ("admin", "user").
what i want to acheive is that, once user log in, based on the type of
permission, they will be allowed to delete data dispplayed in the
page.

I tried doing this by creating a session variable at the time of
logging in but when i try to retrieve this session variable, it does
not return anything.

Please help and let me know how can i retain the login information for
a user so that it can be used till user leaves the site. below is the
code from login page:

Set cnnSimple = Server.CreateObject("ADODB.Connection")

SQLstr="SELECT * FROM tblBuyers WHERE buyerUserName='" & userName & "'
AND buyerPassword='" & pwd & "';"

'Response.Write(SQLstr)

cnnSimple.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strDBPath & ";"
Set rstSimple = cnnSimple.Execute(SQLstr)
Show full article (1.58Kb)
1 Comment
  Re: ASP page losing formatting with large ADO recordset         


Author: PW
Date: Jan 18, 2008 23:29

I had a similar problem a while back.

Try putting "response.Flush" in the loop where you collect your record set,
after the movenext statement.

Similar to how I do it in this loop ...

Do While Not rs1.EOF
myOption = rs1("ESCI") & " | " & rs1("ESCN")
response.write myOption
response.write "
"
rs1.MoveNext
response.Flush
------ example
Loop

HTH,
PW
no comments
  Problem with queries... Call for help.         


Author: johnmay1248
Date: Jan 18, 2008 09:48

I am having a problem with queries running in this code When I use the
query "SELECT * FROM sample" the code runs and the data grid binds and shows
the contents of the sample table. If I change the query to filter the
results such as "SELECT * FROM sample WHERE (sales > 2000)" the code fails
on - objDataReader =
objCommand.ExecuteReader(CommandBehavior.CloseConnection) with an unknown
error.

If I load the database up into access2000 and run the sql queries they run
as expected so I know they are valid queries of the data

I am a noob at asp.net data. Can anybody give me a hand?

The Code I am using is below followed by the error info with the stack
trace.

-----------------------------------------------------------------------------

Imports System.Data.OleDb
Imports System.Data
Show full article (3.49Kb)
1 Comment
1 2