DSN Connectivity with ASP (buntine i need your help!!!!)

[montysidhu911]

Hi,

I have received a DSN from my webservices provider.

i have placed in the connection file as

con.Open "DSN=dsnname;UID=userid;PWD=password"


after i had uploaded the file and try to run the same im getting the following error :-

==================================================

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/forums/conn.asp, line 7

==================================================

Please help me out guys, i need your help

Sure to hear soon from your side

monty

[montysidhu911]

is it possible to create a general DSN for a particular type of database like for MS Access or do the service provider has to ask me about the path where my database lie and then create a DSN for it........... Please help in this as only then i will speak to my service provider

[Ubik]

You will get more help from your service provider. Just ask them it's not working and to help you get it to work over the phone. They probably get 1000 calls a day asking about this kind of stuff.

It sounds like you might have a typo in your connection string, or they set it up incorrectly.

[chrismartz]

If you are using a MS Access database, you usually need to tye the DSN name to the access database when you set that up. I know with godaddy as my host, creating DSN's takes about a half hour to be fully created.

[montysidhu911]

Thanks Guys for your help!!!!!!!!!!!!!!!!!!!!

The issue was at the service providers end only. They had conveyed me the wrong DSN. and had asked to create a special folder to put the database in it.

But i need one clarification . i m using a MS Acess database. and connectivity is throught the DSN only so is there any way to save guard my database i mean can i supply the database with a password. because other wise if some knows the physical path to the database the person can easily download the datbase

hope to hear soon on this post

monty

[chrismartz]

In MSAccess you can set a password, go to Tools > Security > Set Database Password. Then you need to provide this password to your DSN connection.

[montysidhu911]

u mean i had to ask my service provider to supply dat password when they had created the same............. or can i supply the same in the connection string

monty

[Ubik]

You can supply it in the connection string.