I need to connect to a remote SQL Server that is configured to use TCP/IP (not named pipes). It appears that A5's connection string builder assumes named pipes. The connection string I use from .NET projects is:
Data Source=Server1;Failover Partner=Server2;Network Library=DBMSSOCN;Initial Catalog=DBName;User ID=xxx;password=yyy
I tried just using this directly (without using the connection string builder) but it appears (I'm new to A5) that A5 wants the key/value pairs spoon fed to it in a particular format (at least the error message is meaningful and gave me a couple of options). So I did this instead:
Data Source='Server1',Failover Partner='Server2',Network Library='DBMSSOCN',Initial Catalog='DBName',User ID='xxx',password='yyy'
When I attempt to test this connection it returns "Could not connection. Error reported was: The SQL API you requested is not installed" (Someone might want to note the grammatical errors in this message and correct them.)
I don't know where to go with this. I Googled this particular error and a couple of people indicated it went away when they restarted A5 and someone suggested installing SQL Server express on the client running A5. I did the both, and rebooted the client as well (Window 7 x64 Ultimate) but no joy.
I can connect to this SQL Server fine using ODBC (SQL Server native client). I can also use the resulting ODBC System DSN from A5 but I presume that this would just treat it as a generic ODBC database with some attendant limitations and possibly a performance hit of some kind. My client is unwilling to allow named pipes for remote connections. So ... I need to get this puppy working with TCP/IP. This doesn't seem like it should be rocket science and I don't see why it should be a problem for A5 if it's not for legacy ODBC.
Can anyone help with this?
Data Source=Server1;Failover Partner=Server2;Network Library=DBMSSOCN;Initial Catalog=DBName;User ID=xxx;password=yyy
I tried just using this directly (without using the connection string builder) but it appears (I'm new to A5) that A5 wants the key/value pairs spoon fed to it in a particular format (at least the error message is meaningful and gave me a couple of options). So I did this instead:
Data Source='Server1',Failover Partner='Server2',Network Library='DBMSSOCN',Initial Catalog='DBName',User ID='xxx',password='yyy'
When I attempt to test this connection it returns "Could not connection. Error reported was: The SQL API you requested is not installed" (Someone might want to note the grammatical errors in this message and correct them.)
I don't know where to go with this. I Googled this particular error and a couple of people indicated it went away when they restarted A5 and someone suggested installing SQL Server express on the client running A5. I did the both, and rebooted the client as well (Window 7 x64 Ultimate) but no joy.
I can connect to this SQL Server fine using ODBC (SQL Server native client). I can also use the resulting ODBC System DSN from A5 but I presume that this would just treat it as a generic ODBC database with some attendant limitations and possibly a performance hit of some kind. My client is unwilling to allow named pipes for remote connections. So ... I need to get this puppy working with TCP/IP. This doesn't seem like it should be rocket science and I don't see why it should be a problem for A5 if it's not for legacy ODBC.
Can anyone help with this?
Comment