Need "dsn-less" connection

[schwankieog]

i am writing a asp file for a outside company which i do not have acces to the server. i need to connect to a database without using a dsn connection. the company wants everything to be running then they will transfer it to their server. i plan on using general variables but if some one could please give me the syntax for a dsn-less connection i would appreciate it. thanx

 

[dilettante]

Can you supply more details?

If these guys can't make a DSN on their server then I assume they can't administer a database. So it sounds like you're providing a Access .mdb or something.

Do you plan to use a simple Access database that will sit in the same directory as the ASP pages? This would be bad. At least put it into another directory that doesn't allow Read or Write access via the web.

 

[Guest_imported]

I usually use this very basic version to connect to SQL Server:

strconn="driver={SQL Server};server=server_name;uid=user_id;
pwd=password;database=db_name;"

 

[snr]

I am getting ----
The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
--- This error message when trying to connect to Acess database , which is not on my local drive. If I connect to the database , which is on my local drive , the program works fine....but not on network drive...
Please help

 

[schwankieog]

in response, yes they have adminstrating database privileges on the server. they just choose not give me any information and refuse to use a dsn although they can (their 'all-knowing' tech doesnt like them) any way if there is a way to write a generic connection to a database please respond. the database they are using is going to be a access database