|
|
hi everybody im a newbie in asp.net my current programming is vb/sql2k. im looking for a code that can connect asp.net application to my sqlserver2k. i have a problem with the connection because my sqlserver2k is installed on other machine and my web server is installed in my local pc with my .net framework. how im going supposed to do that, please please help me, to all experts.
|
|
|
|
Hi,
Dim myCon As Sqlonnection=New SqlConnection("Data Source=SYS1;Integrated Security=SSPI;Initial Catalog=FinAccounting")
The Data Source:
The datasource is the location of the database or database server.
For example, if your database server is on the same machine as your development environment, you could use the name localhost. If the database is remote, we must provide the name of the database server .Here, The SYS1 is the Database Server name(Where SQL Server is installed).
Security Information:
The Integrity Security setting is to specify that the connection is secure. SSPI is essentially a buffer between your application and various security protocols used by data and service providers, such as databases or web servers. If integrated security is not supported, the connection must indicate a valid user and password combination. For a newly installed SQLServer database, the sa(system administrator) account is present without a password.
Regards
bhar
http://www.vkinfotek.com
|
|
|
|
thanks timmy123, i got to try this one i hope it will work in my pc. see you soon
|
|
|
|
Ground shaking content i get form your blog. Very nice post about sql server 2000. Thanks for your beneficial information about testking 646-985, testking 70-270 and testking 70-271 certifications. These are the best certifications in the world.
|
|
|
|
|
|
|
|
guyver
