Other Connection Strings - VMORA9 from a networked...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Striped-down Connection Strings Microsoft Access 2000, XP Reaching the NorthWind database at local drive c. Provider="Microsoft.Jet.OLEDB.4.0"; Data Source="C:\Access-Data\Northwind . mdb "; Microsoft SQL Server  Reaching the NorthWind database placed on the (corporate) MSSQL server called SQLSRV01 from a networked workstation named MYMACHINE . workstation id=MYMACHINE;packet size=4096;integrated security=SSPI; data source= SQLSRV01;persist security info=True;initial catalog=Northwind Oracle Server User scott reaching a corporate Oracle server called
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: VMORA9 from a networked workstation (the user’s password tiger is required at connection time) Using Oracle driver: Provider="OraOLEDB.Oracle.1";User ID=scott;Data Source=vmora9;Extended Properties=;Persist Security Info=False Using Microsoft driver for Oracle: Provider=MSDAORA;User ID=scott;Data Source=VMORA9 ; Sybase Adaptative SQL Anywhere 9.0 Use name: dba (password sql ) reaches the corporate server ASADEMO from a networked workstation. Provider="ASAProv.90"; User ID=dba;Data Source=asademo ;...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online