Connect unify td 5.2 to Sql Server 2005

[nascent]

I want to use Sql Server 2005 with TD 5.2.

While using the connectivity Administrator to Add the Data Source under the ODBC head,
what should be the value for connection string.

My database name is FA2010 and my database Sql Server Name is SERVER2005.

Can any one guide me?

Thanks

[Jeff Luther]

Add the Data Source under the ODBC head

What is that? I'm looking at the ODBC Mgr. dlg. and don't see that title. I run Win XP Prof.

I see the title "Create a New Data Source for SQL Server" and I would add:
Name: FA2010
Server: SERVER2005

and then for TD connections in your SQL.INI you would need to add:
[odbcrtr]
remotedbname=FA2010,dsn=FA2010

[Nils Jänicke]

Hi,

We are using these entries in the sql.ini to connect to SqlServer databases (works with SqlServer 2000, 2005 and 2008):

[win32client]
setzerolengthstringstonull=1

[odbcrtr]
longbuffer=131072
remotedbname=FA2010, DRIVER={SQL Server};SERVER=SERVER2005;DATABASE=FA2010;Uid=sa;Pwd=sa;

(SERVER2005 is the name of the server, User-ID and Password you can change, we are using SYSADM and sysadm and are creating them on the database)

You can enter multiple lines with the remotedbname keyword to access to other databases too.
The advantage of this entry is that you dont need to configure the ODBC settings in every workstation, TD 5.2 has access to the database only if these entries exists in the sql.ini.

Nils

[nascent]

Thanks Nils for the reply.

When I raised this topic, I had two things in my mind.

1. Not to depend on the SQL.INI entry for connecting to database. Instead use the ConnectionString. But some how I am not in a position to do so.

2. Get the list of database names defined in the Sytem DSN for SQL Server and show them in a Combo Box. This also I am not in a position to do so.

At present I define an entry for the database in the System DSN. Set the values for SqlDatabase, SqlUser and SqlPassword. Use SqlConnect( ) to connect the database. But here I am not in a postion to show the user all the valid SQL Serever database names and give him the choice to select the desired database.

Could please throw some light on these two issues.

Thanks

[FRBhote]

The Connectivity Administrator's job is to add the remotedb line to the sql.ini.

[nascent]

FRBhote, what you say is right.

But I would like to populate a Combo Box with database names defined in System DSN for SQL Server without using SQL.INI.