im new to vb,
i need to use vb6 to connect to local sql server with
the local system account and get all the databases.
ill be very thanksfull for any help.
abdadak
0
Newbie Poster
Recommended Answers
Jump to PostYou can only get the databases that you have access and permissions to. If the local system account does not have the permissions you cannot view the tables.
What is your connection string techz_boy? What error is it giving you?
All 4 Replies
techz_boy
0
Newbie Poster
i get some project and i have problem on it.i just can connect and view the table in sql server
jwshepherd
0
Junior Poster
You can only get the databases that you have access and permissions to. If the local system account does not have the permissions you cannot view the tables.
What is your connection string techz_boy? What error is it giving you?
Alvein
2
Junior Poster
*Using ADO*
.Connect with
Provider=SQLOLEDB;
Data Source=<your domain>;
Integrated Security=SSPI;
Initial Catalog=master;
Persist Security Info=FalseAnd then .Execute
EXEC sp_databasesThat will return every DB you had access in the column 'DATABASE_NAME'
Hope this helps. ;)
techz_boy
0
Newbie Poster
yeah i can connect it. but i don't know how to navigate it, select it, or query the table
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.