Jijo,
Under Control Panel/Data Sources/System DSN , you should be able to create a connection to your remotely hosted SQL database. I'm assuming they've given you an IP address or domain. You should be able to setup this IP or domain and test it there. I would get to this point first and address any remaining issues later. Also, make sure the required port is open in the firewall where the database will reside so you can access it.
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only