Re: ARDGATE connecting to MS SQL

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 08/21/2016
02:42:17 PM:

I am trying to set up ARDGATE that Dieter Bender created. I believe I

have

the basics set up but I do not see how to point it to the MS SQL server.

We have a SQL server running with multiple databases on the SQL

instance.

How would I point it to
- the server
- the SQL instance
- database name

I think the properties in the file global.properties point to the server
and SQL instance only. I tried connecting to the MS SQL server using the
CONNECT statement in STRSQL and it times out.

Any ideas or help?

I am using the following global properties to point to the same MS
SQL server instance via two different drivers. The server/instance are
addressed by the url. The database is addressed by a property -- as
shown. Your embedded SQL code would CONNECT to the name give in your
RDBDIR entry and which is reflected in the qualified names shown to the
left of the equal signs below.

##### use MS SQL Server, via SF driver
ard.driver.DONALD=net.sourceforge.jtds.jdbc.Driver
ard.url.DONALD=jdbc:jtds:sqlserver://donald.winwholesale.com
ard.properties.DONALD.databaseName=DW2012_Dev
ard.properties.DONALD.selectMethod=direct
#
##### use MS SQL Server, via MS driver
ard.driver.DONALD2=com.microsoft.sqlserver.jdbc.SQLServerDriver
ard.url.DONALD2=jdbc:sqlserver://donald.winwholesale.com
ard.properties.DONALD2.databaseName=DW2012_Dev
ard.properties.DONALD2.selectMethod=direct

Now, that said... I'll note that the MS driver quit working when
we applied PTFs to our system at some point. We have not identified the
problem. We just keep using the JTDS driver from SourceForge. It is
faster than the MS driver, anyway. However, is there anybody that has run
into this and fixed the problem? If so, please enlighten me. Thanks.

Sincerely,

Dave Clark