how to connect to sql server

[radubalmus]

hy,
I have made a small program with an Excel interface and Acces database, and i need to switch to Microsoft Sql.
For this the IT guys gave me an adress server, database name, user and password for the Sql server, but not even a litlle bit of tehnic support.
I have nerver worked with SOL before, can you give same pointers how to start, do i need to install some program on my computer, how do i convert from Acces to SQL, and first how do i connect to the server???????
Any links or explinations would be very usefull

Thanks in advance!!

There are simple solutions for almost every problem! The hard part is to see them!!!!

 

[ptheriault]

1st you should install the SQL client tools. What version of SQL Server does your company use?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[radubalmus]

now i will do some testing on 2000, but i will run the program, after it is done, on 2005, after we buy the licence.




There are simple solutions for almost every problem! The hard part is to see them!!!!

 

[radubalmus]

can i not connect to the database using ODBC(VBA Programnig)

There are simple solutions for almost every problem! The hard part is to see them!!!!

 

[ptheriault]

What do you get for an error?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[radubalmus]

it is not that i am getting an error...
i have never worked with microsoft sql
i just need some pointers and links to learn how to use it,
and the first step for me is knowing how to connect to the server.....

There are simple solutions for almost every problem! The hard part is to see them!!!!

 

[ptheriault]

Did you install the SQL Client tools????

Then check out this site.

http://www.computerperformance.co.uk/SQL2000/SQL_home.htm

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[wbodger]

Are you just looking for a connection string:

 "Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

 

[onpnt]

I mean no direct stabs at anyone but I had to share.

I read teh subject line of, "how to connect to sql server?" and thought....hmmmm....pull down SQL Servers pants and grab some jumpers cables

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[onpnt]

seriously though. wbodger brings up a good question.

At what level are you trying to connect to SQL Server in detail? In a macro or something outside SQL Servers normal client tool set

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[radubalmus]

Like i said i am working to a small program with an excel interface and Acces database and i want to switch to SQL.
si i am working with VBA(macros), and i need something like wbodger posted.
but i olso need some directions how to transfer tabels from acces in sql becase i think there are easyer ways to do it.

if i am working with macros do i need the SQL Server tools???

There are simple solutions for almost every problem! The hard part is to see them!!!!

 

[onpnt]

Try the VBA forums. They will be able to explain the process of working in the macro and interacting with the data source

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[wbodger]

You do not absolutely need the SQL client tools, but they would be a much nicer way to transfer your tables across if nobody from the database side of your company is willing to help you.