I need some help with database connections.

Here's the situation. I made some aspx pages that that use an OleDb Connection to call up an Access database and create DataSets, DataTables, etc. This works great on my WinXP machine.

I just uploaded my pages and database to my hosted server and it doesn't work, just hangs there without error. Tech support says they don't support DSN-less connections, they made a DSN on the server for me and told me to use ADODB.Connection to connect to it.

Now, I'm pretty new to ASP and Web Databases, but isn't ADODB.Connection for ADO/ASP and not ADO.NET/ASP.NET? ADO uses Recordsets, not Datasets so I'd have to completely rewrite everything.

Is there any way to connect to this database using the DSN or otherwise so that I don't have to rewrite everything? Is my host wrong for not supporting the OleDb Connection or is that pretty normal?

Thanks
-Tom

You're right, ADODB.Connection is for ADO/ASP. You won't have to completely re-write everything, but I think you may have to switch to the ODBC Classes though. Not totally sure... I use OleDb with a DSNless connection.

I'm surprised they only support DSNs and not DSNless, most hosts I've come across only did it the other way round. Have you tried it DSNless anyway to see what happens?

if you want to use dns in aspx. you should provide previlage to dsn to use on remote web server.
regards,
rakesh.
http://www.logixsoln.com

There is an OleDb method of connecting in C# but some hosts have it disabled because its pretty intense on memory and its not the best for security. Looks like with them there is no other way to connect but to use ADODB.

-dk

Im also having problems with my sql connection.. my host server is located somewhere else and Im connecting to it using a control panel provided by the web hosting company.. Here are the connection strings I used..

1.)
var MM_Applicant_STRING = "dsn=mssql_555.dsn;uid=username;pwd=password;"

2.)
MM_Applicant_STRING = "Driver={SQL SERVER};SERVER=' & db_server & ';DATABASE=' & db_server & '; UID=' & db_username & '; PWD=' & db_password &'"

3.) strCnn = "Provider=SQLOLEDB.1; User ID=user; password=password; Initial Catalog='DB_5133'; Data Source=DataSourcce; Use Procedure for Prepare=1; Auto Translate=True; Packet Size=4096"

what seems to be wrong with my syntax?