[protege-discussion] DataMaster connection to SQL Server

[Csongor Nyulas]

Hi Andrew,

So, is the problem with setting up the ODBC data source, or when you try 
to connect to the data source using DataMaster?

If you want to connect to an ODBC data source with DataMaster
- you have to select "Data Source Type": ODBC
- "ODBC Driver" will be automatically set to 
"sun.jdbc.odbc.JdbcOdbcDriver", but if you have a different ODBC/JDBC 
driver added to the Protege class path, you can use that one here
- specify the "Data Source Name" as it was defined in the ODBC Data 
Source Administrator (in your case I think it would be EPR-REPOSITORY)

I hope  this helps,
Csongor

Andrew Roberts wrote:
> I seem unable to get Protege 3.4/DataMaster to make an ODBC connection to a
> SQL2005 Electronic Patient Record datasource. For a start the UserDSN that I set
> up does not appeat in the sorce pull down list and when I enter the IP
> Address\Database name manually with my database logon and password Protege dies
> and closes. As far as I can see the User DSN is OK:
>
> Microsoft SQL Server ODBC Driver Version 03.85.1117
>
> Data Source Name: EPR-REPOSITORY
> Data Source Description: Test repository - static
> Server: 10.128.136.212\Graphnet
> Database: (Default)
> Language: (Default)
> Translate Character Data: Yes
> Log Long Running Queries: No
> Log Driver Statistics: No
> Use Integrated Security: Yes
> Use Regional Settings: No
> Prepared Statements Option: Drop temporary procedures on disconnect
> Use Failover Server: No
> Use ANSI Quoted Identifiers: Yes
> Use ANSI Null, Paddings and Warnings: Yes
> Data Encryption: No
>
> Has anyone experienced this? or is there some configuration I'm missing. The
> header of the error log states:
>
>
> # An unexpected error has been detected by HotSpot Virtual Machine:
> #
> #  EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x7c911770, pid=1032, tid=5704
>
> Thanks in expectation
>
> andrew
>
> _______________________________________________
> protege-discussion mailing list
> protege-discussion at lists.stanford.edu
> https://mailman.stanford.edu/mailman/listinfo/protege-discussion
>
> Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03 
>