| Author |
Message |
    
Gochi
Bewarse Legend
Username: Gochi
Post Number: 7175
Registered: 07-2004
Posted From: 68.94.80.68
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, May 03, 2005 - 5:23 am: |    |
••••• lo undavaaa thadi mayyaa  |
Deithadi
Celebrity Bewarse
Username: Deithadi
Post Number: 2464
Registered: 03-2004
Posted From: 68.249.107.23
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, May 03, 2005 - 5:22 am: | |
bin anei folder vundetivanni sql databases mama
mysql folder lo vuntai  |
Nayakudu
Pilla Bewarse
Username: Nayakudu
Post Number: 46
Registered: 05-2005
Posted From: 129.188.33.222
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, May 03, 2005 - 5:00 am: | |
Another approach...
Open Enterprise Manager console... and try to register the new SQL server... provide IP address of SQL Server name and in the next GUI select database level authentication and provide the username/pwd for the database u want to browse. now u can see all available DBs in that sql server
hope am clear |
Nayakudu
Pilla Bewarse
Username: Nayakudu
Post Number: 45
Registered: 05-2005
Posted From: 136.182.2.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, May 03, 2005 - 4:49 am: | |
If you do not know the Db name, do one thing...
Am assuming that u know the server namee.
Try to set up a DSN.. during the DSN creation, it would show all the DB names available inthe server.. hope it helps you... |
Andhrawala
Celebrity Bewarse
Username: Andhrawala
Post Number: 6032
Registered: 03-2004
Posted From: 24.163.73.246
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, May 03, 2005 - 4:44 am: | |
Nayak mama,
I want to access databases from Query Analyzer tool.
The databases are not on my box but lying on some servers in my office. I am connected to Office Network(VPN).
How will it know all the SQLServer databases available. |
Nayakudu
Pilla Bewarse
Username: Nayakudu
Post Number: 43
Registered: 05-2005
Posted From: 136.182.2.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, May 03, 2005 - 4:42 am: | |
If you want to access from an application, u need to set up the DSN in your machine |
Nayakudu
Pilla Bewarse
Username: Nayakudu
Post Number: 42
Registered: 05-2005
Posted From: 136.182.2.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, May 03, 2005 - 4:38 am: | |
AW mama...
are u using SQL server 2000 Enterprise Server?
If Yes, you have to open SQL Server client and provide the server name and DB name and try to connect.. there is no file as such like tnsnames.ora in oracle...
mama eppudo work chesa SQL server meeda thappu aithey manninchu... KIKIKIKI |
Andhrawala
Celebrity Bewarse
Username: Andhrawala
Post Number: 6031
Registered: 03-2004
Posted From: 24.163.73.246
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, May 03, 2005 - 4:31 am: | |
Connecting to office from Home thro VPN.
Installed SQL Server on my Home Computer.
How do I see the databases existing at the servers in Work.
Is there any file which contains that information
similar to tnsnames.ora in Oracle |
