Hello All,

I’m trying to setup a ConflictSolver DB running from my IS 11.5 box. I have to use MySQL 4 drivers. I downloaded and setup up MySQL 4 on my Dev pc and server now I have to run the IS SQL script called AS_Schema.SQL to populate the new MySQL DB I made with tables. [:@]

So my two issues are 1) I can’t figure out the commands to populate the DB to create the tables with IS script file(could also be the script file). 2) I can’t get ConflictSolver to use the MySql 4 drivers to connect to the pc running the DB. The only choice of “Providers” or drivers inside ConflictSolver is SQL, Access, and Oracle.

Can any one shed light on how the ConflictSolver can be setup and ran using the MySql 4 drivers and DB? Also is this even feasible?

Thanks,
Rob
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Do you have Enterprise or Professional licensing? If you have Enterprise, you need to create a "Managed" application catalog. If you have Professional you create a "Stand-Alone" catalog.

http://helpnet.installshield.com/robo/projects/adminstudio70/ASIDETaskCreatingNewFAS.htm

As far as I know, you have to use Access, Oracle or SQL (7, 2000 or 2005). I don't think they support MySQL. You could always use SQL 2005 Express. It's free. I haven't tried it, but it's supposed to work according to Installshield.
Answered 04/28/2006 by: turbokitty
Sixth Degree Black Belt

Please log in to comment
0
Hey turbokitty,

Thanks for the insite I'll try that today. I'll keep you posted.

Thanks,
Rob
Answered 04/28/2006 by: Trooper23
Orange Belt

Please log in to comment
0
Hi turbokitty,

Well after a irritating [:@] 2 days of trying to install MS SQL 2005 Express, here’s what I found.

First you need to upgrade your .NET from 1.1 to .NET 2.0 then you need to install SP2. On my corporate XP sp1 pc (were also a Novell environment) that had deleted directories (like Outlook express) and locked registry entries I was not able to install SP2 while loged in as Admin. These are dependencies for MS SQL 2005 Express. I am now going to build a XP image from scratch to try to get a ConflictSolver pc up and running. Also I was able to installed .NET 2.0 and SP2 on my MS only VMware (5.0) but after reboot it locks up [&o].

Do you or anyone else know how [:(] to get a Conflict Solver from FLEXnet AdminStudio 7.5= I.S. 11.5 PC up and running with free database and drivers?
Answered 05/01/2006 by: Trooper23
Orange Belt

Please log in to comment
0
Ouch, sorry to hear that Trooper23!

I should have been more clear, my apologies. Your requirements for SQL2005 Express are correct (also keep in mind that SQL2005 Express only supports one processor and 1 GB of memory). There are requirements for the Application Database as well beyond SQL2005's requirements.

IS says you need a server O/S:
http://www.macrovision.com/products/flexnet_adminstudio/adminstudio/resources/tech_specs.shtml

I think if you want a supported setup, you'll need to use SQL 2005 Express or some other such free version of the either SQL, Oracle or Access on Windows 2000 or 2003 Server. You'll also need a big hard drive in the box if you're going to package a lot of applications as the databse gets big pretty quickly.
Answered 05/02/2006 by: turbokitty
Sixth Degree Black Belt

Please log in to comment
0
Hi turbokitty,

OK well I've made some progress. [:)] I created a MS 2003 server, added SP1, .Net 2.0, the SSEUtil (drivers), SQLEXPRE.exe and SQLExpAdm (pack). I created the accounts on the server and within the SQL Ser Mang Studio .msc. Was able to connect from my XP box to the sql server BUT. 1st I was not able to create the DB and 2nd populate it from IS the scripts. [:@]

Now I followed this link from IS to create the DB to no avil.

http://helpnet.installshield.com/Robo/BIN/Robo.dll?mgr=agm&tpc=%2Frobo%2Fprojects%2Fadminstudio60%2FASConceptSQLDBPermissions.htm&wnd=InstallShieldLivingHelp%7CMain&agt=wsm&ctxid=kb%2Fview.asp

Here's from the log.


Do you have any other ideas?

thanks,
Rob
----------------------------------
Starting execution of AS_Schema.SQL
----------------------------------

**** Creating SQL Server Login named ASAdmin...
**** Server Login ASAdmin already exists. ***
**** Database User ASAdmin already exists. ***

Creating tables

Starting the transaction...



Creating ConflictSolver Supporting Tables...
-----------------------------------
Starting PIM Schema objects
-----------------------------------
Table cspchBulletin
Table cspchPatchPackage
Table cspchPatchProducts
Table cspchProducts
Table cspchServicePacks
Table cspchProductServicePacks
Table cspchPatchOperation
Table cspchPatchFileData
Table cspchPatchRegistryData
Table cstblPatchConflictConfig
Table cstblPatchConflictPackages
Table cstblPatchConflictResults
Table cstblPatchConflictDestPkgs
-----------------------------------
Finished PIM Schema objects
-----------------------------------
Table cstblSoftRepCheckOut
Table cstblPatchProperties
Table cstblTransformProperties
Table cstblPackageProperties
Table cstblPackageExeDependencies
Table cstblSubscribedDatabases
Table cstblSubscribedDirectory
Table cstblSubscribedData
Table cstblPackageRelationships
Table cstblPackage
Table cstblGroups
Table cstblGroupPackages
Table cstblGroupPatches
Table cssysExtendedAttributeSchema
Table cssysSchemaInfo
Table cssysSoftRepAttributes
Table cssysHistory
Table cssysTables
Table sysManagedCatalog
Table cstblValidationConfiguration
Table cstblValidationResults
Table cstblConflictConfiguration
Table cstblConflictACE
Table cstblConflictPackages
Table cstblConflictResults
Table cstblConflictTransformList
Table cstblConflictResultsDestPkgs
Table cstblExtendedAttributeData
Table cstblIgnoreTableList
Table cstblPackageHistoryLog
Table cstblPackageVersionHistory
Table cstblTransformFile
Table cstblPatchFile
Table cstblSetupFiles

Creating MSI tables...
Table csmsiActionText
Table csmsiAdminExecuteSequence
Table csmsiAdminUISequence
Table csmsiAdvtExecuteSequence
Table csmsiAdvtUISequence
Table csmsiAppId
Table csmsiAppSearch
Table csmsiBBControl
Table csmsiBillboard
Table csmsiBinary
Table csmsiBindImage
Table csmsiCCPSearch
Table csmsiCheckBox
Table csmsiClass
Table csmsiComboBox
Table csmsiCompLocator
Table csmsiComplus
Table csmsiComponent
Table csmsiCondition
Table csmsiControl
Table csmsiControlCondition
Table csmsiControlEvent
Table csmsiCreateFolder
Table csmsiCustomAction
Table csmsiDialog
Table csmsiDirectory
Table csmsiDrLocator
Table csmsiDuplicateFile
Table csmsiEnvironment
Table csmsiError
Table csmsiEventMapping
Table csmsiExtension
Table csmsiFeature
Table csmsiFeatureComponents
Table csmsiFile
Table csmsiFileSFPCatalog
Table csmsiFont
Table csmsiIcon
Table csmsiIniFile
Table csmsiIniLocator
Table csmsiInstallExecuteSequence
Table csmsiInstallUISequence
Table csmsiIsolatedComponent
Table csmsiLaunchCondition
Table csmsiListBox
Table csmsiListView
Table csmsiLockPermissions
Table csmsiMIME
Table csmsiMedia
Table csmsiModuleComponents
Table csmsiModuleDependency
Table csmsiModuleExclusion
Table csmsiModuleSignature
Table csmsiMoveFile
Table csmsiMsiAssembly
Table csmsiMsiAssemblyName
Table csmsiMsiDigitalCertificate
Table csmsiMsiDigitalSignature
Table csmsiMsiFileHash
Table csmsiMsiPatchHeaders
Table csmsiODBCAttribute
Table csmsiODBCDataSource
Table csmsiODBCDriver
Table csmsiODBCSourceAttribute
Table csmsiODBCTranslator
Table csmsiPatch
Table csmsiPatchPackage
Table csmsiProgId
Table csmsiProperty
Table csmsiPublishComponent
Table csmsiRadioButton
Table csmsiRegLocator
Table csmsiRegistry
Table csmsiRemoveFile
Table csmsiRemoveIniFile
Table csmsiRemoveRegistry
Table csmsiReserveCost
Table csmsiSFPCatalog
Table csmsiSelfReg
Table csmsiServiceControl
Table csmsiServiceInstall
Table csmsiShortcut
Table csmsiSignature
Table csmsiTextStyle
Table csmsiTypeLib
Table csmsiUIText
Table csmsiUpgrade
Table csmsiVerb
Table csmsisys_Columns
Table csmsisys_Tables
Table csmsisys_Validation

Creating MSM tables...

Table csmsmActionText
Table csmsmAdminExecuteSequence
Table csmsmAdminUISequence
Table csmsmAdvtExecuteSequence
Table csmsmAdvtUISequence
Table csmsmAppId
Table csmsmAppSearch
Table csmsmBBControl
Table csmsmBillboard
Table csmsmBinary
Table csmsmBindImage
Table csmsmCCPSearch
Table csmsmCheckBox
Table csmsmClass
Table csmsmComboBox
Table csmsmCompLocator
Table csmsmComplus
Table csmsmCondition
Table csmsmControl
Table csmsmControlCondition
Table csmsmControlEvent
Table csmsmCreateFolder
Table csmsmCustomAction
Table csmsmDialog
Table csmsmDirectory
Table csmsmDrLocator
Table csmsmDuplicateFile
Table csmsmEnvironment
Table csmsmError
Table csmsmEventMapping
Table csmsmExtension
Table csmsmFeature
Table csmsmFeatureComponents
Table csmsmFileSFPCatalog
Table csmsmFont
Table csmsmIcon
Table csmsmIniFile
Table csmsmIniLocator
Table csmsmInstallExecuteSequence
Table csmsmInstallUISequence
Table csmsmIsolatedComponent
Table csmsmLaunchCondition
Table csmsmListBox
Table csmsmListView
Table csmsmLockPermissions
Table csmsmMIME
Table csmsmMedia
Table csmsmMoveFile
Table csmsmMsiAssembly
Table csmsmMsiAssemblyName
Table csmsmMsiDigitalCertificate
Table csmsmMsiDigitalSignature
Table csmsmMsiFileHash
Table csmsmMsiPatchHeaders
Table csmsmODBCAttribute
Table csmsmODBCDataSource
Table csmsmODBCDriver
Table csmsmODBCSourceAttribute
Table csmsmODBCTranslator
Table csmsmPatch
Table csmsmPatchPackage
Table csmsmProgId
Table csmsmProperty
Table csmsmPublishComponent
Table csmsmRadioButton
Table csmsmRegLocator
Table csmsmRegistry
Table csmsmRemoveFile
Table csmsmRemoveIniFile
Table csmsmRemoveRegistry
Table csmsmReserveCost
Table csmsmSFPCatalog
Table csmsmSelfReg
Table csmsmServiceControl
Table csmsmServiceInstall
Table csmsmShortcut
Table csmsmSignature
Table csmsmTextStyle
Table csmsmTypeLib
Table csmsmUIText
Table csmsmUpgrade
Table csmsmVerb
Table csmsmsys_Columns
Table csmsmsys_Tables
Table csmsmsys_Validation
Table csmsmModuleSignature
Table csmsmFile
Table csmsmModuleComponents
Table csmsmComponent
Table csmsmModuleAdminExecuteSequence
Table csmsmModuleAdminUISequence
Table csmsmModuleAdvtExecuteSequence
Table csmsmModuleConfiguration
Table csmsmModuleDependency
Table csmsmModuleExclusion
Table csmsmModuleIgnoreTable
Table csmsmModuleInstallExecuteSequence
Table csmsmModuleInstallUISequence
Table csmsmModuleSubstitution

Creating OS Snapshot tables...

Table csoscFile
Table csoscIniFile
Table csoscShortcut
Table csoscRegistry

Successfully created ConflictSolver Tables.


Creating Workflow Tables...
Table wftblCommandLines
Table wftblTemplateTasks
Table wftblTemplateWorkflow
Table wftblTemplates
Table wftblTools
Table wftblUserWorkflows
Table wftblWorkflowTasks
Table wftblGroups
Table wftblGroupTools
Table assysRolePermissions
Table assysRoles
Table assysRoleTools
Table assysUserRoles

Successfully created Workflow Tables.


Creating Tables Required for AMS-integration...
Table asAMSAppRegistrations
Table asAMSWorkflowProjects

Successfully created AMS-integration Tables.
-----------------------------------
Starting PDT Schema objects
-----------------------------------

[PreDeployment Testing] Creating tables...
[pdtJobInfo] Table Created
[pdtMachineRoot] Table Created
[pdtJobMachineResult] Table Created
[pdtDeployTest] Table Created
[pdtDeployTestMessages] Table Created
[pdtConflictTest] Table Created
[pdtConflictPackages] Table Created
[pdtConflictMessages] Table Created
-----------------------------------
Finished PDT Schema objects
-----------------------------------
----------------------------------
Creating SMS Schema objects
----------------------------------
[SMS Integration] Creating tables...
[AMS_GlobalDistributionSettings] Table Created
[AMS_SMSSettings] Table Created
[AMS_SMSPackageProperties] Table Created
[AMS_SMSPrograms] Table Created
[AMS_SMSProgramOSDetails] Table Created
[AMS_SMSAdvertisements] Table Created
[AMS_SMSAccessAccounts] Table Created
[AMS_SMSDistributionPoints] Table Created

[SMS Integration] Creating stored procedures...
[AMSsp_SMS_GetTotalAppCount]
[AMSsp_SMS_GetTotalAppsByPage]
[AMSsp_SMS_GetExistingPackagesCount]
[AMSsp_SMS_GetExistingPackagesByPage]
----------------------------------
Finished SMS Schema objects
----------------------------------
----------------------------------
Starting JobManager schema objects
----------------------------------
Msg 113, Level 15, State 1, Line 24
Missing end comment mark '*/'.
Created AsJobStep table
Msg 113, Level 15, State 1, Line 12
Missing end comment mark '*/'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'ASJobStepMaster'.
Created AsJobStepMaster table
Created AsJobQueue table
Created AsSchedule table
Created AsJobQueueStepDetail table
Created AsNotification table
Created AsQueueStatus table
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "AsJobStepMaster" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "AsJobStep" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 4
Cannot find the object "AsJobStep" because it does not exist or you do not have permissions.
Msg 1767, Level 16, State 0, Line 12
Foreign key 'FK_asJobQueueStpDt_AsJobStep' references invalid table 'AsJobStep'.
Msg 1750, Level 16, State 0, Line 12
Could not create constraint. See previous errors.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "AsNotification" because it does not exist or you do not have permissions.
Created Job Manager Foreign key constraints
-----------------------------------
Finished JobManager Schema objects
-----------------------------------

Initializing ConflictSolver tables...

cssysSchemaInfo Table...
Msg 208, Level 16, State 1, Line 14
Invalid object name 'cssysSchemaInfo'.

Creating Table Column Indexes...
Msg 1088, Level 16, State 12, Line 7
Cannot find the object "dbo.cstblGroupPackages" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 4
Cannot find the object "dbo.csmsiRegistry" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 5
Cannot find the object "dbo.csmsiFile" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 5
Cannot find the object "dbo.csoscRegistry" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 5
Cannot find the object "dbo.csoscFile" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "dbo.csmsiComponent" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "dbo.csmsiModuleComponents" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "dbo.csmsiModuleSignature" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 5
Cannot find the object "dbo.csmsmFile" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 5
Cannot find the object "dbo.csmsiShortcut" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 5
Cannot find the object "dbo.csmsiIniFile" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 5
Cannot find the object "dbo.csmsiODBCDriver" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "dbo.csmsiServiceInstall" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "dbo.csmsiExtension" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "dbo.csmsiCreateFolder" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "dbo.cstblValidationResults" because it does not exist or you do not have permissions.

Creating Stored Procedures....

Creating ConflictSolver Stored Procedures....

cssp_GetPackageDetails
Msg 2714, Level 16, State 3, Procedure cssp_GetPackageDetails, Line 5
There is already an object named 'cssp_GetPackageDetails' in the database.

cssp_GetExtendedAttributes
Msg 2714, Level 16, State 3, Procedure cssp_GetExtendedAttributes, Line 5
There is already an object named 'cssp_GetExtendedAttributes' in the database.

cssp_GetExtendedAttributeValue
Msg 2714, Level 16, State 3, Procedure cssp_GetExtendedAttributeValue, Line 6
There is already an object named 'cssp_GetExtendedAttributeValue' in the database.

cssp_SetExtendedAttributeValue
Msg 2714, Level 16, State 3, Procedure cssp_SetExtendedAttributeValue, Line 19
There is already an object named 'cssp_SetExtendedAttributeValue' in the database.

cssp_GetWITableData
Msg 2714, Level 16, State 3, Procedure cssp_GetWITableData, Line 7
There is already an object named 'cssp_GetWITableData' in the database.

cssp_GetConflictDetails
Msg 2714, Level 16, State 3, Procedure cssp_GetConflictDetails, Line 8
There is already an object named 'cssp_GetConflictDetails' in the database.

cssp_GetPackageHistoryLog
Msg 2714, Level 16, State 3, Procedure cssp_GetPackageHistoryLog, Line 4
There is already an object named 'cssp_GetPackageHistoryLog' in the database.

cssp_GetGroups
Msg 2714, Level 16, State 3, Procedure cssp_GetGroups, Line 3
There is already an object named 'cssp_GetGroups' in the database.

cssp_GetGroupInfo
Msg 2714, Level 16, State 3, Procedure cssp_GetGroupInfo, Line 6
There is already an object named 'cssp_GetGroupInfo' in the database.

cssp_GetSchemaInfo
Msg 2714, Level 16, State 3, Procedure cssp_GetSchemaInfo, Line 4
There is already an object named 'cssp_GetSchemaInfo' in the database.

cssp_GetIgnoreList
Msg 2714, Level 16, State 3, Procedure cssp_GetIgnoreList, Line 3
There is already an object named 'cssp_GetIgnoreList' in the database.

cssp_GetEASchema
Msg 2714, Level 16, State 3, Procedure cssp_GetEASchema, Line 3
There is already an object named 'cssp_GetEASchema' in the database.

Creating Workflow Stored Procedures...

wfsp_GetWorkflowList
Msg 2714, Level 16, State 3, Procedure wfsp_GetWorkflowList, Line 3
There is already an object named 'wfsp_GetWorkflowList' in the database.

wfsp_GetProjectList
Msg 2714, Level 16, State 3, Procedure wfsp_GetProjectList, Line 3
There is already an object named 'wfsp_GetProjectList' in the database.

wfsp_GetWorkflowDetails
Msg 2714, Level 16, State 3, Procedure wfsp_GetWorkflowDetails, Line 9
There is already an object named 'wfsp_GetWorkflowDetails' in the database.

wfsp_GetProjectDetails
Msg 2714, Level 16, State 3, Procedure wfsp_GetProjectDetails, Line 6
There is already an object named 'wfsp_GetProjectDetails' in the database.

wfsp_GetToolsList
Msg 2714, Level 16, State 3, Procedure wfsp_GetToolsList, Line 3
There is already an object named 'wfsp_GetToolsList' in the database.

wfsp_GetToolDetails
Msg 2714, Level 16, State 3, Procedure wfsp_GetToolDetails, Line 4
There is already an object named 'wfsp_GetToolDetails' in the database.

wfsp_AddProject
Msg 2714, Level 16, State 3, Procedure wfsp_AddProject, Line 54
There is already an object named 'wfsp_AddProject' in the database.

assp_RegisterApplicationWithAS
Msg 2714, Level 16, State 3, Procedure assp_RegisterApplicationWithAS, Line 7
There is already an object named 'assp_RegisterApplicationWithAS' in the database.

wfsp_GetUsers
Msg 2714, Level 16, State 3, Procedure wfsp_GetUsers, Line 3
There is already an object named 'wfsp_GetUsers' in the database.

repsp_AddPublicationArticles_Internal
Msg 2714, Level 16, State 3, Procedure repsp_AddPublicationArticles_Internal, Line 23
There is already an object named 'repsp_AddPublicationArticles_Internal' in the database.

repsp_AddPublicationArticles_Packages
Msg 2714, Level 16, State 3, Procedure repsp_AddPublicationArticles_Packages, Line 54
There is already an object named 'repsp_AddPublicationArticles_Packages' in the database.

repsp_AddPublicationArticles_MergeModules
Msg 2714, Level 16, State 3, Procedure repsp_AddPublicationArticles_MergeModules, Line 29
There is already an object named 'repsp_AddPublicationArticles_MergeModules' in the database.

repsp_DeletePublication_Articles
Msg 2714, Level 16, State 3, Procedure repsp_DeletePublication_Articles, Line 31
There is already an object named 'repsp_DeletePublication_Articles' in the database.

repsp_DeletePublication
Msg 2714, Level 16, State 3, Procedure repsp_DeletePublication, Line 18
There is already an object named 'repsp_DeletePublication' in the database.

Successfully created all the required stored procedures.


Done.

----------------------------------
Execution of AS_Schema.SQL complete
----------------------------------
Answered 05/03/2006 by: Trooper23
Orange Belt

Please log in to comment
0
Sounds like you're getting closer.

What version of AdminStudio are you running, 6 or 7? Any "Value Packs"?

Do you have Enterprise or Professional licensing for AdminStudio?

This is SQL 2005 Express correct? Just checking.

Was it a clean DB when you ran the script?
Answered 05/03/2006 by: turbokitty
Sixth Degree Black Belt

Please log in to comment
0
Hi Trooper,
I tried this out myself to see if it could be done.
- Built a VMWare session with Windows 2003 STD SP1
- Installed .net 2.0
- Installed SQL2005 Express
- Installed SQL Server Management Studio Express CTP (SSMSECTP)
- Enabled remote connections: LINK
- Opened SSMSECTP and created a DB called "AdminStudio"
- Ran AS_SCHEMA.SQL from SSMSECTP with no errors

Here's where the instructions that IS gave us seem wrong.

- Tried to conenct to the database with AdminStudio (Open AdminStudio main GUI and click Catalog > Connect

It fails with an error "Not a recognized application catalog" or something.

- I then tried to create a new Application Catalog with the AdminStudio GUI by clicking Catalog > New
- Forces me to pick "Stand alone Server" (which is what I want as I don't have WorkFlow Manager - Enterprise licensing)
- Filled in the SQLServer as "computername\SQLEXPRESS"
- Used sa/password (not Windows Authentication)
- Called the catalog "AdminStudio".
- The GUI then runs AS_SYSTEM_SCHEMA.sql

How odd. It says in HelpNet that this script is the second one to be run after AS_SCHEMA.SQL and only if you DO have WorkFlow Manager.

So it seems that you're running the wrong script and HelpNet is wrong. Try running AS_SYSTEM_SCHEMA.sql and see where that gets you.

I can connect to the new catalog no problem. Although it's empty of course and it doesn't let you import the Access database that comes with the product.
Answered 05/05/2006 by: turbokitty
Sixth Degree Black Belt

Please log in to comment
0
Hi turobkitty,

Thank you for trying this yourselves and sticking with me. [:)] I apologize for not getting back to last week (other fires to put out). I too was finally able to get this darn ConflictSolver DB up and running. [:D]

Here’s the skinny;

Installed;
MS Sever 2003
Sever SP1
Go into ARP – add IIS
Windows Installer 3
.Net 2.0
SQL Server 2005 Express Edition - SQLEXPR_ADV.EXE, 240 megs ***Must use SQL Server Authentication***
FlexNet AdminStudio 7.5

On the server, I then fired up FlexNet > ConflictSolver > Create > Create Standalone Catalog> Logged into server. Gave the DB a name and off it went.

The dialog said;
Creating the application catalog.
Executing SQL Script “AS_System_Schema”
SUCCESS! Finished creating the application catalog.

I then went to my XP box, logged in. I imported about 12 MSI’s, imported about 100+ Merge Modules. Then ran the Conflict Wizard.

I found I need to create a ODBC System DSN on my XP box or else I was not be able to run the Conflict Wizard. In the 7th dialog called Target Information, I could not select the group/groups and Next was not an option. When I added the ODBC System DSN back in then I could continue. [&:]

This new version of ConflictSolver still has the same general look but of course they changed it a bit.

Take care and happy resolving,
Rob
Answered 05/08/2006 by: Trooper23
Orange Belt

Please log in to comment
0
Good to hear you got it going. For the sake of completeness, I opened a trouble ticket with Macrovision to get them to fix that KB article.
Answered 05/08/2006 by: turbokitty
Sixth Degree Black Belt

Please log in to comment
0
Hi turbokitty,

Here is a email we received from Macrovision, it took three weeks for this reply. Not good!
_______________________________________________________________________
There has been recent activity on your Support Incident #SIOA-000050959.

Incident Description: "****,

As a result of my research, I have found that MySQL and AdminStudio don't seem to mesh well together. I tried to put some extra effort to see if i could get this to work, but I could not with a managed catalog. MySQL is, at this time, unsupported with AdminStudio and not expected to work correctly.

I apologise for any delays or inconvenience.

Please let me know if you have any further questions or information.

Thanks,

******"

Please click this link: http://support.macrovision.com to review the incident details.

Regards,
Macrovision Support
_______________________________________________________________________

So there you have it IS and Mysql wont work even though there's documentation to support it does, how weak!!!
[&:]
Answered 05/25/2006 by: Trooper23
Orange Belt

Please log in to comment
0
Hmm.. well to be fair, I don't think it says anywhere that MySQL is supported. Just SQL, Oracle and Access. They should add SQL Express to that list now, as we've proven that it works!
Answered 05/25/2006 by: turbokitty
Sixth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity