Hi!!

I am new in SQL server. I want make link SQL server with my application.
View -> data view window -> MS OLE DB provider for SQL server -> clicked next ->

My question: what shall i write SERVER NAME (list is empty), username & password and Database on the server?

Please help!!!

Servername is the computername that's running the SQL Server.

Depending on how the server is configured, the username/password or integrated security (NT based) would vary. Database also varies based on what's on SQL server.

Still getting connection test failed...

I have a single pc and not connected with network server. My computer name is SHAHID and pwd 1234. I did command as follows:

vb-> View -> data view window -> MS OLE DB provider for SQL server -> next -> ServerName: shahid, username and password: shahid and 1234. But what shall i write under database name? How can i configure my SQL server and add a database into it?

Please help. I am a beginer and i will be happy if you could write me from starting.

one more thing: in my book (name:how to client/server) there is written "creating a database device" ->steps - open SQL enterprise manager from ur ms sql server6.5 utilities group. But i checked my whole computer and i couldnt find sql server utilities group. Where can i find that? or how can i install that?

Please help, help help!!!!

SQL Server is an additional ($1k-$25k program), if you purchased and installed it, then you should have a group in the program files under a "Microsoft SQL Server" (or similar).

While you can add databases via VB, you need to be able to connect to SQL. Otherwise you have to add databases via SQL Server Enterprise manager.

SQL sets up a "Northwind" database when it's installed. So if it's been installed properly, there should be a northwind database that you can connect to. As far as usernames and passwords... Unless you've added the username and password to SQL, there is only one "sa", with no password by default I believe. And then in the enterprise manager, SQL properties/security the "SQL Server and Windows" authentication has to be selected otherwise you can only connect with "Integreted security" [which is only an option on NT].

But all options to verify are based on being accessed with the enterprise manager.

Please refer to the books online helpfile (11MB) It contains lots of info about SQL Server. But if you don't have that:
SQL Server can use stored procedures to Attach and detach databases. You can execute these stored procedures in the Query Analyzer, provided by the SQL Server installation. look for isqlw.exe. If you don't have that either   , you can always attach a database using VB. Look for the specifics on msdn.microsoft.com you'll find a example vb script there.

Enjoy!
Guus

Wait, there is more! Excerpt from BooksOnline.chm

Syntax
sp_attach_db [@dbname =] 'dbname',
    [@filename1 =] 'filename_n' [,...16]

Arguments
[@dbname =] 'dbname'
Is the name of the database to be attached to the server. The name must be unique. dbname is sysname, with a default of NULL.
[@filename1 =] 'filename_n'
Is the physical name, including path, of a database file. filename_n is nvarchar(260), with a default of NULL. There can be up to 16 file names specified. The parameter names start at @filename1 and increment to @filename16. The file name list must include at least the primary file, which contains the system tables that point to other files in the database. The list must also include any files that were moved after the database was detached.

Syntax
sp_detach_db [@dbname =] 'dbname'
    [, [@skipchecks =] 'skipchecks']

Arguments
[@dbname =] 'dbname'
Is the name of the database to be detached. dbname is sysname, with a default value of NULL.
[@skipchecks =] 'skipchecks'
skipchecks is nvarchar(10), with a default value of NULL. If true, UPDATE STATISTICS is skipped. If false, UPDATE STATISTICS is run. This option is useful for databases that are to be moved to read-only media.



[Edited by GPA on 13-06-2002 at 06:27 AM GMT]

You are so kind. Thanksssss for ur help.