ASP Errors on my page - Dev Articles

Dev Articles Community Forums Sponsor:

May 2nd, 2003, 06:48 AM

dragonsteve

Junior Member

Join Date: Apr 2003

Location: Belgium, Poperinge

Posts: 12

Time spent in forums: < 1 sec
Reputation Power: 0

ASP Errors on my page

Hi,

I'm getting more and more strange errors on my website concerning connections.

As for instance:

PHP Code:


		
			
 ADODB.Connection.1 error '800a0bb9' 



The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. 



/newsite/loadpage.asp, line 63

At line 63 I have the following code:

PHP Code:


		
			
 oConn.Open sConn

//As where sConn equals:

sConn = "provider=Microsoft.jet.oledb.4.0; data source = " & Server.MapPath("/")  & "/databases/drweirdoproductions.mdb"

At first I recieved this error:

PHP Code:


		
			
 ADODB.Connection.1 error '80004005' 



SQLState: IM002

Native Error Code: 0

[INTERSOLV][ODBC lib] Data source name not found and no default driver specified





/newsite/loadpage.asp, line 61

Also on my connection open line.

Could somebody help me on this?
Also any links on help to these errors are welcom.

tHx

May 2nd, 2003, 08:37 AM

crazytrain81

Contributing User

Join Date: Aug 2002

Posts: 232

Time spent in forums: < 1 sec
Reputation Power: 7

that's going to return a screwed up path for your dsn. will have // at the start. try just typing in the path... from the look of th ecode you know where the file lives, so there's no need to add unneeded code.

sConn = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=/databases/drweirdoproductions.mdb"

May 2nd, 2003, 09:17 AM

dragonsteve

Junior Member

Join Date: Apr 2003

Location: Belgium, Poperinge

Posts: 12

Time spent in forums: < 1 sec
Reputation Power: 0

Thx crazytrain81,

That error is away, but now I'm getting the second error back.

The error:

PHP Code:


		
			
 ADODB.Connection.1 error '80004005' 



SQLState: IM002

Native Error Code: 0

[INTERSOLV][ODBC lib] Data source name not found and no default driver specified





/newsite/loadpage.asp, line 63

This is my code..
Line 63 is the oConn.open

PHP Code:


		
			
function loadLinks(sTableName)

        Dim oRS

         Dim collects

        dim returnString

                

        if request.querystring("nbr") = "" then

            Session("nbr") = 1

        else

            Session("nbr") = request.querystring("nbr")

        end if

        sConn = "provider=Microsoft.jet.oledb.4.0; data source =/databases/drweirdoproductions.mdb"

        oConn.Connectionstring = sConn

        

        returnString = "<div name=""moveBack"" style=""background-color: transparent; border: Black; width: 164; height: 32; background-image: url(images/linkbutton.gif);color:white;  text-align: center; vertical-align: baseline; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-style: normal; font-size: xx-small; padding-top: 8;"" onClick=""moveBack();"">Back</div>"

         Set oRS = Server.CreateObject("ADODB.Recordset")

        

         if oConn.State = adStateClosed then

             oConn.Open

         end if

                 

        oRS.Open "SELECT * FROM [" & sTableName & "] WHERE filter = '" & Session("filter") & "' AND seqnbr >= " & Session("nbr") & " AND seqnbr <= " & Session("nbr") + 10 & " ORDER BY Name" , oConn, 2, 3

        If not oRS.EOF Then

            Session("Count") = oRS("filterCount")

           

             Do While Not oRS.EOF

                returnString = returnString & "<div name=" & oRS("id") & " style='background-color: transparent; border: Black; width: 164; height: 32; background-image: url(images/linkbutton.gif);color:white; text-align: center; vertical-align: baseline; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-style: normal; font-size: xx-small; padding-top: 8;' onClick=openLink(this.childNodes) onMouseOver=setComment(this.childNodes) onMouseOut=unsetComment()>"

                // *** Index = 0

                returnString = returnString & "<input type=hidden name=""" & oRS("id") & "comment"" value=""" & oRS("Comment") & """>"

                //*** Index = 1

                returnString = returnString & "<input type=hidden name=""" & oRS("id") & "link"" value=""" & oRS("Url") & """>"

                // *** Index = 2

                returnString = returnString & "<input type=hidden name=""" & oRS("id") & "title"" value=""" & oRS("Title") & vbcrlf & """>"

                // *** Index = 3

                returnString = returnString & "<input type=hidden name=""" & oRS("id") & "label"" value=""" & oRS("Label") & vbcrlf & """>"

                returnString = returnString & oRS("Name")

                returnString = returnString & "</DIV>"

                oRS.MoveNext

           Loop

         End If

        oRS.Close

        Set oRS = Nothing

        oConn.Close

        Set oConn = Nothing

        returnString = returnString & "<div name=""moveForward"" style=""background-color: transparent; border: Black; width: 164; height: 32; background-image: url(images/linkbutton.gif);color:white;  text-align: center; vertical-align: baseline; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-style: normal; font-size: xx-small; padding-top: 8;"" onClick=""moveForward();"">Next</div>"

        

        loadLinks = returnString

    end function

May 5th, 2003, 10:52 AM

crazytrain81

Contributing User

Join Date: Aug 2002

Posts: 232

Time spent in forums: < 1 sec
Reputation Power: 7

Well, those errors mean the path to your DSN is wrong or the file isn't there. The other error means the driver is incorrect...

The formatting and string capitalization has to be correct, just like I put it in my previous post.

May 5th, 2003, 06:54 PM

stumpy

May contain nuts.

Dev Articles Regular (2000 - 2499 posts)

Join Date: Aug 2002

Location: Sydney, AU

Posts: 2,058

Time spent in forums: 5 h 8 m 57 sec
Reputation Power: 9

i don't see oConn get created anywhere?

set oConn = server.createobject("ADODB.connection")

__________________
DevArticles Moderator
BlueSix - Web Development and Consulting

May 8th, 2003, 01:33 PM

dragonsteve

Junior Member

Join Date: Apr 2003

Location: Belgium, Poperinge

Posts: 12

Time spent in forums: < 1 sec
Reputation Power: 0

Thx for the help guys,

seems the problem is at the side of my webhosting.
I can use ASP but it is on a linux server.
So I had to export my Access database to mySQL.
In that case I had to use a DSN.

I never worked before with MySQL so I'm a newbie on that.
Is there anybody who has experience in that mather?
How do I put my database online?
How do I create a dsn on the site of the webserver?

Any help or links on this mather are greatly appriciated.

THX

May 10th, 2003, 07:42 AM

stumpy

May contain nuts.

Join Date: Aug 2002

Location: Sydney, AU

Posts: 2,058

Time spent in forums: 5 h 8 m 57 sec
Reputation Power: 9

Code wise, using mySQL is no different to using MS Access. (well, 95% of it anyway.) The only difference I noticed working w/ mySQL about a year ago is that it doesn't have sub-select functionality.

You don't have to use a DSN to access a DB. Simply use a DSN-less connection, or the OLDDB method - http://www.4guysfromrolla.com/webtech/063099-1.shtml. Both are faster than DSN's.

Other than that, you shouldn't have any problems using mysql.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: