ADO Connection

Can I connect to an Access database which is sittng in  a web server using the IP ?
I tried with ADO and it is working when I include server name in datasource . But when I give the IP address of server in data source it is not connecting.But If the database is MSSQL Server it is workig. Please Help.
durgeshgnAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DanielCarConnect With a Mentor Commented:
Hello!

You cannot connect to an Access Database using its IP address. You can do it with SQL Server, because SQL has a protocol to talk to clients on IP, Access doesn't...

Sorry.



Daniel    :-)
0
 
durgeshgnAuthor Commented:

Will You Pl name those protocols available with MSSQL Server and Oracle ?
0
 
DanielCarCommented:
On the client side of SQL Server, you can choose which library you want to use to connect to which server: Multiprotocol, TCP/IP, NWLink, Named Pipes, Banyan Vines and ApleTalk are the standard ones.
The equivalent options are available on Oracle.

Regards.


Daniel      :-)

0
All Courses

From novice to tech pro — start learning today.