>I am trying to access a database on another maching from a local web server with the following: but this renders Error Type:
>Microsoft OLE DB Provider for Visual FoxPro (0x80004005)
>Invalid path or file name on the OPen.
>
>set oConnection = Server.CreateObject( "adodb.connection" )
>oConnection.Provider = "vfpoledb.1"
>oConnection.ConnectionString = "data source=\\Servername\amft\vamft\data\vamft.dbc"
>oConnection.Open
>
>
>
>Any Help Is Appreciated!!
>
>Thanks
Try this:
Create a text file on your desktop, name it anything you want.
Select the file on your desktop and right click on it.
Change the extension to .UDL.
Right click on the file and choose "Properties..."
Choose your provider and make your connection and test it.
Once you've exited the properties, open the file with note pad. A complete connection string will be in the file as indicated.