asp: establishing connection to dbase

[hybrid_X]

---

how to resolve database connection in asp. the dbase source is currently located in my domain provider. my current application/package both support ms access database and asp.


currently im using the code and it sending an error :

Set mycon = Server.CreateObject("ADODB.Connection")
mycon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/db/contacts.mdb")



error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[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.

/dbview.asp, line 5




Set mycon = Server.CreateObject("ADODB.Connection")
mycon.Open "DSN=contacts.mdb.dsn"

error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/dnsview.asp, line 5




any help will greatly appreciated.tnx

[kibotizer]

mao ni ako codes kung mag-connect ko bai...


palihug lang ug study ani nga codes

conString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath("data/database.mdb") & ";"

Set con=Server.CreateObject("ADODB.Connection")
con.ConnectionString=conString
con.Open
.
.
.
.
.
con.Close


so far OK man ni siya nako nga codes...

wala ko mag-gamit ug DSN


hope nakatabang ni



yeah! bling bling men...abz'

[hybrid_X]

ol rights bro. i made it work now.

anyway do u have xperience in online db program (asp-access) development and implementation.

[kibotizer]

ol rights bro. i made it work now.

anyway do u have xperience in online db program (asp-access) development and implementation.

yap naay gamay bro... hehee...


bitaw nag-praktis praktis lang ko...http://f1society.freespaces.com


wala pa mahuman...


by da way bai nag-work ka o nag skul?


ngita bitaw ko company asa ko mag-OJT karon summer... requirement man gud namo para 4th year



yeah! bling bling men...abz'

[hybrid_X]

working ko ron. my proj include 2tier and 3tier in-house database server for the company system. human na ko sa 2tier(client server) under prototype model. my prob is the online dbase kai gusto sa dsign na ang dbase server ibutang sa company office not na i upload sa provider. nya were currently using windows server wla pa man ngani gud specific server. our site available at www.gpzgroup.com. naa pre upload asp pra test www.gpzgroup.com/lpo/materials.asp

i was thinking kong pd ra mag url redirection like what i did sa mu online private server na akong gi buhat. though php and sql server ang gamit adto i think pd ra pod ang access and asp.

anyway kong ok lang i upload ang dbase sa provider i think maka proceed dayon ko. bago ra pud ko sa asp nd my d online transaction required asp+script(ajax,etc)...

kong naa ka kaila bro pd makatabang pra sa akong project pd pa list pud pra ka ask ko nila

[kibotizer]

2tier and 3tier in-house database server for the company system... wala ko kaila... hehe...


unsa diay nga company imong gi-trabahoan bai?,.. unsay product or output nila?


layo-a na siguro nimo ug naabtan... ako kay student pa intawon... mag-lisod jud ko ug tabang bro...


wala pa ko kasuway ug AJAX...


ako kamao sa dynamic web development kutob pa man sa "ASP - ACCESS" ug "PHP - MYSQL"(gamay)

naa ko kaila bag-o lang ni-graduate, skillful kaayo to... dali ra kaayo makat-on... hehe...

yeah! bling bling men...abz'

[hybrid_X]

2tier(eg. client-server application) 3tier(eg online dbase transaction)

dre ko work: www.gpzgroup.com

kong plan ka abroad usually sqlserver,oracle linux e focus kai mostly mao na gi require.

[kibotizer]

cebu rana nga company bai?

sige lang bai, mag-tuon lang ko aning SQL SERVER... salamat

basin naa ka mga ebooks or other ma-share diha bai... e-share lang... hehe


yeah! bling bing men...abz'

[hybrid_X]

sowe bai kai la ko ron available na ebooks.

[kibotizer]

sowe bai kai la ko ron available na ebooks.

ok lang...



yeah! bling bling men...abz'