Hi Mark,
If you mean on any of my websites I am using neither.
Thank You,
-Augie Marcello III
--- Mark E <[EMAIL PROTECTED]> wrote:
> Are you using SQL Server or Access? I see a
> reference to each and want to be sure.
>
> Mark
>
> kuku b <[EMAIL PROTECTED]> wrote:
> well it stilll didn't work.now its giving an error
> as
> Microsoft OLE DB Provider for ODBC Drivers
> (0x80004005)
> [Microsoft][ODBC Driver Manager] Data source name
> not found and no default driver specified.
> I have made a table inventory which is inside
> inventory db,
> & i have stored it in same file as my asp page.
> Mark E <[EMAIL PROTECTED]> wrote:
> This should work for sql server:
>
> Set conn = Server.CreateObject("ADODB.Connection")
>
> aConnectionString="DRIVER={SQLServer};" & _
> "SERVER=localhost;UID=sa;" & _
> "PWD=;DATABASE=inventory"
>
> conn.open aConnectionString
>
> Mark
>
> kuku b <[EMAIL PROTECTED]> wrote:
> I tried to do that but it didn't work
> so the next thing itried was
> strConn = "DBQ=My Documents\inventory\inventory.mdb"
>
> conn.open "DRIVER={Microsoft Access Driver
> (*.mdb)}; " & strConn
> but this too is giving an error as
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers
> (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver]
> '(unknown)' is not a valid path. Make sure that the
> path name is spelled correctly and that you are
> connected to the server on which the file resides.
> i think i am giving the right path.
> well i don't know whats the problem.
>
> Mark E <[EMAIL PROTECTED]> wrote:
> I think this line:
>
> conn.open
>
> Should be like this:
>
> conn.open aConnectionString
>
> You are not specifying a connection string while
> trying to open your connection. That's what the
> error means.
>
> Mark
>
> kb1711 <[EMAIL PROTECTED]> wrote:
>
> hi i am getting this error when i am trying to
> connect my asp page
> with the db which has 2 tables.
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers
> (0x80004005)
> [Microsoft][ODBC Driver Manager] Data source name
> not found and no
> default driver specified
>
>
> my code
>
> <%@ Language=VBscript %>
> <% option explicit %>
> <html>
>
> <head>
> <meta http-equiv="Content-Language" content="en-us">
>
> <meta http-equiv="Content-Type" content="text/html;
> charset=windows-
> 1252">
> <title>All the values with an asterisk</title>
> <meta name="Microsoft Theme" content="compass 1011">
>
> </head>
>
> <body>
> <%
> dim serialnumber
> dim modelnumber
> dim description
> dim errorMsg
> dim i
> dim conn
> dim SQL
> dim R
> dim RecsAffected
> dim aConnectionString
> dim adModeReadWrite
> dim adUseClient
>
> if Request.ServerVariables("REQUEST_METHOD")="POST"
> THEN
> serialnumber = Request.Form("serialnumber")
> modelnumber = Request.Form("modelnumber")
> description = Request.Form("description")
> serialnumber = trim(serialnumber)
> modelnumber = trim(modelnumber)
> description = trim(description)
>
> if len(serialnumber)=0 then
> errorMsg = "You must enter the serial number"
> else
> for i=1 to len(serialnumber)
> if instr(1,"abcdefghijklmnopqrstuvwxyz-*" ,mid
> (serialnumber,i,1),vbTextcompare)=0 then
> errorMsg="serial number is not valid"
> exit for
> end if
> next
> end if
> if len(errorMsg)=0 then
> if len(modelnumber)=0 then
> errorMsg = "You must enter the model number"
> else
> for i=1 to len(modelnumber)
> if instr(1,"abcdefghijklmnopqrstuvwxyz-*'", mid
> (modelnumber,i,1),vbTextcompare)=0 then
> errorMsg="model number is not valid"
> exit for
> end if
> next
> end if
> end if
> if len(errorMsg)=0 then
>
> Response.Write "Serial Number=" & serialnumber
> Response.Write "Model Number=" & modelnumber
> Response.Write "Description=" & description
> end if
> if len(errorMsg)= 0 then
> aConnectionString= "Provider=SQLOLEDB;Data"
> & "Source=(local);Database=ClassRecords;"
> & UID=sa;PWD=;"
> set conn=Server.CreateObject("ADODB.Connection")
>
> conn.Mode=adModeReadWrite
> conn.ConnectionString=adUseClient
> conn.open
>
> conn.BeginTrans
>
> SQL="INSERT INTO inventory
> (serialnumber,modelnumber,description)
> values("& serialnumber & ", " & modelnumber & ", '"
> & description
> & "')"
> conn.Execute SQL
> if conn.Error.Count = 0 Then
> conn.CommitTran
> Else
> conn.RollbackTrans
> end if
> conn.close
> set conn=Nothing
> end if
>
> end if
> %>
>
> <p><i>All the fields with asterisk(<font
> color="#FF0000">*</font>)
> sign are
> <font color="#FF0000">mandatory</font></i></p>
> <p></p>
> <form name= "frmuserInfo" action= "inventory.asp"
> method= "post">
> <%if len(errorMsg)>0 then
> Response.Write "<p><font color = red> "& errorMsg &
> "</font></p>"
> end if
> %>
>
> <table border="0" cellpadding="0" cellspacing="0"
> width="40%">
> <tr>
> <td width="30%"><b>Serial number</b></td>
> <td colspan="2"><b><input type="text"
> name="Serialnumber" value="<%
> =serialnumber %>"></b></td>
>
> </tr>
> <tr>
> <td ><b>Model number</b></td>
> <td colspan="2"><b><input type="text"
> name="modelnumber" value="<%
> =modelnumber %>"></b></td>
>
> </tr>
>
> <tr>
> <td><b>Description</b></td>
> <td colspan="2">
> <select >
> <option selected value="none">none</option>
> <option value="keyboard">Keyboard</option>
> <option value="scanner">scanner</option>
> <option value="fingerprintreader">finger print
> reader</option>
> </select><p>
> </tr>
> <tr>
> <td align=center> </td>
> <td align=center width=110><input name="Submit"
> type=submit
> value="Submit"></td>
> <td align=center width=100><input name="Reset"
> type=reset
> value="Reset"></td>
> </tr>
>
>
>
>
>
> </table>
> </form>
> </body>
>
> </html>
>
>
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
>
[EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
> Yahoo! Groups Sponsor
> Get unlimited calls to
>
> U.S./Canada
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
>
[EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Check out the new Yahoo! Front Page. www.yahoo.com
>
> [Non-text portions of this message have been
> removed]
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
>
[EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
>
[EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Check out the new Yahoo! Front Page. www.yahoo.com
>
> [Non-text portions of this message have been
> removed]
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
>
[EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
