I have installed SQL, then Autotrack v4.

Hi,

You're halfway there I think - PSquared\AutoTrck is the correct folder as thats where the actual DATABASEv3 file is.

Is this on the same PC as Myriad v3? If so then have you setup Multiple Profiles (see http://forum.psquared.net/6250/Running-Myriad-v3-and-Myriad-v4.0.9-on-the-same-computer  so that v4 has it's own configuration information and then make sure you tick to enable the SQL Server support when you select the second profile.

Can you check those over and then if give it another go?

------------
Peter Jarrett, Technical Director
Broadcast Radio Ltd.

Bill Bailey: No win, no fee, no basis in reality. Just a room above a minicab office in Acton and a steady stream of greedy simpletons whose delusion is only matched by their clumsiness

Hi 

Pete,

I'm having the same problem, importing/upgrading a v3 database into v4! Its a copy on an external HD. No version of Autotrack v3 exists on this pc!

Ta

Q

Hi Q,

Is SQL running on the same PC as AutoTrack - if not, then we have seen this on some machines and seems to be some sort of lag in the way SQL Creates the database and then we start adding in the tables we use to identify databases.

Can you try moving AutoTrack onto the same machine as SQL and seeing if this then lets you create the database? You can always then release the license and move it back to where you need it afterward the DB is created

------------
Peter Jarrett, Technical Director
Broadcast Radio Ltd.

Bill Bailey: No win, no fee, no basis in reality. Just a room above a minicab office in Acton and a steady stream of greedy simpletons whose delusion is only matched by their clumsiness

I am having the same issues.  I have SQL Server Std 2012 installed on our Server and have created additional profiles in Myriad for v4 for the SQL connection. 

I know that an installed instance works as I have tested using an UDL file from the client to the server.  I will try installing AutoTrack on our Server as suggest above to create the databases and then uninstall moving back to a client PC. 

I am available by phone at Hospital Radio if you'd like to have a remote session and check the install.

The database created when AutoTrack was installed on the Server.  This should really work from the client install though!

This works for SQL2012 Std with the following string

Data Source=SERVER\INSTANCENAME;Provider=SQLNCLI11;Integrated Security=SSPI;Persist Security Info=False;DataTypeCompatibility=80

I also had to ensure the authenticated user had Create Table permissions for the Mayriad DB.