If you are passing in a connection string you need to enclose it in " marks. AddUser.asp <% dim rsUsers set rsUsers=Server.CreateObject("ADODB.Recordset") SQL_str="Select * from Person where E_Mail='" & Session("E_Mail") & "' and Pword='" & Session("FormPass") & "'" rsUsers.Open SQL_str, objConn,adOpenForwardOnly, adLockOptimistic, adCmdTable --> shows Error on I'm not sure why it isn't. United States English English IBM® Site map IBM IBM Support Check here to start a new keyword search.
To start viewing messages, select the forum that you want to visit from the selection below. The time now is 05:43 AM. The error is in the Conn.open line because the connection string parameter passed is invalid probably because of that "" in pwd. I'd say you're trying to pass char data to either a numeric or date required parameter.Brett8-) Krb_iiaba Starting Member 16 Posts Posted-02/19/2004: 15:24:59 @CounterName varchar(30) MichaelP Jedi Yak
You may have to register before you can post: click the register link above to proceed. I've tried the following options: - enclosed the connection and recordset with application("") var - unique connection and recordset names - opened connection and recordset.. - without application("") > the error I am using two files here. X002548 Not Just a Number 15586 Posts Posted-02/19/2004: 15:23:02 Do you know the paramter list of the sproc?
Back to top #3 [email protected] [email protected] Newbie Members 3 posts Posted 11 July 2011 - 12:49 PM Is your spread sheet open in Excel when trying to connect to it? wrote: >> rsItems.Open "Item", objConn, 0, 3,2 > > Thanks for the suggestion. Example of the correct use of the Recordset's Open method would be: strSQL = "SELECT field1, field2 FROM table1" strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db1.mdb" objRS.Open strSQL, strConnect, adOpenForwardOnly, adLockReadOnly, adCmdText - or Substitute the constant names until you discover which > name is undefined. > > The fact that you have undefined constants indicates a problem with the type > library file.
In BarTender format, remove database connection setup and connect again. - Try ODBC connection to the Excel sheet(You need to create ODBC datasource by ODBC Administrator)also in this stage, please ask Come on over! However,my ado recordset returns this error:: : >ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range...: : The code is working on asp pages except in global.asa. Regards, Nick D.
Reply With Quote 07-23-2006,04:42 PM #4 Terrorke View Profile View Forum Posts Registered User Join Date Mar 2006 Posts 591 Use BETWEEN in your sql statement Code: "SELECT * FROM tbl_Bro What I want is for expeduc.asp to display information from the database, that is, if the database contains the "id" of the person displayed in expprof.asp, otherwise, display an ADD form And another file (expeduc.asp) which is also included in the first file (