Hello! How can I browse the sql servers on the net from a workstation in Windows 9x. I execute the function with de DSN or the driver and the stringout is empty. I hope the name of the server(s). When I execute the function from a server the stringout is '(local)'. The next call to the function to obtain the databases is ok.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
odbc. Problems with sqlbrowseconnect
- Thread starter dbs
- Start date
I am using a DSN-less connection:
Don't know if this will work for you or not.
In my case the SQL server database is hosted by our ISP thus the "server=WEB_SERVER.com;"
<html>
<%@ Language=VBScript %>
<head>
<title>Brochure Request</title>
</head>
<body>
<%
Set Conn = server.CreateObject("ADODB.Connection"
Conn.Open "driver=SQL Server;server=WEB_SERVER.com;uid=USERID;pwd=PASSWORD;database=YOUR_SQL_DATABASE_NAME;"
Set RS = Conn.Execute("SELECT field_name FROM [tablename]"
somevalue=RS("field_name "
%> [sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]
Don't know if this will work for you or not.
In my case the SQL server database is hosted by our ISP thus the "server=WEB_SERVER.com;"
<html>
<%@ Language=VBScript %>
<head>
<title>Brochure Request</title>
</head>
<body>
<%
Set Conn = server.CreateObject("ADODB.Connection"
Conn.Open "driver=SQL Server;server=WEB_SERVER.com;uid=USERID;pwd=PASSWORD;database=YOUR_SQL_DATABASE_NAME;"
Set RS = Conn.Execute("SELECT field_name FROM [tablename]"
somevalue=RS("field_name "
%> [sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]
- Status
Similar threads
- Locked
- Question