I am trying to connect to a SQL Server 2005 DB from Visual Studio

support microsoft com
Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.

are you using MS SQL 2005? if so,

try this one:

1.open your MS SQL Server Management Studio,
2. connect to your data server and locate the database that has an issue on disk space
3. Right click that DB and select properties,
4. a new window will open, on the upper left part, select Files, now you may notice the settings for initial size of your DB.
5. on the autogrowth column, click the button corresponds to your database.
6. a new window will appear and displays options for your database autogrowth settings,
7. set your desired configuration, apply and your done,.

or you may check this blog:
http://blog.sqlauthority.com/2007/08/08/sql-server-2005-ssms-enable-autogrowth-database-property/

thanks

The .sdf or standard data file is used for storing data in a structured format; uses fields of fixed lengths to store values; can be imported and exported by various database and data analysis programs; commonly used for transferring data between different programs.

Hi,

Visual Basic 6.0 and MS Sql server 7 or 2000 are highly compatible with each other. VB.net is compatable with sql 2005 which is inbuilt as well.

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition loadTOCNode(2, 'moreinformation'); You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:

1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.
   
   Note Click OK when you receive the following message:Changes to Connection Settings will not take effect until you restart the Database Engine service.
4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

there is facility in enterprise manager to take back of database!

try to complete uninstall .net framework and install it again or get the latest copy of .net framework to install 3.5 latest version already available for download

installl SQL SERVER 2005

Vb.net is fine its your sql that will mess things up

BTW visual studio come with an SQL server

Regarding what is .SDF -- A file format that is compliant with the combination of SQL Server 2005 Compact Edition, SQL Server 2005 and Visual Studio 2005 to build, test, deploy, and manage applications for users. Databases of this type can be accessed directly as a datasource, e.g., from Visual Studio 2005, or from SQL Server Management Studio. As such, they can be passed around with programs or projects, although they are mainly used for embedded applications. The file includes all necessary code points to access the data, and so does not require an instance of SQL Server to be installed.

You can create a .SDF file with a software called PocketSYNC. (Although i have never tried it myself, a lot of people claim that this software works like charm. But it is not free)

You have to creat a table in the SQL server db then you can

 

a) use some windows host script or vb to read your data and insert into the db..

 

b)you can also use the acess: