Connected to TV Server / Unable to connect to database

potfish · 2007-03-06, 21:13

Hello again. Making good progress but hit another stumbling block - this time on a second PC trying to use TV Client.

My HTPC now runs OK (minus a couple of niggles) with TV server and client plugin running on the same machine, i.e. the Nebula boxes are connected to that machine.

I'd like to watch TV on my laptop too so I installed Media Portal on that, installed the TV client plug-in and run MP. As expected, it tried looking for the TV server on the laptop first of all, so I tried to change it to connect to my HTPC.

It didn't work at all at first (said it couldn't connect to the TV server), but I got it a bit better by opening some ports and allowing the TVService, SQLServr and SQLBrowser full access, so I get a different error but it still doesn't work:

This happens even when firewalls are turned off on both machines. Anyone any ideas? I don't believe I should need to change anything on my router should I?

Thanks, Martin

MediaPortal Version: 0.2.2.0 plus SVN 13216 from 3/3/07
MediaPortal Skin:
Windows Version:
CPU Type: XP SP2 with all updates
Motherboard: Abit NF-M2 nView
Video Card: Motherboard Nvidia GeForce 6150
1. TV Card: Nebula uDigiTV USB
1. TV Card Type: DVB-T
1. TV Card Driver: latest BDA drivers from Nebula web site
2. TV Card: Nebula uDigiTV USB
2. TV Card Type: DVB-T
2. TV Card Driver: latest BDA drivers from Nebula web site

Erbsenkopp · 2007-03-06, 21:52

Hi,

i got the same problem, until i change the SQLBROWSER process to autostart.

You can do this with the sql manager.

regards
Erbsenkopp

potfish · 2007-03-07, 10:21

Works now!

Cheers, Martin

-.-PhanTom-.- · 2007-03-10, 17:49

Thanks, heldped me also :=)

bokohut · 2007-03-17, 23:35

I am running tvserver with MySql. I was also getting this error on every install. Using the mysql gui tools I found that in the mysql tables of "server" there is an entry for the tvservers name. I believe this maybe assuming the local LAN has proper DSN working. I do not use DSN on my local LAN and therefore use IP's for everything, thats just how I do it. So back to the topic, I believe the clients pull this from setup in some way and on my network the client knows nothing of this name. I updated the "server" table with the ipaddress then installed on a clean VISTA Os but it didnt work. So the solution that I used on all my machines was to make a named entry in the host file of windows directory located in "SYSTEM32\driver\etc" directory. After this entry no reboot is needed and all is well...

shanizar · 2007-04-10, 19:14

thank you, this helped me as well!

suren · 2007-04-25, 11:41

thank you, this helped me as well!

laauso · 2007-06-17, 00:16

thank you, this helped me as well!

jan_chu · 2007-10-27, 22:46

helped me to!! (the bit about the sqlbrowser)

thanks!

//Jan Chu

Winston · 2007-11-06, 13:36

Top Man Erbsenkopp!!

Nailed my problem in one hit, Thanks!!

Win

2007-03-06, 21:13	#1 (permalink)
potfish Portal Member Join Date: Mar 2007 Posts: 7 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Connected to TV Server / Unable to connect to database Hello again. Making good progress but hit another stumbling block - this time on a second PC trying to use TV Client. My HTPC now runs OK (minus a couple of niggles) with TV server and client plugin running on the same machine, i.e. the Nebula boxes are connected to that machine. I'd like to watch TV on my laptop too so I installed Media Portal on that, installed the TV client plug-in and run MP. As expected, it tried looking for the TV server on the laptop first of all, so I tried to change it to connect to my HTPC. It didn't work at all at first (said it couldn't connect to the TV server), but I got it a bit better by opening some ports and allowing the TVService, SQLServr and SQLBrowser full access, so I get a different error but it still doesn't work: This happens even when firewalls are turned off on both machines. Anyone any ideas? I don't believe I should need to change anything on my router should I? Thanks, Martin MediaPortal Version: 0.2.2.0 plus SVN 13216 from 3/3/07 MediaPortal Skin: Windows Version: CPU Type: XP SP2 with all updates Motherboard: Abit NF-M2 nView Video Card: Motherboard Nvidia GeForce 6150 1. TV Card: Nebula uDigiTV USB 1. TV Card Type: DVB-T 1. TV Card Driver: latest BDA drivers from Nebula web site 2. TV Card: Nebula uDigiTV USB 2. TV Card Type: DVB-T 2. TV Card Driver: latest BDA drivers from Nebula web site

2007-03-10, 17:49	#4 (permalink)
-.-PhanTom-.- Portal Member Join Date: Apr 2006 Age: 35 Posts: 90 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Thanks, heldped me also :=) __________________ WinXPSP2 X2 3600+ - Abit NF-M2 nView Hauppauge MCE-500 Asus EN7100GS512 2 X 1 GB PC6400 DDR2 Last edited by -.-PhanTom-.-; 2007-03-10 at 17:55.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Another Unable to connect to database error	testlab	Get Support	11	2007-10-23 17:30
unable to connect to the server	raiuga02	Installation, configuration support	1	2007-02-04 13:59
Unable to connect to database	grandalf	Get Support	5	2007-02-02 18:41
TV Server - Controller:Unable to connect to database	JavelinJonny	Plugins/Erweiterungen	1	2007-01-15 07:00
Controller:Unable to connect to database	fpeters	Get Support	1	2006-12-27 23:13

2007-03-06, 21:52	#2 (permalink)
Erbsenkopp Portal Member Join Date: Aug 2006 Age: 42 Posts: 95 Thanks: 0 Thanked 3 Times in 1 Post Country: My System	Hi, i got the same problem, until i change the SQLBROWSER process to autostart. You can do this with the sql manager. regards Erbsenkopp

2007-03-07, 10:21	#3 (permalink)
potfish Portal Member Join Date: Mar 2007 Posts: 7 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Works now! Cheers, Martin

2007-03-17, 23:35	#5 (permalink)
bokohut Portal User Join Date: Mar 2007 Age: 33 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts Country:	I am running tvserver with MySql. I was also getting this error on every install. Using the mysql gui tools I found that in the mysql tables of "server" there is an entry for the tvservers name. I believe this maybe assuming the local LAN has proper DSN working. I do not use DSN on my local LAN and therefore use IP's for everything, thats just how I do it. So back to the topic, I believe the clients pull this from setup in some way and on my network the client knows nothing of this name. I updated the "server" table with the ipaddress then installed on a clean VISTA Os but it didnt work. So the solution that I used on all my machines was to make a named entry in the host file of windows directory located in "SYSTEM32\driver\etc" directory. After this entry no reboot is needed and all is well...

2007-04-10, 19:14	#6 (permalink)
shanizar Portal User Join Date: Apr 2007 Age: 29 Posts: 4 Thanks: 0 Thanked 0 Times in 0 Posts Country:	thank you, this helped me as well!

2007-04-25, 11:41	#7 (permalink)
suren Portal User Join Date: Apr 2007 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	thank you, this helped me as well!

2007-06-17, 00:16	#8 (permalink)
laauso Portal User Join Date: Feb 2007 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts	thank you, this helped me as well!

2007-10-27, 22:46	#9 (permalink)
jan_chu Portal Member Join Date: Oct 2007 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts Country:	helped me to!! (the bit about the sqlbrowser) thanks! //Jan Chu

2007-11-06, 13:36	#10 (permalink)
Winston Portal Member Join Date: Oct 2007 Posts: 8 Thanks: 2 Thanked 0 Times in 0 Posts Country:	Top Man Erbsenkopp!! Nailed my problem in one hit, Thanks!! Win