How to connect via ODBC

Hi,

I would like to connect in SqlServer 2005 via ODBC SQLServer, how are the steps?

1 - How can I connect ODBC?

1.1 - I need SqlServer 2005 name - ok

1.2 - Which option should I take in order to login? Windows NT authentication or Sql Server authentication?

Which one is the best option?

Cheers,

Alessandro

1.2 - Which option should I take in order to login? Windows NT authentication or Sql Server authentication?

That depends - Windows authentication is almost always better but if you cannot use it then SQL Server authentication is fine as long as you have it enabled on the server and you have created a login on the server. With Windows authentication you can easily use existing Windows domains, groups and users, you don't have to create everything on the server and use extra login names and passwords.

What type of application are you using to connect to SQL Server? ODBC should be your last choice, rather use OLE DB or the .NET data provider if you can.

|||

Hi,

- I picked windows authentication. I can not use OLE DB from my application.

I've created one windows user and created one login, but I still getting "Not associated with a trusted SQL Server connection". I changed Surface Area configuration and Configuration Manager as well. I heard that I nedd to enable mix mode option, how can I do this?

thanks

|||

You haven't told me anything about your application or why you can't use OLE DB, so I'm guessing - but it sounds like you cannot use Windows authentication. In SQL Server Management Studio, right click your server and select Properties. Select the Security page, and on that page select the SQL Server and Windows Authentication mode radio button.

Then add a SQL Server login, and use that login and password in your connection string.

How to connect remote SQL Server?

I wnat to connect to remote sql server 2005, I do the following steps:

Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
Turn on the SQL Server Browser service.
Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.

sp_addlogin 'Wind','ack@.123','db'

but still can't login,tips as follwing:

Login failed for user 'Wind',The user is not associated with a trusted SQL Server connection.

Error:18452

Why? Must use "SQL Server Authentication" connect?

YOu are trying to connect with SQL Server Authenitcation, but you only have Windows Authentication enabled. See the Screencast on my site for more information how to switch the Authentication mode.

Jens K. Suessmeyer

http://www.sqlserver2005.de

how to connect MySQL?

A naive question on how to connect MySQL DB from my C# application.
Kindly explain the steps to be taken to communicate with this DB.

Hi,

There're probably multiple ways of doing this, but one could be:

== Get an ODBC driver for MySQL, for instance here: http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32

== Use System.Data.Odbc namespace functions withC#

The latter is nicely explained in MSDN with samples, you shouldn't have any problems getting into it easily. Have you considered using SQL Express instead of MySQL? You might get richer functionality out of the SqlClient.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||hey!
Thanx for help. I successfully established connection through first method.
The second one I dont have an idea about what namespace is so didn't try to go that way.It would be helpful if you can shed some light on that method or provide some tutorial link.

Also, I have never heard of SQL express. MySQL is available free and being a student thats the best thing for me. Is SQL express free too? I guess it may be since other express editions are free for students. And is there any extra functionality that would entice me to use SQL express?

regarsd
Sumit Dagar.

how to connect jsp file with Microsoft SQL Server

Can anyone please teach me how to make a connection between jsp file and Microsoft SQL Server database steps by steps?

I'm using Windows XP and I found that my computer do not have JDBC (I already have ODBC). Is this mean that I have to install some JDBC or SQL driver in order to make the connection? Which driver should I install and where can I get the driver?

If possible, please show me some example so that I can understand better..Thanks a lot.

Regards,
san sanYes, you need to download a jdbc driver and include its jar in your classpath.

Below is a URL that demonstrates what you need to do.

http://www.akadia.com/services/sqlsrv_jdbc.html

How to connect Anasysis server in different domain

Please let me know the steps to connect Analysis server 2000 from different domain.

fyi for connecting sql server I am using SQL server authentication and I am able to connect.

try this, it works for me in as 2005:

create a local user on the AS server as yourself. Use the same user name/password that you have on the other domain.

example:

domain dom1:

you are logged on as dom1\bob with password xxxxx

On the AS server, create a local user bob with password xxxx. give bob access to the cubes.

Test your connection.

|||

this also works:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1365877&SiteID=1

|||

Thanks for you information,

It is working now.

How to configure SSRS on DMZ! Help!

Hi all,

Would any please guide me to get SSRS set up on DMZ server please. What are the steps i need to aware of? How will the process work will be same as regular SSRS installation? also what prot or ports i have to open on the firewall side!!

Thanks
Pat

You need to read this article it was great help for me
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx

http://sqlserver-qa.net/blogs/tools/archive/2007/10/08/how-to-run-reporting-services-2000-and-2005-side-by-side.aspx

how to configure SQL Server 7.x memory

Hi,
I am curious what the steps are to follow to configure the
SQL server memory settings please?
How do you tell what the current setting is?
We have 500 MB of RAM and an additional 500 MB of RAM was
added. How do you give more memory to SQL server?
In previous posts that I have scanned for memory in here,
what is awe?
Thanks,
Cynthia
(only temporarily assisting to optimize the SQL Server, as
I am not a SQL Server DBA..any help is appreciated).Until you reach 4GB of physical RAM, PAE and AWE are unnecessary settings.
Normally, SQL will adjust itself to take all memory and leave 8-10MB free.
This is good if the server is dedicated to SQL. If other applications run
on SQL, you may want to limit how much memory SQL uses. That can be a trial
and error process since the memory consumption depends on the behavior of
other applications.
So, if it is a dedicated SQL server, leave it alone. Once the OS sees the
memory, SQL will take advantage of it.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cynthia" <anonymous@.discussions.microsoft.com> wrote in message
news:940601c40525$32a37b00$a101280a@.phx.gbl...
> Hi,
> I am curious what the steps are to follow to configure the
> SQL server memory settings please?
> How do you tell what the current setting is?
> We have 500 MB of RAM and an additional 500 MB of RAM was
> added. How do you give more memory to SQL server?
> In previous posts that I have scanned for memory in here,
> what is awe?
> Thanks,
> Cynthia
> (only temporarily assisting to optimize the SQL Server, as
> I am not a SQL Server DBA..any help is appreciated).
>|||Geoff,
Thank you for the quick response. Does this mean you do
not have to run sp_configure "Memory" (similar command as
in sybase) to fix a set amt of memory if it is less than 4
gb in size?
Thanks
Cynthia
>--Original Message--
>Until you reach 4GB of physical RAM, PAE and AWE are
unnecessary settings.
>Normally, SQL will adjust itself to take all memory and
leave 8-10MB free.
>This is good if the server is dedicated to SQL. If other
applications run
>on SQL, you may want to limit how much memory SQL uses.
That can be a trial
>and error process since the memory consumption depends on
the behavior of
>other applications.
>So, if it is a dedicated SQL server, leave it alone.
Once the OS sees the
>memory, SQL will take advantage of it.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Cynthia" <anonymous@.discussions.microsoft.com> wrote in
message
>news:940601c40525$32a37b00$a101280a@.phx.gbl...
the
was
here,
as
>
>.
>|||Actually, there are commands to set min and max server memory. These are
for two circumstances, 1) there is more than 4GB of physical RAM in the box.
2) If you want/need to manage memory yourself. If neither apply and you
want SQL to take care of memory management, just leave it alone.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:8df701c40528$402761d0$a301280a@.phx.gbl...
> Geoff,
> Thank you for the quick response. Does this mean you do
> not have to run sp_configure "Memory" (similar command as
> in sybase) to fix a set amt of memory if it is less than 4
> gb in size?
> Thanks
> Cynthia
> unnecessary settings.
> leave 8-10MB free.
> applications run
> That can be a trial
> the behavior of
> Once the OS sees the
> message
> the
> was
> here,
> as