Forums

This topic is locked

at what point do you start ripping hair out?

Posted 04 Jul 2001 13:47:39
1
has voted
04 Jul 2001 13:47:39 jon badda posted:
This is a long post, so please bear with me.

heres what i have. im using UD4, and have two connections that work.

one works on my local machine using a dsn-less connection and works fine.
the other works with my database server side and also works (its tests are succeeful and i can insert data from it)

Now the problem is, every time i go to open a .asp page that uses the database in someway (displaying or inserting entries) it gives me errors like this:

"
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/esquared/com_general.asp, line 5
"

or something similar. but a common trait is the same line, and that line in the file is:

"
rsComDetailGeneral.ActiveConnection = MM_connServerTestdata_STRING
"

and then that line relates to the connection i have for the server side database.

The serverside connection tests succesfully and i can insert data from it (albeit after an intial long wait).

what the problem? why ami getting those damn error messages? i havent been able to view a database driven page yet.

Sorry to make this so long, but at what point do you start ripping your hair out?

if any additional information is required, just ask.

Replies

Replied 06 Jul 2001 19:30:13
06 Jul 2001 19:30:13 Joel Martinez replied:
hmmm..... try to debug the connection string by doing a response.write before the errorline:

response.write MM_connServerTestdata_STRING
rsComDetailGeneral.ActiveConnection = MM_connServerTestdata_STRING

tell me what the output is, along with what database server/language/platform you're using

Joel Martinez

----------
Is this thing on?....
Replied 11 Jul 2001 15:52:34
11 Jul 2001 15:52:34 jon badda replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
hmmm..... try to debug the connection string by doing a response.write before the errorline:

response.write MM_connServerTestdata_STRING
rsComDetailGeneral.ActiveConnection = MM_connServerTestdata_STRING

tell me what the output is, along with what database server/language/platform you're using

Joel Martinez

----------
Is this thing on?....
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

sorry mate, but I figured it out by myself after all the torment. After moping about on the inet for ages, posting long agonising pleas for attention, and not getting any, i realised i was basically on my own (sniff).

but this string worked (one line)


MM_connTestdata_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("..\username\dbpath\database.mdb" & ";User Id=admin;"

so basically "../dbpath" with the server.mappath is what was hamstringing me. it said it was working and tested fine, but wasnt. so after a last ditch attempt i was just fucking around with it and made it work.

hoorah for me.

Replied 11 Jul 2001 21:23:15
11 Jul 2001 21:23:15 Joel Martinez replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
sorry mate, but I figured it out...
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
no need to be sorry, good job<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

----------
Is this thing on?....

Reply to this topic