Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: connecting through IP address


Message #1 by "Enzo" <enzo@t...> on Sat, 16 Jun 2001 02:31:41 +0800

The code below is a connection from a remote mahcine.  The 

xxx.xxx.xxx.xxx is the IP address of that remote machine, how can I 

state the phycical path of the dbase file that I'll be using????  In 

standard connection the Data Source property is like for example 

"c:/datastores/data.mdf" so what will be in this case connecting through 

IP address????

  

    oConn.Open "Provider=3Dsqloledb;" & _

                     "Data Source=3Dxxx.xxx.xxx.xxx,1433;" & _

                     "Network Library=3DDBMSSOCN;" & _

                     "Initial Catalog=3DmyDatabaseName;" & _

                     "User ID=3DmyUsername;" & _

                     "Password=3DmyPassword;"



Thanks,



Enzo

 


  Return to Index