>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
lcDSNLess="DRIVER=SQL Server;" +;
"SERVER=mssql.mydomain.com;UID=sa;PWD=mypw;DATABASE=mydatabase"
Cetin