Moving : AccessSQL Server 2005(Enterprise Edition) VB6—VB.Net

I am a new in .Net Environment. I am moving from VB to VB.Net and Access DB to SQL Server 2005. Please reply me the following questions bellow.

Access Works

SQL SERVER (SS)?

When I create .MSI file it include ADO library in that executable file and my client install software and don’t need any kind of file to install and wherever my program install it can be accessed by using following connection string.

Con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db\PAYROLL_DB.mdb;Persist Security Info=False" Con.Open

What file needed on client’s PC to access SS on server.

What about connection string change dynamically in client sides

I create relation on Access Relationship Diagram.

Where to create these diagrams either on VB.Net Server Explorer or on Management Studio? And how?

Please answers me this basic questions further I have more question in mind but please first answers me these questions…

Hi,

What file needed on client’s PC to access SS on server.

What about connection string change dynamically in client sides

-You will just need a driver to access SQL Server like the ADO (included in MDAC) or ADO.NET (included in the .NET FW) or the SQL Server Native Client (SNAC).

Where to create these diagrams either on VB.Net Server Explorer or on Management Studio? And how?

I would create them in the SSMS, don′t know if the functionality is EXACTLY the same as in server explorer, but I am used to to it there, but from a short inspection of mine I would say that they are feature-identical.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

move log file to diff location

Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.Please don't multi-post. See my answer in .clustering.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23lg8C4luHHA.1768@.TK2MSFTNGP04.phx.gbl...
Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.

Move DTS package from Server A to Server B

Hi

What would you say is the best method to move a DTS package from, say, a test environment to the production server please?

Thanks muchlySave it as a file instead of within msdb.|||DTS best practice,check this link.

http://vyaskn.tripod.com/sql_server_dts_best_practices.htm|||Thanks Blindman

Had just imported it as you posted - it is nearly the end of the Friday working day for me here - that's my excuse for not googling properly before posting :rolleyes:

You guys across the pond enjoy the rest of your Friday afternoon (working...) - I'm off to play the girly version of Football :D|||Check out DTSBackup at sqldts.com