problem setting oldeb connection properties, IDBProperties::SetProperties fails
Hi, I have problem initializing an oledb native client connection.IDBProperties::SetProperties fails. The Initilization works fine as long as I am initializing a connection to the local sql server as I am setting the following properties: DBPROP_INIT_DATASOURCE = L"(local)" DBPROP_INIT_CATALOG = L"MyDBName" DBPROP_AUTH_USERID = L"USER" DBPROP_AUTH_PASSWORD = L"PSW" But now I am deploying the app on a different location and the app needs to access the database in sql server on remote machine in such address \\Servername\sqlinstance name and port 1234. What other set of parameters do I need to add to the list above to get this working? setting the DBPROP_INIT_DATASOURCE = L"\\Servername\sqlinstance,1234" doesn't work. do I need to set server and port separately? I have found information about DBPROP_INIT_LOCATION which I think I need to use but I am not sure about the format and weather or not the port should be added to location. I really appriciate your reply.