Forums

This topic is locked

Connecting a ms access database to DW

Posted 20 Mar 2008 12:19:10
1
has voted
20 Mar 2008 12:19:10 alice xiao posted:
hi, all...i'm new here...i want to ask u sth about the connection problem.
when i connect the database to DW, every thing seems correct, and when i add database to the asp file, i also got successful connection on the testing server.
but when i displayed it using IE, the problem came. it told me that The page cannot be displayed...and it provided the following information: Technical Information (for support personnel)

<b>Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/new web/sdhwobgmain.asp, line 5


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.2)

Page:
GET /new web/sdhwobgmain.asp

Time:
Thursday, March 20, 2008, 5:07:53 PM</b>

what does this mean?

the following are the particulars of my asp file:
file name: sdhwobgmain
my connection string is:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/New Web/data/MOCSDHWOBGDate.mdb"

Replies

Replied 20 Mar 2008 23:06:37
20 Mar 2008 23:06:37 Javier Castro replied:
The error could be that you are trying to pass a numeric data to text or vice versa.
What is your Query????

Javier
"I'm a slow learner and I forget fast" grandpa
DW | FW | ASP | HTML | CSS
Replied 24 Mar 2008 04:06:15
24 Mar 2008 04:06:15 alice xiao replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
The error could be that you are trying to pass a numeric data to text or vice versa.
What is your Query????

Javier
"I'm a slow learner and I forget fast" grandpa
DW | FW | ASP | HTML | CSS
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
thanks for ur reply!

i want to connect an empty db to a webpage, like a contact list, and the users can update the details of the list or edit or delete a particular row...
Replied 24 Mar 2008 08:34:01
24 Mar 2008 08:34:01 alice xiao replied:
i solved the prob by using the following string fomat~
MM_connRealtor_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=(C:\Inetpub\wwwroot\New Web\data\MOCSDHWOBGDate.mdb)"
<img src=../images/fwzone/forum/icon_smile_big.gif border=0 align=middle>

Reply to this topic