pvraj
asked on
DSN
Hi
Can u pls suggest how can i set up a DSN in my server for my access database
regs
raj
Can u pls suggest how can i set up a DSN in my server for my access database
regs
raj
Control Panel - ODBC Data Sources - System DSN - Add - Microsoft Access Driver (*.mdb) - Finish, then enter your data source name, click select button and choose your database. after that u can access it from your asp program.
Control Panel
ODBC Data Source (32bit)
System DSN
Add
Microsoft Access Driver (*.mdb)
Finish
Enter data source name
Select database
It worked for me!
ODBC Data Source (32bit)
System DSN
Add
Microsoft Access Driver (*.mdb)
Finish
Enter data source name
Select database
It worked for me!
ASKER
hi
this part i know ... but i want to know that how tocreate it in the server. I want to access a database which is uploaded in the server using the dsn that i created in the server .. if i create it in my pc as mentioned before, is it possible to access the database if my PC isput off?...
pls comment
regs
this part i know ... but i want to know that how tocreate it in the server. I want to access a database which is uploaded in the server using the dsn that i created in the server .. if i create it in my pc as mentioned before, is it possible to access the database if my PC isput off?...
pls comment
regs
If your site is hosted by a third party, call their technical support people and ask them to set up the DSN for you.
If you have access to the server yourself, set up the DSN there.
If you have access to the server yourself, set up the DSN there.
ASKER
yes i have the access but i dont know how to set up the dsn there
You've come to the end of my knowledge on the subject.
I thought that you would set the DSN up on a server in the same way as you would have locally.
I'll be interested to hear more.
I thought that you would set the DSN up on a server in the same way as you would have locally.
I'll be interested to hear more.
if your running an IIS Server with NT you set up the DSN just as stated above
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.