Friday, February 24, 2012

centralized database using VB and SQL server

hi to all,
I am using VB as front end application and MS sql server as back end.
I want to make the database centralized.
does anybody know how to connect the database across the network?
thanks in advance for your anticipation.ummm..with a connection string?

What are you doing now?|||ADO.
You will learn about security along the way.

And connection strings.

Originally posted by vnbharath
hi to all,

I am using VB as front end application and MS sql server as back end.
I want to make the database centralized.
does anybody know how to connect the database across the network?

thanks in advance for your anticipation.|||Originally posted by Brett Kaiser
ummm..with a connection string?

What are you doing now?

hmm.. actually i am doing a project in which,i'll keep the database in one system and now i want to access this database from other systems which are connected across the network and also from the same system in which the database is installed.
i dont know which connection to use (like ado,rdo).
thanks|||anybody please help me|||The following Url gives you some info about the connection strings by which you may connect to your database from different front ends
This URl shows odbc connection strings , search for the one which suits SqL db
http://www.able-consulting.com/ADO_Conn.htm
hope it helps

Page specified for SQL server is:
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer|||thanks a lot rasha
this will certainly help.

No comments:

Post a Comment