Ok so I had sql 2000 sp3 installed and working.. i decided to install sql 2005 and sql 2008 to play around... well long story short is I uninstalled ALL versions and got sql 2000 sp3 re-installed.
Now for some reason my sql is not right..
example is with ultralog... connection string can be
Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=HomeSeerDB;Trusted_Connection=yes
or
Provider=SQLOLEDB;Data Source=servername;Initial Catalog=HomeSeerDB;Trusted_Connection=yes
the first one works but if I use the second one (yes put my server name in there instead of just servername) it fails.
now I do not know why that would be but due to that...
I got ultralog working again since you create the db manually with the code proveded..... so that is why this isnt posted under ultralog as it is working fine..
now if I try and install any app that wants to use sql as the database, I get a failure and sql will not create a database.. not sure why....
anyone know where logs or anything is where I can check to try to fix this?
also any pointers based on what I said above?
Thanks
Jeff
Now for some reason my sql is not right..
example is with ultralog... connection string can be
Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=HomeSeerDB;Trusted_Connection=yes
or
Provider=SQLOLEDB;Data Source=servername;Initial Catalog=HomeSeerDB;Trusted_Connection=yes
the first one works but if I use the second one (yes put my server name in there instead of just servername) it fails.
now I do not know why that would be but due to that...
I got ultralog working again since you create the db manually with the code proveded..... so that is why this isnt posted under ultralog as it is working fine..
now if I try and install any app that wants to use sql as the database, I get a failure and sql will not create a database.. not sure why....
anyone know where logs or anything is where I can check to try to fix this?
also any pointers based on what I said above?
Thanks
Jeff
Comment