ADO.NET ( Connections ..... ? )

[persianboy]

hi,

i'm hosting a site on a web server, i have a page that fills a access database, i cant figure out how to make the connection, cant figure out were to find the Connection String from

i guess i cant make a connection to the database using vs.net since i'm using the professional edition ( regarding to an answer i got in post 1638167 )

i tried making a connection to a local mdb file, then using the same connection string in my web page, by just changing the source, but that didnt work either


so any one with any ideas of what to do?
thanks for your time(s)..

[persianboy]

okay know i checked out my account in the site thats hosting my site and was able to add a DSN
so what next? how do i connect to the database knowing a dsn?

[persianboy]

this is what i got
its an oledb connection the connection string is :
Dim strConn As String = "PROVIDER=Microsoft.Jet.OleDb.4.0;Data Source=" & Server.MapPath("/ain.mdb") & ";User Id=admin;Password=;"

as i mentioned the site supports dsn , but dont know how to do it ( i think for dsn we need odebc , which ado.net doesnt have )

click on the button on www.ain.ae/amir/register to see the error that i'm getting


help is badly needed, i'm stuck in the first step

[VBCrazyCoder]

Not sure, but you should be able to use the dsn instead of your path to the db. The dsn will get resolved into the actual ip and path when requested.

The host should have some samples or help on how to do it too! Unless it is free hosting