Community
Showing results for 
Search instead for 
Do you mean 
Reply

Why one connection string works and one doesn't

Copper Contributor
Posts: 16
Country: New Zealand

Why one connection string works and one doesn't

I have problems figurin out the connection string to ACT database using OleDb.

 

When I use the following it works fine:

 

@"Provider=ACTOLEDB.1;Data Source=C:\Users\zhili\Documents\ACT\ACT for Windows 11\Databases\ACT11Demo.PAD;User Id=Chris Huffman;"

 

But when I try this it gives me error:

 

@"Provider=ACTOLEDB.1;Server=CAM\ACT7;Database=ACT11Demo;Uid=Chris Huffman;"

 

The error is "Multi-Step OLE DB operation generated errors"

 

 

Thanks