nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

MSSQL Connection

billychan

Dear,

Is there any class or JDBC class in WSMP SDK or WorkflowHelpers.jar to connect to MSSQL server? Or we have to download 3rd parties JDBC driver like jTDS to connect to MSSQL server to insert additional data?

Thanks.

Find more posts tagged with

Comments

dbguy

You must not insert data directly into the WorkSite MP databases.

In any case, there are no JDBC classes available in the SDK.

Migrateduser

You made an assumption about what he wants to do that may or may not be valid dbguy. I'm guessing he's writing a connector or something and wanting to connect to a database other than the WSMP db.

You can download the type jdbc drivers directly from Microsoft.

I think this is the link you want:
http://www.microsoft.com/downloads/details.aspx?FamilyID=07287b11-0502-461a-b138-2aa54bfdc03a&DisplayLang=en

but you'll want to double check that they don't have a newer version.