Problem with VB.Net SQL Server

[boloygabs]

---

Hi istoryans.. i have a problem with my program in VB.Net.. it seems that it can connect to the database, but it couldn't read the table inside the database.. i've tried to make some test connection, and it was fine.. but it just can't locate the tables in my database.. i already tried this one in school, and it can perfectly locate the tables, but when i try it at home, it can't locate the tables.. any ideas on how i can solve this problem?

below are the screenshots that i can connect to the database perfectly...

Connection Successful
Imageshack - connsuceeded.jpg

Advance Option
Imageshack - advanceopt.jpg

[rhex_tendo]

'good day!
'karon lang ko nkasugat ing.ani...
'
'kung makaconnect ka sa database, ug kung naa tables imo database,
'makita na ang mga tables bro oi...
'tali wla tables imo database sa inyo, mao dili makita..
'
'dili kaayo ko familiar anang AttachDBFileName, try sab daw ug check na bro...
'

[sanggano_boy]

bro. try using this classes. (C#.NET code rani, pero naa pud ni VB.NET)

MySqlCommand cmd = new MySqlCommand(sSQL, conn);
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();


adapter.Fill(ds, "temp_table");


sa .NET mn gud daghan pa agi-an ang imong recorsets something ana.

I hope that helps.

- Free posting of jobs and resume @ cebujobline.com

[boloygabs]

'good day!
'karon lang ko nkasugat ing.ani...
'
'kung makaconnect ka sa database, ug kung naa tables imo database,
'makita na ang mga tables bro oi...
'tali wla tables imo database sa inyo, mao dili makita..
'
'dili kaayo ko familiar anang AttachDBFileName, try sab daw ug check na bro...
'

ako pud gani bro.. karn pako kasugat ani.. ambot lng ani lagi bro kng nganu di ma detect akong tables.. naa man pd ko tables sa akong database.. nag libog jd ko ani kng nganu..

[boloygabs]

bro. try using this classes. (C#.NET code rani, pero naa pud ni VB.NET)

MySqlCommand cmd = new MySqlCommand(sSQL, conn);
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();


adapter.Fill(ds, "temp_table");


sa .NET mn gud daghan pa agi-an ang imong recorsets something ana.

I hope that helps.

- Free posting of jobs and resume @ cebujobline.com

naka try napud ko ani nga code bro didto sa lain nko nga form.. same ra gihapon, dili gihapon niya makit-an akng table; imbis nana koi table nga nahimu..

[rhex_tendo]

' bro, pag.create daw utro ug database ug tables sab,
' then try ug connect if makita nba mga tables. . .
' wizard sa .net mn na imo gigamit pgconnect sa server sah
' try tnan option bro. . au unta makita namu giunsa nim
'

[boloygabs]

mao raman gihapon bro.. dli gihapn makita akng table..

[SYNCH]

mao raman gihapon bro.. dli gihapn makita akng table..

I assume you are using Visual Studio and Server Explorer pane to connect to the database.

Can you see the tables using the Server Explorer?
Can your code see the tables?
How are you creating the database? Are you attaching an existing database?

[bbriones]

are u using the same version of SQL?

or try lang ni nga approach...

Do not use Attach/Detach
Use the Backup/Restore to copy ur dbase

Backup ur dbase sa school then i restore sa inyo home

I hope this will work

[boloygabs]

hi all.. thank you for all your help.. i have solve this problem now..
thank u for all your inputs..

Please close mods..

Thanks istorya..