Dear All,

I have requested to my domain registrar to create MS SQL data base in my domain, they have created the database. If the account information is as follows

Domain Name............: mydomain.com
MSSQL database order:
Database name: mydatabase
Password: mypw

Pls explain

1.How can I create ODBC for this database?
2.How can I do server Register in my SQL Enterprises manager?

pls provide with a sample

The syntax I got from theire site is

<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={SQL
Server};SERVER=mssql.domain.com;UID=USER;PWD=password;DATABASE=mydatabase"
Conn.open DSNtest
%>

I have midified the above code to connect thru my vfp application

lcDSNLess="DRIVER={SQLServer};SERVER=mssql.mydomain.com ;UID=sa;PWD=mypw;DATABASE=mydatabase"
?sqlstringconnect(lcDSNLess)

but not working, pls tell what i wrong with ths

Thanks in advance

Jijo David