Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
Although connection strings on 32-bit computers do not require the "Data Provider" component, connection strings on 64-bit computers do require it. In the following example, the two connection strings both work on 32-bit computers, but only the second string, which includes the "Data Provider" component, works on 64-bit computers:
strConn1 = "server=" & dbServer & ";driver={SQL Server};UID=" & UserID & ";PWD=" & PWD & ";database=" & bizDBName & ";"
strConn2 = " Data Provider=SQLOLEDB ;server=" & dbServer & ";driver={SQL Server};UID=" & UserID & ";PWD=" & PWD & ";database=" & bizDBName & ";"
Use the "Data Provider" component consistently in your connection strings to make sure that they can be ported to 64-bit computers.