NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public Developers v
« Previous 1 … 54 55 56 57 58 … 93 Next »
How to use MSDE(SQL Server) as GBPVR Database

 
  • 0 Vote(s) - 0 Average
How to use MSDE(SQL Server) as GBPVR Database
Ericwiz
Offline

Member

Posts: 68
Threads: 12
Joined: Jan 2005
#61
2005-02-11, 01:59 PM
That's what jumped out at me too.
the Data Source=base\gbpvr should just be your server so it should be (local) or base if that is it's name.

Use Initial Catalog to specify the db.
cginzel
Offline

Member

Posts: 192
Threads: 22
Joined: Dec 2004
#62
2005-02-11, 02:58 PM
I had tried (local) but that didn't work. I just tried base and that doesn't work either. In both of those cases, the error says that no server exists. I have MSDE installed as a specific instance of GBPVR (you can have multiple instances running as separate databases on different ports at one time).

When I use base\gbpvr at least it seems to recognize the server it just fails the login...

-Charles



[SIZE="1"]NextPVR v2.3.4 on XP Home SP2
Rig: Dual Core P4 2.8GHz, 3GB Ram + 230GB HD
Media: WinTV PVR-150/MCE (2) + Media MVP 1000 (1) vD3A
Tools/Plug-ins: Weather, ComSkip, NEWA[/SIZE]
Ericwiz
Offline

Member

Posts: 68
Threads: 12
Joined: Jan 2005
#63
2005-02-11, 03:18 PM
When you login using QA what database are you in? If not gbpvr what happens if you change to gbpvr?

It could be that the gbpvr login has access to the msde but not the gbpvr db.

MSDE has standard SQL access turned off by default. I dont know why but *shrug*. Anyway, somewhere in the setup you can turn it on. I dont remember where but if you are comfortable accessing the registry just go here:
HKeyLocalMachine\Software\Microsoft\Microsoft SQL Server\ Instance Name\MSSQLServer\LoginMode
and change it from "1" to "2" for mixed mode.

Then if your login still doesn't work try using login=sa and pwd empty (assuming you did not give sa a password) and let us know how that works.

-Eric...



cginzel
Offline

Member

Posts: 192
Threads: 22
Joined: Dec 2004
#64
2005-02-14, 03:52 PM
Okay, so I uninstalled MSDE and then manually cleaned up the registry because the MSDE install was "remembering" my instancename when I was not specifying one! After doing that, I was able to get MSDE running with GBPVR using the (local) reference for the data source!

However, I'm getting the same problem I did way back when where the EPG update was complaining about an "Incorrect syntax near 'p'. " and "Specified cast is not valid." (I'm using the Zap2It as the source) I think I had that fixed at some point using the DTS import, but that is what I did this last time… so I'm not sure what's up here.

If anyone has a suggestion for this problem, please fire away… I will do more investigating tonight.

Thanks,
-Charles



[SIZE="1"]NextPVR v2.3.4 on XP Home SP2
Rig: Dual Core P4 2.8GHz, 3GB Ram + 230GB HD
Media: WinTV PVR-150/MCE (2) + Media MVP 1000 (1) vD3A
Tools/Plug-ins: Weather, ComSkip, NEWA[/SIZE]
KingArgyle
Offline

Posting Freak

Posts: 1,271
Threads: 95
Joined: Nov 2004
#65
2005-02-14, 05:23 PM
Cginzel, I haven't tried it with 9.0.10 yet, but youmight also want to try and import an XMLTV formatted version of Zap2It. Check with Sub and see if he is doing anything that is Access specific with the SQL in 9.0.10 that is different from the 23.13 import.



sub
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 106,729
Threads: 767
Joined: Nov 2003
#66
2005-02-14, 05:34 PM
[b Wrote:Quote[/b] ]Check with Sub and see if he is doing anything that is Access specific with the SQL in 9.0.10 that is different from the 23.13 import.
No I dont think I'm doing anything that'll stop MSDE working, but I dont test with it so I dont know for sure. The v0.90 release removed the access specific uses of now()
cginzel
Offline

Member

Posts: 192
Threads: 22
Joined: Dec 2004
#67
2005-02-15, 02:33 AM
My bad! It seems for some reason the identities did not come over with the DTS Data import... and they did not all take the first time I tried to manually set them (it was a late night though!Wink. Now that I have the identities set, the EPG update is a little better, but I'm still seeing the following error in the log:

2/14/2005 8:16:32 PM.187 VERBOSE [139] RecordingFactor.ScheduleSeasonRecordings(77, Nature)
2/14/2005 8:16:32 PM.203 VERBOSE [139] Found potential match at 2/20/2005 8:00:00 PM
2/14/2005 8:16:32 PM.203 VERBOSE [139] - scheduling this episode
2/14/2005 8:16:32 PM.203 VERBOSE [139] Looking for capture source to record: Nature
2/14/2005 8:16:32 PM.203 VERBOSE [139] Checking Cox Cable (DIRECT:Hauppauge PVR150:1)
2/14/2005 8:16:32 PM.218 VERBOSE [139] RecordingFactory.loadScheduleRecording()
2/14/2005 8:16:32 PM.234 VERBOSE [139] RecordingFactor.save()
2/14/2005 8:16:32 PM.250 ERROR [139] Unabled to save ScheduledRecording: Specified cast is not valid.
2/14/2005 8:16:32 PM.250 ERROR [139] at bn.e(ScheduledRecording A_0)
2/14/2005 8:16:32 PM.250 VERBOSE [139] Requesting recording service schedule reload
2/14/2005 8:16:32 PM.281 VERBOSE [139] Found potential match at 2/21/2005 2:00:00 AM
2/14/2005 8:16:32 PM.281 VERBOSE [139] - scheduling this episode
2/14/2005 8:16:32 PM.281 VERBOSE [139] Looking for capture source to record: Nature
2/14/2005 8:16:32 PM.281 VERBOSE [139] Checking Cox Cable (DIRECT:Hauppauge PVR150:1)
2/14/2005 8:16:32 PM.281 VERBOSE [139] RecordingFactor.save()
2/14/2005 8:16:32 PM.281 ERROR [139] Unabled to save ScheduledRecording: Specified cast is not valid.
2/14/2005 8:16:32 PM.281 ERROR [139] at bn.e(ScheduledRecording A_0)

Does any of that ring a bell with you sub? Do you know what specific SQL the EPG update is trying to run at that point? Maybe if you send it to me (SQl statement) I can run it locally and see what's up...

-Charles
[SIZE="1"]NextPVR v2.3.4 on XP Home SP2
Rig: Dual Core P4 2.8GHz, 3GB Ram + 230GB HD
Media: WinTV PVR-150/MCE (2) + Media MVP 1000 (1) vD3A
Tools/Plug-ins: Weather, ComSkip, NEWA[/SIZE]
KingArgyle
Offline

Posting Freak

Posts: 1,271
Threads: 95
Joined: Nov 2004
#68
2005-02-15, 03:36 AM
It looks like it it is trying to schedule a recording when it encounters the problem. Does the recording ever get scheduled???

Cginzel, if you continue to get this problem, a work around is to use the CDK Scheduler. It has been tested to work with MSDE as well as Access.
cginzel
Offline

Member

Posts: 192
Threads: 22
Joined: Dec 2004
#69
2005-02-15, 05:56 AM
[b Wrote:Quote[/b] (KingArgyle @ Feb. 14 2005,21:36)]if you continue to get this problem, a work around is to use the CDK Scheduler. It has been tested to work with MSDE as well as Access.
First I'd like to see if sub will have enough patience to deal with me on this... [Image: smile.gif]

There may be a few issues left, but I think GBPVR is very close to working with MSDE straight up. I see the other threads about boosting performance in different ways, but honestly, I think using MSDE is one of the best ways... All data access is much faster as you know.

I'm tempted to try your CDK Scheduler simply for the priority scheduling, but I'd rather convince my wife that we need a second capture card! [Image: biggrin.gif]

-Charles



[SIZE="1"]NextPVR v2.3.4 on XP Home SP2
Rig: Dual Core P4 2.8GHz, 3GB Ram + 230GB HD
Media: WinTV PVR-150/MCE (2) + Media MVP 1000 (1) vD3A
Tools/Plug-ins: Weather, ComSkip, NEWA[/SIZE]
sub
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 106,729
Threads: 767
Joined: Nov 2003
#70
2005-02-15, 06:11 AM
The two bits of sql executed in that function are:

select max(recording_group) from RECORDING_SCHEDULE
insert into RECORDING_SCHEDULE (programme_oid, capture_source_oid, filename, status, recording_group, recording_type, manual_channel_oid, manual_start_time, manual_end_time, quality_level, pre_pad_minutes, post_pad_minutes) values (?,?,?,?,?,?,?,?,?,?,?,?)
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)

Pages (15): « Previous 1 … 5 6 7 8 9 … 15 Next »
Jump to page 


Possibly Related Threads…
Thread Author Replies Views Last Post
  Determine Server Tuner/Recorder Status from Console App 27InchSony 13 8,309 2016-12-21, 05:03 AM
Last Post: mvallevand
  Looking for C# UPnP Media Server code bgowland 5 7,657 2016-12-16, 08:25 PM
Last Post: mvallevand
  TitanTv Remote Schedule For GBPVR UncleJohnsBand 51 33,825 2015-08-20, 05:11 PM
Last Post: sub
  Delete recordings from database but not from disk? spinnaker 8 3,837 2013-10-26, 10:51 PM
Last Post: spinnaker
  trying to fake npvr database for unit tests reven 3 2,268 2013-05-20, 08:53 AM
Last Post: reven
  Roku & GBPVR pvruser 16 11,531 2011-10-16, 08:31 PM
Last Post: pvruser
  (Yet Another) Rename Helper script for GBPVR & NPVR pvruser 2 2,737 2011-07-22, 01:27 AM
Last Post: pvruser
  Merged database queries mvallevand 4 2,100 2011-06-26, 09:56 PM
Last Post: mvallevand
  NPVR database questions mvallevand 25 9,877 2011-01-06, 12:58 AM
Last Post: jksmurf
  NPVR database - why so stringy with the fields?? :0) carpeVideo 4 2,042 2010-09-21, 01:48 AM
Last Post: sub

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode